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'.