How to Update Supplier Costs and Product Prices in Shopify
A supplier price update is the work of bringing new supplier costs into your own systems and deciding how they affect what you charge. Done well, it means matching each item in the supplier’s price list to your products, updating cost prices, recalculating selling prices to protect your margins and applying the changes on the right date.
Price lists arrive in every format and at awkward times, often covering hundreds or thousands of items. A repeatable process keeps those updates fast and accurate, so you don’t sell below cost or leave old prices on your store for weeks.
What a Supplier Price Update Changes
A supplier price update can change two different prices, and keeping them separate is the key to getting it right. Your cost price is what you pay the supplier, while your selling price is what customers pay you.
| Price | What it is | What a supplier update does to it |
|---|---|---|
| Cost price | What you pay the supplier per unit, sometimes stored per supplier | Changes directly to the supplier’s new price |
| Selling price | What customers pay in your store or on marketplaces | Changes only if you decide to pass the cost change on |
| Compare-at or list price | A reference price shown next to a sale price | May need adjusting so sale displays still make sense |
| Margin | The share of the selling price you keep after cost | Shrinks or grows if costs change but selling prices don’t |
Many systems let you update cost only, or cost and selling price together. Updating cost alone keeps your shelf prices steady but changes your margin, while recalculating selling prices from a markup or margin rule keeps the margin steady but changes what customers see.
How to Process a Supplier Price Update
Whatever system you use, the same steps keep a price update accurate. Work through them in order, since each one depends on the last.
1. Check the price list
Confirm the list is current and complete before you use it. Note the date it was issued, the date the new prices take effect, the currency and the unit each price refers to, such as each, case or pack.
Unit and currency mismatches cause some of the most expensive mistakes. A case price entered as a unit price, or euros read as dollars, can make products look wildly cheaper or more expensive than they are.
2. Match supplier items to your products
Map each line in the supplier’s list to a product or variant in your catalog, ideally using a shared identifier such as your SKU, the supplier’s part number or a barcode. Matching by product name alone is unreliable, since names change and small differences are easy to miss.
Sort the results into three groups. Changed items are products you already sell with a new price, new items are products in the list you don’t carry yet, and discontinued items are products you stock that no longer appear on the list.
3. Review the changes before applying them
Compare old and new costs side by side and look for anything unusual. A spreadsheet column showing the percentage change for each item makes outliers easy to spot, such as a price that doubled or dropped to zero.
Check outliers with the supplier before accepting them. A typo in a price list is much easier to fix before it reaches your store than after customers have ordered at the wrong price.
4. Update cost prices
Apply the new costs to your products, keeping supplier-specific costs separate if you buy the same item from more than one supplier. Shopify, for example, stores a cost per item for each variant, which feeds its profit reporting, and that field can be updated through a product CSV import.
5. Recalculate selling prices
Decide how each cost change affects what you charge, using the rules in the next section. Then calculate new selling prices for the products you’re changing and review them before they go live.
6. Apply the changes on the effective date
Timing matters as much as the numbers. Raising prices too early can cost sales, while applying them late means selling at the old price after your costs have gone up.
Prepare the update in advance and apply it when the new costs take effect. Some inventory and purchasing systems support future-dated prices that switch over automatically, while stores without that feature can schedule the import for the right day.
7. Handle new and discontinued items
Decide whether to add new products from the list, and set their selling prices with the same rules as existing items. For discontinued items, stop reordering them, sell through remaining stock or remove them from sale, and update any purchase orders that still reference them.
How to Decide on New Selling Prices
A clear pricing rule turns each cost change into a selling price quickly and consistently. Most stores use either a target margin or a markup, and the two produce different prices from the same cost.
| Rule | Formula | Example with a $20 cost |
|---|---|---|
| Target margin of 40% | Selling price = cost ÷ (1 − margin) | $20 ÷ 0.60 = $33.33 |
| Markup of 40% | Selling price = cost × (1 + markup) | $20 × 1.40 = $28.00 |
Confusing the two is a common pricing mistake. A 40% markup gives a margin of only about 29%, so make sure everyone involved knows which one your rule uses. A few more decisions then make the rule practical:
- Rounding. Round calculated prices to your usual price endings, such as .99 or whole dollars, so new prices look consistent with the rest of your store.
- Thresholds. Decide whether very small cost changes should change your selling price at all, or only update your recorded cost.
- Competitive pricing. For price-sensitive products, check competitors before passing on a full increase, and accept a lower margin where it makes sense.
- Supplier pricing policies. Some suppliers set minimum advertised prices, so check that new prices still follow any policy you’ve agreed to.
- Sale prices. If a product is on sale, update the compare-at price as well so the discount shown stays accurate.
Ways to Apply Supplier Price Updates
The right method depends on how many items change and how often. Most stores combine more than one approach as they grow.
| Method | How it works | Best for | Watch out for |
|---|---|---|---|
| Manual edits | Change each product’s cost and price by hand | A few products | Slow and easy to get wrong at volume |
| From purchase orders or invoices | Save the cost from a purchase order or booked supplier invoice as the product’s new cost | Keeping recorded costs in line with what you actually pay | Usually updates cost only, not selling prices |
| Spreadsheet import | Edit an export or the supplier’s file, then import it with an option to update existing products | Price lists covering many products | Wrong column mapping or overwriting fields you didn’t mean to change |
| Bulk price rules | Raise or lower prices by a percentage for a filtered group of products | Across-the-board increases from one supplier | Ignores item-level differences in the supplier’s list |
| Scheduled imports | Fetch and apply the supplier’s file automatically on a schedule | Suppliers who send regular updates | Needs validation so a bad file doesn’t update prices unchecked |
For spreadsheet imports, include only the columns you need, usually the product identifier, cost and selling price. Leaving out descriptions, images and other fields prevents an import from overwriting data you didn’t intend to change.
Supplier files rarely match your store’s columns, which is why field mapping matters so much for regular updates. Bulkflow supports bulk import, field mapping, updates to existing records and scheduled data updates for Shopify, WooCommerce and Wix, which suits applying supplier price files without reformatting them each time.
Common Supplier Price Update Mistakes
Most pricing errors come from a handful of avoidable slips. Watch for these each time you process a price list:
- Updating cost but forgetting selling prices. Margins quietly shrink until someone notices in a monthly report.
- Mixing up units or currencies. Case prices, pack sizes and foreign currencies need converting before you update anything.
- Matching on names instead of identifiers. Similar product names lead to prices landing on the wrong items.
- Applying changes on the wrong date. Early increases cost sales, and late ones cost margin.
- Accepting every change without review. A single typo in a price list can price a product at a fraction of its cost.
- Ignoring other channels. Marketplaces, feeds and wholesale price lists may need the same update as your store.
- Skipping a backup. Without an export of the old prices, reversing a bad update is slow and uncertain.
Make Price Updates a Routine
Supplier price updates get easier when they follow the same routine every time. Keep a calendar of when each supplier usually sends new lists, and ask suppliers for files in a consistent format with the identifiers you match on.
Save your column mappings and pricing rules so each update starts from the same setup. Test changes on a small batch or a copy of your data first, as many inventory systems advise, then keep a record of what changed and when.
That record pays off later. It lets you track how supplier costs move over time, explain margin changes and spot suppliers whose prices rise faster than others.
Conclusion
A supplier price update is more than typing in new numbers: it means matching items carefully, updating costs, recalculating selling prices with a clear rule and applying everything on the right date. With a repeatable process and the right method for your volume, price changes stop being a scramble and your margins stay where you want them. We hope this guide helps you handle every supplier price update with confidence. If you apply supplier files regularly, you can explore Bulkflow.
