Step 3: Adjust Data
Use this step to make any adjustments to your feed data. All fields at Step 3 are optional, however, for some feeds they may be especially powerful at modifying your feed to be better imported into PrestaShop.
Categories Delimiter: If your category and subcategory are in the same field in your file, you can split them into separate fields by inputting the delimiter text or character (e.g., if your category and subcategory field was “category&sub category” enter “&” into this field [without quotation marks])
Keyword Delimiter: If you want to include multiple keywords (Meta Keywords from Step 3) in a field, you can separate using a delimiter of your choice. For example, the delimiter for "clothing|shirts|juniors" would be "|" [without quotation marks].
Tags Delimiter: If you want to include product tags (Tags from Step 2) in a field, you can separate using a delimiter of your choice. For example, the delimiter for "printer:ink:paper" would be ":" [without quotation marks].
Unity for Unit Price field: This is the unit of measurement for the unit price field. If you are importing a unit price of 2.00 per lb. You would map the 2.00 column to the Unit Price in Step 2; then include "lb" [without quotation marks] in the Unity for Unit Price field here.
Discount Type: The impact type can be selected with this setting. This setting corresponds to the Discount field in Step 2: Field Mapping. If you select Amount, the value in the feed column will be the discount impact, such as a value of 10.00 will be 10.00 off the final price. If you select Percentage, the discount impact for a value of 10 will be 10% of the final price.
Price Multiplier: To increase all products’ prices by a percentage, insert the amount to multiply by here (e.g., input “1.1” [without quotation marks] to increase the price of all items by 110%).
Image Remove Text: Remove extra text from the beginning of the image text being imported; especially
helpful if your image text refers to a URL and you already imported the images manually to a location inside your PrestaShop root directory. Use this to remove “http://yoursite.com/images/” as an example.
Image Prepend Text: Add a certain string of text to the beginning of each image name. If not remote, the images are assigned a path from their location from the PrestaShop root directory: http://hostjars.zendesk.com/entries/26329693-How-do-I-import-images-. One usage would be adding “data/” (without quotation marks) to correctly reference the images being located in a data folder inside the PrestaShop root directory.
Image Append Text: Add a certain string of text to the end of each image name; if your image names match your reference field, you could use this field to add an image extension such as “.jpg” (without quotation marks) to each image name being imported.