When importing products into the Orderry on the My Company > Products page, it is important that the file contains correctly filled-out and up-to-date data in the table. If an error is detected in a specific row, the system will notify you and will not import the product from that row until the error is corrected.
1. You must specify no more than 2 barcodes. Check the barcode column and leave no more than 2 values for a single product. Delete any extra barcodes and try importing again.
2. A supplier with this specific ID was not found or is inactive. Check that the supplier ID in the import file is correct. Also make sure the supplier exists in Orderry.
3. You must specify the product category. Fill in the product category column in the import file. Make sure the specified category exists or create it before importing products.
4. Duplicate rows. To remove duplicate rows in the Excel file, select the column you want to check (e.g., Name, Code, or SKU), then go to Conditional Formatting → Highlight Cells Rules → Duplicate Values and mark them. Delete the duplicates, save the file, and then import it again.
5. For new products, the product ID column must not be filled in. If the import file contains ID values for new products, they will not be uploaded. When creating new products, the system automatically assigns them IDs after a successful import. These IDs can later be used to update information about products that already exist in the system.
6. Incorrect price column. The price column contains an incorrect value or data format that the system cannot process. Please ensure:
only numeric values are specified in the price column;
there are no extraneous characters or text values;
a value is specified in the required price field.
7. The product already exists. This error occurs if you have selected a unique identifier for Name or SKU. Make sure there are no duplicate products in the file with the selected unique identifier.