A clearance sale on products that have stopped selling
Find 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.
- Difficulty
- Advanced
- Time
- about 30 min
Find products with more than [5] in stock that sold [nothing / fewer than 3 orders] in the last [90] days. Show me them with their stock and regular price. I'll pick which go on clearance at [40]% off, rounded to [.90]. Wait for my approval, then run the 30-day lowest price check on them.
Already connected?
If SAR is already in your AI app, this is enough:
Find products with stock that haven't sold in [90] days and put the ones I pick at [40]% off.
What happens
- The AI app reads the sales report by product for the period, and exports your products with their stock and prices.
- It lists the products with stock that sold little or nothing, for you to choose from.
- The clearance prices go to SAR as one change of up to 50 products or variations that you approve once; each can be undone on its own.
- The 30-day lowest price check then compares the old price shown with the lowest price of the 30 days before the discount.
Approvals involved
Worked out from the tools this recipe uses.
wordpress_woo_sales_reportSales reportNonewordpress_woo_export_productsExport products to CSVNonewordpress_woo_bulk_update_productsChange many products at onceApprovalwordpress_omnibus_check30-day lowest price checkNone
What you get
Stock that was standing still turned into a clear sale list, with the prices checked.
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 20 minA weekend sale on one category, with the 30-day lowest price shownPut a category on sale in one change you approve once, check the price shown before the discount and show the 30-day lowest price.
- 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.
Try it on your own site
Install the plugin, add SAR to your AI app and paste the prompt. Free to start.