Migrating from WooCommerce to Classic Commerce

Projects Ecosystem
15

Just to summarise what I have found so far… there are four main areas of change to the database in WooCommerce 4.x

  1. New tables created for the action scheduler.
    actionscheduler_actions
    actionscheduler_claims
    actionscheduler_groups
    actionscheduler_logs
    Note that plugins (eg WooCommerce Subscriptions) may start to make use of these tables for their procedures.

  2. New tables created for the WooCommerce Admin reporting features
    wc_admin_note_actions
    wc_admin_notes
    wc_category_lookup
    wc_customer_lookup
    wc_order_coupon_lookup
    wc_order_product_lookup
    wp_wc_order_stats
    wc_order_tax_lookup

  3. A new table created for handling reserved stock (managing stock levels for items that may be currently in the checkout process) - wc_reserved_stock
    More details here: Reserved Stock in WooCommerce 4.3 Explained | Puri.io

  4. A change to an existing table - wc_product_meta_lookup
    This has 2 new columns added - tax_status and tax_class
    See: Add product lookup table tax columns by mikejolley · Pull Request #25428 · woocommerce/woocommerce · GitHub
    It also has a change to two existing column definitions
    min_price decimal(10,2) DEFAULT NULL and max_price decimal(10,2) DEFAULT NULL
    becomes
    min_price decimal(19,4) DEFAULT NULL and max_price decimal(19,4) DEFAULT NULL
    See: Need to change `wc_product_meta_lookup` table structure datatype size for min_price and max_price · Issue #24428 · woocommerce/woocommerce · GitHub

6 Likes