Quick Rule Summary · Updated November 2026

Every sellable variant row in a Shopify CSV needs a plain numeric Price (such as 24.50—no $ symbols, commas, or currency codes), while image-only continuation rows must leave Price blank and discounted items must set Compare-at price higher than Price.

01 / COMPARE THE RESULTSChange one price. See what changes.

All three files contain the same QA Shirt, handle qa-shirt and SKU QA-SHIRT-001. Only the Price cell changes. Use Create new products in the workspace, confirm the four field mappings, and compare the findings.

A / INVALID NUMBER

twelve

1 error

The workspace reports a price-format error and blocks the Shopify CSV export. Enter the intended numeric price in your source copy or edit the cell deliberately.

Price
twelve

B / EMPTY PRICE

An empty cell.

1 review item

The workspace asks you to review this product’s empty Price cell. Export is allowed and the cell stays empty. It is not automatically changed to zero.

Price
(empty cell)

C / NUMERIC PRICE

12.50

0 findings

The example passes the supported file checks and can be exported. Confirm the intended amount and currency yourself, then check Shopify’s import preview.

Price
12.50

The snippets show the price column only. Each download contains all four columns and one invented record. “Empty cell” is an explanation here; the CSV contains a genuinely empty value.

A blank price needs a deliberate choice. Product records with an empty Price cell are flagged for review, including simple products without a SKU. Image-only continuation rows can leave the price empty. A review item does not block export or fill in an amount.

02 / CHOOSE THE IMPORT TASKRequired fields depend on what you are doing.

Use the current Shopify sample or a recent store export as your reference. A short list of columns is a starting point, not a complete template for every product.

Shopify’s documented starting requirements
Your taskColumns to checkBefore you continue
Create new productsTitleAdd the other fields needed for the product you intend to create.
Create products with variantsTitle and URL handleCheck the option fields and variant data against Shopify’s current format.
Update existing productsURL handle and TitleRetain dependent columns. Variant-related changes can also require Option1 name and Option1 value.

The example files use the create intent. They are not update templates. Row & Record does not inspect live products or verify every platform dependency.

If the first row itself is blank or duplicated, start with the header-check examples. For supplier column names, use the CSV templatemapping walkthrough.

03 / KEEP THE INTENT VISIBLEA blank cell is not a missing column.

Shopify documents a 0.00 default for an empty Price value. During an update, a column included with blank cells and a column omitted from the file can affect saved data differently. Review the overwrite settings and the actual import preview.

The workspace leaves a blank price unchanged. Decide whether to enter an amount, deliberately use zero, or leave a saved field out of a particular update. Confirm that choice against a recent store export; do not use a blank as a guess.

For prices, Shopify expects a monetary number without a currency symbol. Use a clear decimal value such as 12.50. This tool does not convert currencies or infer whether 19,99 was intended as a decimal amount.

04 / WORK ON A COPYCheck, compare, then review the import.

  1. Keep the original. Prepare a comma-separated UTF-8 copy. The workspace supports up to 10 MB and 50,000 source records, and does not read XLSX workbooks.
  2. Choose the task. Open the workspace, select Choose my CSV, then choose create or update to match your intended operation.
  3. Confirm the mapping. Check where the product title, handle, SKU and price go. A SKU is an identifier, not a replacement for a missing product name.
  4. Resolve errors and read review items. Verify empty prices and currency choices yourself. Keep unrelated fields in the original-column copy.
  5. Inspect the target and download. Confirm the selected columns and values in the target preview. A generated or downloaded CSV still needs to be checked locally.
  6. Review in Shopify. Check its import preview and overwrite choices before confirming. Row & Record does not connect to your store or validate its saved products.

Common questions.

Is a blank price always an error?

No. In the SKU example above it is a review item, and target export remains available. Review the intended amount and Shopify’s documented default even when no finding appears.

Will the tool convert currencies or choose a price for me?

No. You choose the amount and currency. Review any deliberate cleanup in the change preview before applying it.

Does a passing example prove my store import will succeed?

No. The workspace checks supported file rules. It cannot verify live product matches, every field dependency, online images or the effect of an import on saved data.

Can I use the three sample files to update my products?

No. They contain invented product data for the create-intent walkthrough. Use your own current export and preserve the fields required for your actual update.

RELATED CSV TOOLSRelated price & storefront CSV tools

Know the amount. Keep the original.

Review a CSV copy before taking it to your store.

Open the CSV workspace ↗

Platform rules checked on 19 October 2026. Example results were run through the current Row & Record checker.

Shopify fields, defaults and dependenciesShopify import review