This text file layout is used by the Load External Price File (5.6.2.3). The text file could be produced automatically, but will generally need to be prepared in Excel.

The text file must contain TAB-delimited fields in the following order:

Important Note: the Part Number (field 1 below) should not contain the Mfr Code. The Mfr Code will be entered in the Load External Price program.

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        (Number with no decimal points)
6. F) UPC Code                (12 digit UPC code or other, 12th digit will be stripped)
7. G) Unit Weight        (MR4)
8. H) Price 1                (MR2)
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, UN1234)
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, 5 characters max)
18. R) Group Code 2        (5 characters max)
19. S) Group Code 3        (5 characters max)
20. T) Group Code 4        (5 characters max)
21. U) Group Code 5        (5 characters max)

All of the above 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.  The lone exception is UPC Code, which will always be updated if the UPC does not currently exist in our INVENTORY,BAR.CODE file. Also, it will become the primary UPC for the part number unit of measure being updated.

The filename must end with a TXT extension.  Costs and or prices may be in any order, during the import of the file 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 raw data.  Prices may contain decimals, but if absent, it will be assumed to be 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