Case study · Shopify automation
Client: An Australian irrigation products retailer · Platform: Shopify · Catalogue: 3,435 products (15,434 variants) · Built: a 3-step checked price update
The challenge
Supplier price rises were being applied by hand. Over time, the prices on the website drifted away from the business’s own price list. When one supplier renamed 47 of its product codes, 14 price changes quietly never made it to the shop.
What I built
1
Links each line of the price list to exactly one item in the online store, so a price can never land on the wrong product. Some product codes appear on two different products, so this mattered.
2
Reads the supplier’s new price list and updates the business’s own price list, even when the supplier has renamed a part. Every change is recorded with the old price beside it.
3
Builds the update for the online store from the price list, then compares the store before and after. That proves the right prices changed and nothing else moved.
Updates go into the Shopify store through its normal bulk import. Anything unusual, such as a big jump or a price at or below cost, is held back for a person to decide, and a copy of the store taken beforehand means any change can be undone.
The results
133
prices updated in one run
104
out-of-date shop prices caught and corrected
0 of 43
untouched items changed (in testing)
Each supplier update now flows through one checked process, and anything that looks wrong is stopped before a customer sees it. One item that had been selling at $9.00 instead of $59.00, below cost, was found and fixed along the way.
Free, no-obligation
If your team spends hours updating products, prices or orders by hand, let’s find out what can be automated. The first chat is free.
