How to Import & Export WooCommerce Products with Images (2024 Guide)
Are you looking to move your WooCommerce store to a new site? Or maybe you want to bulk edit your product data externally? Whatever the reason, knowing how to import and export WooCommerce products with images is an essential skill for managing your online store.
In this comprehensive guide, we‘ll walk you through the process step-by-step. Whether you‘re a WooCommerce beginner or a seasoned pro, you‘ll learn everything you need to know to confidently handle your product data. Let‘s dive in!
Why Import & Export WooCommerce Products?
There are several scenarios where importing and exporting WooCommerce products can be incredibly useful:
- Moving to a new website or server
- Duplicating products across multiple WooCommerce stores
- Bulk editing product data using spreadsheet software
- Creating a backup of your product catalog
- Migrating from another ecommerce platform to WooCommerce
By exporting your products to a CSV file, you have a portable, editable version of your product data that you can manipulate outside of WordPress. Once your changes are made, you can then import the CSV file back into WooCommerce to update your live products. This process is much faster than manually editing each product within WooCommerce itself.
What Data is Included When Exporting WooCommerce Products?
When you export products from WooCommerce, the following key data points are included in the CSV file:
- Product name & description
- SKU (Stock Keeping Unit)
- Regular and sale price
- Tax status and tax class
- Product categories and tags
- Product images (as URL paths)
- Product type (simple, variable, grouped, external)
- Product attributes and variations
- Shipping weight, dimensions, and class
- Upsells and cross-sells
- Custom metadata
Essentially, exporting gives you access to all the data that makes up a product listing. This allows you to make bulk changes efficiently, without limits.
How to Export WooCommerce Products (2 Methods)
WooCommerce provides a built-in product exporter that works well for simple stores. However, if you need more advanced export options, you‘ll want to use a plugin. Let‘s look at both methods:
Method 1: WooCommerce Built-In Product Export
- From your WordPress dashboard, go to Products → All Products.
- Click the Export button at the top of the screen.
- Choose which product data you want to export. If unsure, leave all boxes checked.
- Optionally, select Export custom meta to include custom fields.
- Click Generate CSV to create and download the export file.
The CSV file can be opened with any spreadsheet application like Microsoft Excel or Google Sheets. Each column represents a field of product data, and each row represents an individual product.
Method 2: Using the Product Import Export Plugin
For more advanced export options, you can use the free Product Import Export for WooCommerce plugin. This allows you to select specific products to export, filter by category or type, and include/exclude certain data fields.
- Install and activate the Product Import Export for WooCommerce plugin.
- Go to WooCommerce → Product Export.
- Select Products as your export type.
- Choose Quick Export or Advanced Export.
- If using Advanced Export, set your desired filters and options.
- Click Export to generate and download the CSV file.
The plugin provides granular control over your export, which is helpful when working with large, complex product catalogs. You can also save your export settings as a template to reuse later.
How to Import WooCommerce Products from a CSV File
Now that you have your product data in a CSV file, let‘s look at how to import it into WooCommerce. As with exporting, you have two main options: using the built-in WooCommerce product importer, or using a plugin for more advanced features. We‘ll cover both below.
Before You Begin: Prepare Your Import File
To ensure a smooth import, your CSV file must be properly formatted. Here are a few key points to keep in mind:
- Your CSV file should include column headers that match WooCommerce‘s expected fields. You can refer to an export file to see the correct headers.
- Fields that include commas, quotation marks, or other special characters should be enclosed in quotation marks.
- Image fields should contain the full URL path to the image, not just the filename.
- For multi-value fields like categories and attributes, separate values with a pipe character (|).
If you‘re including HTML in your product descriptions, make sure it is properly formatted and free of errors. It‘s also a good idea to remove any rogue spaces or line breaks around fields.
Once your CSV file is ready, you can proceed with the import.
Method 1: WooCommerce Built-In Product Import
- From your WordPress dashboard, go to Products → All Products.
- Click the Import button at the top of the screen.
- Click Choose File and select your CSV file, then click Continue.
- On the Column Mapping screen, match each column in your CSV file to the corresponding WooCommerce field. The importer will attempt to auto-map fields with matching names.
- If importing attributes, use the Attributes tab to map the columns and values.
- Click Run the Importer to start the import process.
The time to complete the import will depend on the number of products and images being processed. Once finished, you‘ll see a success message indicating how many products were imported.
Method 2: Using the Product Import Export Plugin
The Product Import Export for WooCommerce plugin offers additional import options, such as batch importing, updating existing products, and controlling stock status. Here‘s how to use it:
- Install and activate the plugin.
- Go to WooCommerce → Product Import.
- Select Products as your import type and click Continue.
- Choose your import file and delimiter settings, then click Continue.
- Map the columns of your import file to WooCommerce fields. The plugin supports custom mapping.
- Set your advanced import options, such as batch size and error handling.
- Click Import to start the process.
The plugin will process your import in batches to avoid server timeouts. You can view detailed logs of the import to troubleshoot any issues.
Tips for Successful WooCommerce Product Imports & Exports
Importing and exporting WooCommerce products is generally straightforward, but there are a few best practices to keep in mind:
Always backup your site before performing an import. This allows you to quickly restore if something goes wrong.
Test your import file with a small batch of products first. This lets you verify the data mapping and catch any formatting issues before importing your entire catalog.
Carefully review your products after the import to ensure images, variations, and other data points are displaying correctly.
When updating existing products via import, use the product SKU or ID to match records. Avoid matching by name or other fields that could have duplicates.
Be patient! Importing a large number of products and images can take some time. Don‘t navigate away from the import screen until it‘s fully completed.
By following these tips, you‘ll be well on your way to mastering WooCommerce product imports and exports.
Troubleshooting Common Issues
While WooCommerce product imports are usually smooth, you may occasionally encounter issues. Here are some common problems and how to resolve them:
"Invalid file type" error when uploading import file:
Make sure your CSV file is properly formatted and saved with the .csv extension. Avoid opening and saving the file in Excel, as this can introduce formatting issues. Use a plain text editor instead.
Images not importing:
Verify that your CSV file contains full URL paths to each image, not just filenames. The images must be accessible via HTTP from the WooCommerce server.
Variations not linking to parent products after import:
Make sure your CSV file includes the correct parent SKU or ID for each variation. Double-check that the parent products are being imported correctly.
Prices or other data not updating on existing products:
When updating products, make sure the SKU or ID column exactly matches the existing value in WooCommerce. Also verify that your column mapping is correct.
If you continue to have issues with your import, reach out to your web host or a WooCommerce expert for assistance. They‘ll be able to access your logs and troubleshoot the problem in more depth.
Frequently Asked Questions
Can I export only certain products from WooCommerce?
Yes! When using the Product Import Export plugin, you can filter your export by product type, category, status, and more. This allows you to export only the specific products you need.
How do I export WooCommerce products with images?
When exporting products, make sure to leave the Images column checked. This will include the full URL path to each product image in the export file. During the import process, WooCommerce will download and attach the images to each product.
Can I import and export products between different WooCommerce versions?
In general, it‘s best to export and import products between sites running the same major WooCommerce version (e.g. 3.x or 4.x). Importing products from a newer version of WooCommerce to an older version can lead to unexpected issues.
How can I speed up the import process?
If you‘re importing a large number of products, consider increasing your server‘s max_execution_time and memory_limit PHP settings. This will allow the import process to run longer without timing out. You can also use a plugin like Product Import Export to break your import into smaller batches.
Conclusion
Importing and exporting products is a key skill for any WooCommerce store owner. Whether you‘re migrating to a new host, duplicating products across multiple sites, or simply need to bulk edit your product data, the import/export process is crucial.
By following the steps outlined in this guide, you‘ll be able to tackle product imports and exports with confidence. Remember to properly format your CSV file, map columns carefully, and always backup your site before beginning. If you run into issues, don‘t hesitate to seek help from a professional.
With a little practice and preparation, you‘ll be a WooCommerce data wizard in no time!
