Can't change price of products

[Antoine]

Hello,

I try to update several products prices.
I had first to change the vendor of the product as it changed since last update.
I enter the current price in the appropriate field and save.
The new price is well saved in backend, but when I go frontend on the order form the old price is still the one used on submit.

If I go back in backend, I can see by changing back to the old vendor that the old price is still there too.
So I tried setting it back to 0.00, saving, changing to the new vendor with the good price, and saving once more.
But now on frontend the product is considered as free !

I really don't understand how nBill is behaving !
How can I do to have the good prices? (I use nBill 1.2.9)

Regards,
Antoine

[netshine]

Do you have access to a database admin tool like phpMyAdmin? If so, please run this SQL query (change the table prefix if necessary):

DELETE jos_inv_product_price.*
            FROM jos_inv_product_price
            LEFT JOIN `jos_inv_product` ON jos_inv_product_price.product_id = jos_inv_product.id
            AND jos_inv_product_price.vendor_id = jos_inv_product.vendor_id
            WHERE jos_inv_product.vendor_id is NULL

That should clear out any old prices assigned to the wrong vendor.