Importing discounts
- Name
- Status
- Valid from
- Valid to
You can find an example of a discount import .csv spreadsheet with all the headers here.
Below is an overview with descriptions and instructions for each header (column), which you can select in your imported file, and how/what to write in the .csv spreadsheet.
GENERAL | |
---|---|
Name | One of the most important information that is required in each import. Names can contain letters, numbers, text symbols and spaces. |
Note | Used as tooltips in the front-end view to describe the discount. A description can contain letters, numbers, text symbols and spaces |
Promo code | Use only alpha-numerical characters and/or dash. Min. length: 3 characters. |
Number of uses | The number of times a promo code can be used (example: 20). |
Number of uses per contact | The number of times this promo code can be used by a registered user (example: 5). |
Minimum cart sum< | Total value of all products in the cart. Enter the value without currency symbols (example: 50). |
Minimum quantity in cart | Minimum quantity of targeted items in cart (example: 250). |
Status | For a discount promotion to be functional, it must be Enabled. To activate a discount, set the status to Enabled. To deactivate a discount, set it to Disabled. |
Valid from | Enter the discount start date in the following format: YYYY-MM-DD HH:MM:SS |
Valid to | Enter the discount end date in the following format: YYYY-MM-DD HH:MM:SS |
Show in grid filters | 1 - checked (YES), 0 - unchecked (NO) |
Locked | 1 - checked (YES), 0 - unchecked (NO) |
DISCOUNTS | |
Discount percent | Enter percentage discounts without percent symbols (example: 50). |
Discount amount | Enter discount amounts without currency symbols (example: 50). |
Cart discount percent | Enter percentage discounts without percent symbols (example: 50). |
Cart discount amount | Enter percentage discounts without currency symbols (example: 50). |
FREE ITEMS | |
Number of payable items | Set the required quantity at which free items are available. |
Number of free items | Set the number of free items, which the customer will receive. |
SHIPPING | |
Free shipping | 1 - checked (YES), 0 - unchecked (NO) |
Shipping discount | Enter discount amounts without percent symbols (example: 50). |
TARGETS | |
Apply to all products 1 | 1 - checked (YES), 0 - unchecked (NO) |
Products | Find respective product IDs in Catalog -> Products-> ID. To target multiple products, separate product IDs with the “|” separator (example: 101|102|103|104). |
Brands | Find respective brand IDs in Catalog -> Brands -> ID. To target multiple brands, separate brand IDs with the “|” separator (example: 1|2|5). |
Specific categories | Find respective category IDs in Catalog -> Categories -> ID. To target multiple categories, separate category IDs with the “|” separator (example: 425|426|427|408). |