{"id":1700,"date":"2021-06-15T14:49:43","date_gmt":"2021-06-15T14:49:43","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/?p=1700"},"modified":"2025-10-21T08:49:20","modified_gmt":"2025-10-21T08:49:20","slug":"how-to-import-data-to-woocommerce-using-woocommerce-bulk-product-editing-plugin","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/how-to-import-data-to-woocommerce-using-woocommerce-bulk-product-editing-plugin\/","title":{"rendered":"How to import data to Woocommerce using PBULKiT &#8211; Bulk Edit WooCommerce Products plugin?"},"content":{"rendered":"\n<p>Importing data related to the thousands of WooCommerce products can be done in a few minutes by using the&nbsp; <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-product-editing\/?utm_source=kb&amp;utm_content=import-products\" target=\"_blank\" rel=\"noreferrer noopener\">PBULKiT &#8211; Bulk Edit WooCommerce Products Plugin<\/a>.&nbsp;This means you can import data as WooCommerce default import products.<\/p>\n\n\n\n<p>By using the options provided in the \u201c<strong>Import\/Export<\/strong>\u201d tab of our plugin, you can import data from files with CSV format, including thousands of products with their features, attributes, prices, shipping classes, or any other field supported in WooCommerce.&nbsp;&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to import <\/strong>t<strong>housands of WooCommerce Products to our plugin?<\/strong><\/h2>\n\n\n\n<p>To import data from your pc or any other devices, first, you need to go to the address below and open the \u201c<strong>Import\/ Export<\/strong>\u201d tab:<\/p>\n\n\n\n<p><strong>WordPress dashboard >\u00a0 iThemeland >\u00a0 PBULKiT >\u00a0 Import \/ Export tab<\/strong><\/p>\n\n\n\n<p>As shown below, there is a specific button for importing data in this tab: the \u201c<strong>Import Now<\/strong>\u201d button<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2024\/04\/Import-Export-tab.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1518\" height=\"774\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2024\/04\/Import-Export-tab.png\" alt=\"import data in WooCommerce bulk product editing plugin\" class=\"wp-image-2503\"\/><\/a><\/figure>\n\n\n\n<p>Clicking on this button will direct you to a new page that is specifically designed by the WooCommerce plugin for importing data from your device.<\/p>\n\n\n\n<p>As you can see in the picture below, you need to complete four stages to import data to our plugin, including:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Upload CSV file<\/li>\n\n\n\n<li>Column mapping<\/li>\n\n\n\n<li>Import<\/li>\n\n\n\n<li>Done<\/li>\n<\/ol>\n\n\n\n<p>Completing these stages is straightforward. So, stay with us to see how we can use these stages to import data to our plugin.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Upload CSV file<\/strong><\/h3>\n\n\n\n<p>To upload a CSV file, you need to click on the \u201c<strong>Choose file<\/strong>\u201d button:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-upload-CSV-file.jpg\"><img decoding=\"async\" width=\"1200\" height=\"597\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-upload-CSV-file.jpg\" alt=\"upload CSV file in WooCommerce bulk product editing plugin\" class=\"wp-image-1705\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>Then select your file in the new pop-up and click on the \u201c<strong>Open<\/strong>\u201d button:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-select-file.jpg\"><img decoding=\"async\" width=\"1200\" height=\"620\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-select-file.jpg\" alt=\"select csv file for import data\" class=\"wp-image-1708\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>After adding a CSV file, you can click on the \u201c<strong>Continue<\/strong>\u201d button to go to the next stage.<\/p>\n\n\n\n<p>There is also a checkbox on this page; if you mark the checkbox, the data of products that have the same ID or SKU as the products in the imported file will be updated.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-Continue-button.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"585\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-Continue-button.jpg\" alt=\"import products in woocommerce bulk product editing\" class=\"wp-image-1710\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Column mapping<\/strong><\/h3>\n\n\n\n<p>As soon as you click on the \u201cContinue\u201d button, you will be led to the next stage. In this stage, all fields related to the products are available, and you can choose from which columns in the imported file you want to assign data to them.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-Column-mapping.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"604\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-Column-mapping.jpg\" alt=\"Column mapping during import data\" class=\"wp-image-1712\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>All fields are assigned to a default column, although it is possible to match the fields with the columns that exist in your file according to your requirements.<\/p>\n\n\n\n<p>For example, we assigned the following columns to the fields:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u201c<strong>Product<\/strong> <strong>Id<\/strong>\u201d (a column in our CSV file) to <strong>ID<\/strong> (A field in our plugin)<\/li>\n\n\n\n<li>\u201c<strong>Product Title<\/strong>\u201d (a column in our CSV file) to \u201c<strong>Title<\/strong>\u201d (A field in our plugin)<\/li>\n\n\n\n<li>\u201c<strong>Color<\/strong>\u201d (a column in our CSV file) to \u201c<strong>Attribute name<\/strong>\u201d (A field in our plugin)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-map-to-field.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"603\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-map-to-field.jpg\" alt=\"map to field\" class=\"wp-image-1714\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>When you assign those columns properly, you need to click on the \u201c<strong>Run the import<\/strong>\u201d button at the bottom of this page to go to the next stage.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"600\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-Run-the-import.jpg\" alt=\"click on the \u201cRun the import\u201d\" class=\"wp-image-1719\" style=\"width:1200px\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Import<\/strong><\/h3>\n\n\n\n<p>In this stage, there is no need to do anything. Please wait to import data from your file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-importing.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"583\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-importing.jpg\" alt=\"import data\" class=\"wp-image-1722\" style=\"width:1024px\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Done<\/strong><\/h3>\n\n\n\n<p>You will see the message below in the final stage, which means that WordPress imported all of the data successfully.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-importing-is-done.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"591\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-content\/uploads\/sites\/4\/2021\/03\/42-importing-is-done.jpg\" alt=\"importing is done\" class=\"wp-image-1724\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>The result<\/strong><\/h3>\n\n\n\n<p>To see the result, you can go back to the PBULKiT &#8211; Bulk Edit WooCommerce Products plugin main page(<strong> iThemeland &gt;&nbsp; PBULKiT<\/strong>) and check the table of products.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importing data related to the thousands of WooCommerce products can be done in a few minutes by using the&nbsp; PBULKiT &#8211; Bulk Edit WooCommerce Products Plugin.&nbsp;This means you can import data as WooCommerce default import products. By using the options provided in the \u201cImport\/Export\u201d tab of our plugin, you can import data from files with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1700","post","type-post","status-publish","format-standard","hentry","category-plugin-usage"],"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/posts\/1700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/comments?post=1700"}],"version-history":[{"count":2,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/posts\/1700\/revisions"}],"predecessor-version":[{"id":3698,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/posts\/1700\/revisions\/3698"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/media?parent=1700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/categories?post=1700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/wp-json\/wp\/v2\/tags?post=1700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}