Avatar of Mitul Prajapati
Mitul PrajapatiFlag for Australia

asked on 

Import 18000 new items in Microsoft dynamic RMS

Hi All,

My company is using Microsoft Dynamic RMS (Retail Management System) as retail application. In store Operation manager, I have to create 18000 new items in it. I have got all the information for all the items includes name, description, cost, supplier, quantity and all rest of the information to create item in the system. It is almost impossible to do it manually. I have google online for import utility but got no success and also have no idea about the required format in CSV file to import all these items and how to import it?

Can anyone help me with this?

Thank you in Advance.
Microsoft SQL Server

Avatar of undefined
Last Comment
Raja Jegan R
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Mitul Prajapati
Mitul Prajapati
Flag of Australia image


Thank you Raja Jegan for a quick reply.

I am working as network and system engineer in the company.  SQL application is handle by 3rd party and they asked for heaps of money to accomplish this task and my manager asked me to finish this task.

I got all admin rights for SQL server but I am poor in SQL terms. I will follow your instructions and will update you ASAP.

Exact task given by manager:

I need to create duplicates of all items. The new items will be the same as the old but end in the letter "B".  (item 5025 will be added as 5025B)
I need all information of the new items to match the old (price, category, etc), however the quantity on hand will be 0 for all new items and both items will stay in the system.
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Sure, kindly try and let me know if any assistance required..
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo