...
Each row of the CSV file will correspond to a unique Promotion Code. The following fields should appear as columns on the CSV file, in the order listed. Fields marked with * are mandatory.
| Column/Field name | Data TypeDescription |
|---|---|
| Promotion Code | Unique value |
| Description | Short description of promotion |
| Start Date | dd/mm/yyyy |
| End Date | dd/mm/yyyy |
| *Promotion Type | WO = Whole Order Discount; PG= Product Group Discount; PC = Product Code Discount; FF = Free Freight Discount |
| Product Parameter | for Product Code or Product Group Types |
| Discount Percent | (before tax) |
| Discount Amount | (before tax) |
| Discount Threshold | (before tax) |
| *Discount Threshold Type | DD = Dollar Discount; QD = Quantity Discount; QDM = Quantity Discount Multiples;DDM = Dollar Discount Multiples |
| *Discount Action Type | A = Add To Any; O = Override Any; OIM = Override If More Than Current;Blank for Free Freight Discount Promotions |
| Discount Charge Type | The charge type created on the sales order in PRONTO (can be left blank, or assigned a value of 0-9) |
| Discount Charge Description | The charge description created on the sales order in PRONTO |
| Carrier Code | for Free Freight Type |
| User Usage Limit | 0 = unlimited; default is unlimited |
| Global Usage Limit | 0 = unlimited; default is unlimited |
| Apply With Charge Line | true/false |
| Mode | B2B; B2C; Both |
...