Importing products is a swift approach to filling your inventory with product entries for a convenient posting process. That is, this is the creation of a product without adding its residues.
Remember: you cannot import the stock balances. Instead, Orderry allows you to import the product names and properties. Use postings to upload the product stock balances.
Hit the “Import” button on the “Inventory > Products and categories” page, and download an Excel file example to import products to your inventory. We recommend working right in the import template.
Remember: Do not change the column names and order in the Excel file, so Orderry can process the file and import your products correctly.
Let's consider the file content in detail.
The “Сode” column is the product code used for internal product identification.
The “Article (SKU)” is the product identifier. It often contains digital and characters. The vendor code may be the same as for the similar supplier and vendor product.
“Barcode” is a product ID that respects the international EAN-13, EAN-8, UPC-A, and Code128 formats. Barcode is a unique identifier, meaning there cannot be two products with the same barcode.
The “Сode”, “Article (SKU)”, and “Barcode” columns are not required.
The “Title” column contains the product name and is required. The “Title” is a unique identifier, meaning there cannot be two products with the same product name.
The “Category” column contains the product category. This is a required field. You should preserve the subcategory order and divide them by “>” character.
For instance, “Accessories > Apple Original > XS” will display in the following way:
Note: The “All products” category is a default root category.
The system automatically generates the categories missing on the “Inventory > Products and categories” page.
The “Warranty” column represents the client warranty duration amount (it's a number).
The “Warranty period” is the unit of measurement for the client warranty (days or months).
Note: the “Warranty” and “Warranty period” are not required. However, if you need to add the warranty, make sure to fill both columns.
The “Serial accounting” column is required. If you want to enable serialization, indicate “yes” in the line; if you want to leave the products non-serial, indicate “no”.
Remember: Enabling serialization is irreversible. Once activated, you'll have to enter the serial number for every product item.
There is no “Stock balance” column because the product importing is only for the product names and properties.
Your import file should have up to 2500 entries.
Hit the “Import” button on the “Inventory > Products and categories” page, attach the filled file, and hit the “Import” button to upload your Excel file with products to the Orderry system.
Exporting products is the reverse process to the product importing.
Hit the “Export” button on the “Inventory > Products and categories” page to initiate an Excel file download.
Remember: The product export downloads all product names and properties from all warehouses, regardless of the stock balances.
The export file is similar to the import sample file.
The file contains the “Code”, “SKU”, “Barcode”, “Name”, “Category”, “Client warranty” (value and period), and “Serial accounting” columns. There are also columns with the current retail prices you can use for product repricing.
Exporting stock balances
Stock balance export gets only the products with positive stock balance.
Hit the “Export” button on the “Inventory > Stock” page to start an automatic download of an Excel file with your product stock balances.
The file contains the “Code”, “SKU”, “Barcode”, and “Name” columns — these are the product identifiers. The “Bin location” column displays the bin if you have enabled the bin location. The “Balance” column contains the current quantity of your product items in the inventory. The “Serial numbers” column contains serial numbers of serial products. The exported Excel file also contains the Retail price columns you can use for product repricing.
Import simplifies your inventory filling routine, and export enables you to get the detailed product information for extended analytics.
Use the product import and export features for product repricing and bulk changes of the product properties. Just export the product data, perform changes, and import back the changed product data into Orderry.
Note: Do not change the product “Name” column fields, because it's a unique identifier, meaning there cannot be two products with the same product name. If you change the field, the system will consider the entry as a new product and will create a new product dialog window for it.