• Contents

Importing Fashion Products

Last updated 18/02/2021

Overview of importing fashion products.


Fashion products require a few extra fields to store their sizes. We've created a separate template for fashion products to give you an idea of what is required.

If you sell both fashion and simple products, then you will be able to import both in the same spreadsheet - you will just omit the irrelevant fields for the simple products.

Before importing fashion products, it may be worth reviewing Creating a Product, Product Codes, and Importing Simple Products before starting. These articles will give you the background to Cin7's product structure.

Fashion Template

The Fashion Product Template is an excel file containing all the fields for a fashion product. The fields are explained in detail in the Product Import Reference Help article.

Preparing your spreadsheet

Here are a few pointers for creating your import spreadsheet. The easiest way to understand the below principles is to make some test imports with a small amount of data.

Style Code

Each fashion product requires a different Style Code. The Style Code is a unique code for each Product. This means that you can have multiple products with the same name, but with different Style Codes - useful for recurring staple products such as plain t-shirts. If this applies to you then remember to "Group by Style Code" when importing.

Style Codes

Style codes are also used for simple products, but we have left them out of the Simple Product Import for the sake of simplicity. We create the style code automatically based on a code when the style code column is not included in the spreadsheet.

Stock Control Method

Remember that fashion products are stored using the "batch" stock control method in the system. This means that in the stock control column in the spreadsheet, you must enter "Batch" against each fashion product.

Size Range

All fashion products require a Size Range. This is explained in more detail in Creating Fashion Products. It is not necessary for the size range to have been created before import - the system will create them for you upon import. This does mean however that you should create a row for every product in the possible range of sizes. For instance if you intend to sell S - XL but don't currently have any XL in stock, your product spreadsheet should still include the XL size.


The size column will contain the sizes of each row, and can be as simple as "S", "M" or "L".

Size Codes

Each size in your system will have a unique code, and there will only ever be one size code per row. We find it best to build size codes in a logical way, e.g. "RGB1-Red-M". Ideally it will incorporate the "size" as explained above.