[All import guides](/en/import)

# Shopify won't import your products file?

Fix the errors Shopify shows when importing a products CSV, then import clean every week.

## Fix it in a supported AI chat

Check your file against Shopify rules in a supported AI chat, fix the safe problems with one button and download it clean.

*   Checking is free
*   Fixing uses one export
*   Your file is not kept, and the fixed file’s link works for 30 minutes

[See which assistants](/en/connect-your-agent)

## Errors Shopify shows

### Price can't be blank

> Validation failed: price can't be blank

[Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)

### Inventory quantity isn't numeric

> Inventory quantity is not a number

[Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)

## What Shopify's importer checks

*   Every product needs a price.
    
    we point out a blank price in a column you mark required: open the column ⋯ menu → **Edit column…** → **More options** → **Required Field**, and the Invalid filter over the grid shows each blank
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
*   Price must be a plain number, without a currency symbol.
    
    DocTransform fixes this: type “Make Price a plain number”
    
    Or by hand
    
    open **Health** → **Amounts not written as plain numbers** → **Rewrite 4 values**, which writes each amount as a plain number; €19,90 becomes 19.9
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/using-csv)
*   Inventory quantity must be a whole number.
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
*   Fulfillment service can't be blank; use "manual" if you don't use a third-party service.
    
    DocTransform fixes this: type “Fill empty Fulfillment Service cells with manual”
    
    Or by hand
    
    press / in the command bar, pick **Fill empty cells with a value**, choose Fulfillment Service and put manual in the value box
    
    Shopify skips the row
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
    
    Last checked October 28, 2026
    
*   Each product needs a unique URL handle.
    
    Shopify doesn't say what happens
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
    
    Last checked October 28, 2026
    
*   The file needs a column named Title, and the other column names must match Shopify's own, such as URL handle, Status, Fulfillment service or Continue selling when out of stock.
    
    DocTransform fixes this: open the column’s ⋯ menu → **Edit column…** → click the name at the top of the drawer, rename it to Title and press Enter
    
    Shopify refuses the file
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
    
    Last checked October 28, 2026
    
*   Continue selling when out of stock – Either deny or continue.
    
    DocTransform fixes this: open the Continue selling when out of stock column’s ⋯ menu → **Find & replace…**, find the value, **Replace with** the value Shopify lists, **Match entire cell** → **Replace all**
    
    Shopify skips the row
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
    
    Last checked October 28, 2026
    
*   Status – active, draft or archived.
    
    DocTransform fixes this: open the Status column’s ⋯ menu → **Find & replace…**, find the value, **Replace with** the value Shopify lists, **Match entire cell** → **Replace all**
    
    Shopify doesn't say what happens
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/using-csv)
    
    Last checked October 25, 2026
    
*   Fulfillment service – manual, shipwire, webgistix or amazon\_marketplace\_web.
    
    DocTransform fixes this: open the Fulfillment service column’s ⋯ menu → **Find & replace…**, find the value, **Replace with** the value Shopify lists, **Match entire cell** → **Replace all**
    
    Shopify doesn't say what happens
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/using-csv)
    
    Last checked October 25, 2026
    
*   The file must be saved as CSV UTF-8; Shopify won't read a file saved another way.
    
    DocTransform fixes this: in Export, pick the CSV format and click **Download**; the file is written in UTF-8
    
    Shopify refuses the file
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
    
    Last checked October 28, 2026
    
*   Every quote in the file must be paired: a stray quote inside a value, text after a closing quote or a quote never closed makes Shopify stop with a quoting error.
    
    Shopify refuses the file
    
    [Shopify help centre](https://help.shopify.com/en/manual/products/import-export/common-import-issues)
    
    Last checked October 28, 2026
    

## Before and after

3,516 products

erp\_articles.csv

BeforeAfter

Title Price Inventory Qty Fulfillment Service

Wireless Mouse €19,901 1 2002 3

USB-C Cable 9,50 €4 340 5

Laptop Stand 24.00 75 manual

Desk Lamp 15,00 €6 2 5007 8

Keyboard 45.00 60 manual

Monitor Stand €32,509 18 10

Webcam 28.00 90 manual

Before

## Fix it in DocTransform

By hand: 14 stepsDocTransform: 1 sentence

1.  **1.** Upload erp\_articles.csv into DocTransform.
2.  **2.** Type “Make Price a plain number and fill empty Fulfillment Service cells with manual” and press **Send**. Check the steps it adds; **Undo** takes them all back.Or by hand
    
    Apply the fixes: **Health** → **Amounts not written as plain numbers** → **Rewrite 4 values** turns €19,90 into 19.9 on Price, and pressing / in the command bar, then **Fill empty cells with a value**, with manual fills Fulfillment Service. Remove the space in Inventory Qty by hand, as in the steps above: DocTransform saves no step for it.
    
3.  **3.** Download the cleaned file as CSV, ready for Shopify's importer.

![“Make Price a plain number and fill empty Fulfillment Service cells with manual” typed into DocTransform; two steps applied, Price written as plain numbers, four empty Fulfillment Service cells filled; Undo shown](/guide-shots/shopify/en/flow-desktop-poster.webp)

1.  Type the change in one sentence, in your own words.
2.  Wait about 5 seconds while the steps are written. Stop cancels.
3.  Check each step and how many cells or rows it changes.
4.  The file is clean. Not what you meant? One Undo takes it all back.

Save this fix once, then rerun it on next week’s export with one click.

## Fix it by hand in Excel or Sheets

1.  Open erp\_articles.csv in Excel with File → Open.
2.  Find any blank Price cell and type that product’s price by hand; Shopify treats Price as required.
3.  In the empty cell E2, type =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"€","")," ",""),",",".")) to drop the euro sign and space and use a decimal point.
4.  Double-click the fill handle at the bottom-right corner of E2 to fill the formula down to the last product.
5.  Scan column E for any #VALUE! error and retype that price in column B by hand, e.g. 19.90.
6.  Select E2 down to the last product and press Ctrl+C.
7.  Right-click B2 and choose Paste Special → Values, so €19,90 becomes 19.9 and 24.00 becomes 24.
8.  Right-click the column E header and choose Delete to remove the helper column.
9.  Click the Inventory Qty column header (column C) and choose Home → Find & Select → Replace (Ctrl+H).
10.  Type one space in Find what, leave Replace with empty, and click Replace All, so 1 200 becomes 1200.
11.  Select the Fulfillment Service cells from D2 down to the last product.
12.  Choose Home → Find & Select → Go To Special, pick Blanks, and click OK.
13.  Type manual and press Ctrl+Enter to fill every selected blank cell at once.
14.  Choose File → Save As, set the file type to CSV UTF-8 (Comma delimited), and click Save.

## Questions

Does DocTransform split my file if it's over Shopify's 15 MB limit?

Yes, by rows. In Export Studio choose Split into files → By number of rows… and set the most rows each file may hold: you download one .zip and upload the files one at a time. It splits by rows, not by size, so it cannot promise a file stays under a size limit: check each file before you upload it.

Does DocTransform know what Shopify will reject?

Some of it. It checks what Shopify's help pages state: a Title column and the exact names of Continue selling when out of stock, Status, Fulfillment service and URL handle; a file saved as UTF-8; quotes Shopify can read; commas between the columns; a Fulfillment service that is not blank; and the allowed values of Continue selling when out of stock. Where Shopify names a requirement but not what happens if you break it (Status, the values of Fulfillment service, two products with the same URL handle), it tells you to check those rows instead of promising a rejection. Each is listed above with the date it was last checked. How your variants are laid out is not checked.

Can I reuse this fix next time I export products?

Yes — save it once in DocTransform and rerun it on next week’s export.

## Moving from another system

*   [WooCommerce to Shopify: map the columns, import the CSV](/en/import/shopify/from-woocommerce)

## Free tools for this file

*   [Check your products CSV before you upload it to Shopify](/en/tools/check-shopify-products-csv)
*   [Convert Excel to CSV](/en/tools/xlsx-to-csv)

[Try this sentence free](/en/signup?plan=free&guide=shopify)

Free plan, no card required.

Salesforce, HubSpot, Shopify, QuickBooks, Mailchimp, Pipedrive, WooCommerce, Klaviyo, Google Contacts, ActiveCampaign, Brevo, Zendesk, Square, Zoho CRM, and Xero are trademarks of their owners. DocTransform is not affiliated with them.
