Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Bulk product import

Posted on by 2,270

Is there a  way to do a bulk product import from an Excel spreadsheet?

*This post is locked for comments

  • HobbyNtoys Profile Picture
    HobbyNtoys 10 on at
    RE: Bulk product import

    Thanks much for the reply, I really appreciate it, and in a few months I will have written a free import utility for a new store, User transfer of there data, for free!

    I used to program a lot, and I even wrote some parts of Virtue Mart, NCR stuff, Learn Key, Store Win a complete grocery store front end and back end. Once my store is up and running I will do some programming..

    Thanks,

    Lynn

  • Suggested answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Bulk product import

    See this post: community.dynamics.com/.../308975.aspx

  • HobbyNtoys Profile Picture
    HobbyNtoys 10 on at
    RE: Bulk product import

    Dave J: That is a reasonable number. I suggest you reply to that post with "can someone please send this directly? I don't have CS access".

    Lynn H: okay, I will see how many run me over for asking :(

    Dave J: Many People ask for help, they just reply offline.

    Dave J:Bye for now

    Does anybody have an import utility for csv files to import product into my Database, I would really like to get my shop up and running, I purchased the system from a Bankruptcy sales of a hobby shop, and I am a hobby shop, I just need to import my data from a Excel file, or a csv, comma delimited file.

    thanks

    Lynn

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Bulk product import

    That is just for Partners I believe, so if so you will not be able to get to it even if your CustomerSource membership is current (BRAP/BRAP). You may be able to get Microsoft to do one import for you with an Incident if that is all you need (never sen that done, so not sure).

    But what we usually do for our customers is a One-Time import, or we sell them a more advanced Import tool that can import to pretty much any field in RMS, and even import POs and such, if they need it on an ongoing basis.

    Regards

    Mike Haugen

    Retail Technology Experts

    800-513-5917

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Bulk product import

    Clicking on the link, it says I'm not authorized to view?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Bulk product import

    Page Title: Microsoft Retail Management Systems Store Operations Import Utility

    mbs.microsoft.com/.../RMS_SO_ImportUtility.htm

    here is the link. but this tool it can't import all the field in the screen

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Bulk product import

    Is this QSImport still available?Was on customersource and I don't find it.

  • Kinnard Profile Picture
    Kinnard 80 on at
    Re: Bulk product import
    Yes, with some qualification needed. It is possible. Microsoft has a utility for importing databases called QSImports, it is the old Quicksell import utility. You must have access to Customersource or Partnersource to download it from the MS website. It worked well in Version 1.2 and 1.3, but some of the schemas changed in Version 2.0. Having said that, I successfully imported a 50,000 item database recently without issues into Version 2.0. It just takes some testing prior to actually doing a live import and a backup prior to doing so. The utility was designed, I assume, to bring in a csv file from other POS programs as a data conversion, but can also be used to import new catalog items. I would recommend not trying to import Parent Child items, that is very dicey. Retail Realm also has a add-on import program, but I have done just as well with the free utility. Kinnard L. Kohler Retail Management Systems of Arkansas P. O. Box 3332 Little Rock, AR 72203-3332 [Voice] 501-412-5686 [Fax] 501-325-1315 pos@kohler.net

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,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