Data migration

[Persnickety]

Hello,

I am currently searching for a free or cost-effective solution to migrate all data from PrestaShop in one go, with the aim of creating a multishop. Despite extensive research, I haven’t had much success so far. I believe that a solution code for this shouldn’t be too complicated, or am I mistaken? Any help or advice in finding a solution would be greatly appreciated. If you have any recommendations or know of tools that could facilitate this process, I would be very grateful to hear about them

[assisassi]

Prestashop ha un database con oltre 300 tabelle, con centinaia di join. Con suffisso "product" sono una ventina... e istallando alcuni moduli aumentano le tabelle... 

decisamente non direi che possa esistere una soluzione semplice!

C'é uno script (Prestools) realizzato da Musicmaster che, con un po' di pazienza, può risolvere molti problemi.

Io te lo consiglio. puoi provare la versione free ed eventualmente acquistare, se ti occorrono, alcune funzionalità extra che sono a pagamento.

(automatic translation)

PrestaShop has a database with over 300 tables, with hundreds of joins. With the "product" suffix, there are about twenty... and installing some modules increases the number of tables...

I definitely wouldn't say there's a simple solution!

There's a script (Prestools) created by Musicmaster that, with a little patience, can solve many problems.

I recommend it. You can try the free version and, if you need it, purchase some additional paid features.

 

[Paul C]

As long as the multishop PrestaShop version is the same as the original site you should be able to just move the tables that contain your catalog, customer and order data across. Assuming you're not merging multiple stand-alone shops. In the latter case you're going to need to update the tables of each shop in turn to modify id_shop to be unique for each.

It's usually best not to copy over any of the configuration tables (including modules, tabs, carriers etc. etc.) just the purely "shop data" tables which are, as a whole, self-contained.

[El Patron]

On 7/6/2025 at 10:16 PM, Persnickety said:

Hello,

I am currently searching for a free or cost-effective solution to migrate all data from PrestaShop in one go, with the aim of creating a multishop. Despite extensive research, I haven’t had much success so far. I believe that a solution code for this shouldn’t be too complicated, or am I mistaken? Any help or advice in finding a solution would be greatly appreciated. If you have any recommendations or know of tools that could facilitate this process, I would be very grateful to hear about them

At the moment, it’s not clear exactly what you’re trying to accomplish. Here are a few possibilities based on your question:

1. Enabling PrestaShop’s built-in multistore feature (no migration needed).
2. Cloning your existing shop into a completely separate installation.
3. Migrating or syncing data between two PrestaShop installations.
4. Inventing a brand new multishop concept the world has never seen.

here is one of my works, it's cost effective in that it takes only minutes loool

https://prestaheroes.com/collections/international-growth-solutions/products/prestashop-multistore-multishop-pro?variant=41091628859599

Edited July 12 by El Patron (see edit history)