From my experience working with many clients, I often see how chaotic pricing and inventory management at Emag results in losses – both financial and image. One simple mistake, like failing to update inventory, can end up with canceled orders and dissatisfied customers. That’s why mastering the file update process is the key to effective sales.
Table of contents
File generation
We start the process of updating inventory and prices by logging into Emag and going to the “Import from Excel” tab.
Then click “Update Offers”.
and wait for eMAG to generate a file with the current offers for us to download.
Generation:
Once the file is generated and downloadable then instead of the spinning icon we will see an arrow and the button will turn green. Then we press the same “Update Quotes” button again and download the file.
After downloading the document, you will get a file with a table that contains the auction name, brand name, product code: PNK, EAN information about selling price, currency, stock, etc.
Changes in prices, inventory, etc.
If you want to change prices and, for example, inventory, then:
- First, we need to find the products we are interested in and leave only those products subject to change in the file (by removing rows with redundant products). This can be done in several ways, such as through the “search vertically” or “mark duplicates” function, e.g. after adding the corresponding eans of the products to be changed, in the eans column.
- In the appropriate columns we make changes to the price, stock – note here that with prices we use dots, not commas, and the data entered is formatted as text/general, not numeric.
- We remember that in the file we enter NET prices. eMAG itself adds 19% VAT.
- In addition, when changing prices, pay attention to whether they are within the range specified by the PRICE VALIDATION columns – if our prices are lower or higher than indicated in these columns – you should correct the rates in the Price Validation columns – otherwise eMAG will not approve them.
- Once we have made all the changes in the file, we save the file on the computer
XLS import
After saving the file on your computer, open eMAG again and click Import XLS
A new communication window will appear for us and we click in them Drop files here to load:
Search for the appropriate file on your computer and attach it then click add
A message should appear: Upload performed with success.
At this point, we can close this window, and our attached file will show up at the top of the list with the appropriate status, e.g. “in processing”
If all changes save correct, you will get the message “Imported successfully” , and in the column next to “Reprocessed” we will get the result of how many offers have been successfully changed
Check that the number of changed products matches.
If the number of changed products agrees, it means that the task has been done correctly. If there is an error, we will have the opportunity to download the file and verify the error.
Summary
Changing prices and inventory by file on Emag is a basic but very important part of successful sales on this platform. By learning the update process, preparing the correct file and implementing regular changes, you gain full control over your offer and increase your chance of success. If you would like someone to help you implement this procedure, optimize the process and avoid mistakes, I invite you to take advantage of our free consultation. We will help you develop your sales on Emag faster and without stress.
