Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Mass SQL insert into ITEM table

Posted on by 365

Hello All,

I want to mass insert into the ITEM table of RMS, I would like to know if anyone has attempted this and if there is anything I need to be weary of,

The theory is to add 1 item via the front end, look at the insert into the table ITEM, then mimic that exact line over a mass query.

I will obviously backup the current database and only test with a few lines first. If anyone has advice before this is attempted please let me know? :)

Kind regards :)

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass SQL insert into ITEM table

    Hello!

    Hows your bulk upload? I run also a script to branch so they can have  new items from HQ directly run from their database using sql script. My problem is supplier tab don't have data. 

    It can be punch thru POS and it can be use in Purchase Order only thing im missing is supplier tab i guess.

    Thanks,

    Chris

  • electroCUTE Profile Picture
    electroCUTE 365 on at
    RE: Mass SQL insert into ITEM table

    Hey Bruce, Fernando,

    Thank you for your responses. Lol Fernando.... that really puts it into perspective. (And yes, its HQ)

    Well I have just received another bulk lot, need to move fast and commit to a direction. If I do the custom script I will backup the DB and test locally. Will also check the pricing on the App you suggested.

    Many thanks guys.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass SQL insert into ITEM table

    In a Headquarters environment? More complex than store ops - you have the ITEMDYNAMIC table to also populate; I can't see the future but I do sense a head on a platter...there are add-ons that will accomplish this for you - check the Retail Realm Import Utility - works in an HQ environment. Trust me - you will spend double the amount on Tylenol if you go this route....

  • Bruce Liao Profile Picture
    Bruce Liao 265 on at
    RE: Mass SQL insert into ITEM table

    Bulk insert to temp table from csv, then copy to item table, we did it....

  • electroCUTE Profile Picture
    electroCUTE 365 on at
    RE: Mass SQL insert into ITEM table

    Hey Spencerm,

    Im in Headquarters environment. I think your Trace advice is the better option :D

    Will do that for sure

    Thank you for your response!

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,085 on at
    RE: Mass SQL insert into ITEM table

    Are you in a Headquarters environment or just Store Ops? In Headquarters, you will also need to make corresponding entries into the ItemDynamic table to hold the information for each store. In Store Ops alone, this won't be necessary, but you'll have to manually go back and specify supplier reorder info. I believe the SupplierList table is the only other table besides Item that is updated in Store Ops when a new item is created, but I'd recommend running a trace against the database while creating an item to make sure before you make any big changes.

  • electroCUTE Profile Picture
    electroCUTE 365 on at
    RE: Mass SQL insert into ITEM table

    Hey Fernando,

    I could spend the few hours, but my concern is that I am going to receive more and more bulk requests soon, so I want to script this as soon as possible.

    I totally hear what you are saying and will consider it carefully :)

    Much obliged

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass SQL insert into ITEM table

    Probably not the reply you want to hear, but for 200 items, it's not worth it. Spend a couple hours defining your departments, categories and suppliers, then enter them manually, do it the right way from the start. You can probably knock this out within a few hours data entry and avoid headaches down the road due to orphaned records.

  • electroCUTE Profile Picture
    electroCUTE 365 on at
    RE: Mass SQL insert into ITEM table

    Hey Eluid,

    Thank you so much for your response. Thats exactly what I needed to know :)

    Will give it a shot,

    Cheers for now

  • Verified answer
    eliud mugo Profile Picture
    eliud mugo 1,440 on at
    RE: Mass SQL insert into ITEM table

    Basically it will not be 100% accurate since not all tables will be updated.But it will be a quick way to create bulk items.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans