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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.