Great class Rick.  Here's a question (using the class' updating vendor pricing as an example)-what do you do if the vendor's product codes aren't unique enough for you?  For example, you have two vendors, and they both have a product 003, and you don't want to manually tweak the spreadsheet to include your autonumber for the product id etc.  To solve this, I've been using a concatenation for the product id (for example, their product code concatenated with the company id).  Is there a better way?

---

Reply from Richard Rost:

This is why I recommend having a separate import for each vendor's price updates. They're likely going to have different fields or field names. Unless they're EXACTLY the same and using something universal like a UPC code, then this is probably the best solution for you. Perhaps eventually everyone will get onboard with the same XML-based data set (at least for your business) but until that day it's best to have separate imports, IMHO.