Hi all, I have been having a problem with this for about a month and have not been able to find a solution until now. I have chatted with Shopify several times and my imports have been correct per their instruction (don’t delete rows or columns). I recently spoke with someone who told me the following, which is something I have not been told by any other Shopify support member and it is not in any forums. In addition to not removing any columns or rows, you also CANNOT SORT ROWS.
Here is a copy of our conversation. I don’t know if it is helpful to anyone, but may shed some light on this problem if you feel like you are going crazy like I did.
Shopify: This issue commonly occurs when someone sorts the CSV columns or rows (e.g., sorting variant rows by inventory) before importing. Since additional variants and product images are on separate rows, sorting can break up these rows, causing variants or images to be deleted during import. In this case i would advise avoid sorting the CSV. If you have a backup CSV that hasn’t been sorted, you should import that instead.
Me: We have hundreds of SKUs and prices to update right now. I have to combine a Shopify product export with our new price list, and sort by SKU to compare and adjust. I highlight the Rows that were not part of the original Shopify product export and remove them. I keep all variants in the file, nothing from the original export is deleted.
Shopify: I understand, having 100’s of SKUs with frequent price can be challenging. I can suggest you try the follow to help manage your bulk price updates while minimizing risks:
- Shopify’s bulk editor allows you to edit multiple products and variants directly within the admin without exporting and importing CSVs. This reduces the risk of data loss from CSV imports.
- There are third-party apps available in the Shopify App Store designed specifically for bulk product and price management. These apps can provide more advanced filtering, sorting, and bulk update capabilities tailored for large inventories.
- Consider apps or integrations that can automate price adjustments based on cost changes or tariff updates.
- To handle tariffs effectively, we offers built-in tools like the duties calculator and Managed Markets, which can help calculate and display duties at checkout, ensuring pricing reflects total costs transparently.
Me: These suggestions unfortunately aren’t helpful, since I need to compare in the same spreadsheet to make these adjustments. What do others do?
Shopify: Directly sorting / rearranging the CSV before importing can cause issues like variants being wiped out. You can look to keep your original export CSV intact in one tab, and perform your sorting, filtering, and price comparison in a separate tab within the same spreadsheet. This way, you preserve the original data structure needed for import. Also in your working tab, use formulas to pull in data from the original tab. This allows you to sort and compare without altering the import-ready data.
Me: Do you have a webpage with instructions to do that and how to create the formulas? I would need something like, if SKU in other tab = XYZ, then replace with this new cell price with the matching SKU in the other tab… if that makes sense.
Shopify: Currently, there isn’t a specific Shopify help page that provides step-by-step instructions on how to keep the original CSV intact in one tab and use formulas in a separate tab for sorting and filtering without breaking the import structure. For learning how to use formulas to pull data between tabs, you can refer to general spreadsheet tutorials such as: IMPORTRANGE - Google Docs Editors Help
Shopify: To achieve this kind of conditional update where you replace prices based on matching SKUs between two tabs, you can use the VLOOKUP function in your spreadsheet software (Google Sheets or Excel).
Me: Ok, so just to be sure… If I keep the order of rows and columns the same as my export, and change data in the cells only, there shouldn’t be any problems?
Shopify: Yes, that’s correct. If you keep the order of rows and columns exactly the same as your original export CSV and only change the data within the cells (such as prices, descriptions, or inventory quantities), you should not encounter issues like variants being wiped out during import. Maintaining the original structure ensures that Shopify correctly associates each row with the right product and variant. Be sure not to sort, add, or delete rows or columns, as this can break the relationships between products and variants and cause data loss or duplication.