For merchants preparing prices in Excel

Keep your SKUs intact.

The SKU is 00123. Keep it as text in your supplier workbook, then review selling prices against a fresh Shopify export.

Download the practice workbook

Original fictional Cedar Supply data. Three incoming prices; four existing variants. Free to review and export.

The identifier survivesFictional example

Stored as text in the workbook

00123 → 00123

Studio cup · Cream · studio-cup

Studio cup prices in the store’s existing currency
SKU Before Reviewed
00123Cream 24.00 26.00Price revised
00124Ink 24.00 26.00Price revised
00125Moss 24.00 24.00Kept unchanged

All three colors stay together. Moss is absent from the supplier workbook. Its existing variant and price stay in the update.

Set the type before the data arrives.

A number format can display 00123 while the cell still contains the number 123. Catalog Relay reads the stored value. It does not guess missing zeros.

  1. Format the SKU column as Text first

    Do this before entering or pasting identifiers into a new workbook. A custom format such as 00000 changes the display, not the stored identifier.

  2. Import CSV identifiers as Text

    Use Excel’s text/CSV import controls and set the SKU column’s data type to Text before loading. Menu names vary by version. Opening a CSV directly can let Excel convert the values automatically.

  3. Check against the original source

    Compare identifiers with the supplier’s authoritative file, then save a values-only XLSX. Formulas, macros and external workbook links are unsupported. See Microsoft’s leading-zero guidance and text-cell instructions.

Three workbook rows. Four output variants.

The “Selling prices” worksheet has only Supplier SKU and Retail. The matching store file supplies product names, handles and options. The SKU cells are actual text.

Supplier prices · XLSX · 3 rowscedar-text-sku-prices.xlsx

00123 and 00124 become 26.00. 00910, the Cotton tea towel, becomes 16.00.

Current Shopify example · CSV · 4 variantscedar-price-only-shopify.csv

Studio cup in Cream, Ink and Moss, plus Cotton tea towel. Use a fresh complete export for your own store.

After both products are approved

The whole variant set

Cream 26.00, Ink 26.00, Moss 24.00, tea towel 16.00. The missing supplier SKU 00125 keeps its existing price.

Inspect the exact result

These are fictional practice files. Do not import their products into a live store. Prices stay in the store’s existing currency. 00123 and 123 are different SKUs.

Take the workbook through review.

Use the downloads above to exercise the real XLSX import. The optional in-app price-only example starts with preloaded CSV files containing the same values; it does not import this workbook.

Open the preloaded CSV example
  1. Choose your files and price scope

    Open Catalog Relay, choose “Use your own files,” then “Selling prices only.” Load cedar-text-sku-prices.xlsx as the supplier file and cedar-price-only-shopify.csv as the Shopify export. If you have saved work, back it up and start fresh under Project before practising; opening the example does not replace it.

  2. Map exactly two columns

    In “Map columns,” name this practice project Cedar Supply (fictional). Assign SKU to Supplier SKU and Selling price to Retail. Check the number format. Product identity comes from the Shopify file; there are no title, cost, vendor or option mappings in this mode.

  3. Approve the complete products

    Review Studio cup: Cream and Ink rise to 26.00, while the preserved Moss variant stays 24.00. Review Cotton tea towel at 14.00 → 16.00. Check the exact SKUs, handles and options, then approve both products. Nothing is approved for you.

  4. Download the update and its record

    Choose “Review export.” Expect two approved products and four output variant rows. Download the update CSV, review brief and row report. Vendor, cost, description and tag columns are omitted from the price-only update.

Keep a readable handoff.

These files were exported from the workbook above after approving both products. The brief records the XLSX source, reviewed prices and preserved variant. The row report accounts for all three supplier rows.

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 handoff for the reviewed change. To create its matching price update pack, load the practice workbook and Shopify baseline in Catalog Relay. Open the actual Excel brief.

Row-by-row decisions · 3 supplier rowscatalog-relay-review.csv

Each original SKU, its matched handle and approval decision.

Already saved as 123?

Changing that cell to Text afterwards cannot tell you whether the original was 123, 00123 or something else.

Get the authoritative identifier back

Return to the original supplier export or ask for a replacement. Do not pad every SKU to an assumed width. A mismatched identifier is held for review. If an altered value happens to match another real SKU, a matcher cannot know your intent. Check the source before approving.

Keep long identifiers as text too

Excel can lose digits in long numeric identifiers. Catalog Relay rejects numeric XLSX cells whose absolute value is at least 1,000,000,000,000,000. This checks their size, not their significant-digit count. Smaller numeric identifiers, including decimals, can already be imprecise. It cannot reconstruct rounded digits or detect every earlier alteration. Keep the exact original text at the source. A formula result needs a clean values-only file before import.

Check the final import in Shopify.

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

Keep a fresh export and inspect the preview

Follow Shopify’s current CSV overwrite rules. Check the affected products after import. Included blank cells can clear values; omitted columns are not updated. The example has been checked through file generation; a live Shopify import has not been tested.

Keep the identifiers intact through the last step

Avoid reopening and resaving the final CSV with automatic numeric conversion. If you inspect it in Excel, import the SKU column as Text again. The review brief is a readable record, not a store import file or store rollback. See the complete price-only workflow for supported fields and option limits.

Try the three text SKUs.

Files with up to 50 supplier rows export free. A $29 USD one-time individual license unlocks larger files within the product’s stated limits. No subscription or automatic renewal. Purchase availability is shown in the app.

Open Catalog Relay