This topic is part of Tips for Exporting Data from Your Old Point of Sale System
Departments
Required:
Department code, department description.
Optional:
Taxable Y/N, Tax Class (if you have items that have different tax rates, for example clothing is 6% and alcohol is 9%.
Sub-Departments
Department Code, Sub-Department Code
Units of Measure
Unit of Measure Code, Description, Factor
Examples:
EA, Each, 1
CASE012, Case of 12, 12
Items
Item Number (See note 10, description, List Price, Average Cost, Qty On Hand, Tax Class, Department Code, Stocking UOM, Selling UOM, Purchasing UOM, SNAP Eligible, Wait for Scale Y/N
Note 1. The full UPC code if possible, including leading and trailing digits)
Item Replenishment
Item Number (must exist in Acme), Reorder Point, Standard Order Qty, Target Stocking Level.
Standard Order Quantity -Can be entered at the item location level. "I'd normally buy 4."
Enter the quantity you think you will normally order. May be trumped by Vendor Minimum Quantity and or Target Stocking Quantity if those numbers or increments are higher. -May be subject to Target Stock Level, Vendor Minimum Quantity and Purchasing Unit of Measure if found.
Target Stock Level -this is an optional "build to" number that only works when its number is greater than the reorder point. "Buy enough to build back up to 10." -May be subject to Vendor Minimum Quantity and Purchasing Unit of Measure if found.
Item Pricing
Provide information for your customer specific pricing, price breaks for quantities, special prices etc. Example:
Price code, price type, item number, qty break1, qty break1 price, qty break2, quantity break2 price, start date, end date.
“Price Type” is usually special, default, customer specific OR mix and match,
Introduction to Exporting POS Data
Exporting Customer Information
