2015-12-03
Rating 0 stars - 0 votes

Assign PrestaShop Products to Categories Having Their IDs in Import File

Appending merchandise to PrestaShop, you are supposed to place them to certain categories or subcategories and ensure that customers will easily reach them. If you have the categories created and are uploading new products or updating existing ones, the task is to place them to these categories or change category associations.


In order to associate products massively with PrestaShop categories via import performed with Store Manager for PrestaShop, you can use category IDs as identifier in the file. In this post you can find extended guidance on how to assign merchandise with suitable categories or subcategories of different levels having their IDs in the import file.


How Should File Be Formatted

You must have properly formatted .csv file for product import, to be more precise, category IDs for listings to be uploaded should properly be configured in the file. Details, you include in the file depend on whether you are creating new items via import or renewing the ones, added previously. Category ID will, correspondingly, be indicated in Category column of your file. Look at the screenshot provided.



Important: if product is planned to be assigned to several categories, their IDs should be detached by double category delimiter

Points to Consider to Associate Products Massively with PrestaShop Categories Via Import

Now you are about to proceed with usual data upload accomplishment via Store Manager import wizard. Detailed step-by-step tutorial is outlined in this article – Import Products to PrestaShop using Store Manager


We want to draw your attention to settings directly influencing category assign success.


  1. There is a bunch of fields to be configured at Select Fields Delimiter and Quote Character step of PrestaShop product import wizard. To associate products massively with PrestaShop categories when their IDs are provided in the file, check “Use ID as category path” on this step.



  2. Assign products to numerous categories or subcategories FREE with Store Manager for PrestaShop! Import Now!


    Check category delimiter just above this option. It should coincide with the one, detaching category IDs for one product in the file. Do not forget to double the separator when inserting several category IDs.


    If products, indicated in the file, already exist at PrestaShop in some categories and you have other categories specified in the file, but do not want to remove them from current ones, enable “Keep current category association(s)” option. Once the import has been completed, merchandise will be assigned to categories, indicated in the file without being removed from previous ones.


  3. On “Assign .csv Columns to Database” fields step, you are expected to set fields correspondence and select product identifier, the one import file possesses.

  4. Category paths and IDs can not be used as identifiers simultaneously in the course of one product upload procedure. It means, you can use one identifier at a time – either category ID or path and have either ID provided for all the products or entire category path.


  5. Disable “Ignore category path and put product into the most suitable (by name) category” options at the last step, otherwise products will randomly be assigned to the categories defined as the most suitable by PrestaShop import tool.


Make sure data upload configuration has been accurately determined and confirm import to associate products massively with PrestaShop categories.


Relevant category associations is a compulsory element of your PrestaShop product catalog. Assign goods to necessary categories or change category associations for products in bulk with Store Manager.