Practical guide · limited beta · English

How to compare costs when one Shopify product has multiple suppliers

A single Shopify product cost cannot preserve every vendor quote, effective date and invoice price. Keep the vendor-specific evidence outside that one field, then compare the documents before deciding whether the current inventory cost should change.

Keep these fields for each supplier

• Your catalog SKU or barcode.
• The supplier's own item code.
• Supplier name and currency.
• Unit price and the date from which it applies.
• Purchase-order quantity and agreed price.
• Invoice quantity and charged price.

Normalize before comparing

1. Map each supplier item code to one catalog SKU. Leave uncertain matches unresolved.
2. Parse decimal separators and currencies explicitly; do not treat 12,50 as 1,250.
3. Compare the invoice with the price list or PO that was valid on the invoice date.
4. Separate a price mismatch from a currency mismatch, duplicate line or quantity difference.
5. Keep the source rows so someone can verify every flag before contacting the supplier.

When a spreadsheet stops being enough

A spreadsheet can work for a few products and suppliers. It becomes fragile when supplier codes differ from catalog SKUs, price lists change, invoices contain repeated lines or several currencies are involved. The first useful automation is a repeatable exception report, not an automatic overwrite of Shopify costs.

Try the structured-data check

OPP-008 compares catalog, supplier price-list, invoice and optional purchase-order rows. It flags price, currency, duplicate, quantity and uncertain-match cases. It does not update Shopify or approve invoices.

Open the free browser checker

Accepted today: CSV, TSV and tabular JSON, up to 2 MB and 5,000 rows per file, on verified desktop Chromium. Files are processed locally in the browser and are not intentionally uploaded. Results require operational verification. Privacy information.