Overwriting product attribute prices

[bartjee]

I am working on a Prestashop project for a customer of mine. There are 3000 products in the database at the moment from different manufacturers.

 

From 1 manufacturer the prices aren't calculated the right way and need to be editted.

 

The basic prices, i.e. product prices, can simply be overwritten via a CSV import using product ID and the price field.

 

But the attributes cannot be overwritten, as far as I have found out. And from this particular manufacturer we have 500 products in our database, with a total of 500 product attributes. So editting them 1-by-1 isn't really an option.

 

Is there a simple way to just overwrite the attribute prices? Preferably using a CSV import.

 

If I do it now, then every attribute will be double, so the system just adds the new attributes to the old ones.

 

I hope my question is clear and that it is possible.

 

Thanks in advance for the help :-)

[stottycabanas]

Hi Bartjee,welcome to the forum.

Not sure I do understand, particularly where you say 'we have 500 products in our database, with a total of 500 product attributes.'

An attribute will be something like size, colour, etc. Are you saying you have 500 different attributes? Or 1 attribute with 500 different values? Each product has exactly one attribute? Or something else?

Also you mention 'attribute prices' - I don't know what you mean by that.

In Prestashop, a product will have a base price. Product combinations are formed by selecting values for a number of different attributes associated with the product (e.g. if the product is a T-shirt and you have attributes of size, colour and neckline, then a red V-neck XL T-shirt represents one possible combination).

Each combination can have an 'impact' on the base price, e.g. it might increase it by £10 or whatever. But only the impact is stored for that combination, not the resultant increased price.

It might help if you can give examples of the products and the attributes you are using.

Cheers, Dave

[bartjee]

Thanks for the reply.

 

I know they are called combinations, but everytime I googled something about these product combinations all the results came back as "attributes", thats why I called them like that.

 

The numbers were just an indication to show that it will be a big job to do everything manually. From this manufacturer there are 500 base products and these products combined have 500 combinations. So some have 0 combinations and others 5+. Only to inform that I want to do this with a script or import list and not stone-age manually.

 

What I HAVE is this:

Product A = 10 euro

Combinations of product A are:

X + 2 price impact

Y + 4 price impact

Z + 6 price impact

 

But these price impacts are incorrect. They should be:

X + 2.5

Y + 3.9

Z + 7.3

 

If I have:

X + 2

Y + 4

Z + 6

And then import a CSV file with the correct price impacts, I get:

X + 2

Y + 4

Z + 6

X + 2.5

Y + 3.9

Z + 7.3

 

But I want the new price impacts to OVERWRITE the old price impacts of these combinations.

 

I hope it is clear now what the problem is and what I am looking for :-)

[bartjee]

No other people have this problem? Then what do I do wrong..?

 

Help would be greately appreciated :-)

[stottycabanas]

I think others have reported duplication when trying to update via CSV import.

You will probably need to run a SQL script against your (backed-up) database.

Cheers, Dave