Product Import
The product import feature can be used to add new products and update existing products in bulk.
Orderspace uses CSV files, which can be imported and exported from spreadsheet software such as Microsoft Excel, Google Sheets or Apple Numbers.
The format of the product import file is the same as the product export. We recommend you create a few products manually on the admin site, and then export those products to see how the CSV file works with your own products.
The CSV file contains one line for each product variant. Where a product contains multiple variants, the first line should contain all the information specific to the product as a whole (see the Scope column below), and the first variant. For each subsequent line of a multi-variant product, the 'Product' columns, except for 'Product Code' should be left blank.
| Column | Scope | Type | Description |
| Product Code | Product | Text | A unique code for the product. For products with multiple variants this should be the part of the code that is the same for each variant. For example, for a product with Small, Medium and Large sizes, where the variant codes are TS001-S, TS001-M, TS001-L, the product code would be TS001. |
| SKU | Variant | Text | A unique code (Stock Keeping Unit) for this variant. E.g. TS001-S. If the product doesn't have any variants, this should match the Product Code. |
| Name | Product | Text | The name of the product |
| Categories | Product | Text | The names of the categories that this product is in. Multiple categories can be separated with a semi-colon. Unrecognised names will be added as new top level categories. |
| Description | Product | Text | The description of the product shown on the product page. |
| Active | Product | Yes/No | Controls the visibility of the product on the ordering site |
| Tariff Code* | Product | Text | The Tariff Code for this product, for use with Commercial Invoices *Only visible if the Commercial Invoices feature is enabled |
| Country of Origin* | Product | Text | The Country of Origin for this product, for use with Commercial Invoices *Only visible if the Commercial Invoices feature is enabled |
| Composition* | Product | Text | The Composition for this product, for use with Commercial Invoices *Only visible if the Commercial Invoices feature is enabled |
| Attribute 1 | Product | Text | The name of the first way in which this product varies e.g. color, size length. |
| Attribute 2 | Product | Text | The name of the second way in which this product caries. E.g. if the product has multiple colors and sizes, set Attribute 1 to 'color' and Attribute 2 to 'size' |
| Attribute 3 | Product | Text | The name of the third way in which this product varies. E.g. if the product has multiple colors, sizes and lengths, Attribute 3 would be 'length' |
| Variant 1 | Variant | Text | The name of the specific variant, corresponding to attribute 1 above. E.g. red |
| Variant 2 | Variant | Text | The name of the specific variant, corresponding to attribute 2 above. E.g. small |
| Variant 3 | Variant | Text | The name of the specific variant, corresponding to attribute 3 above. E.g. long |
| Unit Price | Variant | Number | The wholesale price, excluding tax, for this variant. |
| RRP | Variant | Number | The retail price, including tax, for this variant |
| On Hand | Variant | Number | The quantity in stock in your warehouse |
| Available | Variant | Number | The quantity available to order, calculated from On Hand minus any unfulfilled items |
| Backorder | Variant | Yes/No | Controls whether the product can be ordered when it is out of stock |
| Minimum | Variant | Number | The minimum order quantity for this variant |
| Multiple | Variant | Number | The order multiple for this variant |
| Images | Variant | Text | Links to the image URLs for this variant. Multiple images will be separated with semicolons |
| Barcode* | Variant | Text | The barcode number (UPC) for this variant. *Only visible if the Barcodes feature is enabled |
| Location* | Variant | Text | A description or code representing the stock location for this variant. *Only visible if the Stock Locations feature is enabled |
