Why does my CSV file didn't update !?

Retired Boards Appdev Fulfillment Api
,

Topic summary

CSV inventory re-import after changing SKU format led to partial import and data inconsistencies in a Shopify store.

  • First round: exported inventory, edited the SKU column, and re-imported successfully (245 items).
  • Second round: modified SKU format again and re-uploaded the original CSV; results showed “Successfully imported: 211; Skipped: 34,” with errors like “Line 2/17: Couldn’t update because the options don’t exist in Shopify.”
  • After this, data became corrupted: stock levels, entry (cost) prices, and sale prices changed incorrectly, with some values set to 0, causing orders to process at 0.
  • Tried editing via both Excel and Google Sheets; issues persisted.

Status:

  • Currently fixing products manually and seeking advice.
  • Unresolved. Key concern is how to safely update SKUs via CSV without triggering “options don’t exist” errors or altering stock and pricing unintentionally.

Note: SKU = Stock Keeping Unit. Error mentions “options,” which likely refers to product options/variants in Shopify.

Summarized with AI on December 19. AI used: gpt-5.
1

Hello, i exported inventory to edit SKU numbers. As i did that i open that file i edited SKU column and i uploaded back. All good, entire 245 items uploaded successfuly. Successfully imported: 245.

I realize that i would like other format for SKU, and i modify again the original csv file and i upload the file and i got this error: Successfully imported: 211 Skipped: 34 Line 2: Couldn’t update because the options don’t exist in Shopify. Line 17: Couldn’t update because the options don’t exist in Shopify.

Since this moment everything become a nightmare. I tryed with Excel and Google Sheets. My stock gone wrong, my entry prices gone wrong, my sale prices gone wrong, some of them even with 0. I wakeup with orders with 0 to pay. Now i have to go through each item and modify manualy.

Please give me some advices. Thank you !