Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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


This topic is 4788 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

This topic is 4788 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.