uom-product-template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Cin7
2	UOM Import Template
3
4	CATEGORY 1	CATEGORY 2	PRODUCT NAME	DESCRIPTION	STOCK CONTROL	SUPPLIER	CODE	OPTION 1	OPTION 2	COST PRICE	Retail Price	Wholesale Price	VIP Price	UOM Code	Price UOM	UOM Cost	UOM Size	UOM Option1	UOM Option2
5	If it is the same product, copy the name to each applicable row.	If it is the same product, copy the name to each applicable row.	If it is the same product, copy the name to each applicable row.	If it is the same product, copy the name to each applicable row.	FIFO, Serial or Batch.	If it is the same product, copy the supplier to each applicable row.	Unique code Cin7 uses to match products on.	If you have variations on a product in the "Option 1 field", identify 1st variable here.	If you have variations on a product in the "Option 2 field", identify 2nd variable here.	The cost price if purchased in your default currency.	The retail price if purchased in your default currency.	If applicable. If the price column names are different, change the price heading accordingly.	If applicable. If the price column names are different, change the price heading accordingly.	Unique code to identify the Unit of Measure (UOM) option of the main product.	Price of the UOM if it will be different to the main product price multiplied by UOM size.	Cost of the UOM if it will be different to the main product cost multiplied by UOM size.	Multiplier to calculate UOM quantity.	Name describing the UOM to display in transaction and documents.	Second name describing the UOM to display in transaction and documents.
6	Phone Case		Phone Case	Description here	FIFO	Phone Supplier	Phone1	Unit		1.5	15	10	8
7	Phone Case		Phone Case	Description here	FIFO	Phone Supplier	Phone1							Phone1-pack	80	6	6	Pack
8	Phone Case		Phone Case	Description here	FIFO	Phone Supplier	Phone1							Phone1-carton	280	20	25	Carton
9	Phone Case		Phone Case 2	Description here 2	FIFO	Phone Supplier	Phone2	Unit		2	15	10	8
10	Phone Case		Phone Case 2	Description here 2	FIFO	Phone Supplier	Phone2							Phone2-pack	80	6	6	Pack
11	Phone Case		Phone Case 2	Description here 2	FIFO	Phone Supplier	Phone2							Phone2-carton	280	20	25	Carton
12
13
14	IMPORTANT NOTES	1. Refer to the Cin7 Help article for a complete list of available fields: https://connect.cin7.com/s/article/Product-Import-Reference
15		If you require one of these fields, add it to the above as a new column, ensuring the column name in row 4 matches the field name in the Help article.
16		2. If you want to use this spreadsheet as your important template, you must:
17		2a. Delete rows 1-3, 5, and these IMPORTANT NOTES rows, leaving just the column header row and the data you want to import.
18		2b. You do not have to remove the column/cell shading as the next step will automatically remove it.
19		2c. "Save As" the file and select CSV (comma delimited) (.csv).
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100