MenuStart a projectStart

Online shop

Supplier price lists to WooCommerce and Amazon

Supplier price update automation reads each new price list a supplier sends and compares the new costs with what you charge. It suggests prices that keep your target margin and updates WooCommerce and Amazon only for the lines a person approves.

An example of how the studio would build it. No live services are connected.

From a supplier’s new price list to shop prices you have approved.

  1. Step 01

    Price list arrives

    Pick up the supplier’s spreadsheet or CSV file from a Gmail label.

  2. Step 02

    Costs compared

    Match each line to your products by supplier code and compare the new cost with the current price.

  3. Step 03

    Prices suggested

    Write suggested prices to Google Sheets using your margin and rounding rules, with each change highlighted.

  4. Step 04

    Changes approved

    A person reviews the sheet, edits any price and marks the lines to apply.

  5. Step 05

    Prices updated

    Update the approved prices in WooCommerce and on Amazon Seller Central, and log the date of each change.

The result

Margins protected when suppliers change their prices.

Only lines a person has approved are changed, and each change is logged with the old and new price. A price list that matches too few products is stopped for review, in case its layout has changed.

Before we connect it.

Where this is useful

Useful for retailers who resell products from several suppliers and update prices by hand whenever a new list arrives. A sensible first version handles one supplier with a consistent file layout and produces the comparison sheet before any prices are changed.

What we need to connect

  1. 01Access to the Gmail label where supplier price lists arrive, and a sample of each supplier’s file layout.
  2. 02WooCommerce and Amazon Seller Central access to products and prices, with supplier codes stored against each product.
  3. 03Your margin targets, rounding rules, any prices you want to hold and who approves changes.

What needs careful handling

Suppliers change file layouts, column names and codes without warning, so a list that matches poorly is stopped rather than half-applied. Amazon prices interact with fees, competing offers and any automated repricing you already use, so those lines are reviewed with that in mind. Stock already bought at the old cost may justify timing a rise differently, which the sheet leaves for you to decide.

Questions people ask.

Will it change prices without asking?

No. Every suggested change waits in the sheet until a person approves it. Once a supplier’s lists have proved reliable, you might choose to apply small changes automatically, but that is your call.

What if the supplier publishes recommended retail prices?

They can sit beside the suggested price in the sheet, so you can compare the two. The flow only suggests, and the decision on price is always yours.

Stock level dropped → Sent on approval
Automation 50

Shopify low-stock reorder automation

Order received → Picking list built
Automation 52

Etsy, Amazon and Shopify order and stock sync

All automation examples