How to Create an Excel File to Import WooCommerce Products

Excel files (or any spreadsheet files) can be used to quickly and easily import WooCommerce products. You have complete control over the spreadsheet columns. Powerful functions like copy-and-paste and search-and-replace let you efficiently build large files with minimal typing. And WP All Import makes it simple to import a spreadsheet file into WooCommerce.


=== Chapters ===
00:00 Create a new WooCommerce product spreadsheet with the required columns
01:38 Create one row for each product variation
05:44 Publish the product spreadsheet to the web and obtain its URL
06:10 Create a new product import in WP All Import using the spreadsheet URL from the previous step
06:44 Drag and drop incoming data elements from the product spreadsheet to the WooCommerce product fields
09:41 Confirm and run the import
09:47 Review the imported products
10:22 Modify the import file (i.e., the product import spreadsheet) to add new products
11:07 Modify the settings associated with the previous product import
12:02 Rerun the import to import the new products
12:18 Review the newly added products
12:35 Set the import to run automatically on a schedule


=== Frequently Asked Questions ===
› Do I Have to Use a Specific Layout for My WooCommerce Product Spreadsheet?

No. WP All Import is extremely flexible when it comes to imports of any kind. You can map pretty much any incoming data element to any WordPress or WooCommerce field. The best thing to do is to build your WooCommerce product import file so that it makes sense to you and is easy to review and maintain.


› Does the Format of Each Column in the Product Import Spreadsheet Matter?

Yes and no. Simple is better. For example, entering just one value in each field instead of multiple values per field makes it easier to parse the data during the import. It also makes it easier to enter and maintain that data. But if the data is coming from elsewhere, and multiple values are stored in a single field (such as multiple sizes or colors for product variations), WP All Import can handle this with ease. In fact, as long as the incoming data is consistent, WP All Import can handle pretty much any type of content.


› Can I Change the Structure of My Product Import Spreadsheet For Subsequent Imports After I Have Already Used It?

Yes, but you have to make certain that you change the import template and/or settings to match the new import file structure. Otherwise, you will cause an error.


› What Can I Do if I Complete a Product Import and Then Later Discover That It Had Errors in It?

The best solution here is to fix your product import file and then rerun the import. When you do this, make sure that you configure your import settings to create, update, or delete existing products, as required by the errors you are attempting to correct.


=== Related Tutorials ===

To understand how to import WooCommerce products in general, see https://www.wpallimport.com/documenta....

For instructions on how to import WooCommerce variable products, see https://www.wpallimport.com/documenta....

When rerunning a product import, if you are attempting to sync stock levels, see https://www.wpallimport.com/documenta....

When rerunning a product import, if you are attempting to update prices, see https://www.wpallimport.com/documenta....

To bulk edit WooCommerce products, see https://www.wpallimport.com/documenta....

#wordpress
#wordpressplugin
#woocommerce
#woocommerceplugin
#woocommerce_products
#woocommerce_products_import
#woocommerce_products_excel
#woocommerce_products_spreadsheet