Woo » Database Tables Excluded from Stage-to-Prod Migration

Woocommerce Database Description

Bukvalno to što mi treba, ali fokusirano na orders: How to Exclude WooCommerce Orders from Being Copied to the Live Site with “HPOS” • WP STAGING

Exclude WooCommerce sessions from WP Migrate DB Pro migration Copy Environment - Support Center WooCommerce Best Practices - Support Center

Marked (*) are tables to exclude from migration from stage to production, as they contain sales data, inventory, orders, etc:

Woo: Action Scheduler

• actionscheduler_actions | Stores scheduled actions
• actionscheduler_claims | Stores claims on actions being processed
• actionscheduler_groups | Groups scheduled actions
• actionscheduler_logs | Logs action scheduler events

Woo: Google Listings and Ads

• gla_attribute_mapping_rules | Attribute mapping rules for Google listings
• gla_budget_recommendations | Budget recommendations for Google Ads
• gla_merchant_issues | Merchant related issues with Google listings
• gla_shipping_rates | Shipping rates for Google listings
• gla_shipping_times | Shipping times for Google listings

Woo: Database tables

• wc_admin_notes | Admin notes for WooCommerce
• wc_admin_note_actions | Actions associated with admin notes
• wc_category_lookup | Category lookup table

• wc_customer_lookup | Customer data and order stats
• wc_download_log | User downloads logging
• wc_orders | Order details
• wc_orders_meta | Order metadata
• wc_order_addresses | Order address details
• wc_order_coupon_lookup | Order coupon details
• wc_order_operational_data | Additional order details
• wc_order_product_lookup | Order product details
• wc_order_stats | Order statistical analysis
• wc_order_tax_lookup | Order tax details

• wc_product_attributes_lookup | Product attribute details
• wc_product_download_directories | Product download directories
• wc_product_meta_lookup | Product metadata
• wc_rate_limits | Rate limiting details

• wc_reserved_stock | Stores reserved stock and is used to prevent race conditions during checkout

• wc_tax_rate_classes | Stores tax classes data
• wc_webhooks | Stores any webhooks that have been setup on the store
• woocommerce_api_keys | Stores API Keys used for the REST API
• woocommerce_attribute_taxonomies | Stores global attribute taxonomy names for products

• woocommerce_downloadable_product_permissions | Downloadable product access permissions (granted after purchase)
• woocommerce_log | General logging table (alternative to file based logging)
• woocommerce_order_itemmeta | Stores meta data about order line items
• woocommerce_order_items | Stores line items which are associated with orders
• woocommerce_payment_tokenmeta | Stores sensitive payment token metadata
• woocommerce_payment_tokens | Stores customer payment tokens (used by gateways)
• woocommerce_sessions | Stores customer session data, such as carts

• woocommerce_shipping_zones | Stores shipping zones you create in the settings area
• woocommerce_shipping_zone_locations | Stores locations associated with your shipping zones
• woocommerce_shipping_zone_methods | Stores shipping methods linked to your shipping zones
• woocommerce_tax_rates | Stores tax rates you define in the admin area
• woocommerce_tax_rate_locations | Stores locations (postcodes and cities) associated with the above tax rates

Tako da je finalni spisak tabela koje se preskaču iz migracije:

actionscheduler_actions
actionscheduler_claims
actionscheduler_groups
actionscheduler_logs
wc_customer_lookup
wc_download_log
wc_orders
wc_orders_meta
wc_order_addresses
wc_order_coupon_lookup
wc_order_operational_data
wc_order_product_lookup
wc_order_stats
wc_order_tax_lookup
wc_reserved_stock
woocommerce_downloadable_product_permissions
woocommerce_log
woocommerce_order_itemmeta
woocommerce_order_items
woocommerce_payment_tokenmeta
woocommerce_payment_tokens
woocommerce_sessions