Skip to main content

How to bulk change offer prices?


How to bulk change offer prices?

To bulk change offer prices, log in to your seller account in the Mirakl panel and follow these steps:

  1. Go to Price and StockOffers.

  2. In the upper right corner, click the document icon named Inventory File “Ready for Import”.

  3. Choose the XLSX format to start downloading the file with all your offers.

    Remember to always download the file in XLSX format. Files with other extensions will not be imported into the system!

    price1

  4. In the downloaded file, find the price column and update the data.

    price2

    Remember that the system will read the default currency for your account's sales market, regardless of the currency filled in the file.

  5. After making changes, save the file. Do not change its format.

  6. In the Mirakl seller panel, go to Price and Stock, then File Imports.

  7. In the Product File field, select the edited file from your computer and set the following import options:

    • In the File Content section, choose Offer from the dropdown list.
    • In the Import Mode section, select Normal.

    price3

    Note!

    If you change the import mode to Delete and Replace, all your offers will be deleted and replaced only with those available in the file.

  8. To import the file, click the Import button at the bottom of the screen.

To check if the imported file contains errors:

  1. From the left menu, select Price and StockFile Imports.

  2. Go to the Monitor Offer Imports tab.

  3. On the right side of the row for the file, in the Errors column, you can check how the import proceeded.

    price4

Hovering over the icon will show you the details of the process. If errors occurred during the file import, you can download an error report. To do this, click the 𝄙 icon.

  • Correctly imported files will indicate that the number of rows processed matches the number of rows updated.

  • Incorrectly imported files will indicate which rows contain errors.

If an error occurs during import, review the file saved on your computer and ensure all data is correctly filled out according to the above instructions. Then re-import the file. If you do not import the corrected file, some or all products will not be updated with the new prices.

Last update: