Item Import T-SQL

Does anybody have the T-SQL code to do bulk item importing in HQ. I have about 360,000 items, of which most were imported in SO before starting using the system in HQ. However, once you start using HQ, it has a new table called ItemDynamic, plus the SupplierList. I can still import items, but then you dont have info for the stores & tax. A utility can be built that updates these items, but is complex. Please reply if you already have a utility, or would like to help build one. I need one that will CREATE and item if not there, or UPDATE item description and cost if it is there, plus take care of ItemDynamic and SupplierList.

Reply to
Jon
Loading thread data ...

Reply to
Ahmed Nashat

itemdynamic(itemid,StoreID,quantitycommitted,quantity,ReorderPoint,RestockLevel,SnapShotQuantity,SnapShotQuantityCommitted)

quantity,0 as ReorderPoint,0 as RestockLevel,0 as SnapShotQuantity,0 as SnapShotQuantityCommitted

just need to run a "request full item count" worksheet to get the missing info

Reply to
Jon

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.