Main issue: Attempt to update unit pricing across product variants failed in the Shopify bulk editor, which returned an error (shown in a screenshot). The user then tried a CSV (spreadsheet) product import as a workaround.
Outcome: After the CSV import, products with multiple options (e.g., Size and Color) had some variants (option combinations) silently deleted. No error message or warning appeared; the problem was discovered later. A second image shows the discrepancy.
Constraints: The Matrixify app does not yet support the unit pricing field, limiting alternative bulk-update methods.
Expectations: Importing to update data should not remove existing variants that are present in the file. If deletions might occur, Shopify should display an explicit confirmation and provide clear reporting.
Impact: Risk of unintended catalog changes and data loss without notification.
Status: Unresolved. The user requests Shopify investigate the cause, fix CSV import behavior, and add safeguards. Key unanswered question: why the import removed variants and how to prevent it in future.
I wanted to update unit pricing on several variants in several products. I tried doing this with the variant bulk editor but it always gives me this error:
Matrixify also doesn’t support unit pricing yet, so I resorted to using Shopify’s native product CSV import. Big mistake! For some reason, on every product that had multiple options(Size and Color or whatever), some of the variants got deleted. I still don’t know why. We didn’t get any error message or anything informing us that this happened, we just had to discover it ourselves.
This is NOT ACCEPTABLE!!! I don’t see any reason why my import file should have caused the deletion of any variants. They were all there as you can see. And IF an import would result in the deletion of anything, the user should be explicitly told that this is going to happen! Shopify fix this!
You probably might have ended up doing something wrong in the CSV file which caused that, I highly suggest you to not edit your products via CSV bulk until and unless you have a good experience of using Excel.
To fix your current problem, if I was at your place what I would do is download that csv file again which Shopify emailed you and import that same CSV file and make sure while importing you check the first option so that it gets overwrite instead of duplicated products.
Well whoever fault it was, we can’t do anything about it now. But the good part is that you have the backup file of your variants so you can just simply run that original CSV again and most likely you’ll get your variants back which will save most of your time.
Shopify has no native backup system, so it’s on the merchant to put a backup process in place.
It doesn’t just preserve data is prevents unneeded frustration so merchants don’t even have to think about it.
Just shaking your fist at the clouds here.
For actual bugs contact shopify support directly or have the merchant(admin) do it.
Give them replicatable bugs or be dismissed as user error https://help.shopify.com/
Make a sample CSV of before and after that can reproduce the issue, or find similar posts that do have data.
Otherwise no matter how big mad you feel it will be dismissed as user error.
e.g. https://stackoverflow.com/help/minimal-reproducible-example
Test imports first.
It’s a system it uses logic to update and remove variants.
Otherwise how would merchants have to bulk remove variants.
I did tell Shopify support. I’m just also making a thread about it. And I did test importing first, I just didn’t specifically test multiple-option variants which is where the problem is.
But yes Paul please keep coming up with reasons why I’m at fault here.
All my products have multiple variants, and have exported, imported, and changed values many times every month without any such issue. Perhaps you did something wrong there. Maybe a mistep. Maybe there was something corrupted in your csv file. It happens sometimes. In any case, you seem bent out of shape, you are welcome to come cool off in the snow
I’d rather blame your sizes which include quote marks for sizes in feet.
Because quotes are usually used to wrap text fields.
In fact, Excel does a very bad job of escaping tricky characters.
I always prefer Google Sheets for final export to CSV before getting it into Shopify.
And no, it’s not a Shopify problem when it’s fed wrong data.
Sorry to hear the variants got deleted, the Shopify admin import is always a bit flakey. I did try a few times to reproduce the issue on a test store and it seemed to work but it’s very sensitive to small things so I might have missed something. Either way, it’s very opaque and hard to see what’s being modified.
I know it’s too late for this case, but to use the Matrixify format, while also updating unit prices, I would suggest checking out our Altera app. It supports the Matrixify format while also adding support for newer fields like Unit Prices.
For example, this is what an export could look like and you can also import that data to update products:
I don’t see any reason why my import file should have caused the deletion of any variants. They were all there as you can see. And IF an import would result in the deletion of anything, the user should be explicitly told that this is going to happen! Shopify fix this!
