Why does exporting a CSV file from my store create two incomplete files?

Shopify Discussion

Topic summary

  • CSV export produces two files (“Export 1” and “Export 2”) that lack correct data, forcing manual price checks across ~47,000 lines. Background: a prior expert’s CSV upload removed product photos and introduced widespread pricing errors.

  • Clarification requested: whether the export is from Inventory or Products. Inventory exports do not include pricing, so exporting from Products is needed to get price data.

  • Data integrity tip: check product “handles” (the unique identifier/URL slug). If handles show a “+11” suffix due to collapsed/duplicated values, correct by formatting the handle column as Numbers with 0 decimal places to prevent unintended duplicates.

  • Status: No confirmed resolution. Suggested next steps are to re-export from Products for pricing data and review/normalize handles. The issue of two incomplete files remains to be validated after trying the correct export source.

Summarized with AI on January 12. AI used: gpt-5.
1

I’m currently in the process of launching my store. However, when I export a CSV file, it generates two files labeled Export 1 and 2, but unfortunately, both lack the correct data. To verify pricing, I find myself toggling between Shopify and the supplier costs since there are over 47,000 lines to check. I’m working around the clock with my current method.

The reason behind this extensive effort is that a Shopify expert, who worked on my store, uploaded a CSV file that not only resulted in the loss of all product photos but also had inaccuracies in pricing across the board.

2

Are you exporting from inventory or products? Inventory wont have pricing data so this could be the issue. I am assuming you want pricing data from the context; if you need other data just let me know. Also make sure when updating any information from product exports that you are checking to make sure the handle doesn’t have +11 at the end. If you have collapsed handles you can fix this by selecting the column, right clicking, format cells > numbers > Decimal Places 0. You may already know this but putting in this side note just in case as that would be a pain if you duplicated that many items.