• Contents

Product Import Reference

Last updated 18/02/2021

Overview of the fields in the product import spreadsheets.

Templates


This is a reference for all three product import templates. These templates are to be used as guides and provide basic examples using a minimal number of fields. You can import into any field in the Product module; simply include it in the spreadsheet as a column to include it in the import. You will need to match your additional columns yourself after import, however.

The templates are:

Simple Product Fields


Field Explanation
CATEGORY Parent level category.
SUBCATEGORY Subcategory of the product. Note that although you can have three levels (or more) of categorization in Cin7, it is not possible to import these.
PRODUCT NAME Required. This is the name of the product.
DESCRIPTION A long description of the product.
SUPPLIER Preferred supplier of the product. It must match exactly the name of a supplier in the system for a match to be created automatically.
Stock Control Required. Stock control method. Choices are "FIFO", "Batch", "Serial", or "Non Stock" for non-stock products.
Option 1 Label Title of the option, and not the option itself (i.e., "Color", not "Red").
Option 2 Label See above.
Price CODE Required. This is the unique code for each option.
Option 1 An option (e.g., "Red").
Option 2 A second option, if needed.
Cost Price Cost price of the product in the home currency.
Retail Price Retail price of the product in your home currency.
Wholesale Price Wholesale price for the product.
VIP Price Price for VIPs.

Fashion Product Fields


Field Explanation
Style Code A code common to a group of product options and size options.
SKU Range A SKU / Size Range; see the Fashion Products Help article for additional information. This range is applied at the product level and should be the same for all options/variants within a product. If no Size Range exists in the system, one will be created based on this name using the sizes within Size column (see below).
Size Code Unique code applied to a size (e.g.; "Ts-1-M").
Size A single size (e.g., "m"). It must correspond with the Size Range.

Alternative Units of Measure Fields


Field Explanation
UOM Code Unique code for the unit of measure, usually built from the code (e.g., "rg1-box").
Price UOM The price per this unit of measure, if applicable.
UOM Cost The cost of this unit of measure, if applicable.
UOM Size A number that represents the multiple of the base unit of measure.
UOM Option1 The name of this unit of measure.
UOM Option2 A second name if needed.