Mass Update Sale Price via excel?
Hi all,
Can anyone tell me or link to me an excel sheet/guide where I can mass update pricing?
I want to run a sale on goods from 19/02 to 03/03, but going in and editing each items sale price, start date, end date will take way too long on their new system, it must hang for like 3 minutes per product before you can confirm the changes and I'm not sitting here for 3 hours to put in discounts.
Mass Update Sale Price via excel?
Hi all,
Can anyone tell me or link to me an excel sheet/guide where I can mass update pricing?
I want to run a sale on goods from 19/02 to 03/03, but going in and editing each items sale price, start date, end date will take way too long on their new system, it must hang for like 3 minutes per product before you can confirm the changes and I'm not sitting here for 3 hours to put in discounts.
4 replies
Seller_hOZNPw7G8FIjl
Yes you can but only if you are on the Professional Selling plan.
Run an inventory report and also download the Price & Quantity template file.
Copy and paste all SKUs and stock quantities from the inventory report into the P&Q template file and enter your new prices.
Save the file as a txt file and upload the file in Manage Inventory > Add Products via upload.
When your sale is over enter you normal prices n(and revised stock quantities in your P&Q file. Save the file as a txt file and upload the file in Manage Inventory > Add Products via upload.
Seller_hOZNPw7G8FIjl
No it won't. But even if you enter a sale price manually Amazon does not cross out the old price and show % off any more. I've just tried it.
The only way to get it to show % off is to use the list price field (enter here your old price) and put the lower price in the normal price field.
Sarah_Amzn
Hello @Seller_h0c55MyYPN1YW,
This is Sarah from Amazon.
Following @Seller_hOZNPw7G8FIjl 's suggestion, were you able to upload the products successfully?
Specifically, I'd like to know if the suggested method was successful and, if so, whether it resulted in any time savings or improved efficiency.
Regards,
Sarah.
