In this guide, we will review how you can upload larger amounts of product offers to the campaigns available on the eMAG Marketplace.
First of all, access the eMAG Marketplace platform and log in to your seller account.
The see the available campaigns on eMAG Marketplace, go to the Promotion menu, and select the Campaigns section. Here you can upload a large number of offers in bulk using an .xls file.
In the open area, access the Campaign Proposals button. It will take a few minutes for the template to be generated, depending on the number of products in the offer, the internet connection, or the degree of loading of the platform.
After generating the template, the Campaign Proposals button will turn red. Only now will you be able to download the campaign file with all your active offers on the eMAG site.
Depending on the browser used, the file can be saved automatically or you can save it yourself, with the name you want, but keeping the .xls file extension.
It is mandatory to use this file type to participate in the campaign and not to have errors in the process of adding offers. Any other type of uploaded file will generate its rejection and by default the products in the file. When you open the file, you should know that in columns A to F and O to V, but also in rows 1 – 5 you are not allowed to change anything.
The template contains two additional pages at the bottom side of the screen: Instructions and Data definition regarding each field information of the file. Use them to find out more details.
You will only upload in the file the offers you want to propose for the actual campaign. If there are offers you do not keep for the campaign, you can delete them by selecting the lines – right-clicking on your selection – and pressing delete.
For the products you will register in the campaign, you will fill in the details of the offers during the campaign – in columns G – K and after the campaign – columns L – N, even if it seems that there is already text in them:
- In column G – Campaign ID – The ID of the campaign in which the offer will be available. You must enter the ID of the campaign in which you want to participate with your product offer. You can check the campaign IDs on the Active Campaigns tab or in the ID column in Promotions – Campaigns menu.
- In column H – Sale price – you will complete the sale price of the product, during the campaign.
- In column I – Prior price – you will enter the base price here. It will appear cut on the product page and will represent the price from which the discount was applied. When adding the sale price and the prior price, please keep in mind our new pricing and price indicating guidelines, details of which can be found here.
- In column J – Stock – you do not need to complete the stock coloumn. This field is only required for the Black Friday campaign. The other campaigns will automatically take over the stock quantity specified for the products on the platform.
- In column K – Maximum quantity per order – you must fill in the maximum number of identical products that a customer can buy in a single order. The value must range from 1 to 4. This field is only required for ‘In Stock’ type campaigns.
- In column L – Post campaign product price – you will fill in the sale price, which will be displayed after the campaign.
- In column M – Post campaign prior price – you will fill in the base price (the one that is crossed) after the campaign.
- In column N – Post campaign offer’s avaliability – fill in the value 1, if you want the products in this file to be sold only in the campaign.
We remind you that the prices filled in here must not include VAT, and the price format accepts up to 4 decimal places (100,0000).
We just finished filling in the file. You can now save it in a location you can easily access with any name you want as long as you keep the file extension .xlsx.
Access the campaign from the Promotion menu, the Campaigns section, by pressing the blue Campaign details button. Now press the green, XLS upload button. Select the file you just filled in (or use drag & drop option) and press Upload. When the successfully uploaded message appears, click Close.
You will see the status of your import as In progress. But, in a few moments it will change to one of the following statuses:
- Import succesful: if you followed each step successfully and none of the offers have errors.
- Partial import: if your file was successfully imported but at least one of the offers has an error. In this case, you have to download the file that contains only those products that have been rejected, by clicking the Report button in the Actions
- Import failed: occurs when all the offers in the file were found errors. In this case, you have to download the file that contains only those products that have been rejected, by clicking the Report button in the Actions
- Invalid file: means you have deleted or inserted one or more columns, changing the table from the file, entered formulas or calculation functions or you used an older version of the file than the one currently used by the platform. You must download the file again, fill it in exactly the way it is and upload it back to the platform.
To check the errors occured during the uploadings, you can download the file which contains all the rejected products, using the Generate campaign offers file button, in the Rejected offers column. When it turns red, press it again and download the file with the rejected offers.
In the downloaded file, in the (P-V column) section, you can check which offers need to be changed to upload them successfully, and exactly the type of reason why your offer was rejected in the campaign. Correct the offers that ran into an error in the template file and re-upload the offers to the campaign. If your offer does not meet the pre-set campaign criteria, it will remain available on the interface as a regular (non-campaign) offer.
You can also upload a new product offer that you have not yet uploaded to the Campaign until you have finished uploading your offers.
If you need help with uploading your campaign offers, please contact us through the MessageCenter choosing Campaign Info sub-category under Seller performance type.
Keep up the good work!
