|
Posted by convoluted on September 8, 2008, 5:39 pm
Please log in for more thread options
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 don't work for Retail Realm - hope this helps....
"RCS" wrote:
> 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.
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap