Updating the price list in tbl_skus

If you have the sku ids stored in your pricelist, you should be able to import the table with your database admin tool, join it with the tbl_skus table, and run a simple update statement in your admin tool to update prices.

For example, given this sample table:

CREATE TABLE newprices(
 skuid varchar (50) NOT NULL ,
 price double NULL
)

Join to the tbl_skus table and update the SKU_Price field:

(access,mysql)
UPDATE tbl_skus
INNER JOIN newprices
ON newprices.skuid = tbl_skus.sku_merchskuid
SET tbl_skus.sku_price = newprices.price
WHERE newprices.skuid = tbl_skus.sku_merchskuid

(sql server)
update tbl_skus
SET tbl_skus.sku_price = newprices.price
from tbl_skus, newprices
WHERE newprices.skuid = tbl_skus.sku_merchskuid

Back to Cartweaver PHP FAQ, code changes, and samples