We use data import software to update item information for new customers from Excel or CSV files, however it is very time consuming to update reorder numbers since they aren't in the Item table of the database where most of the other information is stored. Is there an easier way to update reorder numbers? I was thinking of maybe putting the reorder numbers in the extended description and running a query to update the items but it doesn't seem to work.
It's probable that your import is not creating an item reference in the supplierlist table, where supplier reorder number is tracked. You would actually need two queries, one to insert item and supplier references in the supplierlist table (itemid and supplierid) then a second one to update these references with the reorder number, master pack qty, etc.
If you are doing item imports on a regular basis you may want to look into purchasing a good RMS import tool, search the newsgroup, you'll find plenty of postings regarding this. I have personally used the Retail Realm Import Utility to import new items and the item mapping includes creating the entry in the supplier list table for you - it did what I needed it to do, but shop around and compare.
BTW I d> We use data import software to update item information for new customers from
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.