Check Shopify discounts against EU price rules with metafields and Gmail
Go to Workflow
Melbin Francis
Description
Quick overview
In the EU, a discount must show as its old price the lowest price of the last 30 days. Shopify does not keep price history, so this workflow keeps it for you and fixes or flags discounts that break the rule.
How it works
It runs every time a product changes in your shop, and once every night as a safety net.
It reads each product variant fresh from Shopify: today's price and the crossed-out 'was' price.
It keeps a small price diary on each variant inside Shopify itself, so the history stays with your shop and nothing is stored elsewhere.
For every discount it works out the lowest price of the 30 days before the sale started.
If the 'was' price is higher than that, it lowers it to the real 30-day low. If the 'discount' is not really cheaper, it removes the crossed-out price.
If there is not enough history to be sure, it emails you and you choose 'Fix it' or 'Keep it'. One question at a time, no repeat emails while you think it over, and silence is never taken as a yes.
Once you trust it, it can make the corrections on its own and send you one email listing every change and why.
Setup
In the Shopify Dev Dashboard, create an app with permission to read and write products, and use the redirect address shown in the n8n Shopify credential.
In n8n, connect that Shopify app and your Gmail account.
Open 'Price Rules' and enter your shop name (the part before .myshopify.com) and the email address that should receive the questions. Leave automatic fixing off until you have checked a few emails.
Requirements
A Shopify store with a Dev Dashboard app, and a Gmail account.
Customization
In 'Price Rules' you can turn on automatic fixing, change the 30-day window, limit how many questions are sent per run, and decide what happens when history is missing.
Additional info
The price history starts the day you switch it on, so for the first 30 days most discounts will come to you as questions. This helps you follow the rule; it is not legal advice.
This workflow was created by Melbin Francis and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.