Woo to Shopify Check

Shopify import error · from WooCommerce

Shopify import: prices at 0.00, wrong or rejected after a WooCommerce export

Products import at 0.00, at the wrong price, or lose their sale price. Price columns are where WooCommerce and Shopify disagree most quietly, and the mistakes cost money from the first order.

Why it happens

Shopify expects a plain number with a dot for decimals in Price and Compare-at price. A WooCommerce export from a store set up with European formats can carry 12,50 or 1.234,50, and a file opened and saved again in a spreadsheet can gain currency symbols or thousands separators. Values like these are read wrong or not at all, and an empty price imports as 0.00, which means a product anyone can buy for free.

Sales are modelled differently too. WooCommerce has a regular price and a sale price, optionally with start and end dates. Shopify has Price and Compare-at price, with no dates: Price is what the customer pays. Copying the sale price straight into Price makes a scheduled sale permanent; copying the regular price loses a sale that is running.

How the free check finds it

The check reads both prices of every product and variation, understands 12,50, 1.234,50 and 1,234.50, strips currency symbols, and flags anything that is still not a number or is negative. A product without a valid price is an error and is set to Draft, so it cannot be sold at 0.00. A running sale becomes Price = sale price and Compare-at price = regular price; a sale with dates is imported at the regular price and flagged; a sale price that is not lower than the regular price is ignored and flagged.

These are the findings the check reports for this problem, each with the lines of your file where it found them:

  1. Must fix

    Price that is negative or not a number

    Shopify cannot read it, so the variant would end up without a valid price.

    What to do: Fix the price in WooCommerce or in the file before importing.

  2. Must fix

    Product without a price

    Shopify would import it at 0.00 and sell it for free.

    What to do: Set the price. In the converted file it is set to Draft so it cannot be sold at 0.

  3. Changes silently

    Scheduled sale

    Shopify has no scheduled sale price, so the product imports at the regular price.

    What to do: Recreate the sale with a discount or a compare-at price on the right dates.

  4. Changes silently

    Sale price not lower than the regular price

    Shopify would show a crossed-out price that makes no sense, so the sale price is dropped.

    What to do: Check which price you meant.

Fix it by hand

  1. Filter problems.csv on PRICE_MISSING and PRICE_INVALID and fix those first: they are the expensive mistakes.
  2. Recreate scheduled sales in Shopify, with a discount or by setting Compare-at price on the right dates.
  3. After the import, sort products by price in Shopify admin and look at the bottom of the list for anything at 0.

Find this in your own export, free

Upload your WooCommerce product export (and customers, if you like). In about a minute you see every row this affects, with line numbers, before anything touches Shopify. No account, no access to your store.

Run the free check See an example report

Other import errors

All Shopify import errors