How to Move PrestaShop Database to Another Store
30
20 usages left
Rating 4.89 stars - 9 votes

How to Transfer PrestaShop Database to Another Store

PrestaShop database migration can be triggered by multiple business needs. You might need to open another PrestaShop store, change the domain, move to a new server, or shift your store from the Cloud to a self-hosted version.

In any of the cases mentioned, you would like to attain consistent and fluent data copying, including products (with all related details), categories, orders, customers. To transfer the PrestaShop database to another store in a time-efficient way, you can consider Store Manager for PrestaShop import/export functionality.

Using Store Manager import/export wizard, you can transfer PrestaShop categories, products, customers, and orders. In this article, you’ll learn how to export all store entities into CSV files and import them to a new PrestaShop store.



Export Store Data That You Want to Migrate

Store Manager offers a wizard for every kind of entity. Select a corresponding option on the side menu.

PrestaShop Store Manager Import/Export Tools to Transfer Database


Export Category Tree Structure

Migrating PrestaShop data to another store starts with copying the category tree structure to the .csv file.

  • Launch category export wizard (Tools->Import/Export Categories) and select Export action.

  • Export PrestaShop Category Tree Structure by eMagicOne

  • Choose a file to save category data to.

  • Save export Category Tree file with eMagicOne

  • Select ‘All Categories’ on the next step to pull down the entire category tree.

  • Select PrestaShop Categories for Export with eMagicOne

  • Specify file separators or leave the default and consider a delimiter used to detach categories in a category path.

  • Select Field Delimeter and Quate Character forPrestaShop Categories Export with eMagicOne

    To export category images, enable the ‘Import/Export Images’ checkbox and select the folder, to which images will be downloaded in the process of export.

  • Select all category fields to be exported to the.csv on the following step and confirm the procedure.

  • Select Fields for Categories Export with eMagicOne


Download free trial of Store Manager and transfer Prestashop database smoothly

Download Now

Export Products from a Source PrestaShop Store

Now, let’s export to a .csv file those products that want to migrate.

  • Launch Products export wizard (Tools->Import/Export Products) and select the “Export” action.

  • Export PrestaShop Products with eMagicOne

  • Select the file to save product data to.

  • Save PrestaShop Products Exported file with eMagicOne

  • Decide on the export options displayed on the following wizard page.

  • Options for PrestaShop Products Export with eMagicOne


    • Export full category path – if you want to create categories on the fly while migrating PrestaShop data to another store enable this checkbox.
    • Export parent details – if you want to record parent product details (name ) in the .csv file for all product combinations, enable this option.
    • Product accessories identification method – to preserve accessory relations, choose the identifier for them. The output file will have Reference or EAN13 in the “Accessories” column depending on what you chose.

  • Set export file delimiters or leave the default on the following step.

  • Select Export Fields Delimeters and Quote Characters PrestaShop Products Export with eMagicOne

  • Select all product-related fields to pull them to the .csv file.

  • Select Fields for PrestaShop Products Export with eMagicOne

Done! The catalog has been downloaded from your source PrestaShop site.


Export PrestaShop Customers

Download PrestaShop customers via export wizard next.

  • Launch Customer Import/Export wizard, select the ‘Export’ action.

  • Export PrestaShop Customers with eMagicOne

  • Choose the file where customer data will be stored

  • Save Exported PrestaShop Customers file with eMagicOne

  • Consider file separators and customer groups delimiter (if a customer belongs to more than one group, all these groups will be arranged within one file column and separated by this delimiter).

  • Select Fields Delimiter and Quote Character during PrestaShop Customers Export with eMagicOne

  • Choose all customer-related details at this step and confirm that you want to transfer them to the spreadsheet.

  • Select Fields to be Exported During PrestaShop Customers Export with eMagicOne

Export PrestaShop Orders

You should now export orders if you would like to transfer sales data to a target store.

  • Launch Orders Import/Export Wizard (Tools->Import/Export Orders) and select the “Export” action.

  • Export PrestaShop Orders with eMagicOne

  • Open the Order Export Wizard and select the file to store orders.

  • Save PrestaShop Exported Orders file with eMagicOne

  • Select orders to export – all existing orders or selected.

  • Set file delimiters or leave the default ones.

  • Select fields to be exported to .csv using traditional options on this step or field groups filter.

  • Select Fields to be Exported for PrestaShop Orders Export with eMagicOne

  • Finish the export by pressing the “Export” button.

  • Extended order export tutorial is available at- Export PrestaShop Orders Quickly and with Ease!

    Having downloaded these entities, you can transfer PrestaShop database to another store.


Prepare Your New PrestaShop Store Before Data Migration

Before starting data import to a new store, you need to:

  • Install and configure a PrestaShop store. Please check PrestaShop official documentation describing how PrestaShop installation is accomplished – https://docs.prestashop-project.org/v.8-documentation/v/english/
  • Add languages and download language packs
  • Enable the multistore option if you plan to create multiple shops, create shop groups and shops
  • Configure payment methods as this tutorial describes
  • Set up carriers and shipping methods

What to consider transferring PrestaShop database via Store Manager:

  • Store Manager allows you to preserve all product properties in the process of export/import.
  • If you have product combinations, you can import them to a new store. Store Manager will automatically create attribute values, though it does not allow to create attribute groups via import. So you need to create attribute groups before the import.
  • Product features also must be created manually on the new store. Feature values will be created automatically during import.
  • Manufacturers exported from a source store will be automatically created and assigned to products on the new store.
  • PrestaShop suppliers must be created before the import. You can assign them to products during import.
  • Tax rate and rules must be created manually. The import wizard allows you to assign rates.
  • Shipping carriers must be created in advance because the import tool allows you to assign carriers, but not create them automatically.

Now you need to connect to your target store database via Store Manager and import entities from the files you have prepared.


Transfer Data to the New Store Via Import

Form a Category Tree in the New PrestaShop Store

If your target store must have the same category hierarchy as a source store, it would be nice to import categories and build the structure on the fly.

  • Start the Import/Export Category Wizard and opt for the import option there.

  • Import Prestashop Categories with eMagicOne

  • Choose the datafile exported from the source store and preview data from the file on the following page.

  • Set the delimiters matching the ones used to separate data.

  • Select Fields Delimiters and Quote Character during Categories Import with eMagicOne

    To upload category images, enable a corresponding option on this step and specify the name of the folder on your PC in which these images are stored.

  • Map file fields with database fields to append data correctly and get store category structure transferred. Use the “Automap” option to link fields automatically, since the file exported by Store Manager has identical column titles.

  • Assign csv columns to Database Fields during Categories import with eMagicOne



  • Use the ‘Add and Modify’ import option on the last step of the import wizard and complete the procedure.

  • PrestaShop Category Import Options with eMagicOne

Check category tree in Store Manager after the import is accomplished.

Extended category import tutorial is available at- Import PrestaShop Categories without a Tension

Import Products to the New PrestaShop Store

Once the categories exist in PrestaShop, you can fill them with product listings using the file exported from the source store.

  • Run the product import profile and select the datafeed to import products from.

  • Adjust delimiters or leave the default ones. A file preview box allows you to verify the accurateness of separator setup.

  • Select Fields Delimiters and Quote Character during PrestaShop Products Import with eMagicOne


    If you have full HTTP path to PrestaShop product images in .csv, just enable the “Import Images” checkbox under the preview box.

    To upload locally saved pictures, you have to activate this option and also select the folder keeping these images.


  • Associate file columns with database fields to migrate data to another PrestaShop store or apply automapping since exported file columns have identical names.

  • Assign csv Columns to Database Fields during Products Import with eMagicOne

    The best way to identify products is to set Reference and Product Name on this step. ID can’t be used as an identification method for products creation, only for updating. Store Manager does not allow you to force ID import because IDs are autoincremented.

    To import combinations, select combination reference in the ‘Identify combinations by’ dropdown.



    To preserve accessories in the new store, you have to set identifier that you have in the export file.


  • Set import options on the last wizard step. It is advisable to choose the ‘Add and Modify’ import method. To create attribute and feature values you have in the exported file, enable the ‘Create new attributes’, ‘Create new features’ and ‘Create feature values’ options.

  • PrestaShop Products Import options with eMagicOne


Import PrestaShop Customers

Add customers to the new PrestaShop site using Customer Import/Export Wizard as outlined below.

  • Launch customer import wizard and select necessary file for import.

  • Set file delimiters and preview parsed data in the field below.

  • Select Fields Delimeter and Quote Character duering PrestaShop Customers Import with eMagicOne

  • Complete fields mapping to link file columns to the appropriate database fields.

  • Assign csv Columns to Database Fields during PrestaShop Customers Import with eMagicOne

  • Designate options at the last page and complete the upload.
Follow these instructions to import customers with their passwords – Migrate PrestaShop Customers with Passwords for Free


Download FREE Trial Version of Store Manager

Download It Now

Import Orders to PrestaShop

The last step of data migration is sales data upload.

  • Launch order import wizard and choose the file keeping orders.

  • Move to the next step, outline file delimiters, and have a look at the preview.

  • Select Fields Delimiter and Quote Characters during PrestaShop Orders Import with eMagicOne

  • Assign file columns to the PrestaShop database fields and set order, customer, address, and product identifiers.

  • Assign csv Columns to Database Fields during PrestaShop Orders Import with eMagicOne

  • Set PrestaShop order import options on the last step, complete the procedure and check orders in the application.

  • PrestaShop Orders Import Options with eMagicOne
Follow these instructions to import orders to the necessary store – How to Import Orders to PrestaShop


Related Articles:


Manage Multiple PrestaShop Stores from One Location
Manage Multiple PrestaShop Stores from One Location

Find out how to handle multiple stores using one database with Store Manager. Read More…

How to Import PrestaShop Products Into Specific Shops
How to Import PrestaShop Products Into Specific Shops?

Configure settings for importing products into multiple PrestaShop stores at one stroke. Read More…

How to Manage Data Per Specific Shop
How to Manage Data Per Specific Shop?

Use PrestaShop Global Selector to change shop associations, create new entities, import data to specific store etc. Read More…

PrestaShop Database Backup and Restore
PrestaShop Database Backup and Restore

Backup or restore your PrestaShop store in few clicks with the help of Backup Wizard. Find out how to backup multiple stores at once. Read More…


COMMENTS
Be the first to comment.