This guide shows you how to export and import promotion into effectmanager using an Excel-file.
This guide is only of relevance if you have the promotion module in effectmanager.
If you have corrections to a large number of promotions, you can easily make these corrections using the exporting function in the Reports Module.
In this article, you will find a guide that shows you:
- How to export and import promotions using an Excel file
- How to create new promotions using the Excel file
- How to update promotions using the Excel file
How to export and import promotions using an Excel file
To the top of the article
When you have corrections for promotion and connected products, these changes can be made using our export/import function in the Reports Module.
1. In the Reports Module, navigate to the left side menu and find EXPORTS - Promotions and Products.
2. In the filter on the right side, select your filtering criteria.
You can filter by basic criteria, such as Chain, Category, State, Period, or Dynamic Period. You can add a detail filter, such as Type, Mechanism, or Flag.
Pressing Excel for an Excel.XLSX and CSV for an Excel-CSV file to be exported.
3. Fill out the Excel file with your corrections
Additional instructions on how to use the Excel file to create or update promotions are in the guides below.
4. To update a promotion in effectmanager, you must import your Excel.XLSX file to effectmanager by pressing Browse - Select the file in the pop-up window. Upload the file by pressing Import.
🔴OBS! Importing the Promotions and Products Excel file will block the Promotion Scheduler for all users while the corrections are being imported. We recommend importing the file at the end of the business hours.
5. You will receive an email notification with your import results.
If there are any errors in the mail, your import will only be partially successful, and you will need to address the errors listed in the email.
🔴OBS! Importing the Promotions and Products Excel file will block the Promotion Scheduler while the corrections are being imported. We recommend importing the file at the end of the business hours.
👍 Pro-Tip: You can always check your logs, to see the progress of your imported files.
How to create new promotions using the Excel file
You can create a new promotion using the Excel file.
To create new promotions using the Excel file, you must export a Promotions and Products file. Follow steps 1-2 in the guide above
1. In the exported Promotions and Products file, you must fill out the mandatory fields to import your file.
For a further description of the Excel columns, download our guide: Promotions and Products - Column Description.
🔴OBS! If you correct the headers in row 1, the import will fail.
2. When you have made your corrections, save your file and import it to effectmanager following Steps 4-5 from above
🔴OBS! Importing the Promotions and Products Excel file will block the Promotion Scheduler while the corrections are being imported. We recommend importing the file at the end of the business hours.
How to update the promotion using the Excel file
You can use the Excel file to make corrections to multiple promotions at once.
To make corrections to multiple promotions using the Excel file, you must export a Promotions and Products file. Follow the guide above
1. In the exported Promotions and Products file, you can make corrections to all fields of the promotions.
The most common promotion updates by Excel are:
- Changes in Promotion State - also canceling promotions
- Changes to Promotion Start and End date
- Changes to the Promotion Mechanism
2. When you have made your corrections, save your file and import it to effectmanager following Steps 4-5 from above
🔴OBS! Importing the Promotions and Products Excel file will block the Promotion Scheduler while the corrections are being imported. We recommend importing the file at the end of the business hours.