how to import item list into rms pos?

Hi, i have large list of items, how could i import them into RMS? any tools? -Cheng
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.
formatting link
Reply to
mchenga
There is an unsupported tool called QSImport that is available from MS Tech Support. Personally I don't think that tool is worth the effort of learning - it's easier for me to just use the tools built into SQL Management Studio. If you want to use a tool specific to RMS, get the Import Tool from Retail Realm - it is far more powerful than QSImport.
formatting link

Glenn Adams Tiber Creek Consulting
formatting link
snipped-for-privacy@tibercreek.com----------------------------------------------Please DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.
formatting link
Reply to
Glenn Adams [MVP - Retail Mgmt
Hi,
If you are interested we can write a custom import solution for you.
Regards, Manick snipped-for-privacy@hotmail.com
formatting link
Reply to
manick
QSCimport works OK.
For items, it's almost easier to use Excel to generate a series of query statements.
Unless you are absolutely helpless, don't pay for data import into RMS.
Tom
Reply to
Terrible Tom
Hi Tom,
I am obviously helpless as I don't know how you can import an excel file into RMS. Can you give me any hints as this would save a considerable amount of time.
Thanks
Andy
formatting link
Reply to
Andy Willis
Contact me by e-mail and I will give you some direction.
Basically, use the text functions in Excel to build a series of INSERT INTO statements, copy the statements into SO Admin and run them.
For every row, add this in the rightmost column: ="INSERT INTO Item (ItemLookupCode, Description, etc...) VALUES ("&ILC&", "&DESC&", "&ETC...&")"
Where the values referenced are cell references. The quotes are required.
The Excel VLOOKUP function can help you associate the items with the necessary SupplierIDs from the Supplier table. You'll want to export the supplier table and copy it into Excel - preferably to a separate worksheet within a single workbook.
If you need to import suppliers, do that first. Items second. If you want to import customers with account balances, use QSCimport. Importing customers (no account balances) would be OK.
Tom
Reply to
Terrible Tom
You can contact me and I will give you an FTP address to download the evaluation version of our RR Import Utility tool.
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm
formatting link
Reply to
Afshin Alikhani
Yes it works with 2.0 Store and HQ
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm
formatting link

Reply to
Afshin Alikhani

I am looking for import thousands of items from Excel to RMS. Any suggestions are welcomed. If excel works, please provide more detail instructions.
Reply to
ming y

We have an Import Utility for RMS Store and HQ. This also allows for import of catalogues from different vendors.
Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm
>I am looking for import thousands of items from Excel to RMS. Any >suggestions are welcomed. If excel works, please provide more detail >instructions.
Reply to
Afshin

There is a utility for importing from QuickSell - QSCImp. If you can find that somewhere then you can import from a text file that is saved in Excel.
Koit Lahesoo
Reply to
Koit Lahesoo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.