Import PrestaShop Products with IDs - Store Manager for PrestaShop
30
5 usages left
Rating 5.00 stars - 1 votes

Import PrestaShop Products with IDs

How to import PrestaShop products with IDs? This is a primary task when you are migrating your store, and IDs are a part of product URLs, for example. There may be other reasons to import products preserving their original IDs too. In this article, we’ll describe two approaches to solving this task.

Use the Force All ID Numbers option with default PrestaShop importer

PrestaShop default importer has the built-in option Force Product IDs. To use this option, log into your PrestaShop back office and navigate to Configure > Advanced Parameters > Import.

On the page, select the entity your want to import (Products), then select your file. Scroll to the bottom of the page and find the option Force All ID Numbers. Switch the toggle to Yes.


PrestaShop Import Products Force IDs

Proceed with the import and in the next step check the mapping of fields. As you can see, not all fields are mapped automatically so you need to assign the field manually.

After all the fields are associated with the columns from the file, press Import and wait for the- process to complete.


PrestaShop Import Products Force IDs Mapping Manual

In the course of import, PrestaShop will create products from the file with their original IDs and also create N/A products to fill in the gaps between the product IDs from your file.


PrestaShop Import Products Force IDs N/A Products

Finally, you have to filter and delete the N/A products. Enter N/A in the Name filter and press Search. Select the filtered products, expand the Bulk Actions dropdown list, and click Delete Selection.


PrestaShop Import Products Force IDs N/A Products Delete

Limitations of the Force ID option

The default PrestaShop import tool doesn’t allow importing features and attributes. Therefore you can’t import variable products with combinations. You can import only simple products with original IDs.

PrestaShop default importer doesn’t have the automapping feature that’s why field mapping takes longer than expected.

Import PrestaShop products with IDs using Store Manager for PrestaShop

Store Manager for PrestaShop offers an alternative approach to importing PrestaShop products preserving IDs. The process includes several steps.


Store Manager is a downloadable application that enhances the default functionality with tools for bulk edits, advanced import/export, database backup, data generation, and others.

If you don’t have Store Manager yet, download a free trial and install it on your computer. Connect the application to your store database and enjoy the simplicity of your store administration.


Export PrestaShop products you want to migrate

Begin with exporting PrestaShop products via Store Manager for PrestaShop.

Read the detailed guide on how to export products via Store Manager for PrestaShop.

Open the file and in column Product ID, find the biggest product ID number. In our example, it’s ID 404:


PrestaShop Store Manager Export Product IDs

Create dummy products to create necessary IDs via import

Now we have to create a new file with dummy products. In the file, we should create just one column – Product Name. This one field will be enough to create dummy products and IDs. Then we should populate the column with the name demo and the numbers from 1 to 404.


PrestaShop Store Manager Import Dummy FIle

Import demo products to PrestaShop

With Store Manager open, navigate to Catalog&Products > Import/Export > Import/Export Products:


PrestaShop Store Manager Import Dummy Product Launch

Select and preview the file with dummy products:


PrestaShop Store Manager Import Dummy File Preview

Proceed to step 7 and select Product Name as an identifier:


PrestaShop Store Manager Import Dummy Product Identifier

Complete the import and check created demo products with necessary IDs. As you can see, there were 404 products created and therefore, we now have IDs from 1-404 created.


PrestaShop Store Manager Import Dummy Product Created

Import file with real products and override dummy product data

Launch Store Manager for PrestaShop import wizard and select your export file with actual PrestaShop products.

In step 7, Assign csv Columns to Database Fields, pay attention to the settings Identify products by. This time you should select Product ID:


PrestaShop Store Manager Import Real Product IDs Identifier

Preview the import data and pay attention to the settings in step 9 Import Options. If you want to create product attributes and features during import, select the corresponding checkboxes:


PrestaShop Store Manager Real Product IDs Import Create Features

Complete the import and check the result in Store Manager. As you can see, the product details have been updated and real product data is now displayed:


PrestaShop Store Manager Real Product IDs Created

Delete demo products

Do delete dummy products, expand the filter for the Product Name field and enter Dummy in the search field:


PrestaShop Store Manager Real Product IDs Delete Demo

As you can see, Store Manager for PrestaShop offers an alternative approach to import PrestaShop products with IDs. Additionally, you can use flexible settings to import attributes and features. Automatic mapping of columns from the file to the database fields will save you time on import setup.

Share your experience in the comments: which approach worked for you, and did you face any difficulties? We’ll be happy to review your specific case and offer possible solutions.

Import products with IDs via Store Manager for PrestaShop

Download FREE trial


Related Articles:


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…

Make Your PrestaShop Product Import Automated

Discover the benefits of automated product import and the way to set it up. Read More…

How to Upload Excel Files to PrestaShop
How to Upload Excel Files to PrestaShop?

Import store data to PrestaShop in Excel format. Get full instructions. Read More…

Store Manager Extends its Potentials with XML File Import
Store Manager Extends its Potentials with XML File Import

Find out how to perform PrestaShop import of XML file and what XML import options are available in Store Manager. Read More…


COMMENTS
Be the first to comment.