For teams that run on WooCommerce
WooCommerce lowest price 30 days before a sale
Under the EU rules on price reductions, a discount is compared with the lowest price of the 30 days before it. WooCommerce keeps the current regular and sale price, not their history, so shops add a plugin that stores every price change in their own database, or keep a list by hand.
How it goes today
- Keep a spreadsheet of price changes per product.
- Look up the lowest price before each sale.
- Compare it with the old price shown in the shop.
- Lower the regular price where it was raised just before.
How it can go
Know the lowest price of the past 30 days before a sale goes live.
Every day the regular and sale price of each product and variation is written to a price log outside your shop, from the day you start. Before a sale starts, and each morning while it runs, you get a list per discounted product with the lowest price of the 30 days before it, and the products where the price shown as the old price is higher than that.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your WooCommerce key in the portal, never in the chat.
With Hypamoon, every day, log the regular and sale price of each WooCommerce product and variation. For each product with a sale price, or a sale date coming up, tell me the lowest price of the 30 days before the sale, and list the ones where the regular price is higher than that lowest price. Email me the list each morning.
You create the WooCommerce key yourself under WooCommerce, Settings, Advanced, REST API. It stays yours.
More for teams on WooCommerce
- I want orders to show as shipped, with a tracking link for the customer.
- Many of my customer emails ask where their order is, and I look each one up.
- The low stock email comes too late for a supplier with a four week lead time.
- When new stock arrives I edit every product in WooCommerce by hand.
- I want one page per customer with every order, the total and their favourite products.
- I want to know my repeat purchase rate and my sales per country.
- Business customers ask me for a proper PDF invoice of every order.
- Every month I export the orders and clean up the file for my bookkeeper.
- Our B2B customers email PDF purchase orders and we retype each one.
- I want the sales of yesterday by email, without logging in.
- I want to raise the prices of a whole category without opening every product.
- I want to ask customers for a review a week after their order arrives.
- I want to set a date for a product to go offline or back in stock.
- Customers who first ordered as a guest don't see those orders in their account.
- A bot placed hundreds of fake orders overnight and I cleared them one by one.
- We run two WooCommerce shops and I update the stock in both after every sale.
- Our shopping feed keeps refusing products because the GTIN field is empty.
- Our regular customers order the same every week and I type it in again each time.
- Every week I clean up the supplier's CSV before I can import it.
- I have to set the photo for each colour variation one by one.
- Before each class I build the attendee list from the orders and email everyone.
- I want to tell customers their local pickup order is ready to collect.
- I add up our sales per state in a spreadsheet to see where we are getting close to nexus.
- We have thousands of old coupon codes and no safe way to clear them.
- I need 300 unique single-use discount codes for an event.
- I copy each order to the supplier who ships it and wait for the tracking code.
- When I sell one product, the stock of the other product should go down too.
- Each quarter I split our WooCommerce sales per EU country and VAT rate for the OSS return.
- Every morning I compare the bank statement with the WooCommerce orders on hold.
- I keep a spreadsheet of what each business customer owes us.
- Each month I work out in a spreadsheet what each consignor sold and what we owe them.
- Each month I work out the commission per influencer code by hand.
- Every day I copy the options and names from each order onto a production sheet.
- I open every order and write down what to pick.
- When a backorder is delayed I email each waiting customer by hand.
- I message every cash on delivery customer to confirm before I ship.
- Our business customers want an e-invoice, so I retype each order in our accounting package.
- At the end of the year I make a donation statement for each donor from our WooCommerce orders.
- Our webhook was off for weeks before we noticed orders had stopped coming through.
- I track the open core charges in a spreadsheet and refund each one by hand.
- Everything for WooCommerce