A supplier's price increase passed on to one category
Raise 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.
- Difficulty
- Intermediate
- Time
- about 20 min
My supplier [supplier name] has raised prices by [6]%. Raise the regular price of every product in the category [category] by the same, rounded up to end in [.90]. For variable products, change each variation. Leave out anything that is on sale right now and tell me which those are. Show me a table with the old and the new regular price and wait for my approval. If there are more than 50 items, split them into batches.
Already connected?
If SAR is already in your AI app, this is enough:
Raise regular prices in [category] by [6]%, ending in [.90]; leave out products on sale and show me the table first.
What happens
- The AI app exports the category's products with their prices, and reads the variations of variable products.
- The 30-day lowest price check lists the products on sale, so they are left out. A regular price raised just before a discount is what that check flags, so keep it in mind for your next sale.
- It works out the new prices with your rounding and shows them to you in a table.
- Each batch of up to 50 products or variations is one change you approve once in SAR. 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_variationsProduct variationsNonewordpress_omnibus_check30-day lowest price checkNonewordpress_woo_bulk_update_productsChange many products at onceApproval
What you get
The new prices in place across the category, and a table of old and new prices to keep for your records.
Related recipes
- 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 25 minPrices edited in a spreadsheet and applied back to the shopExport 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.
- Shop · about 30 minA clearance sale on products that have stopped sellingFind products with stock that sold little or nothing in recent months, and put the ones you pick on clearance in one change you approve once.
Try it on your own site
Install the plugin, add SAR to your AI app and paste the prompt. Free to start.