Pricing File Imports

[RickM]

Hello everyone...

Quick question to see how folks are handling the following situation:

We receive pricing files from our distribution partners. I would like to import these into SugarCRM so that my sales folks can use this information to create quotes from within the system. I can see how I can do this ONCE and make it work.

Unfortunately, the prices change rather frequently, so we would like to be able to "update" the product catalog on a regular basis. I tried to reimport and it essentially created duplicate products! OUCH! What I would like to accomplish in the "update" process is the following:

1. Update the qty on hand for existing part numbers
2. Create new products automatically

Optionally, I would like to be able to run an "update" which removes products/skus which are no longer available.

In any event, how are others handling this? Any thoughts/ideas?

TIA
Rick

[RickM]

Anyone???

[Markku]

One way is to create external sql script which would handle adding/updating product and pricing info. You could run this script manually through simple php written interface when needed or use cron job to run it automatically.

The time it takes to write this kind of script depends on the structure of source data and the features needed. Based on your description it should not be too difficult, though.