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)
You can see this by clicking 'Show File Format' within the 'Product Imports' section
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'
-
-