WooCommerce Backup Guide: How to Save Products, Orders, and Customers

If you run a WooCommerce store, a basic WordPress backup isn’t enough. Products, orders, and customer data live in specific database tables and upload folders. Lose them, and your business stops. This guide covers exactly how to back up each piece.

What Makes WooCommerce Backup Different?

Standard WordPress backups save posts, pages, and media. WooCommerce adds custom post types (products), sensitive order data, and customer accounts. All of this lives in the database but also references files in wp-content/uploads (product images, downloadable files). A proper WooCommerce backup must include both.

Most backup plugins handle this automatically if they back up the entire database. But if you’re migrating or restoring selectively, you need to know which tables hold your store data.

Backing Up WooCommerce Products

Products are stored as a custom post type (product) in the wp_posts table, with metadata in wp_postmeta. Variations, attributes, and stock levels all live in related tables like wp_woocommerce_product_meta_lookup and wp_term_relationships.

Method 1: WooCommerce Built-In CSV Export

Go to WooCommerce → Products → Export. You can export all products or filter by category, stock status, or date. The CSV includes basic fields: SKU, name, price, description, stock, and categories. It does not include product images (those are media attachments) or some advanced metadata. This is fine for quick copies or importing into another store.

For a full restore, you’ll need to export media separately and re-import images later. Export a sample CSV first to review the column headers.

Method 2: Plugin-Based Exports

Plugins like WP All Export or the premium WooCommerce Product CSV Import Suite give more control. You can export all product fields, custom attributes, and even gallery image URLs. Use these if you need a full product archive that can be reimported exactly.

Be careful with large stores — exports with thousands of products may time out. Increase your PHP memory limit or run in batches.

Backing Up WooCommerce Orders

Orders are also a custom post type (shop_order), with line items stored in wp_woocommerce_order_items and wp_woocommerce_order_itemmeta. Order notes, status history, and payment details all need to be preserved.

WooCommerce Order Export

Navigate to WooCommerce → Orders → Export. You get a CSV with order ID, date, status, billing info, shipping info, items, and totals. This is great for accounting or transferring to a third-party system, but it’s not a restorable backup — order IDs will change on import, breaking references.

For a true restore, you must back up the database tables directly via phpMyAdmin or a backup plugin. The CSV export is a snapshot for record-keeping, not for restoring order history to a new site.

Backing Up WooCommerce Customers

Customer accounts are stored in the standard WordPress users tables: wp_users and wp_usermeta. WooCommerce adds extra meta fields like billing address, shipping address, and customer notes. If you use the WooCommerce Customer / Order / Coupon Export extension, you can export customer data as CSV: go to WooCommerce → Customers → Export.

Alternatively, export the wp_users and wp_usermeta tables from your database. When restoring, you must keep the same user IDs, or connections to orders break. Plugins like User Migration or just a full database backup are safer.

If you only need a list of customer emails for marketing, CSV export is fine. For a full site move, always take the database dump.

The Complete WooCommerce Backup Strategy

Here’s my recommended approach for a bulletproof WooCommerce backup:

1. Full database backup — Use a plugin like UpdraftPlus or your host’s tool to export all database tables. This captures every product, order, and customer in their native relationships.
2. Files backup — Back up entire wp-content folder, especially uploads for product images, plugins for WooCommerce itself, and themes for your store’s layout.
3. CSV exports — As a secondary safety net, export products and orders to CSV. Store these offsite (Google Drive, Dropbox) for quick reference.
4. Customer data — Export customers via WooCommerce export tool or save the SQL for wp_users and wp_usermeta.
5. Test your backup — Restore to a staging site. Verify products show correct prices, orders have line items, customers can log in. Nothing worse than a backup that fails when you need it.

For a deeper walkthrough on backing up the entire WordPress site before a migration, check out How to Back Up a WordPress Site Before Migration – Step by Step. It covers file and database backup in detail.

Comparing Backup Methods

Method	Products	Orders	Customers	Restorable?
Full database dump	Yes	Yes	Yes	Yes
WooCommerce CSV export	Yes (basic)	Yes (snapshot)	No	Partial
Plugin (e.g., UpdraftPlus)	Yes	Yes	Yes	Yes
PhpMyAdmin tables export	Yes	Yes	Yes	Yes

Automating Your WooCommerce Backups

Manual backups are easy to forget. Automate them. Most WordPress backup plugins let you schedule daily or weekly backups and send copies to remote storage (Amazon S3, Google Drive, email). Set up at least a weekly full backup and a daily database-only backup. Many hosts also offer automatic backups — but don’t rely solely on that. Keep your own copy off-site.

For a more detailed guide on pre-migration backups, see How to Back Up a WordPress Site Before Migration. It covers incremental backups and staging restore tips.

What to Do When a Restoration Fails

If your backup won’t restore, don’t panic. Start by checking the PHP memory limit and execution time. Large databases may time out. Try increasing max_execution_time to 600 and memory_limit to 512M in your wp-config.php or server settings. If the backup file is corrupt, restore from an older backup. Always keep 3–4 recent backup copies. Also, verify your database prefix — if the backup came from a different prefix, update it before importing.

If all else fails, your CSV exports become invaluable. You can manually re-import products and orders, then recreate customer accounts. It’s tedious but better than losing everything.

Final Checklist for WooCommerce Backup

• Database backup including all WooCommerce tables
• Full files backup (plugins, themes, uploads)
• CSV exports of products and orders
• Customer data export or user table SQL
• Backup stored off-site (cloud storage)
• Test restore on a staging site

Your WooCommerce store is the heart of your revenue. A few extra minutes on backup setup can save days of recovery. Make it a habit, and your future self will thank you.

Frequently asked questions

What is the best way to back up WooCommerce products?

The best way is a full database backup, which includes all product data and relationships. Use a plugin like UpdraftPlus or your host’s backup tool to export the entire database. For a portable copy, also export products as CSV via WooCommerce → Export Products.

Can I restore WooCommerce orders from a CSV export?

CSV exports of orders are for record-keeping, not full restoration. They do not preserve internal IDs, so orders will not link to customers or products correctly on a new site. For a true restore, you need a database backup that includes the orders tables.

How do I back up WooCommerce customer data?

Customer data is stored in the wp_users and wp_usermeta tables. Back them up as part of your database dump. Alternatively, use WooCommerce’s Customer Export tool (requires extension) to get a CSV for reference.

How often should I back up my WooCommerce store?

For an active store, schedule daily database backups and weekly full backups. If you have frequent orders or product changes, increase frequency. Always keep at least three recent backup copies off-site.

Does a standard WordPress backup include WooCommerce data?

Yes, if the backup includes the full database and the wp-content folder. Most backup plugins are database-aware and will include WooCommerce tables. Always verify that your backup method backs up all custom post types and related tables.