$id_product = Tools::getValue('id_product'); $id_product_attribute = Tools::getValue('id_product_attribute'); $wholesale_price = Tools::getValue('wholesale_price'); $id_supplier = Tools::getValue('id_supplier'); /* If we have a price for this supplier update for the supplier * At any case we update principal price for product or attribute */ $query = 'SELECT COUNT(id_product_supplier) as nb_products, id_product_supplier FROM ' . _DB_PREFIX_ . 'product_supplier WHERE id_product = ' . (int) $id_product . ' AND id_product_attribute = ' . (int) $id_product_attribute . ' ' . 'AND id_supplier = ' . (int) $id_supplier . ' AND product_supplier_price_te >0.000000'; $nbProducts = DB::getInstance(_PS_USE_SQL_SLAVE_)->getRow($query); /* If price for this supplier, update */ if ((int) $nbProducts['nb_products'] > 0) { $product_supplier = new ErpProductSupplier($nbProducts['id_product_supplier']); $product_supplier->product_supplier_price_te = $wholesale_price; $product_supplier->save(); } /* If not global update of the product in any case */ /* Product */ if ($id_product_attribute == '0') { $product = new Product($id_product); $product->wholesale_price = $wholesale_price; $product->save(); } else { $combination = new Combination($id_product_attribute); $combination->id_product = $id_product; $combination->wholesale_price = $wholesale_price; $combination->save(); } $update = DB::getInstance(_PS_USE_SQL_SLAVE_)->execute($query); echo $update;