Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Import from excel to create items in RMS

Posted on by 150

Is it possible to import from an excel file and automatically create items with basic information? Have seen that some tools exist but don't know how to find them. Thanks for help!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import from excel to create items in RMS

    You can try SQL server 2012 SSIS tool for import and export!! The "rms_so_importutility" does not work straightforward.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: Import from excel to create items in RMS

    One must have access to CustomerSource;

    mbs.microsoft.com/.../rms_so_importutility.htm

  • KenWDavis Profile Picture
    KenWDavis 195 on at
    RE: Import from excel to create items in RMS

    If you can send me an email, I can send you a copy.

  • fritzgigi Profile Picture
    fritzgigi 150 on at
    RE: Import from excel to create items in RMS

    Thanks for your replies! I did investigate the utility from Retail Realm but its quite expensive and I only need it for one of my vendors (out of over 100 different ones.) I have tried to find the utility on Microsoft's website but can't locate it. Can anyone point me in the right direction?

    thanks

  • Suggested answer
    KenWDavis Profile Picture
    KenWDavis 195 on at
    RE: Import from excel to create items in RMS

    Download the Store Operation Import Utility from Microsoft. If's a old but goodie for quick imports and more. You should be able to find it on the Microsoft site.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import from excel to create items in RMS

    We use an add-on from Retail Realm. We use it weekly to add new items. We import them into HQ and download the items to the stores. The add-on is available from some of the MS partners.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import from excel to create items in RMS

     We use Retail Realm's RR Import Utility and it has been a huge success.

    www.rrdisti.com/.../rr-import-utility

     You can contact sales@syssolutionsllc.com for a quote!

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans