Exporting all product info?

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Exporting all product info? Mechphisto 08-18-2009  RE: Exporting all product info? Robert Arms 08-19-2009  Re: Exporting all product info? Mechphisto 08-21-2009  RE: Exporting all product info? kruiser7 09-12-2009
Posted by Mechphisto on August 18, 2009, 12:18 pm Please log in for more thread options 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 Posted by Robert Armstron on August 19, 2009, 2:55 pm Please log in for more thread options 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: > 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 > Posted by Mechphisto on August 21, 2009, 9:47 am Please log in for more thread options Thank you for the reply and the tip. I appreciate the direction. Thanks, Liam On Aug 19, 1:55=A0pm, Robert Armstrong - RMS Systems Inc. > You could customize the report to include the other information you are > looking for. You could also add Date Created and Last Updated fields whic= h > would make filtering more accurate. > > Customizing the reports are fairly simple with some SQL knowlegde. Open t= he > .qrp files using Notepad. You should be able to get an understanding of t= he > concepts used by looking at different reports. Or you could contract an R= MS > Partner and have them do it for you. > > Robert > > "Mechphisto" wrote: > > 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 Posted by kruiser7 on September 12, 2009, 3:12 am Please log in for more thread options "Mechphisto" wrote: > 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 > Similar Threads Posted Exporting Store Operations info into Peachtree June 20, 2008, 12:09 pm Buy Product A, get product B free April 9, 2006, 1:51 am Exporting PO March 12, 2007, 5:20 pm Exporting Reports June 3, 2005, 10:57 pm exporting data December 1, 2005, 2:58 pm need help with exporting error January 5, 2006, 6:20 pm exporting database in rms September 16, 2008, 10:59 am Exporting Database March 13, 2009, 9:47 pm Exporting Labels July 6, 2009, 12:11 pm exporting a mailing list September 2, 2005, 8:31 am