RMS and E-commerce

Apr 06, 2010 4 Replies

I have a very basic question - we are using v2.0 of the RMS. I had a developer create an XML formatted file of an internet order from our e-commerce software on the webserver. There will be a semi-manual process to move that xml file from the server to my local computer to be processed by the POS - but when I try the CTRL + SHIFT + F10 it is looking for a server to connect to - am I missing somehting basic for this functionality. I thought I would be ready to import these online orders once I had this formatted XML file



Any assistance would be much appreciated.



Thank you


When you say move the XML file from your server to your local computer do you mean just copying the file or actually loading the XML into your database? I'm pretty sure the XML needs to be loaded into the table called Exchange in the database. This will allow them to pull up when you hit ctrl+shift+F10.

Thanks for the reply - I have no trouble getting it from the server to local computer - but not sure what to do with it now - when i do that keystroke - is looking for a server to connect to - not sure how to configure it... seems that I have to load that data manually into the Exchange db like you said, but cant find any help on how/where to do it...

When you say that the POS is looking for a server it sounds like you are hitting shift + ctrl + F12 (RMSNet). When you hit shift + ctrl + F10 it pops up a window titled "Open Internet Orders".

The XML file needs to be inserted into the exchange table. Some of the formatting is very specific. One thing that really threw me off is that 'YahooStore' has to be specified for the ProcessorCode. I don't use a Yahoo store but I couldn't get the XML data to be recognized if I used any other string for the ProcessorCode. As far as I'm concerned it's a meaningless piece of data so it's no problem to use 'YahooStore'.

You can automate the downloading and importing of the XML file from your web server to your RMS server by using a scheduled script to ftp down the file and run a sql statement to insert the data into the exchange table. The only manual part should be having a cashier click shift + ctrl + F10 to load an order.

we have a rms integrated solution that readily takes a preformatted XML to the Exchaneg table and from there you can do Ctrl + Shift + F10 and process order in POS.

In addition to this we have a full blown add on that downloads orders from Yahoo Merchant Services.

Please email or call to know more

snipped-for-privacy@lanservices.com

408-649-5371

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required