Bulk 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 Orderspace product export. We recommend you create a few products manually using the Orderspace admin, 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 | Set to 'Yes' the product will be visible to customers, otherwise it will only be visible on the admin site. | |
| 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 you have in the warehouse for this variant. | |
| Backorder | Variant | |
Yes/No | Set to 'Yes' this variant will be backorderable when the quantity available is zero, otherwise the variant will be shown as 'Sold Out'. |
