How to Transfer PrestaShop Database to Another Store
2022-11-16 2017-03-23
Clasificación 4.50 stars - 2 votes

How to Transfer PrestaShop Database to Another Store

Nowadays PrestaShop database migration is highly demanded business maneuver, triggered by multiple business needs. You might need to open another PrestaShop store, change the domain, move to new server or shift store from Cloud to self-hosted version.

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

Store Manager includes import/export wizard for categories, products, customers, orders that allows you to copy related details to new store in the way outlined below.

1. Export Category Tree Structure

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

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

  2. Prestashop Category Export Option

  3. Choose file to store category data after export.

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

  5. Select Prestashop Categories to Be Exported

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

  7. Prestashop Images Export

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

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

  9. Prestashop Category Fields to Be Exported

Download FREE Store Manager and transfer Prestashop database smoothly

Download Now

2. Export Products from Source PrestaShop Store

Prepare .csv file with products exporting them from existing store through wizard.

  1. Open export wizard and select the file to store product data.

  2. Decide on export options displayed in the following wizard page.

  3. Prestashop Products Export Option

    • 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 .csv file for all product combinations, enable this option.
    • Product accessories identification method – in order to preserve accessory relations, choose the identifier for them. Output file will have Reference or EAN13 in Accessories column depending on what you choose.
  4. Set export file delimiters or leave default on the following step.

  5. Prestashop Product Images Export

  6. Select all product related fields to pull them to .csv file.

  7. Prestashop Product Fields to Be Exported

    Done! Catalog has been downloaded from source PrestaShop site.

    3. Export PrestaShop Customers

    Download PrestaShop customers via export wizard next.

    1. Launch customer import/export wizard from main menu, select ‘Export’ action and choose file customers will be stored in afterwards.

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

    3. Choose all customer related details at this step and confirm export to transfer them to spreadsheet.

    4. Select Prestashop Clients Fields to Be Exported

    4. Export PrestaShop Orders

    You should now export orders, since you will definitely like to transfer sales to target store.

    1. Open order export wizard and select file to store orders.

    2. Prestashop Select File location for Orders Export
    3. Select orders to export – all existing orders or selected in Store Manager ones.

    4. Set file delimiters or leave default.

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

    6. Select Prestashop Orders Fields to Be Exported

    7. Finish export pressing “Export” button.
    8. 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.

      Before starting data migration, you need to:

      1. Install and configure PrestaShop store. Please check PrestaShop official documentation describing how PrestaShop installation is being accomplished –
      2. Add languages and download language packs –,
      3. Enable mulsistore option, if you plan to create multiple shops, create shop groups and shops –
      4. Configure the payment methods as this tutorial describes –
      5. Set up carriers and shipping methods –
      • Store Manager allows to preserve all product properties in the process of export/import.
      • If you have product combinations, you can import them to new store, although you have to create attribute groups first. Store Manager will automatically create attribute values, though it does not allow to create attribute groups via import.
      • Product features should also be created manually on the new store, you move database to via import. Features values, specified in the file will be created automatically at new store.
      • Manufacturers, exported from source store, will be assigned to products at new store and automatically created.
      • PrestaShop suppliers must be created at new stores. Further you can assign them to merchandise uploading exported file.
      • Tax rate and rules should be created manually, import allows to assign rates
      • Shipping carriers are supposed to be created before data transferring, since import allows to assign carriers not create them automatically.

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

      5. Form Category Tree at New PrestaShop Store

      On condition that target store should have the same category hierarchy, source store possesses, it would be nice to import categories and build the structure on the fly.

      1. Start category import wizard and opt for import option there.

      2. Choose exported from source store datafile on the following step and preview extract from file on the following page.

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

      4. Prestashop Category Import Option

        To upload category images enable corresponding option on this step and specify name of folder at PC, these images are collected in.

      5. Map file fields with database ones to append data correctly and get store category structure transferred. Use automap option to link fields automatically, since exported by Store Manager file has identical column titles.

      6. Prestashop Category Fields to Be Imported

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

      8. Prestashop Category Import Options

      Check category tree in Store Manager after import is accomplished.

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

      6. Import Products to New PrestaShop Store

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

      1. Run product import profile and select datafeed to import products from.

      2. Adjust delimiters or leave default ones. File preview box allows you to verify accurateness of separator setup.

      3. Prestashop Products Import Delimiters Step

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

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

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

      5. Prestashop Products Import Fields Association

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

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

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

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

      7. Prestashop Products Import Options

      Extended product import tutorial is available at- PrestaShop Import: How to Perform Product Upload from CSV File to PrestaShop

      7. Import PrestaShop Customers

      Add customers to new PrestaShop site using customer import wizard as it outlined below.

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

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

      3. Prestashop Clients Import Delimiters Step

      4. Complete fields mapping to link file columns to appropriate database fields.

      5. Prestashop Clients Import Fields Association

      6. Designate options at the last page and complete 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

8. Import Orders to PrestaShop

The last step of data migrating in sale upload to new store.

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

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

  3. Prestashop Orders Import Delimiters Step

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

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

  6. Prestashop Orders Import Options

    Follow these instructions to import orders to necessary store – How to Import Orders to PrestaShop

    Related Articles:

    Card image
    Manage Multiple PrestaShop Stores from One Location

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

    Card image
    How to Import PrestaShop Products Into Specific Shops?

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

    Card image
    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…

    Card image
    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…

    Sé el primero en comentar.