Free · for Shopify sellers · Excel and CSV stay in your browser
Supplier sent a new price list? Update every Shopify price in one import.
Match the supplier's list to your products by SKU, apply your markup, and download a Shopify CSV with the new cost and price filled in. No more updating prices one by one.
Result
In Shopify: Products → Import → choose this file → tick "Overwrite products with matching handles" → Upload and preview. Check the preview before you import.
Changes
In the supplier list but not in your store
How to bulk update Shopify prices from a supplier list
Why export first. Shopify's import overwrites products by handle. Starting from your own export means every other field (titles, images, inventory settings) goes back exactly as it was; only "Cost per item" and "Variant Price" change.
Match on SKU. Put the supplier's item code in each variant's SKU field once. After that, every new price list lines up automatically, even if the supplier reorders it.
Markup vs. margin. A 2× markup on a $10 cost is $20, a 50% margin. A 40% margin on a $10 cost is $16.67 (cost ÷ 0.6). Pick the rule you actually price by.
Check the preview. Shopify shows a preview before the import runs. Spot-check a few products, especially any with big price jumps highlighted in the table above.