In this tutorial, 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 N to W, but also in rows 1 – 5 you are not allowed to change anything.
Two additional tabs are available in the template file: the Instructions and Data Definitions, where you can find more information about uploading for filling in the field. In the Active Campaigns tab you can view the campaigns that are currently running.
You will only upload in the file the offers you want to propose for the Black Friday campaign. If there are offers you do not keep them 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 Black Friday campaign, you will fill in the details of the offers during the campaign – in columns G – J and after the campaign – columns K – M, even if it seems that there is already text in them:
– In the column G-Campaing ID– you will enter the ID that identifies the campaign, which you can find in the “Promotions – Campaigns” section of the Admin interface.
Black Friday campaign ID: 470
– In column H – Sale price without VAT – you will complete the sale price of the product, during the campaign.
– In column I – RRP – you will enter the retail recommended price.
– In column J – Stock – you will enter the available number of pieces of products that will participate in the Black Friday campaign. The other campaigns automatically take over the inventory quantity of the products specified 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 without VAT, which will be displayed after the campaign.
– In column M – Post campaign RRP– you will fill in the retail recommended price of the product, available after campaign end.
– 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 greem 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 menu.
– 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 menu.
– 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 Feedback (Y 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 Black Friday offers, please contact us through the MessageCenter choosing Campaign Info sub-category under Seller performance type.
Keep up the good work!
