Appendix > Format Requirements for the Import/Export Feature > Inventory File Format Requirements for Importing Data > Inventory Pricing List Option
Inventory Pricing List Option
If you select Inventory Price List in the File Definition field, your external file must conform to the requirements shown in this table. When you select this option, the system will only update existing stock items.
Required fields are noted with an asterisk (*).
Field Order
 
Field Description
Maximum Length
Column Position
(Fixed-Length Format)
Data Type
1
* Stock Number
50
1
Char-Caps
2
* Stock Location
50
51
Char-Caps
3
Vendor Number
50
101
Char-Caps
4
Price Break 2
14
151
Numeric
5
Price Break 3
14
165
Numeric
6
Price Break 4
14
179
Numeric
7
Price Break 5
14
193
Numeric
8
* Price 1
14
207
Numeric
9
Price 2
14
221
Numeric
10
Price 3
14
235
Numeric
11
Price 4
14
249
Numeric
12
Price 5
14
263
Numeric
13
Non-MLI Location of Stock
50
277
Character
 
 
Published date: 07/14/2020