WMS Product Export Format

The following tables list the format for exporting product data to a WMS. Each record is a comma-delimited row in the export file.

Product Location Record

Position	Field Name
1	PRODLOC
2	Location Prefix
3	Product Code
4	Product Code Unformatted
5	Product Name
6	Product Key
7	Product Description
8	Product Search Name
9	Product User Defined 1
10	Product User Defined 2
11	Product User Defined 3
12	Product User Defined 4
13	Product User Defined 5
14	Product User Defined 6
15	Product User Defined 7
16	Product User Defined 8
17	Product User Defined 9
18	Product User Defined 10
19	Product User Defined 11
20	Product User Defined 12
21	Product User Defined 13
22	Product User Defined 14
23	Product User Defined 15
24	Product User Defined 16
25	Product User Defined 17
26	Product User Defined 18
27	Product User Defined 19
28	Product User Defined 20
29	Product Category Code
30	Product Category Description
31	Product Category Key
32	Product Subcategory Code
33	Product Subcategory Name
34	Product Subcategory Key
35	Size Code
36	Size Name
37	Size Sort Sequence
38	NRF Size Code
39	Color Code
40	Color Name
41	Color Sort Sequence
42	NRF Color Code
43	Product Style
44	Product Style Name
45	Product Style Sort Sequence
46	Product Line Code
47	Product Line Name
48	Product Line Sort Sequence
49	Bottle Size
50	Bottle Dimension Basis
51	Location Key
52	UPC
53	GTIN
54	Product Class
55	Base Unit of Measure Code
56	Base Unit of Measure Key
57	Dimensional Basis
58	Dimension Unit of Measure Key
59	Unit Gross Weight
60	Unit Net Weight
61	Weight Unit of Measure Code
62	Weight Unit of Measure Key
63	Cube
64	Cube Unit of Measure Code
65	Cube Unit of Measure Key
66	Weight Per Volume
67	Density Mass Basis
68	Weight Basis Unit of Measure Key
69	Density Volume Basis
70	Volume Basis Unit of Measure Key
71	Hazard Code
72	MSDS Number
73	NMFC Number
74	Harmonization Code
75	Country of Origin
76	Type
77	Kit Product
78	Configuration Kit Product
79	Can Be Sold
80	Not Stocked
81	Drop Ship Allowed
82	Must Drop Ship
83	Potential Discrepancy Flag
84	Cross Dock
85	Allow Pick Up
86	Allow Pick Down
87	Allow Reallocate
88	Discontinued
89	Use Quantity on Order in Discontinued Calculation
90	Discontinued Date
91	Sales Track Level
92	Allocate within X days
93	Backorder Priority List
94	Hold Inventory for Backorder
95	Release Backorder Manually
96	Restricted Allocate
97	Primary Pick Bin
98	Primary Pick Bin Key
99	Primary Putaway Bin
100	Primary Putaway Bin Key
101	Must Backflush
102	Primary Backflush Bin
103	Primary Backflush Bin Key
104	Must Use Primary Work Order Bin
105	Primary Work Order Bin
106	Primary Work Order Bin Key
107	Scrap Factor
108	Pick Bin Minimum Level
109	Pick Bin Maximum Level
110	Package Unit of Measure
111	Pick Method
112	Pick Group
113	Pick Group Key
114	Product Scan
115	Quantity Scan
116	Warehouse Product Code
117	Warehouse Product Name
118	Cycle Count Class Code
119	Cycle Count Class Key
120	Recount Variance Amount
121	Recount Variance Percentage
122	Cycle Count Automatic Reclassify
123	Recount Required
124	Recount Display
125	Count Display
126	Changed
127	Created By
128	Created Date
129	Created Time
130	Update By
131	Update Date
132	Update Time
133	WMS Export Sequence Number
134	WMS Export Batch Number
135	WMS Export Date
136	WMS Export Time

Product Location Unit of Measure Record

Position	Field Name
1	PRODUMLOC
2	Unit of Measure Code
3	Unit of Measure Key
4	Sell
5	Purchase
6	Pick
7	Default Selling
8	Default Purchasing
9	Default Display
10	Default Receipt
11	Web
12	Break-to Unit of Measure Code
13	Break-to Unit of Measure Key
14	Height
15	Length
16	Width
17	Dimensional Unit of Measure Code
18	Dimensional Unit of Measure Key
19	Cube
20	Cube Unit of Measure Code
21	Cube Unit of Measure Key
22	Net Weight
23	Gross Packaged Weight
24	Weight Unit of Measure Code
25	Weight Unit of Measure Key
26	UPC
27	GTIN
28	Putaway Group
29	Replenish Minimum
30	Replenish Maximum
31	Primary Pick Bin
32	Primary Pick Bin Key
33	Primary Pick Zone
34	Velocity
35	Pick Sequence Group
36	Can be Packaged
37	Label Format
38	Product Key
39	Location Key