1 Reply Latest reply on Nov 1, 2011 8:28 AM by philmodjunk

    automatic logging the price change after importing a new price list from the supplier

    DannyKwok

      Title

      automatic logging the price change after importing a new price list from the supplier

      Post

      HI Guys:

      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.. ^^