Exporting all product info?

Aug 18, 2009 3 Replies

Hello, We're using MS's RMS for our in-store POS system. We have an e- commerce site that we want o connect to RMS. All the options I can find (NitroSell, Kosmos) are WAY outside our budget. So, since I can script PHP, XML, and cron jobs, I figured I can at least take an XML or CSV export of RMS's product data and import it into the PHP/MySQL based X-Cart we're using online.



Well, the best export in RMS I can find is a product report that only have the product name, product number, a one-line description, quantity, and prices. This is actually handy for if I want to do qty. and price updates, but not good if I want to add new product from RMS to the Web site.



Is there an RMS report/export that will give me ALL of the product info? Thanks for any advice! Liam


You could customize the report to include the other information you are looking for. You could also add Date Created and Last Updated fields which would make filtering more accurate.

Customizing the reports are fairly simple with some SQL knowlegde. Open the .qrp files using Notepad. You should be able to get an understanding of the concepts used by looking at different reports. Or you could contract an RMS Partner and have them do it for you.

Robert

"Mechphisto" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required