automatic logging the price change after importing a new price list from the supplier
I got a problem on writing a script to complete the following task, plesase help.
I do have a table which contains all the details of individual product, including Model number, Details, Qty in Stock and Price. Every 6 to nine months, the supplier will give us a new price list (approx 500+ items) and I need to log individual item if there is a price change. My original idea is create a temp table which is exact clone of the original Product Table. When there is a new price list came in, I will Import into this Temp table. Each record will then compare to the Original Product table, if there is a price change , or new product, it will update the Orginal Product table and create a record in another table call "product update". Is my logic correct? .
THanks in Advance.. ^^
If you need to log the update in a separate table, this seems a reasonable approach. If you only needed to update the prices, you could perform an "update matching values" import to update your price list and then you wouldn't need the temproary table.