Minimum Requirements for the Order Import Tool
Tab delimited or Comma delimited (csv)
1 File to contain all data for multiple orders.
One Row per SKU Order Item
The first row must contain column headings with no spaces and no special characters. Underline character is accepted.
Each row or First Row of Order should contain Order Header and Customer information as needed.
You can use the following names as column headings, but that is not required.
OrderNumber (unique order number from your system)
CustomerCode (the same value as in PERFECT FIT, to link the Order to the Customer. If not found in PF data, can trigger a new customer insert. There are other options with preference settings.)
SKU (Stock Keeping Unit as stored in PF, aka PFSKU)
Quantity (how many units for each SKU on the order.)
Those are the ONLY required fields.
Additional fields that are commonly added:
These can be imported, or hardwired during the order insert
… and any other fields you see on the order windows.
You have the option of Inserting a new customer, rather than looking up by CustomerCode.
In that case, the SoldTo and ShipTo and SoldToEmail fields are required,
Revised by AG; 12/13/2019