How can I migrate without losing my data?
First of all, NEVER uninstall your module before this process.
If you want to migrate your shop to a new installation or a new version of PrestaShop without losing the configuration of your filters, you have to export them using the following procedure:
Connect to your MySQL database from your PHPMyAdmin account and:
- Copy all the tables prefixed with pm_advancedsearch_ * into your new database
- Inside the "configuration" table, copy the different configurations of your filters (anything with the prefix PM_AS4_ *), in the "configuration" table of your new database
Keep in mind that in order for this copy to conform to your original version, you will need to have the same IDs for products/categories, etc.
If your filters use PrestaShop 9.2's Extra Properties
For criteria groups based on Extra Properties, the module's tables and configuration are only part of the data to preserve. The destination shop must run PrestaShop 9.2 or later with Advanced Search PRO 5.4.0 or later.
- Preserve the PrestaShop Extra Property definitions used by your filters, together with their stored values on products, combinations, categories, brands and suppliers.
- If a module provides these properties, make sure it is installed and available for the relevant shop on the destination installation.
- Preserve the identifiers of the property definitions and the catalog items they refer to, as well as the relevant shop and language associations. If the identifiers change, ask your developer to adapt the filters and their references as part of the migration.
- Keep all module tables covered by the export above, including the Extra Property criterion mappings. Copying those tables does not copy the underlying PrestaShop property definitions or values.
Once the source properties and their values are available on the destination shop, run a complete re-indexing of the affected search engines and check their filters and results. Re-indexing does not recreate missing property definitions or recover source values that were not migrated.
Install the module in your new version. You will find all your filters and your configuration as before.
It may be necessary to do a complete re-indexing at the end of the installation process. To do that, please follow this FAQ.