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
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 centrePrice must be a plain number, without a currency symbol.
DocTransform fixes this: type
Make Price a plain number
Shopify help centreOr 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
Inventory quantity must be a whole number.
Shopify help centreFulfillment 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 centreLast checked October 28, 2026
Each product needs a unique URL handle.
Shopify doesn't say what happens
Shopify help centreLast 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 centreLast 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 centreLast 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 centreLast 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 centreLast 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 centreLast 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 centreLast checked October 28, 2026
Before and after
3,516 products
Fix it in DocTransform
By hand: 14 stepsDocTransform: 1 sentence
- 1. Upload erp_articles.csv into DocTransform.
- 2. Type and press Send. Check the steps it adds; Undo takes them all back.
Make Price a plain number and fill empty Fulfillment Service cells with manual
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. Download the cleaned file as CSV, ready for Shopify's importer.

- Type the change in one sentence, in your own words.
- Wait about 5 seconds while the steps are written. Stop cancels.
- Check each step and how many cells or rows it changes.
- 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
- Open erp_articles.csv in Excel with File → Open.
- Find any blank Price cell and type that product’s price by hand; Shopify treats Price as required.
- In the empty cell E2, type =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"€","")," ",""),",",".")) to drop the euro sign and space and use a decimal point.
- Double-click the fill handle at the bottom-right corner of E2 to fill the formula down to the last product.
- Scan column E for any #VALUE! error and retype that price in column B by hand, e.g. 19.90.
- Select E2 down to the last product and press Ctrl+C.
- Right-click B2 and choose Paste Special → Values, so €19,90 becomes 19.9 and 24.00 becomes 24.
- Right-click the column E header and choose Delete to remove the helper column.
- Click the Inventory Qty column header (column C) and choose Home → Find & Select → Replace (Ctrl+H).
- Type one space in Find what, leave Replace with empty, and click Replace All, so 1 200 becomes 1200.
- Select the Fulfillment Service cells from D2 down to the last product.
- Choose Home → Find & Select → Go To Special, pick Blanks, and click OK.
- Type manual and press Ctrl+Enter to fill every selected blank cell at once.
- 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
Free tools for this file
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.