Skip to content

From WooCommerce

The WooCommerce importer pulls products, customers, orders, and inventory from a WooCommerce store via the REST API.

  1. WooCommerce 3.0+ with REST API enabled
  2. Consumer key and consumer secret (generate in WooCommerce → Settings → Advanced → REST API)
  3. API access with read permissions for products, customers, orders
Terminal window
rcommerce import platform woocommerce \
--api-url https://your-store.com \
--api-key ck_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx \
--api-secret cs_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx \
--entities products,customers,orders \
--overwrite
  • Title, description, SKU, price, weight, dimensions
  • Product images (downloaded to local storage)
  • Categories and category relationships
  • Variants and option values
  • Bundle components (for WooCommerce bundled/party-pack products)
  • Name, email, phone
  • Billing and shipping addresses
  • Metadata
  • Line items with product references
  • Order status (mapped to rCommerce status)
  • Shipping and billing addresses
  • Payment status
  • Stock quantities per product
  • Managed stock flag

WooCommerce “party packs” / bundles are expanded:

  • Parent line carries the bundle price (no inventory reservation)
  • Component lines at $0 reserve underlying product stock

After import, re-sync party pack inventory:

UPDATE products pp
SET inventory_quantity = GREATEST(0, FLOOR(bp.inventory_quantity / 5.0)::integer)
FROM products bp
WHERE pp.slug LIKE '%-party-pack'
AND bp.sku = REPLACE(pp.sku, '-PP', '')
AND bp.is_active = true;
WooCommercerCommerce
pendingpending
processingconfirmed
on-holdon_hold
completedcompleted
cancelledcancelled
refundedrefunded

Preview what would be imported:

Terminal window
rcommerce import platform woocommerce \
--api-url https://your-store.com \
--api-key ck_xxx \
--api-secret cs_xxx \
--entities products \
--dry-run

Use --overwrite to update existing records (matched by SKU for products, email for customers). This is useful after fixing weight data or updating inventory.