/** Helper: update vendor costs when updating a product cost if the product has a defined vendor */ public function updateCostByUPC($upc, $cost, $vendorID) { $updateP = $this->connection->prepare(' UPDATE vendorItems SET cost=?, modified=' . $this->connection->now() . ' WHERE vendorID=? AND sku=?'); $skuModel = new VendorSKUtoPLUModel($this->connection); $skuModel->vendorID($vendorID); $skuModel->upc($upc); foreach ($skuModel->find() as $obj) { $this->connection->execute($updateP, array($cost, $vendorID, $obj->sku())); } $vModel = new VendorItemsModel($this->connection); $vModel->vendorID($vendorID); $vModel->upc($upc); foreach ($vModel->find() as $obj) { $this->connection->execute($updateP, array($cost, $vendorID, $obj->sku())); } }