2013-06-14
Rating 0 stars - 0 votes

How to Update PrestaShop Combinations Preserving Image Relations?

Web merchants, who run their stores on PrestaShop have an advantageous possibility to customize product catalog, creating product options with the help of PrestaShop attributes and their combinations. It simplifies product search and selection for your customers, as they can easily adjust a purchase, choosing this or that product variant without browsing multiple product pages.

To keep your catalog renewed and actual for customers, you should be particular about PrestaShop combinations arranging. Not infrequently, you need to update combinations details (e.g change quantity, impact), what might be not so easy, as it looks like, especially when dealing with huge data sets. When updating attribute combinations by means of data import from .csv, you are, actually, overwriting those, created formerly. For that very reason, it’s very important to preserve data relations.

Oftentimes, when renewing PrestaShop product combinations, you may encounter issues with associated PrestaShop images, as “combination-image” association might be broken. Below in this article you will find tutorial on how to efficiently update attribute combinations and bypass inaccuracies with images.

We can organize overall process of data renewing into several steps:

Export Combination Data

On purpose to update product combinations successfully, you have to physically download their images to hard drive, while exporting information, associated to PrestaShop combinations. For that you need to enable “Export images” option, checking corresponding box on the fourth step of the export process. In the field below you must specify local directory, images will be downloaded to.

Note, “Export image filename with full HTTP URL Path” option should be disabled.

Moreover, you should pay attention to the fields, you are exporting to .csv file, since they are crucial for further data update, namely:

  • Product Image – it’s possible to accomplish further combination update only in case main “Product Images” column, that comprises all combinations images, is listed in the file.
  • Combination images – this column includes the name of exact image, that must be linked to certain attribute combination.
  • Attribute group – this column of your .csv file should contain all attribute options accessible.

Depending on what exactly data you need to update, choose the fields to export (e.g. quantity, impact).


Check FTP Tasks Queue

PrestaShop images are not being downloaded in an instant, they form queue and are being exported one by one. This process is displayed in FTP Tasks Queue section of Store Manager. Once the program downloaded images, FTP Tasks Queue is empty.


Import Data Back to PrestaShop

Having implemented needed modifications to the data exported, you can import the file back to database, re-uploading combination images and updating combination details in such a way. When accomplishing this procedure via Store Manager Import Wizard, you should pay heeds to the following points:

  • on the third step of PrestaShop import you should check “Import Images” box, specify local folder name (combination images are stored in after exporting) and define image delimiter (used to separate images in the file)
  • specify correct identifier and properly link database fields and file columns on “Assign .csv Columns to Database Fields” step of data transfer, so that PrestaShop combinations will be successfully updated
  • on “Import Options” step you should enable “Delete product images before import” box. In such a way you delete existing combination images and re-upload them, assigning to proper combinations. It helps you avoid image duplicates.
    Note, if you upload PrestaShop images from URLs, leading to your FTP, situation differs. Whenever you check “Delete product images before import” box, images will be deleted from FTP and not re-uploaded again. As a result, you won’t get any image at the front-end. This option can be used if images are located at the external source (supplier’s server).
  • Following tips, covered in this article, you will massively update PrestaShop product combinations in a hassle-free manner, avoiding inaccuracies and data muddles. It will help you keep PrestaShop catalog manageable and efficiently control site imagery.



    Import combinations with images to PrestaShop FREE Upload Now