Problem with shippments after orders table migration

  • Resolved User

    (@lostguybrazil)


    9 months ago

    Hi,

    I have recently migrated the WooCommerce Orders from one site to another using Soflyy’s WP All Import. The problem is, I don’t see any shippment information anymore for imported orders. Here’s an how it look like: new orders realized in the new website have correctly the shippment information (orders from June 15, 2024), but previous orders do not have the correct shippment information: https://imgur.com/a/pyc2U9h

    I am aware that Germanized creates multiple datasets, but to proper make an order migration, I wanted to ask which records of which tables (and columns, if applicable) I need to import. Thanks!

    wp_woocommerce_gzd_dhl_im_product_services
    wp_woocommerce_gzd_dhl_im_products
    wp_woocommerce_gzd_dhl_labelmeta
    wp_woocommerce_gzd_dhl_labels
    wp_woocommerce_gzd_packaging
    wp_woocommerce_gzd_packagingmeta
    wp_woocommerce_gzd_shipment_itemmeta
    wp_woocommerce_gzd_shipment_items
    wp_woocommerce_gzd_shipment_labelmeta
    wp_woocommerce_gzd_shipment_labels
    wp_woocommerce_gzd_shipmentmeta
    wp_woocommerce_gzd_shipments
    wp_woocommerce_gzd_shipping_provider
    wp_woocommerce_gzd_shipping_providermeta

Viewing 1 replies (of 1 total)
  • Plugin Author vendidero

    (@vendidero)

    Hi there,

    I guess that’s more of a general issue with such “magic” import plugins – they do only import orders but do not import (there is no way to make that work automagically) other tables/data that rely on orders. I’d advise you to not use such import plugins but manually do a database backup and import that backup to the newly created site. Another issue with such import plugins is that they may adjust the auto incremented order ids (not the formatted number but the actual id handled by the database) – this way all the reference to the actual orders (e.g. from a shipment) will be lost too.

    Regarding your questions: For shipments, you’ll need to import the shipments tables:

    • wp_woocommerce_gzd_shipment_itemmeta
    • wp_woocommerce_gzd_shipment_items
    • wp_woocommerce_gzd_shipment_labelmeta
    • wp_woocommerce_gzd_shipment_labels
    • wp_woocommerce_gzd_shipmentmeta
    • wp_woocommerce_gzd_shipments

    Best,
    Dennis

Viewing 1 replies (of 1 total)
  • The topic ‘Problem with shippments after orders table migration’ is closed to new replies.

Tags