Bulk Assign PrestaShop Accessories to Products Via Import

PrestaShop accessories are widely used by store owners to expose the catalog in a more efficient way since they suggest to shoppers what items can be bought along with the viewed product. Actually, accessories can form a perfect combo of related items that can be purchased together.

PrestaShop Product with Accessories Backend

Ascribing accessories manually to multiple PrestaShop products could really be a hard nut to crack. The traditional method of their assigning should be reconsidered in this case and replaced with an efficient one, that facilitates bulk PrestaShop accessory assign and is available in Store Manager for PrestaShop.

If you haven’t installed Store Manager yet, download the free trial and connect the application to your store database using the wizard inside. Read about other Store Manager tools to simplify and speed up PrestaShop store management

PrestaShop accessory assign through import has been added in Store Manager for PrestaShop 2.25.0.1491. If you have an older version installed, please update Store Manager to the mentioned version or newer in order to have access to accessory import.

So, what points you should pay attention to, before assigning accessories via import. One of the usual pre-import tasks is file arrangement. Afterward, data from this file is being appended to PrestaShop with the aim to set accessory relations. Look through the instructions below to successfully ascribe accessories to PrestaShop products via import.

Getting Ready With Import File

In the import file, you need to set relations between the main product and its accessories. As the screenshot of the test import file demonstrates, there should be a ‘Product Accessory’ column in the file. It keeps Reference or EAN code of items, that perform the role of accessories. In this way, you have to provide an accessory identifier within one cell of the .csv file for the main product and detach the identifiers by multiple value delimiter (we use semicolon).

Important

PrestaShop products you are going to use as accessories should already exist at PrestaShop since you are importing relations, not products themselves.

PrestaShop Import Settings

To bulk add PrestaShop accessories, you are supposed to accurately specify configurations within the data transfer wizard, considering the following:

1. Multiple Value Delimiter Used to Separate Accessories

As it has been stated above, there can be several accessories available for a product in PrestaShop. In order to bulk add PrestaShop accessories, you should detach them by some terminating character and specify the same on the ‘Select Fields Delimiter and Quote Character’ step of the import wizard.

Select Fields Delimiters During Accessories Import with Store Manager

2. Select Accessory Identifier and Map Fields

Field mapping is an obligatory part of data import. In order to bulk add PrestaShop accessories, you need to associate file column keeping accessories with the ‘Product Accessories’ field in database.

Select Identifier for Products Accessories Import with Store Manager

Determine identifier for products and accessories. You can use product ID for an update or any other identifier import wizard offers. Accessories can be recognized by reference or EAN code.

3.Imported PrestaShop Products Already Have Accessories?

PrestaShop import wizard lets you bulk add PrestaShop accessories to products that already have accessories. You can either substitute existing accessories with the ones, listed in the file you import from or add new to existing PrestaShop accessories. If you prefer replacing, enable the ‘Delete product accessories before import’ option.

Import Options Step During Products Accessories Import with Store Manager

Give the final touches to the import settings and confirm data upload fulfilling. After it completes, check results in Store Manager. Select product you added PrestaShop accessories to and open Accessories tab on the lower grid were assigned through import accessories are disposed of.