Yahoo Stores Internet Integration Exchange Data Table

Here is an example of a sql statement executed via OSQL in a .bat file which loads xml data into the exchange table:

INSERT INTO dbo.Exchange (DateCreated,LastUpdated,ProcessorCode,Data,Status,Comment) VALUES('9/4/2005 9:12:14 AM','9/4/2005 9:12:14 AM', 'YahooStore', ' Tue Aug 30 21:12:14 2005

Joe Smith Joe Smith

Phoenix AZ US United States

John Smith John Smith

Phoenix AZ US United States

FedEx Ground

NO

',0,'#7926, Fri 9/2/2005 2:12:10 PM, $161.90, ShipTo: Joe Smith, BillTo: John Smith');

The .bat file simply contains the following command: osql -ddatabase_name -Uusername -Ppassword < internet_orders.sql

internet_orders.sql is the file containing the sql statement with the xml data above.

You're right about the 'YahooStore' part needing to be present. Can't tell you how frustrating it was trying to figure out why I couldn't get the command to work when something seemingly as insignificant as that was missing.

The credit card type is simply a tender name and doesn't have to be Visa,MC,Amex, etc.

I haven't been able to get data to load into the company field...seems like a bug.

The Comment field doesn't have any specific requirement and can be modified any way you like. It's what a cashier will see when they hit at the POS.

Nick S wrote:

Lance,

To get the Company name to load, put the following inside of your AddressInfo element:

New West Technologies

- Evan Culver New West Technologies