DocTransform
All import guides

Shopify won't import your products file?

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

Errors Shopify shows

Price can't be blank

Validation failed: price can't be blank
Shopify help centre

Inventory quantity isn't numeric

Inventory quantity is not a number
Shopify help centre

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
  • 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
  • Inventory quantity must be a whole number.

    Shopify help centre
  • 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

    Last checked October 28, 2026

  • Each product needs a unique URL handle.

    Shopify doesn't say what happens

    Shopify help centre

    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

    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

    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

    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

    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

    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

    Last checked October 28, 2026

Before and after

3,516 products

erp_articles.csv
TitlePriceInventory QtyFulfillment Service
Wireless Mouse€19,9011 20023
USB-C Cable9,50 €43405
Laptop Stand24.0075manual
Desk Lamp15,00 €62 50078
Keyboard45.0060manual
Monitor Stand€32,5091810
Webcam28.0090manual

    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
    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.
    Try this sentence free

    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.