{"id":56400,"date":"2026-11-01T06:32:13","date_gmt":"2026-11-01T11:32:13","guid":{"rendered":"https:\/\/litextension.com\/blog\/?p=56400"},"modified":"2026-11-12T22:22:40","modified_gmt":"2026-11-13T03:22:40","slug":"woocommerce-csv-import","status":"publish","type":"post","link":"https:\/\/litextension.com\/blog\/woocommerce-csv-import\/","title":{"rendered":"WooCommerce CSV Import: Format, Steps &#038; Troubleshooting"},"content":{"rendered":"<p>WooCommerce CSV import is a convenient way to add or update products without entering each item manually. However, even small formatting errors can result in missing images, incorrect variations, or duplicate products.<\/p>\n<p>The good news is that the process is straightforward once you understand the CSV format WooCommerce requires! In this guide, we\u2019ll explain how to structure your product CSV and walk you through importing products, variations, images, and custom metadata.<\/p>\n<hr \/>\n<h2 style=\"text-align: left;\">WooCommerce CSV Import Format: What You Need to Know<\/h2>\n<p>For a smooth WooCommerce CSV import, your file needs to follow the specific structure that WooCommerce\u2019s built-in product importer expects. Correct encoding, column names, value formats, and identifiers help reduce import errors, but you should still review the column mapping and import settings before proceeding.<\/p>\n<h3>WooCommerce CSV import file requirements<\/h3>\n<p>Before importing, make sure your CSV follows these basic formatting rules:<\/p>\n<ul>\n<li><strong>Use UTF-8 encoding<\/strong>. WooCommerce recommends saving or exporting the file as a UTF-8 CSV to avoid character and encoding issues.<\/li>\n<li><strong>Use 1 and 0 for Boolean fields.<\/strong> For example, Is featured? uses 1 for true and 0 for false. Published controls product status: 1 = published, 0 = private, -1 = draft, and 2 = pending review.<\/li>\n<li><strong>Separate multiple values with commas.<\/strong> For example, multiple categories or tags can be entered as comma-separated values. If a single value contains a comma, wrap it in double quotation marks or escape the comma with a backslash, such as <span style=\"font-family: 'courier new', courier, monospace;\">Places\\, People\\, Cities<\/span>.<\/li>\n<li><strong>Use &gt; for taxonomy hierarchies.<\/strong> For example, Clothing &gt; T-Shirts represents a child category under Clothing.<\/li>\n<li><strong>Distinguish product IDs from product references.<\/strong> In the ID column, enter the numeric ID, such as 100. In reference columns such as Parent, use id:100 for an existing product ID or SKU101 for a SKU.<\/li>\n<li><strong>Keep the column headers consistent with WooCommerce&#8217;s schema.<\/strong> WooCommerce automatically maps recognized column names during import; unrecognized columns are not imported by default unless they are mapped appropriately.<\/li>\n<\/ul>\n<div class=\"table3\">Important: You cannot assign a specific WordPress product ID to a brand-new product through the CSV. If the ID does not already exist, WooCommerce assigns the next available ID.<\/div>\n<h3>Important WooCommerce CSV fields<\/h3>\n<p>You don&#8217;t need every available column for every WooCommerce CSV import. The fields you need depend on the product data you&#8217;re bringing into WooCommerce. Below are some of the most important ones:<\/p>\n<table class=\"wptb-preview-table wptb-element-main-table_setting-99401 edit-active\" style=\"width: 100%;\" role=\"table\" data-reconstraction=\"1\" data-wptb-table-tds-sum-max-width=\"543\" data-wptb-cells-width-auto-count=\"1\" data-wptb-horizontal-scroll-status=\"false\" data-wptb-extra-styles=\"LyogRW50ZXIgeW91ciBjdXN0b20gQ1NTIHJ1bGVzIGhlcmUgKi8=\" data-table-columns=\"3\">\n<tbody>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"0\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994100\">\n<div class=\"\">\n<p><strong>CSV field<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"0\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994101\">\n<div class=\"\">\n<p><strong>What it controls<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"0\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994102\">\n<div class=\"\">\n<p><strong>Example<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"1\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994103\">\n<div class=\"\">\n<p><strong>ID<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"1\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994104\">\n<div class=\"\">\n<p>Identifies an existing product for updates<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"1\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994105\">\n<div class=\"\">\n<p><code>100<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"2\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994106\">\n<div class=\"\">\n<p><strong>Type<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"2\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994107\">\n<div class=\"\">\n<p>Defines the product type<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"2\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994108\">\n<div class=\"\">\n<p><code>simple<\/code>, <code>variable<\/code>, <code>variation<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"3\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994109\">\n<div class=\"\">\n<p><strong>SKU<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"3\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994110\">\n<div class=\"\">\n<p>Product&#8217;s unique identifier<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"3\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994111\">\n<div class=\"\">\n<p><code>TSHIRT-001<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"4\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994112\">\n<div class=\"\">\n<p><strong>Name<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"4\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994113\">\n<div class=\"\">\n<p>Product name<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"4\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994114\">\n<div class=\"\">\n<p><code>Blue Cotton T-Shirt<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"5\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994115\">\n<div class=\"\">\n<p><strong>Published<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"5\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994116\">\n<div class=\"\">\n<p>Product status<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"5\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994117\">\n<div class=\"\">\n<p><code>1<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"6\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994118\">\n<div class=\"\">\n<p><strong>Regular price<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"6\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994119\">\n<div class=\"\">\n<p>Regular selling price<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"6\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994120\">\n<div class=\"\">\n<p><code>24.99<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"7\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994121\">\n<div class=\"\">\n<p><strong>Sale price<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"7\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994122\">\n<div class=\"\">\n<p>Discounted price<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"7\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994123\">\n<div class=\"\">\n<p><code>19.99<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"8\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994124\">\n<div class=\"\">\n<p><strong>Categories<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"8\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994125\">\n<div class=\"\">\n<p>Product categories<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"8\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994126\">\n<div class=\"\">\n<p><code>Clothing, Clothing &gt; T-Shirts<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"9\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994127\">\n<div class=\"\">\n<p><strong>Tags<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"9\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994128\">\n<div class=\"\">\n<p>Product tags<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"9\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994129\">\n<div class=\"\">\n<p><code>cotton, summer<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"10\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994130\">\n<div class=\"\">\n<p><strong>Images<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"10\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994131\">\n<div class=\"\">\n<p>Product images<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"10\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994132\">\n<div class=\"\">\n<p><code>https:\/\/example.com\/tshirt.jpg<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"11\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994133\">\n<div class=\"\">\n<p><strong>Parent<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"11\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994134\">\n<div class=\"\">\n<p>Links a variation to its parent product<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"11\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994135\">\n<div class=\"\">\n<p><code>TSHIRT-001<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"12\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994136\">\n<div class=\"\">\n<p><strong>Attribute 1 name<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"12\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994137\">\n<div class=\"\">\n<p>Attribute name<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"12\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994138\">\n<div class=\"\">\n<p><code>Size<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"13\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994139\">\n<div class=\"\">\n<p><strong>Attribute 1 value(s)<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"13\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994140\">\n<div class=\"\">\n<p>Available attribute values<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"13\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994141\">\n<div class=\"\">\n<p><code>S, M, L<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"14\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994142\">\n<div class=\"\">\n<p><strong>Attribute 1 visible<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"14\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994143\">\n<div class=\"\">\n<p>Whether the attribute is displayed<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"14\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994144\">\n<div class=\"\">\n<p><code>1<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 25%;\" data-y-index=\"15\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994145\">\n<div class=\"\">\n<p><strong>Attribute 1 global<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 45%;\" data-y-index=\"15\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994146\">\n<div class=\"\">\n<p>Whether the attribute is a global attribute<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 30%;\" data-y-index=\"15\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994147\">\n<div class=\"\">\n<p><code>1<\/code><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>These fields come from WooCommerce&#8217;s current built-in <a href=\"https:\/\/github.com\/woocommerce\/woocommerce\/wiki\/Product-CSV-Import-Schema\" target=\"_blank\" rel=\"noopener nofollow\">Product CSV Import Schema<\/a>. The schema also includes fields for descriptions, inventory, shipping, downloads, upsells, cross-sells, external products, and other product properties.<\/p>\n<p>For <strong>variable products,<\/strong> the Parent and Attribute fields are particularly important because WooCommerce uses them to establish the relationship between the parent product and its variations. We&#8217;ll cover this structure in more detail later in the guide.<\/p>\n<h3>Custom fields and metadata<\/h3>\n<p>In addition, WooCommerce also supports importing product metadata through CSV. To import a custom metadata field, add the meta: prefix to the column header. For example:<\/p>\n<p><span style=\"font-family: 'courier new', courier, monospace;\">meta:product_depth<\/span><\/p>\n<p>This tells WooCommerce to treat the column as product metadata rather than a standard product field. Unrecognized columns without the appropriate mapping are not imported by default. The built-in importer supports plain-text custom metadata; serialized data and JSON are not supported by the standard CSV schema.<\/p>\n<hr \/>\n<h2>WooCommerce CSV Import: How to Import Important Fields &amp; Data Using CSV<\/h2>\n<p>Once your CSV follows WooCommerce\u2019s required format, you can run a WooCommerce CSV import to add or update product data in bulk. The overall workflow is similar for different types of data, but products, variations, images, and custom metadata require different CSV structures.<\/p>\n<p>Follow the relevant steps below based on what you want to import.<\/p>\n<h3>1. Importing products<\/h3>\n<p>For standard products, you can import fields such as product names, SKUs, prices, categories, stock, and descriptions through WooCommerce\u2019s built-in CSV importer.<\/p>\n<h4><strong>Step 1:<\/strong> Prepare your product CSV<\/h4>\n<p>First, create your CSV with the product data you want to import and use WooCommerce\u2019s supported column headers, such as Name, SKU, Regular price, Sale price, Categories, Tags, and Images. Save the file as a UTF-8 CSV. If you are updating existing products, include their product IDs or SKUs so WooCommerce can match the rows to the products in your store.<\/p>\n<h4><strong>Step 2:<\/strong> Upload the CSV and map your columns<\/h4>\n<p>In your WordPress dashboard, go to <strong>Products &gt; All Products<\/strong> and click <strong>Import<\/strong> at the top of the page.<\/p>\n<figure id=\"attachment_94698\" aria-describedby=\"caption-attachment-94698\" style=\"width: 1272px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"size-full wp-image-94698\" src=\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products.webp\" alt=\"woocommerce-csv-products\" width=\"1272\" height=\"580\" srcset=\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products.webp 1272w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products-300x137.webp 300w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products-1024x467.webp 1024w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products-768x350.webp 768w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products-750x342.webp 750w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woo-products-1140x520.webp 1140w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><figcaption id=\"caption-attachment-94698\" class=\"wp-caption-text\">Click &#8220;Import&#8221; to upload your CSV.<\/figcaption><\/figure>\n<p>On the Upload CSV file screen, click <strong>Choose File,<\/strong> select your CSV, and click <strong>Continue<\/strong>. WooCommerce will take you to the Column mapping screen and automatically match recognized CSV headers to product fields. Review the mappings and use the dropdown beside any column to select the correct field or Do not import if you want to skip it.<\/p>\n<h4><strong>Step 3:<\/strong> Run the import and check your products<\/h4>\n<p>Once the mappings are correct, click <strong>Run the importer<\/strong>. Wait for WooCommerce to finish processing the CSV without refreshing or leaving the page. When the import is complete, open several products and check important fields such as SKUs, prices, categories, stock, and descriptions.<\/p>\n<div class=\"table3\">\n<p>Updating existing products<\/p>\n<p>If you want to update rather than create products, select <strong>Update existing products<\/strong> on the upload screen before clicking <strong>Continue.<\/strong> WooCommerce matches the rows in your CSV to existing products by ID or SKU. In WooCommerce 11.2 and later, a mapped GTIN, UPC, EAN, or ISBN column is also used, but only when both ID and SKU are empty. Rows that do not match an existing product are skipped, except new variation rows that WooCommerce can create under an existing parent product.<\/p>\n<\/div>\n<h3>2. Importing variable products and variations<\/h3>\n<p>Unlike simple products, variable products need a different CSV structure because the file must define the parent product and its individual variations.<\/p>\n<h4><strong>Step 1:<\/strong> Set up the parent and variation rows in your CSV<\/h4>\n<p>First, create one row for the parent product and one row for each variation.<\/p>\n<p>Then, set the parent product\u2019s Type to variable and each variation\u2019s Type to variation. Give the parent and each variation a SKU and make sure every variation has a unique SKU. In each variation row, use the <strong>Parent<\/strong> column to connect it to the parent product using the parent SKU or ID.<\/p>\n<h4><strong>Step 2:<\/strong> Add the attributes and variation values<\/h4>\n<p>Now, use columns such as <span style=\"font-family: 'courier new', courier, monospace;\">Attribute 1 name<\/span>, <span style=\"font-family: 'courier new', courier, monospace;\">Attribute 1 value(s)<\/span>, <span style=\"font-family: 'courier new', courier, monospace;\">Attribute 1 visible<\/span>, and <span style=\"font-family: 'courier new', courier, monospace;\">Attribute 1 global<\/span> to define the attributes. The parent row should contain all available values, while each variation row should contain the value assigned to that variation.<\/p>\n<p>For example, a T-shirt with Small and Medium variations can use this structure:<\/p>\n<table class=\"wptb-preview-table wptb-element-main-table_setting-99402 edit-active\" style=\"width: 100%;\" role=\"table\" data-reconstraction=\"1\" data-wptb-table-tds-sum-max-width=\"543\" data-wptb-cells-width-auto-count=\"1\" data-wptb-horizontal-scroll-status=\"false\" data-wptb-extra-styles=\"LyogRW50ZXIgeW91ciBjdXN0b20gQ1NTIHJ1bGVzIGhlcmUgKi8=\" data-table-columns=\"8\">\n<tbody>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"0\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994148\">\n<div class=\"\">\n<p><strong>Type<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"0\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994149\">\n<div class=\"\">\n<p><strong>SKU<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"0\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994150\">\n<div class=\"\">\n<p><strong>Parent<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"0\" data-x-index=\"3\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994151\">\n<div class=\"\">\n<p><strong>Regular price<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"0\" data-x-index=\"4\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994152\">\n<div class=\"\">\n<p><strong>Attribute 1 name<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"0\" data-x-index=\"5\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994153\">\n<div class=\"\">\n<p><strong>Attribute 1 value(s)<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"0\" data-x-index=\"6\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994154\">\n<div class=\"\">\n<p><strong>Attribute 1 visible<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"0\" data-x-index=\"7\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994155\">\n<div class=\"\">\n<p><strong>Attribute 1 global<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"1\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994156\">\n<div class=\"\">\n<p><strong>variable<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"1\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994157\">\n<div class=\"\">\n<p>tshirt<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"1\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994158\">\n<div class=\"\">\n<p>(leave empty)<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"1\" data-x-index=\"3\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994159\">\n<div class=\"\">\n<p>(leave empty)<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"1\" data-x-index=\"4\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994160\">\n<div class=\"\">\n<p>Size<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"1\" data-x-index=\"5\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994161\">\n<div class=\"\">\n<p>S, M<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"1\" data-x-index=\"6\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994162\">\n<div class=\"\">\n<p>1<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"1\" data-x-index=\"7\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994163\">\n<div class=\"\">\n<p>0<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"2\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994164\">\n<div class=\"\">\n<p><strong>variation<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"2\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994165\">\n<div class=\"\">\n<p>tshirt-s<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"2\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994166\">\n<div class=\"\">\n<p>tshirt<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"2\" data-x-index=\"3\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994167\">\n<div class=\"\">\n<p>24.99<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"2\" data-x-index=\"4\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994168\">\n<div class=\"\">\n<p>Size<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"2\" data-x-index=\"5\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994169\">\n<div class=\"\">\n<p>S<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"2\" data-x-index=\"6\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994170\">\n<div class=\"\">\n<p>1<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"2\" data-x-index=\"7\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994171\">\n<div class=\"\">\n<p>0<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"wptb-row\">\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"3\" data-x-index=\"0\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994172\">\n<div class=\"\">\n<p><strong>variation<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"3\" data-x-index=\"1\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994173\">\n<div class=\"\">\n<p>tshirt-m<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"3\" data-x-index=\"2\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994174\">\n<div class=\"\">\n<p>tshirt<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"3\" data-x-index=\"3\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994175\">\n<div class=\"\">\n<p>24.99<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"3\" data-x-index=\"4\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994176\">\n<div class=\"\">\n<p>Size<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 13%;\" data-y-index=\"3\" data-x-index=\"5\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994177\">\n<div class=\"\">\n<p>M<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"3\" data-x-index=\"6\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994178\">\n<div class=\"\">\n<p>1<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"wptb-cell\" style=\"width: 12%;\" data-y-index=\"3\" data-x-index=\"7\">\n<div class=\"wptb-text-container wptb-ph-element wptb-element-text-994179\">\n<div class=\"\">\n<p>0<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>For a local product attribute, set <span style=\"font-family: 'courier new', courier, monospace;\">Attribute 1 global<\/span> to 0. Use 1 when the attribute is a global attribute already configured in the store. Also, add a Regular price to every variation row, since variations without a price can&#8217;t be purchased.<\/p>\n<h4><strong>Step 3:<\/strong> Import the CSV through the product importer<\/h4>\n<p>Go to<strong> Products &gt; All Products &gt; Import<\/strong>, click <strong>Choose File<\/strong>, select the CSV, and click<strong> Continue.<\/strong> On the Column mapping screen, check that the Type, SKU, Parent, and attribute columns are mapped correctly. Then click <strong>Run the importer<\/strong> and wait for the process to finish.<\/p>\n<h4><strong>Step 4:<\/strong> Verify the variable product<\/h4>\n<p>Last but not least, open the imported product and check that WooCommerce has created the parent as a variable product and attached the expected variations to it. Check the variation attributes, SKUs, prices, and stock individually.<\/p>\n<p>If you are converting an existing simple product: WooCommerce 11.1 introduced a single-import workflow for this case when the parent product row appears before its variation rows. You select <strong>Update existing products<\/strong> during the import, and WooCommerce updates the existing parent and creates the new variations in the same import. For this to work, each variation row needs to:<\/p>\n<ul>\n<li>Leave the ID column empty.<\/li>\n<li>Set Type to variation.<\/li>\n<li>Have a unique SKU (or, in WooCommerce 11.2 and later, a usable GTIN).<\/li>\n<li>Use the parent&#8217;s SKU or id:123 in the Parent column, with attribute names and values that match the parent row.<\/li>\n<\/ul>\n<p>Before you start, create a backup or test the import on a staging site. After the import, check the product&#8217;s <strong>Variations<\/strong> tab.<\/p>\n<p>If you cannot guarantee the row order, or you are using a version earlier than 11.1, WooCommerce recommends using two imports instead. First, import the parent row with <strong>Update existing products<\/strong> selected to change it to a variable product and add its attributes. Then, import only the variation rows with <strong>Update existing products<\/strong> unselected.<\/p>\n<h3>3. Importing product images<\/h3>\n<p>Here&#8217;s the great news: You can add product images through <strong>the Images column in the same product CSV,<\/strong> so images don&#8217;t need a separate WooCommerce CSV import. WooCommerce supports images that are already in the Media Library as well as directly accessible external image URLs.<\/p>\n<h4><strong>Step 1:<\/strong> Add your image references to the CSV<\/h4>\n<p>In the<strong> Images<\/strong> column, enter the direct URL of an online image or the filename of an image that is already available in your Media Library.<\/p>\n<p>Separate multiple image URLs or filenames for one product with commas. The first image is used as the featured image; meanwhile, additional images are added to the product gallery.<\/p>\n<figure id=\"attachment_94701\" aria-describedby=\"caption-attachment-94701\" style=\"width: 1247px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"size-full wp-image-94701\" src=\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images.webp\" alt=\"woocommerce-csv-using-external-images\" width=\"1247\" height=\"327\" srcset=\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images.webp 1247w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images-300x79.webp 300w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images-1024x269.webp 1024w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images-768x201.webp 768w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images-750x197.webp 750w, https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-csv-using-external-images-1140x299.webp 1140w\" sizes=\"(max-width: 1247px) 100vw, 1247px\" \/><figcaption id=\"caption-attachment-94701\" class=\"wp-caption-text\">Enter the direct URL of an online image in the &#8220;Images&#8221; column.<\/figcaption><\/figure>\n<h4><strong>Step 2:<\/strong> Check the image URLs before importing<\/h4>\n<p>For external images, make sure the URL points directly to an accessible image. WooCommerce downloads accessible external images into the Media Library during the import. However, some hosts block these requests, require you to sign in, or return a web page instead of the image file (for example, a file-sharing link that opens a preview page). In that case, upload the image to your Media Library or use a direct image URL.<\/p>\n<h4><strong>Step 3:<\/strong> Upload and import the CSV<\/h4>\n<p>Go to <strong>Products &gt; All Products &gt; Import,<\/strong> then click <strong>Choose File <\/strong>and select your CSV. On the Column mapping screen, make sure the Images column is mapped to the image field. Then, just like with other import processes, click <strong>Run the importer<\/strong> and wait for the import to finish.<\/p>\n<p>Once done, open several imported products and confirm that the featured image and gallery images appear correctly. Note that WooCommerce\u2019s core CSV importer cannot add, edit, or update product image alt text through the CSV.<\/p>\n<h3>4. Importing custom product data<\/h3>\n<p>What if your products contain custom metadata that is not covered by WooCommerce\u2019s standard product fields? In that case, you can import it using the <span style=\"font-family: 'courier new', courier, monospace;\">meta:<\/span> prefix.<\/p>\n<h4><strong>Step 1:<\/strong> Add the custom metadata to your CSV<\/h4>\n<p>First, identify the metadata key used by your custom product field and add it to the CSV header with <span style=\"font-family: 'courier new', courier, monospace;\">meta:<\/span> in front of it.<\/p>\n<p>For example, if the metadata key is product_depth, use <span style=\"font-family: 'courier new', courier, monospace;\">meta:product_depth<\/span> as the column header. Enter the corresponding value for each product in that column.<\/p>\n<h4><strong>Step 2:<\/strong> Upload the CSV and map the metadata column<\/h4>\n<p>Go to <strong>Products &gt; All Products &gt; Import,<\/strong> click <strong>Choose File<\/strong> and upload your CSV. On the Column mapping screen, WooCommerce can recognize meta: columns as product metadata. If the column is not mapped automatically, open its dropdown and select <strong>Import as meta<\/strong>.<\/p>\n<p>After checking the mapping, click <strong>Run the importer<\/strong> and wait for the process to finish. Then check the affected products to confirm that the custom metadata was imported correctly.<\/p>\n<p>Keep in mind that WooCommerce\u2019s core importer only handles fields supported by its product CSV schema and recognized product metadata. If the data comes from a third-party extension and requires extension-specific fields, check that extension\u2019s import documentation before proceeding.<\/p>\n<hr \/>\n<h2>Need Help With Your WooCommerce CSV Import?<\/h2>\n<p>WooCommerce\u2019s built-in importer works well for product CSVs that follow its required format. But a WooCommerce CSV import gets harder when your files come from another platform with different column names, product relationships, or data structures. The core importer also doesn&#8217;t handle customers or orders.<\/p>\n<p>LitExtension\u2019s <strong><a href=\"https:\/\/litextension.com\/woocommerce-migration-tool\/csvfiles-to-woocommerce.html?utm_source=blog&amp;utm_medium=display&amp;utm_campaign=anchortext&amp;utm_term=kristen&amp;utm_content=woocommercecsvimport\">CSV to WooCommerce migration<\/a><\/strong> lets you move products (with categories, variations, attributes, and images), customers, orders, coupons, and more from your files. You can choose between two options:<\/p>\n<ul>\n<li><strong>Automated Migration:<\/strong> Upload your files, run a free demo, then launch the full migration yourself.<\/li>\n<li><strong>All-in-One Migration Service:<\/strong> Our team prepares and maps your files, handles the migration, and checks the results before delivery.<\/li>\n<\/ul>\n<p>If your old store is still live on one of 140+ supported platforms, LitExtension\u2019s <strong><a href=\"https:\/\/app.litextension.com\/?utm_source=blog&amp;utm_medium=display&amp;utm_campaign=anchortext&amp;utm_term=kristen&amp;utm_content=woocommercecsvimport\" target=\"_blank\" rel=\"noopener\">Automated Migration Tool<\/a><\/strong> can transfer the data directly, with no CSV files to prepare.<\/p>\n<div class=\"cta-detail\">\n<div>\n<p class=\"title\"><strong><span style=\"font-size: 28px;\">Move Your CSV Data to WooCommerce Automatically<\/span><\/strong><\/p>\n<p style=\"margin-bottom: 2px; font-size: 16px; line-height: 2;\">LitExtension Automated Migration Tool transfers products, customers, and orders from your CSV files to WooCommerce. Try a free demo before the full migration.<\/p>\n<p><a class=\"btn-frame\" href=\"https:\/\/litextension.com\/woocommerce-migration-tool\/csvfiles-to-woocommerce.html?utm_source=blog&amp;utm_medium=display&amp;utm_campaign=ctabox&amp;utm_term=kristen&amp;utm_content=woocommercecsvimport_mid\" target=\"_blank\" rel=\"noopener noreferrer\">START FREE DEMO<\/a><\/p>\n<\/div>\n<div><img decoding=\"async\" class=\"size-medium wp-image-78213\" src=\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2024\/09\/2-08-1.png\" alt=\"LitExtension Automated Migration Tool Demo\" \/><\/div>\n<\/div>\n<hr \/>\n<h2 style=\"text-align: left;\">Troubleshooting WooCommerce CSV Import Issues<\/h2>\n<p style=\"text-align: left;\">Even a properly formatted file can hit snags during a WooCommerce CSV import. Here are the errors that come up most often, and what actually fixes them.<\/p>\n<h3 style=\"text-align: left;\">1. WooCommerce cannot upload or process the CSV<\/h3>\n<p style=\"text-align: left;\">A CSV may fail before the import starts because of an invalid file format, server restrictions, or a file that is too large for the server to process. WooCommerce recommends using a UTF-8 CSV and splitting large files into smaller batches when necessary.<\/p>\n<p style=\"text-align: left;\">How to fix it:<\/p>\n<ul>\n<li style=\"text-align: left;\">Make sure the file is saved as a UTF-8 CSV with the .csv extension.<\/li>\n<li style=\"text-align: left;\">If WordPress displays \u201cSorry, this file type is not permitted for security reasons,\u201d upload the CSV to the site&#8217;s uploads directory through SFTP or the hosting file manager. Then use Show advanced options in the importer to enter the server file path.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">For large files, split the CSV into smaller batches and import them separately. If the problem continues, ask your hosting provider to check allowed file types, upload, memory, and processing limits.<\/p>\n<h3 style=\"text-align: left;\">2. CSV data is imported into the wrong field or not imported<\/h3>\n<p style=\"text-align: left;\">WooCommerce automatically maps recognized CSV headers, but columns that do not match the product CSV schema are not imported by default. Formatting also affects how values are interpreted: use numeric values in the ID column, and add the id: prefix when referencing a product ID in columns such as Parent.<\/p>\n<p style=\"text-align: left;\">How to fix it:<\/p>\n<ul>\n<li style=\"text-align: left;\">On the Column mapping screen, review the mapping for every column before clicking Run the importer. Select <strong>Do not import<\/strong> for columns you do not need.<\/li>\n<li style=\"text-align: left;\">Check that your headers match WooCommerce&#8217;s supported schema.<\/li>\n<li style=\"text-align: left;\">Use the correct format for special values, such as 1\/0 for Boolean fields and id:100 when referencing an existing product ID.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">For custom metadata, use the<span style=\"font-family: 'courier new', courier, monospace;\"> meta:<\/span> prefix, such as meta:product_depth, and map it to Import as meta if necessary.<\/p>\n<h3 style=\"text-align: left;\">3. Variations or their attributes are not imported correctly<\/h3>\n<p style=\"text-align: left;\">Variation data depends on several CSV fields working together. If the Type, Parent, SKU, or attribute values are inconsistent, WooCommerce may skip the variation or fail to associate it with the correct parent product.<\/p>\n<p style=\"text-align: left;\">How to fix it:<\/p>\n<ul>\n<li style=\"text-align: left;\">Set the parent product&#8217;s Type to variable and each variation&#8217;s Type to variation. Give every variation a unique SKU.<\/li>\n<li style=\"text-align: left;\">Check that Parent contains the correct parent SKU or ID.<\/li>\n<li style=\"text-align: left;\">Make sure the attribute name and values in the variation rows match those defined for the parent.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">When converting an existing simple product using WooCommerce 11.1&#8217;s single-import workflow, make sure the parent row appears before its variation rows and the ID column of each variation row is empty.<\/p>\n<h3 style=\"text-align: left;\">4. Images are missing or duplicated after import<\/h3>\n<p style=\"text-align: left;\">As mentioned earlier, WooCommerce can import images from direct external URLs or reference images already available in the Media Library. Still, problems can occur when an image URL is inaccessible or returns a web page instead of the image file, or when the same image is referenced by slightly different URLs.<\/p>\n<p style=\"text-align: left;\">How to fix it:<\/p>\n<ul>\n<li style=\"text-align: left;\">Open external image URLs directly in a browser to confirm that they point to the actual image.<\/li>\n<li style=\"text-align: left;\">Check that the Images values are correctly formatted.<\/li>\n<li style=\"text-align: left;\">Use the exact same URL for an image across imports, since WooCommerce reuses images it has already imported from that URL. Or use the filename of an image that&#8217;s already in your Media Library.<\/li>\n<li style=\"text-align: left;\">Test a small number of images before importing a large catalog.<\/li>\n<\/ul>\n<p>Again, please keep in mind that the core WooCommerce importer does not add or update image alt text through CSV.<\/p>\n<h3>5. Products are skipped during import<\/h3>\n<p>Check the import log to identify the affected rows and their reported errors.<\/p>\n<ul>\n<li>If a SKU already exists, select Update existing products when you intend to update that product.<\/li>\n<li>For standard product updates, confirm that each row\u2019s ID or SKU matches an existing product.<\/li>\n<li>If products were imported but seem missing, check their Published values and product status.<\/li>\n<\/ul>\n<p>Correct the affected rows and test a small batch before retrying the full file.<\/p>\n<hr \/>\n<h2 style=\"text-align: left;\">Best Practices for WooCommerce CSV Import<\/h2>\n<p style=\"text-align: left;\">Most of the issues above are avoidable, not just fixable after the fact. A few habits go a long way toward making a WooCommerce CSV import predictable instead of a gamble:<\/p>\n<ul>\n<li><strong>Back up your store before importing.<\/strong> Keep a current backup of your database and site files so you can restore the store if needed, or test the import on a staging site first. A product CSV export is useful for reference, but it does not replace a full backup.<\/li>\n<li><strong>Test with a small batch first<\/strong>. Import 5\u201310 rows before running the full file. This surfaces mapping or formatting issues while they&#8217;re still easy to fix, rather than after thousands of rows have already gone through.<\/li>\n<li><strong>Save your file as UTF-8 before every import.<\/strong> Recheck the saved CSV after editing, as spreadsheet applications can change its encoding or formatting.<\/li>\n<li><strong>Use consistent IDs or SKUs for update imports.<\/strong> Confirm that these identifiers match the existing products and are mapped correctly, then select Update existing products before running the importer.<\/li>\n<li><strong>Review the mapping screen manually<\/strong>, even when the auto-match looks right. A silently wrong mapping produces no error \u2013 just incorrect data sitting in the right-looking place.<\/li>\n<li><strong>Spot-check after every import<\/strong>, not just the first one. Open a handful of products \u2013 ideally including at least one variable product \u2013 and confirm images, pricing, stock, and variations all look correct.<\/li>\n<li><strong>Keep source files organized by import date and entity type<\/strong>. If you ever need to re-run or partially undo an import, having the exact file you used on hand saves significant time.<\/li>\n<li><strong>For recurring imports, standardize your export template once<\/strong>. A consistent column structure in your source system means less remapping each time you run the process.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">None of these steps takes long individually, but skipping them is exactly how a &#8220;successful&#8221; import ends up needing a second pass or a manual cleanup a few days later.<\/p>\n<hr \/>\n<h2>WooCommerce CSV Import \u2013 FAQs<\/h2>\n<div class=\"faq faq-single-post\">\n<details>\n<summary>Can I import a CSV file directly into WooCommerce?<\/summary>\n<div class=\"content\">\n<p>Yes. The built-in Product CSV Importer handles WooCommerce CSV import for products through Products &gt; All Products &gt; Import, so you can add or update products in bulk. It does not import customers or orders. To move customer data, see our guide on how to <strong><a href=\"https:\/\/litextension.com\/blog\/woocommerce-import-customers\/\">import WooCommerce customers<\/a><\/strong>.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>What format should a WooCommerce CSV file be?<\/summary>\n<div class=\"content\">\n<p>Save your file as UTF-8 CSV using WooCommerce\u2019s supported column headers. Export an existing product, or download WooCommerce&#8217;s sample product CSV from GitHub, to get a compatible starting template. Use numeric IDs in the ID column and the id: prefix for ID references in columns such as Parent.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Can I import product images with a WooCommerce CSV?<\/summary>\n<div class=\"content\">\n<p>Yes. Use the Images column with directly accessible image URLs or filenames from your Media Library. Separate multiple images with commas; the first becomes the featured image.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>How do I update existing WooCommerce products with a CSV?<\/summary>\n<div class=\"content\">\n<p>Include matching product IDs or SKUs, select Update existing products when uploading your CSV, review the column mapping, and run the importer.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Can I import variable products with a CSV?<\/summary>\n<div class=\"content\">\n<p>Yes. Use a variable parent row and separate variation rows, linked through Parent. Give each variation a unique SKU and matching attribute values. If variations are missing, check the import log and parent references before retrying.<\/p>\n<\/div>\n<\/details>\n<\/div>\n<hr \/>\n<h2>Final Words<\/h2>\n<p>A successful WooCommerce CSV import starts with a file that matches your products and the changes you want to make. Use the correct column structure, check IDs or SKUs when updating existing products, and test a small batch before importing your full catalog.<\/p>\n<p>After the import, review your product details, variations, and images, and check the import log for any failed or skipped rows. These checks help you catch problems early and build a reliable WooCommerce CSV import workflow for future product updates.<\/p>\n<div class=\"cta-detail\">\n<div>\n<p class=\"title\"><strong><span style=\"font-size: 28px;\">Let Our Experts Handle Your CSV Migration!<\/span><\/strong><\/p>\n<p class=\"cta-desc\">With the All-in-One Migration Service, our experts prepare and map your files, run the migration, and check every result for you.<\/p>\n<p><a class=\"btn-frame\" href=\"https:\/\/litextension.com\/migration-services\/csv-files-migration.html?utm_source=blog&amp;utm_medium=display&amp;utm_campaign=ctabox&amp;utm_term=kristen&amp;utm_content=woocommercecsvimport_bot\" target=\"_blank\" rel=\"noopener noreferrer\">BOOK FREE CONSULTATION<\/a><\/p>\n<\/div>\n<div><img decoding=\"async\" class=\"size-medium wp-image-78213\" src=\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2024\/09\/2-08-1.png\" alt=\"All-in-One Migration Service\" \/><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>WooCommerce CSV import is a convenient way to add or update products without entering each item manually. However, even small formatting errors can result in missing images, incorrect variations, or duplicate products. The good news is that the process is straightforward once you understand the CSV format WooCommerce requires! In this guide, we\u2019ll explain how [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":95845,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","jnews-multi-image_gallery":[],"jnews_single_post":{"source_name":"","source_url":"","via_name":"","via_url":"","override_template":"0","override":[{"template":"1","single_blog_custom":"","parallax":"1","fullscreen":"1","layout":"right-sidebar","sidebar":"default-sidebar","second_sidebar":"default-sidebar","sticky_sidebar":"1","share_position":"bottom","share_float_style":"share-monocrhome","show_share_counter":"1","show_view_counter":"1","show_featured":"1","show_post_meta":"1","show_post_author":"1","show_post_author_image":"1","show_post_date":"1","post_date_format":"default","post_date_format_custom":"Y\/m\/d","show_post_category":"1","show_post_reading_time":"0","post_reading_time_wpm":"300","show_zoom_button":"0","zoom_button_out_step":"2","zoom_button_in_step":"3","show_post_tag":"0","show_prev_next_post":"1","show_popup_post":"0","number_popup_post":"1","show_author_box":"0","show_post_related":"1","show_inline_post_related":"0"}],"override_image_size":"0","image_override":[{"single_post_thumbnail_size":"no-crop","single_post_gallery_size":"crop-500"}],"trending_post":"0","trending_post_position":"meta","trending_post_label":"Trending","sponsored_post":"0","sponsored_post_label":"Sponsored by","sponsored_post_name":"","sponsored_post_url":"","sponsored_post_logo_enable":"0","sponsored_post_logo":"","sponsored_post_desc":"","disable_ad":"0","format":"standard"},"jnews_primary_category":{"id":"","hide":""},"footnotes":""},"categories":[16622,16700],"tags":[10218,16741,364],"table_tags":[],"class_list":["post-56400","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-woocommerce","category-platform-tutorials","tag-configure-woocommerce","tag-how-to-import-products-to-woocommerce","tag-woocommerce-migration"],"uagb_featured_image_src":{"full":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-scaled.webp",2560,1830,false],"thumbnail":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-150x150.webp",150,150,true],"medium":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-300x214.webp",300,214,true],"medium_large":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-768x549.webp",768,549,true],"large":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-1024x732.webp",1024,732,true],"1536x1536":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-1536x1098.webp",1536,1098,true],"2048x2048":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-2048x1464.webp",2048,1464,true],"jnews-360x180":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-360x180.webp",360,180,true],"jnews-750x375":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-750x375.webp",750,375,true],"jnews-1140x570":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-1140x570.webp",1140,570,true],"jnews-120x86":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-120x86.webp",120,86,true],"jnews-350x250":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-350x250.webp",350,250,true],"jnews-750x536":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-750x536.webp",750,536,true],"jnews-1140x815":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-1140x815.webp",1140,815,true],"jnews-360x504":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-360x504.webp",360,504,true],"jnews-75x75":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-75x75.webp",75,75,true],"jnews-350x350":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-350x350.webp",350,350,true],"jnews-featured-750":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-750x536.webp",750,536,true],"jnews-featured-1140":["https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/11\/woocommerce-csv-import-1140x815.webp",1140,815,true]},"uagb_author_info":{"display_name":"Kristen Quach","author_link":"https:\/\/litextension.com\/blog\/author\/kristenq\/"},"uagb_comment_info":0,"uagb_excerpt":"WooCommerce CSV import is a convenient way to add or update products without entering each item manually. However, even small formatting errors can result in missing images, incorrect variations, or duplicate products. The good news is that the process is straightforward once you understand the CSV format WooCommerce requires! In this guide, we\u2019ll explain how&hellip;","_links":{"self":[{"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/posts\/56400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/comments?post=56400"}],"version-history":[{"count":74,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/posts\/56400\/revisions"}],"predecessor-version":[{"id":95865,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/posts\/56400\/revisions\/95865"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/media\/95845"}],"wp:attachment":[{"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/media?parent=56400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/categories?post=56400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/tags?post=56400"},{"taxonomy":"table_tags","embeddable":true,"href":"https:\/\/litextension.com\/blog\/wp-json\/wp\/v2\/table_tags?post=56400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}