Product CSV Price Discount Update

[Paul_gpvr]

Hi,

 

I currently have all my products up and running with percentage discounts on all of them.

 

What i would like to do is change them via a csv import to a different percentage, reducing the discount in this case.

 

The import runs fine and creates the new additional specific price on the Item's Prices tab, so there are 2 or more percentage discount prices now. But the webstore front end still shows the previous old discount percent. It looks like it always shows the oldest one?

 

Any ideas how to fix this? Do i need to remove all discounting prices beforehand? Or what is best?

 

Should i be setting the from date as well?

 

Thanks.

 

Paul

Edited June 8, 2012 by Paul_gpvr (see edit history)

[Paul_gpvr]

Any ideas people? Sorry to push i just really need to adjust a lot of products prices.

[Paul_gpvr]

Does anyone know how to get this to work?

 

Surely people often change discounts on multiple products via csv?

[oorbx]

Really to solve something on prestashop forum. Big forum, but so much unanswered questions.

 

Create discount during csv import is easy, only set value in percantage or amount.

 

But is possible also to remove this discount?

 

I try to upload csv with "0" in discount column or with EMPTY SPACE but discount stayed without change.

 

Is it possible to do only with date setup, FROM/TO ?

 

please help

[PhpMadman]

It's not possible to remove an discount from csv.

If you are going to change discount on ALL products i suggest emptying the ps_specific_price table.

And then upload the new discounts.

 

If you don't gonna change on all, I have a very customized stand-alone script for my webshop, that I can share.

But that require you to know alot of php, and mysql login, since we don't use percentage, we use amount reduction based on nr of qty ordered.

Once edited and installed, you just upload a csv and the script changes the discounts.