Magento 2 ShipperHQ Modules and Split Database Architecture
Efficiently Transfer ShipperHQ Data for Split Databases in Magento 2 Stores
Table of Contents
Overview
This guide is for users with a Magento 2 store that uses a split database. If you're unsure whether this applies to you, consult your developer. If your database was already split before you installed the ShipperHQ modules, you don't need this guide.
You'll need at least version 20.8.7 of module-shipper, although we recommend using the latest version. For installation or update information, check out our installation guide. 😊
Moving Information
This section requires some comfort with SQL. While example queries aren't provided, here's how you can handle the data:
Option 1
To retain your data:
- Export the schema and data using your preferred SQL tools.
- Drop the tables from the default database.
- Import them into the sales database.
Move these tables:
- shipperhqquoteaddress_detail
- shipperhqorderdetail
- shipperhqquoteitem_detail
- shipperhqquoteaddressitemdetail
- shipperhqorderitem_detail
- shipperhqquotepackages
- shipperhqquotepackage_items
- shipperhqorderpackages
- shipperhqorderpackage_items
- shipperhqorderdetail_grid
After moving these tables, run:
php bin/magento setup:upgrade
php bin/magento cache:clean
Then, empty all the generated content directories. 💡
Option 2
If retaining data isn't necessary:
- Uninstall the extension.
- Reinstall it as needed.
- Remove all ShipperHQ references from the database, similar to "Option 1" above for additional tables.
Feel free to choose the best path for your needs! 😊