Item Import T-SQL

Apr 01, 2008 2 Replies

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.


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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required