For merchants changing selling prices

Update Shopify prices by SKU.

Your supplier’s price file needs two columns. Your Shopify export supplies the product names, handles and options. Review the prices, then carry the complete variants into your update.

Try this price-only example

Original fictional Cedar Supply files. Free to review and export.
A saved project is preserved; the example loads only when you choose it.

Selling prices onlyFictional example

Cedar Supply

Studio cup

Change two prices. Keep all three colors.

The complete Studio cup variant set, in the store’s existing currency.
Variant Shopify now Reviewed
Cream00123 24.00 26.00Price revised
Ink00124 24.00 26.00Price revised
Moss00125 24.00 24.00Kept unchanged

Moss is absent from the supplier file. Its existing price and color stay in the reviewed update.

Same handle: studio-cupAll 3 colors retained

Three incoming prices. Four existing variants.

Two Studio cup colors rise from 24.00 to 26.00. Cotton tea towel rises from 14.00 to 16.00. The Moss cup stays at 24.00, even though it has no supplier row.

Supplier prices · 3 rows · 2 columnscedar-price-only-supplier.csv

Supplier SKU and Retail. No titles, handles or product groups to map.

Current Shopify export · 4 variantscedar-price-only-shopify.csv

The product identity and complete variant sets. Keep a fresh export for your own store.

After both products are approved · 4 variants

One reviewed Shopify update

Cream 26.00, Ink 26.00, Moss 24.00, tea towel 16.00. Only selling prices change.

Download the exact result

These are practice files for Catalog Relay. Do not import the fictional products into a live store. SKUs stay as text: 00123 is different from 123. Prices are not converted to another currency.

Working in Excel? Follow the text-SKU workbook walkthrough to keep leading zeros and try the same prices from an actual XLSX file.

Map exactly two columns.

Choose Selling prices only in Source files. Titles and other product details come from Shopify.

Open the price-only example
  1. Load the example, or bring your own files

    Choose “Try the price-only example” to load the fictional files. For your own work, choose “Use your own files,” select “Selling prices only,” and load a supplier price file plus a current Shopify export. If you already have saved work, continue it or back it up and start fresh under Project before loading these files.

  2. SKU → Supplier SKU

    Open “Map columns” and check the SKU assignment. Matching ignores leading and trailing spaces. Letter case and leading zeros still matter. The update keeps the SKU cell from your Shopify export. Duplicate or ambiguous SKUs are held for correction.

  3. Selling price → Retail

    Choose the column containing the new selling price and the correct number format. There are no title, cost, vendor or option mappings in this mode. Any other supplier columns remain in the original source and project backup, outside the Shopify update.

  4. Keep the Shopify identity

    The title, handle and option values in review are read-only values from the Shopify export. A SKU absent from that export is held; it cannot become a new draft. Correct the SKU or supply the right current export. Changing workflow clears approvals.

Review prices by product.

Nothing is approved for you. The exact files below come from approving both example products in Catalog Relay.

  1. Inspect Studio cup

    Check Cream and Ink at 24.00 → 26.00. The preserved-variant notice lists 00125, the Moss cup absent from the supplier file. Its price remains 24.00. Approve Studio cup.

  2. Inspect Cotton tea towel

    Check SKU 00910 at 14.00 → 16.00, then approve the product. Choose “Review export.” Expect two approved products and four output variant rows.

  3. Read the actual update before importing

    Open “Preview exact Shopify output” and download the update CSV. It includes URL handle, Title, SKU, Price and all three option name/value pairs. Cost, vendor, description and tags are excluded. New drafts are not part of this workflow.

Keep the files behind the decision.

Download your own output in the app, or compare it with these exact worked-example files. Keep a project backup separately to restore original files, mapping and corrections.

For Shopify’s native importer · 4 variantsshopify-reviewed-updates.csv

Three revised prices and the unchanged Moss cup.

To read or print · works offlinecatalog-relay-review.html

An example brief with approved prices, the preserved SKU and import instructions. Open the worked example in Catalog Relay to generate its matching price update pack. Open the brief.

For the row-by-row record · 3 source rowscatalog-relay-review.csv

Every supplier row, its matched handle and approval decision. Held or unapproved rows would appear here too.

Make the final decision in Shopify.

Catalog Relay prepares files locally. It has no store connection and does not perform or undo the import.

Keep a fresh export and check Shopify’s preview

Use a current export covering the complete products and variants you intend to update. For your own data, choose Shopify’s matching-handle overwrite option deliberately and inspect the preview. Cancel if the result differs from your reviewed prices or variant set. Included blank cells can clear values; omitted columns are not updated. See Shopify’s product CSV guidance.

This workflow changes the ordinary selling price

It does not update inventory, images, metafields, international market-specific prices, costs or option structure. It cannot add a variant to an existing product. Incomplete or inconsistent option identity and linked category-metafield options are held. Keep linked options unchanged and update their prices with Shopify’s own tools. Use the full catalog workflow to review supported product details and new drafts.

Keep your source and backup

A project backup restores this workspace, not your store. Replace both source files with current versions for the next revision and approve again. The example has been checked through file generation; a live Shopify import has not been tested.

Try three prices and one preserved color.

Up to 50 supplier rows per file are free. A $29 USD one-time individual license unlocks larger files. No subscription or automatic renewal. Import, review and project backups remain available without a purchase.

Try the price-only example