• Contents

Importing Products with Alternative Units of Measure

Last updated 18/02/2021

Overview of importing products with alternative units of measure.


Products with Alternative Units of Measure (UOM) require additional fields to store their data. To make it easier to import this additional information, a separate import template for Alternative Unit of Measure products is provided to give you an idea of what is required.

If you sell both UOM and simple products, you will be able to import both in the same import spreadsheet by simply omitting the irrelevant fields for the simple products.

Before importing UOM products, it is recommended to review the Creating a Product, Product Codes, and Alternative Units of Measure Help articles for background on Cin7's product structure before beginning the alternative Units of Measure import process.

See the Importing Simple Products Help article for additional information on just importing simple products.


The Alternative Unit of Measure Product Template is a Microsoft Excel file that contains all fields for a fashion product. The fields are explained in detail in 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.

UOM Code

While 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 which is useful if you receive discounts for buying in bulk, etc.

UOM Size

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.