Subject | how could I resolve this problem |
---|---|
Author | Luis Adrián Amato |
Post date | 2004-03-29T16:17:53Z |
I have to import various price list from diferents places (xls) wich
have diferent description referencing to the same product, for example
suplier A list
hd 40 gb U$S 50
suplier B list
Hard Disk 40gb U$S 51
and so on .....
Database example
Products : {Id_prod, description}
Customer : {id_sup, description, location }
ProdCust: { id_prod, id_sup , price, date}
I must build a proces that could permit me to update the price list
automatically.
I dont know which way take, someone with more experience than me,
could anybody Help me .... please ...
have diferent description referencing to the same product, for example
suplier A list
hd 40 gb U$S 50
suplier B list
Hard Disk 40gb U$S 51
and so on .....
Database example
Products : {Id_prod, description}
Customer : {id_sup, description, location }
ProdCust: { id_prod, id_sup , price, date}
I must build a proces that could permit me to update the price list
automatically.
I dont know which way take, someone with more experience than me,
could anybody Help me .... please ...