Hoping someone can help me with this.
I have a table with product pricing info in it.
I also have a list of updated prices for these products.
I'm trying to set up a query which will check the product Id number and update the price in the table with the new one based on it.
This is what I have so far but I think this will only work for an individual product.
price = '354.2' WHERE
sku = '001102CH';
Any help would be greatly appreciated with this as there are around 30,000 products to be updated!
Thanks in advance
store these in a separate table and then do a joined update