Inventory values deleted from .csv upload

[arabicshopguy]

I exported all my products to .csv file and edited the option name for all clothes because the store was missing some functionality due to the option name (size) being in Arabic, and shopify/theme built the infrastructure around understanding English "Size".

Anyways, I changed the option name to the English "Size" and changed some of the variants option value for example: X-Large changed it to XL - for all products. 

I was comforted by the fact that while exporting and re-importing my .csv file shopify always announced that inventory values will not be changed, I was further comforted by the fact that "inventory qty" column was not included in the exported nor the imported. No changes were made to SKUs or handles or any other data besides option name and value. 

To my surprise this change deleted ALL inventory values of clothing items 1500+ in both locations I manage. I'm devastated and worried that I won't be able to restore my inventory values. I fully blame shopify for not thinking that this could happen regardless of uploading the .csv file from the products. 

I contacted Shopify's support and waiting to hear back. 

Has anyone faced a similar issue? Any suggestions for fixes that do not include counting the entire inventory? 

Thanks

[ShopMatt]

Did you every find a solution to this? Same thing happened to me.

[Justfiguring]

Sadly, the same thing happened to me and contacted shopify support but they said nothing can be done as they do not backup your store’s data. 

[CocoLoca]

The exact same thing happened to me, still trying to figure out a solution but this was the support person's response:

"It looks like the issue you're experiencing is related to how the import process manages changes in option values. When you modify option values, like Option1 Value or Option2 Value, during the import, the system sees this as creating new variants. Consequently, the previous variants and their inventory are removed. This usually occurs when you change the option values, the import creates new variants based on those updates, and you choose to overwrite existing products during the import. To avoid this in the future, it's best to keep the option values unchanged if you want to keep the current inventory levels for those products."