Combination unique price without impact

[kovacsge]

In our billing system (not presta) every product has an unique reference number what I can use to update the quantity and the price via SQL.

 

example:

Airsoft gun's pellets box

(reference number - price - quantity - description)

1001001 - 5,00 - 5 - 2500pcs box

1001002 - 7,50 - 2 - 5000pcs box

1001003 - 10,00 - 9 - 10000pcs box

 

How can I give unique price to every combination item and skip the impact option?

 

I wrote a small script which upload the prices to the ps_product and ps_attribute table where the reference number are match with our billing system.

 

But when I choose a products from the store, that's show me a combined price (product table price + attribute table price)

 

Any idea how can I modify the source code to turn off the impact. I'd like to see only the unique price without the base price.

 

Thank you!

Edited October 4, 2012 by kovacsge (see edit history)

[phrasespot]

The impact of a combination is added/subbed from the base price of the product. Use the attribute_impact table to enter base price +- impacted price

[kovacsge]

Thank you it works!