• Contents

Importing Products with Alternative Units of Measure

Last updated 15/06/2018

If you are importing fashion products, there are a few extra things you should know.


Products with Alternative Units of Measure require a few extra fields to store their data. We've created a separate template for Alternative Unit of Measure products to give you an idea of what is required.

If you sell both UOM 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 UOM products, it may be worth reviewing Creating a Product, Product Codes, and Alternative Units of Measure before starting. These articles will give you the background to Cin7's product structure.

Importing a Simple Product explains the general process of importing products.


The Alternative Unit of Measure Product Template is an excel file containing all the fields for a fashion product. The fields are explained in detail in Product Import Reference.

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.

UOM Code

Whilst not technically a separate product, each alternative unit of measure requires a unique code. This code will appear on invoices and will help you distinguish what unit of measure a transaction is in.

Price and Cost

Each unit of measure can have a price and cost - useful if you receive discounts for buying in bulk etc.

UOM Size

The UOM Size is the multiple that determines how many of your base unit of measure should be received or dispatched.

UOM Options

This is that name of this unit of measure and will appear on invoices etc.