Cheers Jason. I had this version working before I received your response, so I managed to get it working. I was in a proper mess beforehand though.
LEFT JOIN _import_products ON (_import_products.ProductSku = ps4_products.ProductSKU)
SET ps4_products.ProductPrice = _import_products.ProductPrice, ps4_products.ProductWeight = _import_products.ProductWeight, ps4_products.ProductWidth = _import_products.ProductWidth, ps4_products.ProductHeight = _import_products.ProductHeight, ps4_products.ProductLength = _import_products.ProductLength;
The only thing is, if I don't have a product price available in the import table for a product that exists in the product table, the price for that existing product is overwritten to 0.00 which is dangerous to say the least. How can I stop this from happening?