Follow

Step 3 - Operations (Total Import Pro For PrestaShop)

step3.PNG

Operations allow you to modify your data before it enters the store. They run in sequence from top to bottom. This allows you to modify already modified information by adding a follow-on operation. Here are the ways this can be done:

Most Popular:

Adjust Price (Multiply): Allows you to multiply one value by another value. This is useful for adding tax or margins to your pricing.

Format: Multiply <price field> by [input value]

Example: Multiply price by 1.2

 

Adjust Price (Add): Adds a fixed number to your price. Useful for adjusting a constant markup value.

Format: Add [input value] to <price field>

Example: Add 10 to price

 

Split Category on Delimiter: Used to split the category on a delimiter (like >) into multiple columns for importing.

Format: Split <category field> on [delimiter]

Example: Split categories on >

 

Append Text to Image: Appends text to the image field. This is useful to build a correct image path or URL.

Format: Append [text] after <image field name>

Example: Append .jpg after image

 

Prepend Text to Image: Prepend text to the image field. This is useful to build a correct image path or URL.

Format: Prepend [text] before <image field name>

Example: Prepend http://opencart.hostjars.com/ to image

 

Filter Products (equals):  This allows you to remove a products where a field exactly matches another field. This is useful if you wish to remove all products with a certain stock level for example.

Format: Exclude products where <field> equals [field value]

Example: Exclude products where stock equals 0

 

Filter Products (not equals):  This allows you to remove a products where a field does not match a certain fields. For example you can remove all products where enable is not equal to yes.

Format: Exclude products where <field> does not equal [field value]

Example: Exclude products where enabled does not equal yes

Advanced:

Append Text to Any Field:  Choose a field to append text to. This is useful if you wish to craft your image field into the format required by OpenCart.

Format: Append [text] after <image field name>

Example: Append .jpg after image

 

Prepend Text to Any Field: Choose a field to prepend text to. This is useful if you wish to craft your image field into the format required by OpenCart, but can also be used to modify other data.

Format: Prepend [text] before <image field name>

Example: Prepend http://opencart.hostjars.com/ to image

 

Multiply any Field:  Allows you to multiply one value by another value. This is useful for adding tax or margins to your pricing.

Format: Multiply <price field> by [input value]

Example: Multiply price by 1.2

 

Add to any Field:  Adds a fixed number to another number.

Format: Add [input value] to <price field>

Example: Add 10 to price

 

Split Any Field:  This splits a field on a delimiter creating a new column for each field.

Format: Split <category field> on [delimiter]

Example: Split categories on >

 

Replace Text:  Replace a piece of text for another piece of text inside a field. This is useful if you wish to adjust a particular piece of content.

 

Format: Replace [search text] with [replacement] in <field>

Example: Replace .gif with .jpg in image

 

Remove Text:  Select a field to remove text from, and input the text to remove in the Data field. This is useful when you have some generic piece of text you wish to remove.

Format: Remove [search text] in <field>

Example: Remove LHAFA in description

 

Filter Products (containing):  This allows you to remove a products where a field contains a certain value.

Format: Exclude products where <field> contains [field value]

Example: Exclude products where description contains skip

 

Filter Products (not containing):  This allows you to remove a products where a field does not contain a certain value.

Format: Exclude products where <field> does not contain [field value]

Example: Exclude products where description does not contain include

 

Clone Field:  This allows you to duplicate a field into a new column. Useful to back up a field, before you modify it with another operation.

Format: Duplicate <field> to [new_column]

Example: Duplicate price to original price

 

Append Field to Field:  This allows you to add one field on to another with a separator. Particularly useful for building Option and Discount import formats from different columns.

Format: Append <field1> to <field2> separated by [separation text]

Example: Append keywords to description separated by <space>

 

Merge multi-row products: This operation merges multiple rows of products to create a delimited value. This is particularly useful when importing Options, as you can merge all rows and import the correct options for each product.

Format: Common field <field> Merge the following fields <fields>

Example: Common field sku Merge the following fields size color

The merge multi-row products function is specifically for combining multiple products where there are some differing values in each row (such as size and color). This will allow each value to be imported as an option if the new merged field is mapped to Option in Step 4.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk