1. Help Center
  2. Bulk Actions and Automation

How to use the Price Update spreadsheet

Learn how to use the Price Update spreadsheet to update the listing price of your items or disconnect the market price from being synced with the Product price.

With the Price Update spreadsheet you can update the listing price of your marketplace listings. 

Alternatively, if you need to update your product prices, use the Product Edit spreadsheet instead. Learn more

Download the Price Update template

  1. Go to Reports > Import/Export
  2. Select the Price Update template > click Download template

Update marketplace listing prices

The marketplaces integrated with your Listing Mirror account begin with Column C.

🚨 Avoid making changes to Rows 1 or 2. Doing so will cause the spreadsheet upload to fail or result in data loss.

🚨 Changing a SKU in Column A will also cause the upload to fail or cause data loss.

 

To update the market listing price, go to the row of the SKU and enter the price in the column of the marketplace you'd like to update.

If a cell is blank, the listing has not been created on the marketplace OR it is set to sync with the price assigned to the Product.

 

Disconnect market prices from being synced with Product prices 

To view market listing prices that are syncing with the Product price, go to Pricing > Manage Pricing > hover over the price the view the setting:

2024-08-15_14-17-29

  • You can disconnect the marketplace listing price from the Product price by manually turning it OFF with the toggle. 
  • To do this in bulk, simply enter a different market price in the Price Update spreadsheet. When the spreadsheet is uploaded, Listing Mirror will recognize the new price and automatically disconnect the market listing price from the Product price. 

To confirm, return to the Manage Pricing page and check the toggle setting. 

⚠️ Entering a price into an empty cell for a listing that has not been created, will not create a new listing.

Updating an empty cell will simply disconnect the marketplace price from being synced with the Product price.