This text file layout is used by the Load External Price File (5.6.2.3). The text file can be produced automatically, but will generally need to be prepared in Excel.
The filename must end with a .TXT extension.
All of the fields (if present) will be added to new part numbers and/or new units of measure. For existing part number/units of measure, only prices will be loaded (unless optional fields are selected in field 16).
The only exception is UPC Code, which will always be updated if the UPC does not exist in the INVENTORY,BAR.CODE file. And, it will become the primary UPC for the part number unit of measure being updated.
Costs and prices may be in any order; during the import you will specify which price codes to update for Price 1 through 6. You do not have to fill all 6 price fields in the file data.
Prices may contain decimals, but if absent, the program will assume 2 decimal places (MR2). Examples:
| Raw | Converted |
| 12586 | 125.86 |
| 125.86 | 125.86 |
Unit Weight will assume 4 decimal places (MR4). Examples:
| Raw | Converted |
| 17682 | 1.7682 |
| 25.4 | 25.4000 |
Important Note: the Part Number (field 1 below) should not contain the Mfr Code unless you are using the Multiple MFR option for one vendor. The Mfr Code will be entered in the Load External Price program.
The text file must contain TAB-delimited fields in the following order:
| Inventory Price File Layout | Updated: 7/5/2017 | Load External Price File (5.6.2.3) | |
| # | Spreadsheet Column | Field | Note |
| 1 | A | Part Number | 20 characters max including the Mfr Code entered in the Load External Price program and a period. Must be formatted as Text column type in Excel. |
| 2 | B | Unit of Measure | BLANK will default to EACH |
| 3 | C | Description | 40 characters max |
| 4 | D | Inventory Notes | 50 characters max |
| 5 | E | Standard Pack | Whole number with no decimal point |
| 6 | F | UPC Code | 12 digit UPC bar code or other code, 12th digit will be stripped. |
| 7 | G | Unit Weight | MR4. (ex. 1.2345) |
| 8 | H | Price 1 | MR2. (ex. 6.78) |
| 9 | I | Price 2 | MR2 |
| 10 | J | Price 3 | MR2 |
| 11 | K | Price 4 | MR2 |
| 12 | L | Price 5 | MR2 |
| 13 | M | Price 6 | MR2 |
| 14 | N | VOC | MR4 - amount must be provided by unit, not lbs/gal |
| 15 | O | Haz Mat Code | ex. NA1234 |
| 16 | P | Custom Type | E=End Product, C=Component, does not write to the file, this is for information only on the exception report. |
| 17 | Q | Group Code | Group Code 1. 10 characters max |
| 18 | R | Group Code 2 | 10 characters max |
| 19 | S | Group Code 3 | 10 characters max |
| 20 | T | Group Code 4 | 10 characters max |
| 21 | U | Group Code 5 | 10 characters max |
| 22 | V | Tax Indicator | Y or N |
| 23 | W | Status | A, I or O |
| 24 | X | Bar Code Case Flag | Y or N |
| 25 | Y | Bar Code Case Quantity | 99999 max |
| 26 | Z | Is Bar Code | Y or N |
| 27 | AA | Vendor Part Number | Recommend 20 characters max |
| 28 | AB | Key Words | Comma separate multiple key words |