Product-Import - what happens to existing products if they exist in the datafeed as well?

[tomkay]

Hello,

 

If I am importing a datafeed to my store, what happens to products which already exist? Will they be updated if the same product is in the datafeed? Will the other information of this product be kept? I want to price-update some of my products and also change some describtions, but I dont want that all other information will be deleted...

 

Can you help me ?

[RogueWaveLimited]

If you import a product that exists the fields you import will change the corresponding fields in the product. If you want to only change the description or the price, etc. you should import only those fields and only for the products you want to change. For your case it would probably be best to import the price changes in one file then import the description changes in another file.

[tomkay]

So the identifier will be what? The automatically generated ID by PS or my article-number?

[RogueWaveLimited]

Either the ID or the Name can be used to identify a product. So for example to modify prices you need a file with Name and Price or one with ID and Price.

[Constantino]

Hello,
If you decide to try an alternative solution, I can offer you desktop application called Store Manager for Prestashop. It has more flexible system for importing the data and applying changes. For example, if you need to update price, you can simply have column ID (for identification) and column with price. Then during import you can choose to modify existing data and only changes to products prices will be applied. No other fields should be effected. It is possible by choosing option "Modify only" at the lasts step of import: http://www.prestashopmanager.com/useful-articles/prestashop-product-management/prestashop-import-products/ In case you need to implement changes to product details massively, you can use the method which is much easier than Import: http://www.prestashopmanager.com/useful-articles/how-to/how-to-make-mass-product-changes/

[tomkay]

Hello,

If you decide to try an alternative solution, I can offer you desktop application called Store Manager for Prestashop. It has more flexible system for importing the data and applying changes. For example, if you need to update price, you can simply have column ID (for identification) and column with price. Then during import you can choose to modify existing data and only changes to products prices will be applied. No other fields should be effected. It is possible by choosing option "Modify only" at the lasts step of import: http://www.prestashopmanager.com/useful-articles/prestashop-product-management/prestashop-import-products/ In case you need to implement changes to product details massively, you can use the method which is much easier than Import: http://www.prestashopmanager.com/useful-articles/how-to/how-to-make-mass-product-changes/

 

Do you know, if this software also allows to do dynamic changes of columns? For example I want to change all meta-titles like "Buy now {productname} at {shop_url} for price of {price}" ? So that for each product the values of the columns are being used to generate the product-specific meta-title ?

[Constantino]

Basically you need to run import via Store Manager for Prestashop and during import use the following expression formula for the meta-title field -

CONCAT('Buy now ', [CSV_COL(1)], ' at ', [CSV_COL(2)], ' for price of ', [CSV_COL(3)])

Where (1) is column for product name, (2) is column for shop_url, (3) is column for price
 

In case I misunderstood you and you meant something else, please, let me know and I will provide you another solution.

If you want to read more about special expression formulae:
http://www.prestashopmanager.com/useful-articles/how-to/how-to-manage-prestashop-data-in-the-process-of-import-by-means-of-expression/

Edited January 8, 2014 by Constantino (see edit history)

[tomkay]

Ah thats really nice... I may consider using that tool.

 

Thank you !