Update using a Spreadsheet Export file. The input file should have been created using an export function of your spreadsheet database. The expected file format is text with the fields delimited (separators) by the tab character. The fields for each record (line) are in the following order: Inventory Item # (part no) Product Barcode number Store PLU # Product Description (max 60 chars - excess over 30 goes into Extra line 1) Vendor Abbrev. (max 8 chars - should match A/P vendor code) Category (max 4 chars - match an O/E category code) Units of Measure Unit Cost Unit Price for level #1 (inventory P1 price) Unit Price for level #2 Unit Price for level #6 Weight per carton (numeric lbs only) Location Vendor Part number Update Mode The Inventory is updated as follows: If Add New part numbers is checked, a new item is set up in the Inventory Master using the information above. If not in add mode, an error is printed on the report. The barcode is put into the Extra line #3 of primary PN's. If the Add-cross reference is checked, any barcodes not already set up will be added as a cross reference item to the Inventory Item. The description is put into the Description and extra line# 2. The category, location, U/M, unit weight, vendor, vendor PN, and 3 price levels are put into the inventory master corresponding fields. The Unit Cost is never updated (changed) for existing PN's but is put into newly added PN's. Note that a report option may be run to show all items in the input file that do NOT match the Inventory unit cost.