3.13. Update Combinations Wizard
Update Combinations wizard
In case you have products with combinations at your store and need to update their details, there is a possibility to use a Wizard, which is available in the newest released version of Store Manager for Prestashop (i.e. starting from ver. 2.46.0:2053), and called "Update Combinations". You can find it in the top menu of the program inside the Tools tab in the [Import/Export] actions list:
The Wizard consists of the following steps:
You should specify the source with the data to update by selecting one of the possible variants:
- "Local file". Select necessary file on your computer.
"HTTP URL to file". Select this option, if the data is on the external server. You should specify the full URL path to be able to proceed.
Make sure you have an access to the server and the data in it. To do so type the URL path in the browser and see if it opens.
- "FTP URL to file" option means that the data is on the FTP server. Fill the form with the FTP settings details and specify the full path to the file as well.
Take into account, next option (1) launches the file uploading process (2). After that you will be automatically redirected to the next step with the main values separators and delimiters.
Select Fields Delimiter and Quote Cheracter
Leave the settings in this window as they appear. If your import file has some specific delimiter, indicate it in the proper fields.
Click the [OK] button to move to the next stage.
Base Formats and Separators
The current settings will effect the import data, i.e. values and numbers. We recommend to leave default parameters; for this press [Set Default] button to the right.
Assign .csv Columns to Database Fields
The assignment step serves for linking the columns which you want to update with the relevant fields of the store database.
It is important to run update correctly. You should specify an identifier in the upper field to allow combinations, which are processing, to be recognized by the relevant parameter.
Note, select the value that is used at your store and can be easily identified by the program.
Activate the drop-down list opposite each position on the left pane to choose the necessary variant for assignment:
Or press the [Auto Fill] button and program will link the analogical fields itself:
To modify the data after update you can insert the custom formula by using the Expression Editor form.
Select the field and click inside the "Expression" column area to enable the [Editor] button:
Preview Import Data
This step shows the data prepared for an update. The field below allows to start process from the specified row of a file:
Before running an update choose the store(s) where the changes will be reflected. The relevant check-boxes are on the penultimate step.
To monitor the process, you are able to specify the path to the log file in the field below:
In addition, we recommend to save the current configuration in order to use similar settings during the next update process:
- to the wizard:
- to a separate file:
Click on the [Import] button to start the update operation:
Once it is completed, you will see the result in a separate window:
Exit the wizard by clicking the [Finish] button and check how the updated data is reflected at your store.