Step 1: Open the Inventory dashboard<\/figcaption><\/figure>\nStep 2: Specify your export needs<\/h3>\n In the top right corner, click the “Export”<\/strong>\u00a0button. A popup window will appear, allowing you to customize your export options before downloading the file.<\/p>\nStep 2: Specify your Shopify export inventory needs<\/figcaption><\/figure>\n\nExport from:<\/strong> Choose a specific location or select All locations.<\/li>\nInventory states shown:\n\nChoose All states (recommended)<\/strong> to include all inventory details with overwrite protection. If you plan to update inventory quantities and re-import the file, this option will be safer as it helps Shopify catch and prevent accidental overwrites caused by outdated files.<\/li>\nChoose Available<\/strong> to export only current stock levels (no overwrite protection).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\nExport:<\/strong> Select which product variants to include:\n\nCurrent page<\/li>\n All variants<\/li>\n Selected variants<\/li>\n Variants matching your search<\/li>\n<\/ul>\n<\/li>\n<\/ul>\nStep 3: Download your CSV file<\/h3>\n Next, under Export as<\/strong>, choose the file format you prefer, typically CSV for Excel or other spreadsheet programs. Then, click \u201cExport variants<\/strong>\u201d.<\/p>\nStep 4: Update the inventory amounts (optional)<\/h3>\n After exporting your inventory CSV file, you can use it to make bulk changes to inventory quantities or related data. The file includes key product identifiers (such as SKU and variant options) to ensure your updates apply to the correct products and locations.<\/p>\n
When updating inventory, keep the following in mind:<\/p>\n
\nUse whole numbers only<\/strong>, no decimals like 1.5.<\/li>\nYou can enter positive, negative, or zero values.<\/li>\n Use \u201cNot stocked<\/strong>\u201d for products that have never been stocked at that location.<\/li>\nIf you're not changing the quantity of a product, simply leave the “On hand (new)<\/strong>” column blank.<\/li>\n<\/ul>\nNow, here are the steps to update your Shopify inventory quantity in the CSV file:<\/p>\n
\nOpen<\/strong> the exported CSV file in a spreadsheet tool like Excel or Google Sheets.<\/li>\nUpdate inventory quantities<\/strong> based on your export format:\n\nIf you chose All states<\/strong>, update the On hand (new) column.<\/li>\nIf you chose Available<\/strong>, update the available quantities listed under each location name.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\nSave<\/strong> your updated CSV file when you're done.<\/li>\n<\/ul>\nTroubleshooting Shopify Import & Export Inventory<\/h2>\n Even with a correctly formatted CSV file, you might run into errors during import or export of Shopify inventory. Below are common issues and how to fix them:<\/p>\n
1. Rows failed validation after import<\/h3>\n After Shopify import inventory, you might receive an email from Shopify saying that certain rows failed validation. This usually happens when the On hand (current)<\/strong> value in your file doesn\u2019t match the actual stock level in Shopify at the time of import. It\u2019s Shopify\u2019s way of protecting you from accidentally overwriting recent inventory changes.<\/p>\nTo fix this, go back to your Shopify admin and export the most recent inventory file. Then, update your CSV file using the latest stock data before re-importing it. This ensures that Shopify can safely apply your updates without rejecting any rows.<\/p>\n
2. Inventory not updated or rows skipped<\/h3>\n If you notice that some inventory rows weren\u2019t updated after your import, or if certain rows were skipped entirely, it\u2019s often due to missing or incorrect values. Shopify requires valid fields like SKU, product handle, and location name to match exactly with what\u2019s already in your store.<\/p>\n
Double-check your CSV file to make sure:<\/p>\n
\nEach row includes a valid SKU or product identifier<\/li>\n The location name matches exactly with how it appears in your Shopify settings<\/li>\n The product and variant exist in your store<\/li>\n<\/ul>\nEven a small typo in a location name or SKU can cause Shopify to skip the update silently.<\/p>\n
3. File format not accepted<\/h3>\n If your file won\u2019t upload or triggers a \u201cfile format\u201d error, it likely means the structure of your CSV doesn\u2019t match Shopify\u2019s requirements, or it\u2019s simply too large. Shopify only accepts inventory files up to 15 MB<\/strong>, and the columns must follow the correct format.<\/p>\nTo resolve this, download the most up-to-date inventory CSV template from Shopify and structure your file accordingly. If your file is too large, consider splitting it into smaller batches. Also, make sure your file is saved as CSV UTF-8<\/strong> format.<\/p>\n4 \u201cNot Stocked\u201d isn\u2019t working properly<\/h3>\n If you're trying to mark a product as “Not stocked<\/strong>” at a certain location but it's not being applied, there are two things to check.<\/p>\n\nFirst, make sure the location is active and enabled in your Shopify settings.<\/li>\n Second, confirm that the phrase “Not stocked<\/strong>” is spelled exactly right in your file \u2013 no extra spaces, typos, or formatting issues.<\/li>\n<\/ul>\nThis input needs to match Shopify\u2019s system exactly for it to be processed correctly.<\/p>\n
5. Inventory numbers updated incorrectly<\/h3>\n One of the most common mistakes is entering inventory quantities in the wrong column, especially when using the All states<\/strong> export format. If you update the
![\"Shopify](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/shopify-import-inventory-dashboard.webp\")
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/download-a-sample-shopify-csv-file.webp\")
![\"Shopify](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/shopify-import-inventory-csv-template.webp\")
![\"Upload](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/upload-shopify-inventory-file.webp\")
![\"Review](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/review-shopify-import.webp\")
![\"How](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2024\/09\/2-08-1.png\")
<\/div>\n<\/div>\n![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/shopify-inventory-page.webp\")
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/08\/shopify-export-inventory-specification.webp\")