Required Fields to import a product file.
Column A – Promotion ID (The ID of the promotion you wish to add the product(s) to. See Reports / Listings / Promotions Listing to see the ID for each promotion)
Column B – Barcode (The barcode of the product to add to the promotion)
Build Import Promotions File
- There are four(4) steps:
Step 1 - Create each Promotions in the promotion’s module. See link to How to Create a Promotion
Step 2 - Get a list of promotions.
- To do this go to Reports--> Listings--> Promotion Listings Report
- The Report Displays:
- Promotion ID: - this is the ID that needs to be copy and pasted into the CSV file being created to import the promotions
- Name - - this is the ID that needs to be copy and pasted into the CSV file being created to import the promotions
Step 3 – Create Import file.
-
Example – Revive Range 30% Off (from the diagram above)
-
The structure of the CSV file to build is
- column A - the promotion ID
- Column B - the bar code to be linked to the promotion.
-
In the example below we have taken the promotion ID for revive vitamin range
-
In column A We have put the revive promotion ID in all of the lines that cover the revive product barcodes in column B.
Step 4 – Import file to link products to each promotion.
-
Sign into the Back Office
-
Go to 'Product Imports'
- Set the 'Import Type' to 'Promotions File'
- 'Select File'--> Click 'Choose File' and import the file. Your screen will look like the below
-
The system checks that each product has no errors.
-
When it has completed it shows a summary of what you have done on the screen this includes:
-
The Barcode added to the promotion
-
The Product - each product added to that promotion
-
Status - It will show the status of 'added'
-
-
Review the Promotion in the Promotions Module.
-
If you want to check what has been imported against the promotion, then go to:
-
Back office-->promotions, open the promotion that you want to check, and it will show the following:
-
Description - The name of the promotion.
-
Start date - The start date of the promotion.
-
End date - The end date of the promotion.
-
Product name - The product added to the promotion.
-
Retail price - the retail price it will sell at in the promotion before the promotion being applied.
-
-