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.
Item Import T-SQL
Apr 01, 2008
2 Replies
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