Skip to content
Canvo / Systems library / Commerce & inventory

Supplier price and promotion update automation

Update ecommerce prices from supplier price lists and promotion sheets. Check campaign dates, eligible variants and approved margin rules, then verify the live price and its expiry.

First workflow from A$4,900 ex GST, with 12 months of support for the agreed implementation. Scope and pricing →

Workflow design · scope to your operation

From trigger to finished work

  1. Supplier offer + price feed
  2. map eligible variants
  3. resolve dates and price precedence
  4. calculate landed cost and margin
  5. compare proposed price
  6. apply approved changes
  7. expire/revert campaign
  8. reconcile live prices

The rules that matter

Use versioned price books, explicit timezone and precedence, approved margin floor, separate rebate eligibility, and idempotent change batches. A newer approved price must not be overwritten by an old rollback.

When the normal path breaks

Overlapping campaigns; expired rebate; missing tax/currency basis; altered SKU; stale cost; bundle components; minimum advertised price terms requiring review.

Uncertain inputs go to an assigned owner with the source, reason and next decision. Failed writes are reconciled before retrying, so a recovered connection does not create a duplicate order, payment or stock movement.

How we would measure it

Preparation minutes/campaign; below-floor prices caught; wrong-price orders; time from approved cost change to channel update.

Sample representative work before the build, including difficult cases. Compare the same task mix after launch; include review, exception handling and system upkeep in the time used.

Start with one accountable slice

Map the first input, the final accepted result and who can approve it. Agree source systems, read/write access, rules, exception ownership and acceptance checks. Run representative normal, failure and recovery cases before expanding across teams.

What makes this suitable for larger teams?

Role-based access, separation of preparation and approval, versioned rules, an action history, duplicate protection, reconciliation, alerts and a named recovery owner. Private deployment or customer-controlled infrastructure can be scoped where needed. These are design requirements to validate, not an unsupported promise of perfect source data or regulatory compliance.

Before you build

Questions about this workflow

Specific answers to help you judge the fit, the information needed and the decisions your team keeps.

Can this work with supplier price lists and promotion sheets?

We first inspect how the supplier identifies variants, currencies, tax treatment, pack quantities and campaign dates. A stable spreadsheet or export may be enough to prepare proposed changes. Publishing prices depends on the store’s supported update path and your approved pricing rules.

How are overlapping promotions and expired offers handled?

We define which approved offer takes precedence for each product and date range. Expiry checks compare the current live price with the change that originally set it. An old promotion should not restore an outdated price over a newer approved campaign or manual change.

Can we stop a supplier update from selling below our margin?

The proposed price can be checked against your approved landed-cost and margin rules before publication. Freight, tax basis, rebates and bundle components need explicit treatment. Missing or stale costs go to review; a spreadsheet discount alone is not sufficient evidence that the resulting price is acceptable.

Can our merchandising team approve changes before they go live?

Yes, the workflow can prepare a batch showing old price, proposed price, effective dates and the reason for each change. Your team approves the applicable scope. Unmatched variants, unusual movements and commercial restrictions can remain blocked while the accepted lines proceed through the agreed publishing path.

How do we know the right prices actually reached the store?

A successful request is followed by a supported readback or reconciliation against the store’s live records. Failed or partial batches stay visible for recovery. The pilot should compare campaign preparation time, incorrect live prices and manual corrections, including the work of reviewing exceptions and expiring offers.

Why this workflow matters

See this in your industry

Connected problems to explore

All systems →