Data portability is a fundamental advantage of platforms like WooCommerce and WordPress, WooCommerce empowers merchants to fully own and control their data. This ensures that you can freely transfer and utilize your data across different systems as needed. In the context of this documentation, we’ll cover some options for exporting and migrating WooCommerce products.
How are products stored?
↑ Back to topWooCommerce products are stored as a type of ‘post,’ meaning that you can migrate products between sites the same way you migrate WordPress posts.
Products are stored in your site’s database within the _posts table, with product meta data inside the _postmeta table. There are also relationships to things like terms and organizational taxonomies, as they follow the same structure as posts. More info about WordPress’s data schema at Database Description.
There are several good options to assist with the import/export of product data, or migrating your entire site and database.
Exporting and Importing with WordPress
↑ Back to topTo export an XML file containing product data:
- Go to: Tools > Export and choose the content you wish to migrate.
- Click the” Download Export File” button. An XML file is downloaded to your computer.
- Go to the site to which you are moving the content and navigate to Tools > Import.
- Select WordPress and follow the instructions.
More details can be found in this WordPress.org article on Importing Content.
Migrating product data with CSVs
↑ Back to topTo import, export, change and merge product data, WooCommerce has a built-in CSV importer and exporter that covers the core product types, and many others. Check our detailed documentation on the built-in Product CSV Importer and Exporter.
If you have advanced product data, additional product types from extensions, or need a more efficient workflow for merging variable products, use our premium Product CSV Import Suite extension. The premium extension includes several handy extras like a tool to delete all products on your WooCommerce store with a single click.
Both of these tools work with CSV data and can be used to migrate data, or do first-time product imports from a CSV.
Migrating (all) data with Jetpack VaultPress Backup
↑ Back to topJetpack VaultPress Backup is a subscription-based security and backup service for self-hosted WordPress sites. Jetpack VaultPress Backup supports live backups of WooCommerce and it can be used to migrate your WordPress website to another host. Jetpack VaultPress Backup allows you to:
- Restore your site to any past state while keeping all orders and customer data current
- Clone your entire site to a new host or server
- Protect your customer data and stay GDPR compliant
- Backup and restore custom WooCommerce tables
More info at: Jetpack Backup: Migrate to a New Host