Prices edited in a spreadsheet and applied back to the shop
Export SKUs, names, prices and stock to a CSV, edit them in your spreadsheet, and have the changed rows applied in batches of up to 50.
- Difficulty
- Intermediate
- Time
- about 25 min
Export my published products with [SKU, name, regular price, sale price and stock] as a CSV I can open in [Excel]. I'll edit it and paste the changed rows back here. Then match them by SKU, show me only what differs from the shop now, and apply the changes after my approval, in batches if there are more than 50.
Already connected?
If SAR is already in your AI app, this is enough:
Export SKU, name, prices and stock to CSV; when I paste back my edits, apply only what changed.
What happens
- The AI app exports the products with the columns you chose: a download link valid for one hour, and the CSV itself when it is short. Cells that look like spreadsheet formulas are neutralised.
- When you paste back your edited rows, it finds each product by SKU, reads variations where needed, and shows you only what differs.
- Each batch of up to 50 products or variations is one change you approve once. Every item is checked before anything changes, and each can be undone on its own.
Approvals involved
Worked out from the tools this recipe uses.
wordpress_woo_export_productsExport products to CSVNonewordpress_woo_list_productsList productsNonewordpress_woo_list_variationsProduct variationsNonewordpress_woo_bulk_update_productsChange many products at onceApproval
What you get
Your price list kept in the spreadsheet you know, with the shop following it.
Related recipes
- Shop · about 20 minA supplier's price increase passed on to one categoryRaise the regular price of a category's products by a percentage, with your rounding, in batches of up to 50 that you approve once each.
- Shop · about 15 minLast season's colour discounted, with sold-out sizes switched offPut one colour of a product on sale across its sizes and stop offering the sizes you no longer have, without touching the other colours.
- Shop · about 30 minYour stock-take counts applied to the shopPaste the quantities you counted by SKU, see where the shop disagrees, and set the right stock for up to 50 products or variations per approval.
Try it on your own site
Install the plugin, add SAR to your AI app and paste the prompt. Free to start.