Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

How to create more than 10000 Items and Matrix Item in RMS using SQL Server/API

Posted on by 185

Hello There,

I have more than 10,000 Items , some of the items are Matrix and some are Simple Item. i just wanted to know how i create these items to MS RMS. is RMS has a API or something like that. if not so may i know which table involves for Creating simple and Matrix Items. i will be very appreciate if someone helps me.

Thanks for Advance.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to create more than 10000 Items and Matrix Item in RMS using SQL Server/API

    RMS has no built-in APIs. I agree with Hassan; there are excellent Import tools from Retail Realm and Davidson-Richards that will accomplish this, and enable you to import new lines of merchandise at any time.

    I don't think the RMS DB Schema is available to end users - guys please correct if not so.

    Mike Haugen

    RTE

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to create more than 10000 Items and Matrix Item in RMS using SQL Server/API

    I believe there is many importing utilities in the market to import standard/matrix items, I suggest that you try one of them instead of reinventing the wheel specially that you want to consider matrix items as the tables involved in standard items are very limited but it's a bit different when you talk about matrix items coz it involves more tables and you need to understand them very well

    A Hassan

    RMS Leaders

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans