Additional Shipping Cost not Updating

[ianleckey]

Hi folks,

 

I've got a problem with additional shipping cost.

 

Basically, if I update the additional_shipping_cost column in the ps_product table, nothing updates.

The only way I can set it, is if I go into the back office and change it there. The difficulty is I need to mass update all of the products for individual costs - so I've got a script that will do it for me.

 

Any idea as to why it wouldn't update once I've changed the value in the table?

 

Thanks

[Swysbad]

$sql = sprintf("UPDATE %s SET %s = %d WHERE id_category_default = %d", _DB_PREFIX_.'product', 'additional_shipping_cost', $price,  $id);
Db::getInstance()->Execute($sql);
$sql = sprintf("UPDATE %s SET %s = %d WHERE id_category_default = %d", _DB_PREFIX_.'product_shop', 'additional_shipping_cost', $price,  $id);
Db::getInstance()->Execute($sql);

Hello,

 

To change "additional shipping cost" you must update the table "ps_product" AND "ps_product_shop".

 

Good luck,

 

--------------------------

Antoine MACE

epitech_2017

pneusindustriels.fr

Edited September 9, 2013 by Swysbad (see edit history)

[connectcase]

@Swysbad: thank you, been searching for hours for this solution!