Table of Contents
Ecommerce + XML = Flexible
Prior to v0.5.1: When you turn on the XML, FoxyCart will “feed” all “unfed” transactions back to you. That is, if you turn on your datafeed right now, the first XML sent will include ALL previous transactions that your store may have processed. This would be helpful if, for example, you wanted to import all of your customers into a mailing list, but in some cases this is NOT the behavior you want. This functionality may change in the future once exporting transactions to XML is allowed.
An Overview of FoxyCart's XML Datafeeds
In order to allow the flexibility and integration options that you need, FoxyCart can be configured to send encrypted XML to a URL of your choosing. This allows you to integrate FoxyCart without duplicating data across applications.
When you configure it for your store, it will send you an encrypted xml data post of your new transactions immediately* upon a successful transaction. (*The processing actually happens between the checkout and the receipt for FoxyCart version 0.5.1+. Prior versions will send the datafeed once a minute.) You can then update your inventory, manage paid subscriptions, add users to your mailing list, or whatever else you can dream up. You have full control.
Please note that FoxyCart's XML datafeeds do not include credit card information (number, CSC, date, etc.).
DETAILS, BEST PRACTICES and TESTING Recommendations
Details
- When the datafeed is sent it REQUIRES A RESPONSE OF
foxyin order to indicate success. If anything other thanfoxyis returned by your datafeed processing script, FoxyCart will assume that your script errored, and you will be alerted. - As of FoxyCart v051 the XML datafeed is sent immediately, in between the checkout and the receipt during your customers' transactions. Prior to v051 the datafeed was sent once a minute, and may have included multiple transactions in a single POST.
Testing
When you're testing your custom XML integration, don't run transactions through FoxyCart. This is both time consuming (as you have to add-to-cart, checkout, then wait up to a minute to receive the XML), but it also doesn't give you any indication of what's actually going wrong.
A much better method is to use the XML Test Post script or application (C#). This effectively mimics what FoxyCart is actually doing when sending the XML to your server in the first place. Make sure you update the test XML in the script to the appropriate version (below).
If you'd like to test using real data from your store, you can run a test transaction and write the datafeed to a file, then copy it out and put it in the Test Post script.
If you're struggling to just get started with reading the feed, try this: on your script page, capture all the POST data and write it to a file. Test it by posting a simple form to this page just to ensure that it works, and then you can run a single FoxyCart transaction to capture its data. You should end up with an array with a key of 'FoxyData' and pages of url-encrypted data, e.g. “%EBrV%8C%E9…”. After you've saved this to a file, you can work out the other details of your script, e.g. decoding the XML and routing it to your database or 3rd party applications (e.g. MailChimp).
When you turn on the XML, FoxyCart will “feed” all “unfed” transactions back to you. That is, if you turn on your datafeed right now, the first XML sent will include ALL previous transactions that your store may have processed. This would be helpful if, for example, you wanted to import all of your customers into a mailing list, but in some cases this is NOT the behavior you want. This functionality may change in the future once exporting transactions to XML is allowed.
If you'd like to “clear” your datafeed and mark all previous transactions as “fed”, you can create a text file on your server containing just the word “foxy”. Point your datafeed URL to that file and FoxyCart will mark all your existing transactions as “fed”, and it will not feed them again.
Best Practices
- Test according to the above method.
- If you're doing complicated stuff, you may want to backup the XML to a database. This allows you to re-process things at a later date (like if you change mailing list service providers, add a new member functionality, etc.).
- Don't make assumptions about the data structure. Rather than just accessing a node and assuming the value is there, test first. This can prevent errors down the road.
Notes
- The transaction XML datafeed comes with a
POSTname ofFoxyData. This is different than the subscription XML datafeed, which has aPOSTname ofFoxySubscriptionData. - FoxyCart v0.5.1+ sends the XML datafeed immediately, in between the checkout and receipt. Previous version send it once a minute.
Country Codes
For compatibility, FoxyCart uses ISO country codes in our XML:
Example XML
FoxyCart v060 Datafeed
- CHANGE:
CDATAtags added to most elements. - NEW FIELDS:
is_testused to indicate if the transaction is a test transaction (or a live one) based on the store's payment processor settings. - NEW FIELDS:
is_anonymous - NEW FIELDS:
cc_number_masked - NEW FIELDS:
cc_type - NEW FIELDS:
cc_exp_month - NEW FIELDS:
cc_exp_year - NEW FIELDS:
processor_response_details. Only used for Orbital and Cybersource. Child nodes vary per gateway. - FIX:
shipto_shipping_service_descriptionwas added back to the shipto_address node. - CHANGE:
sub_token_urlis populated on the initial transaction's datafeed. At this point, it will populate with thesub_tokenof the first subscription in the transaction. If you have multiple distinct subscriptions in one transaction you may not want to rely on thesub_tokensent in the initial datafeed. - CHANGE: The
processor_responsenow includes the gateway's ID, not the FoxyCart transaction ID.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <foxydata> <transactions> <transaction> <id><![CDATA[3247]]></id> <store_id><![CDATA[9]]></store_id> <transaction_date><![CDATA[2009-10-19 12:51:18]]></transaction_date> <processor_response><![CDATA[Authorize.net Transaction ID:2150746594]]></processor_response> <processor_response_details> <merchantReferenceCode><![CDATA[3797]]></merchantReferenceCode> <requestToken><![CDATA[Azj//wFEsrZ+43+52sqEe7OAAigjD]]></requestToken> <ccAuthReply__cvCode><![CDATA[M]]></ccAuthReply__cvCode> <ccAuthReply__authorizationCode><![CDATA[193189]]></ccAuthReply__authorizationCode> <ccAuthReply__authorizedDateTime><![CDATA[2010-04-21T04:37:29Z]]></ccAuthReply__authorizedDateTime> <ccAuthReply__avsCode><![CDATA[Y]]></ccAuthReply__avsCode> <ccAuthReply__reconciliationID><![CDATA[]]></ccAuthReply__reconciliationID> </processor_response_details> <customer_id><![CDATA[116]]></customer_id> <is_anonymous><![CDATA[0]]></is_anonymous> <customer_first_name><![CDATA[John]]></customer_first_name> <customer_last_name><![CDATA[Doe]]></customer_last_name> <customer_company><![CDATA[ACME Inc.]]></customer_company> <customer_address1><![CDATA[555 Mulberry Dr.]]></customer_address1> <customer_address2><![CDATA[#200]]></customer_address2> <customer_city><![CDATA[Pleasantville]]></customer_city> <customer_state><![CDATA[CA]]></customer_state> <customer_postal_code><![CDATA[90740]]></customer_postal_code> <customer_country><![CDATA[US]]></customer_country> <customer_phone><![CDATA[555-444-3333]]></customer_phone> <customer_email><![CDATA[test1@example.com]]></customer_email> <customer_ip><![CDATA[64.203.53.230]]></customer_ip> <shipping_first_name><![CDATA[]]></shipping_first_name> <shipping_last_name><![CDATA[]]></shipping_last_name> <shipping_company><![CDATA[]]></shipping_company> <shipping_address1><![CDATA[]]></shipping_address1> <shipping_address2><![CDATA[]]></shipping_address2> <shipping_city><![CDATA[]]></shipping_city> <shipping_state><![CDATA[]]></shipping_state> <shipping_postal_code><![CDATA[]]></shipping_postal_code> <shipping_country><![CDATA[]]></shipping_country> <shipping_phone><![CDATA[]]></shipping_phone> <shipto_shipping_service_description><![CDATA[]]></shipto_shipping_service_description> <purchase_order><![CDATA[]]></purchase_order> <cc_number_masked><![CDATA[xxxxxxxxxxxx1111]]></cc_number_masked> <cc_type><![CDATA[Visa]]></cc_type> <cc_exp_month><![CDATA[01]]></cc_exp_month> <cc_exp_year><![CDATA[2011]]></cc_exp_year> <product_total><![CDATA[15.88]]></product_total> <tax_total><![CDATA[0]]></tax_total> <shipping_total><![CDATA[85.29]]></shipping_total> <order_total><![CDATA[101.17]]></order_total> <payment_gateway_type><![CDATA[authorize]]></payment_gateway_type> <receipt_url><![CDATA[https://example.foxycart.com/receipt?id=c78daaf951dc0c0b373ce3ed6f123d0b]]></receipt_url> <next_transaction_date><![CDATA[2009-12-01]]></next_transaction_date> <subscription_end_date><![CDATA[2010-01-01]]></subscription_end_date> <sub_token_url><![CDATA[https://example.foxycart.com/cart?sub_token=ae2f8d30b9a38158a9020d76b95ca327]]></sub_token_url> <taxes> <tax> <tax_rate><![CDATA[1.0000]]></tax_rate> <tax_name><![CDATA[Global Tax]]></tax_name> <tax_amount><![CDATA[0]]></tax_amount> </tax> </taxes> <discounts> <discount> <code><![CDATA[coupon_code_as_entered]]>
<name><![CDATA[$5 off all orders over $5!]]></name> <amount><![CDATA[-5]]></amount> <display><![CDATA[-5.00]]></display> <coupon_discount_type><![CDATA[price_amount]]></coupon_discount_type> <coupon_discount_details><![CDATA[5-5]]></coupon_discount_details> </discount> </discounts> <customer_password><![CDATA[6a204bd89f3c8348afd5c77c717a097a]]></customer_password> <custom_fields> <custom_field> <custom_field_name><![CDATA[ga]]></custom_field_name> <custom_field_value><![CDATA[#__utma=1.1224957675.1255981724.1255981724.1255981724.1&__utmb=1.3.10.1255981724&__utmc=1&__utmx=-&__utmz=1.1255981724.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)&__utmv=-&__utmk=21352507]]></custom_field_value> </custom_field> <custom_field> <custom_field_name><![CDATA[example_hidden]]></custom_field_name> <custom_field_value><![CDATA[value_1]]></custom_field_value> </custom_field> <custom_field> <custom_field_name><![CDATA[Hidden_Value]]></custom_field_name> <custom_field_value><![CDATA[My_Name_Is_Jonas]]></custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name><![CDATA[Example Product]]></product_name> <product_price><![CDATA[10.00]]></product_price> <product_quantity><![CDATA[1]]></product_quantity> <product_weight><![CDATA[4.000]]></product_weight> <product_code><![CDATA[abc123zzz]]></product_code> <downloadable_url><![CDATA[]]></downloadable_url> <subscription_frequency><![CDATA[]]></subscription_frequency> <subscription_startdate><![CDATA[0000-00-00]]></subscription_startdate> <shipto><![CDATA[Me]]></shipto> <category_description><![CDATA[Discount: Price: Percentage]]></category_description> <category_code><![CDATA[discount_price_percentage]]></category_code> <product_delivery_type><![CDATA[shipped]]></product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name><![CDATA[color]]></product_option_name> <product_option_value><![CDATA[red]]></product_option_value> <price_mod><![CDATA[-4.000]]></price_mod> <weight_mod><![CDATA[0.000]]></weight_mod> </transaction_detail_option> <transaction_detail_option> <product_option_name><![CDATA[Price Discount Amount]]></product_option_name> <product_option_value><![CDATA[-2%]]></product_option_value> <price_mod><![CDATA[-0.120]]></price_mod> <weight_mod><![CDATA[0.000]]></weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name><![CDATA[Example Subscription]]></product_name> <product_price><![CDATA[10.00]]></product_price> <product_quantity><![CDATA[1]]></product_quantity> <product_weight><![CDATA[4.000]]></product_weight> <product_code><![CDATA[xyz456]]></product_code> <downloadable_url><![CDATA[]]></downloadable_url> <subscription_frequency><![CDATA[1m]]></subscription_frequency> <subscription_startdate><![CDATA[2009-12-01]]></subscription_startdate> <shipto><![CDATA[Me]]></shipto> <category_description><![CDATA[Default for all products]]></category_description> <category_code><![CDATA[DEFAULT]]></category_code> <product_delivery_type><![CDATA[flat_rate]]></product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name><![CDATA[color]]></product_option_name> <product_option_value><![CDATA[red]]></product_option_value> <price_mod><![CDATA[-4.000]]></price_mod> <weight_mod><![CDATA[0.000]]></weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name><![CDATA[some pdf]]></product_name> <product_price><![CDATA[10.00]]></product_price> <product_quantity><![CDATA[1]]></product_quantity> <product_weight><![CDATA[0.000]]></product_weight> <product_code><![CDATA[some-pdf]]></product_code> <downloadable_url><![CDATA[https://example.foxycart.com/dev/dl.php?p=djX6DTD8eqkU83ndWtJ6ywtiFLEnazhhM9h]]></downloadable_url> <subscription_frequency><![CDATA[]]></subscription_frequency> <subscription_startdate><![CDATA[0000-00-00]]></subscription_startdate> <shipto><![CDATA[Me]]></shipto> <category_description><![CDATA[Downloadables]]></category_description> <category_code><![CDATA[OL]]></category_code> <product_delivery_type><![CDATA[downloaded]]></product_delivery_type> <transaction_detail_options/> </transaction_detail> </transaction_details> <shipto_addresses> <shipto_address> <address_id><![CDATA[55]]></address_id> <address_name><![CDATA[Me]]></address_name> <shipto_first_name><![CDATA[Madre]]></shipto_first_name> <shipto_last_name><![CDATA[Doe]]></shipto_last_name> <shipto_company><![CDATA[]]></shipto_company> <shipto_address1><![CDATA[1234 Calle de Carretas]]></shipto_address1> <shipto_address2><![CDATA[]]></shipto_address2> <shipto_city><![CDATA[Madrid]]></shipto_city> <shipto_state><![CDATA[Madrid]]></shipto_state> <shipto_postal_code><![CDATA[28004]]></shipto_postal_code> <shipto_country><![CDATA[ES]]></shipto_country> <date_created><![CDATA[2010-02-06 12:30:31]]></date_created> <date_modified><![CDATA[2010-02-06 12:30:31]]></date_modified> <shipto_shipping_service_description><![CDATA[UPS Next Day Air]]></shipto_shipping_service_description> </shipto_address> </shipto_addresses> </transaction> <transaction> <id><![CDATA[3250]]></id> <store_id><![CDATA[9]]></store_id> <transaction_date><![CDATA[2009-10-19 13:20:56]]></transaction_date> <processor_response><![CDATA[PayPal Transaction ID:3WA89407UK383652C]]></processor_response> <customer_id><![CDATA[168]]></customer_id> <is_anonymous><![CDATA[1]]></is_anonymous> <customer_first_name><![CDATA[Test]]></customer_first_name> <customer_last_name><![CDATA[User]]></customer_last_name> <customer_company><![CDATA[]]></customer_company> <customer_address1><![CDATA[1 Main St]]></customer_address1> <customer_address2><![CDATA[]]></customer_address2> <customer_city><![CDATA[San Jose]]></customer_city> <customer_state><![CDATA[CA]]></customer_state> <customer_postal_code><![CDATA[95131]]></customer_postal_code> <customer_country><![CDATA[US]]></customer_country> <customer_phone><![CDATA[]]></customer_phone> <customer_email><![CDATA[list_1255983093_per@example.com]]></customer_email> <customer_ip><![CDATA[64.203.53.230]]></customer_ip> <shipping_first_name><![CDATA[]]></shipping_first_name> <shipping_last_name><![CDATA[]]></shipping_last_name> <shipping_company><![CDATA[]]></shipping_company> <shipping_address1><![CDATA[]]></shipping_address1> <shipping_address2><![CDATA[]]></shipping_address2> <shipping_city><![CDATA[]]></shipping_city> <shipping_state><![CDATA[]]></shipping_state> <shipping_postal_code><![CDATA[]]></shipping_postal_code> <shipping_country><![CDATA[]]></shipping_country> <shipping_phone><![CDATA[]]></shipping_phone> <shipto_shipping_service_description><![CDATA[]]></shipto_shipping_service_description> <purchase_order><![CDATA[]]></purchase_order> <cc_number_masked><![CDATA[]]></cc_number_masked> <cc_type><![CDATA[]]></cc_type> <cc_exp_month><![CDATA[]]></cc_exp_month> <cc_exp_year><![CDATA[]]></cc_exp_year> <product_total><![CDATA[130]]></product_total> <tax_total><![CDATA[21.00748]]></tax_total> <shipping_total><![CDATA[44]]></shipping_total> <order_total><![CDATA[195.00748]]></order_total> <payment_gateway_type><![CDATA[paypal_express]]></payment_gateway_type> <receipt_url><![CDATA[https://example.foxycart.com/receipt?id=a6ec3c604df4bda7b26bd8692901fec6]]></receipt_url> <next_transaction_date><![CDATA[]]></next_transaction_date> <subscription_end_date><![CDATA[0000-00-00]]></subscription_end_date> <sub_token_url><![CDATA[]]></sub_token_url> <taxes> <tax> <tax_rate><![CDATA[10.1596]]></tax_rate> <tax_name><![CDATA[California]]></tax_name> <tax_amount><![CDATA[13.20748]]></tax_amount> </tax> <tax> <tax_rate><![CDATA[5.0000]]></tax_rate> <tax_name><![CDATA[US]]></tax_name> <tax_amount><![CDATA[6.5]]></tax_amount> </tax> <tax> <tax_rate><![CDATA[1.0000]]></tax_rate> <tax_name><![CDATA[Global Tax]]></tax_name> <tax_amount><![CDATA[1.3]]></tax_amount> </tax> </taxes> <discounts/> <customer_password><![CDATA[d41d8cd98f00b204e9800998ecf8427e]]></customer_password> <custom_fields> <custom_field> <custom_field_name><![CDATA[ga]]></custom_field_name> <custom_field_value><![CDATA[#__utma=1.1484107376.1255983648.1255983648.1255983648.1&__utmb=1.1.10.1255983648&__utmc=1&__utmx=-&__utmz=1.1255983648.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)&__utmv=-&__utmk=22470587]]></custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name><![CDATA[testing]]></product_name> <product_price><![CDATA[10.00]]></product_price> <product_quantity><![CDATA[13]]></product_quantity> <product_weight><![CDATA[0.000]]></product_weight> <product_code><![CDATA[]]></product_code> <downloadable_url><![CDATA[]]></downloadable_url> <subscription_frequency><![CDATA[]]></subscription_frequency> <subscription_startdate><![CDATA[0000-00-00]]></subscription_startdate> <shipto><![CDATA[]]></shipto> <category_description><![CDATA[Default for all products]]></category_description> <category_code><![CDATA[DEFAULT]]></category_code> <product_delivery_type><![CDATA[flat_rate]]></product_delivery_type> <transaction_detail_options/> </transaction_detail> </transaction_details> <shipto_addresses/> </transaction> <transaction> <id><![CDATA[3251]]></id> <store_id><![CDATA[9]]></store_id> <transaction_date><![CDATA[2009-10-19 13:29:33]]></transaction_date> <processor_response><![CDATA[Purchase Order]]></processor_response> <customer_id><![CDATA[169]]></customer_id> <is_anonymous><![CDATA[1]]></is_anonymous> <customer_first_name><![CDATA[John]]></customer_first_name> <customer_last_name><![CDATA[Doe, Jr.]]></customer_last_name> <customer_company><![CDATA[]]></customer_company> <customer_address1><![CDATA[555 Testing]]></customer_address1> <customer_address2><![CDATA[Suite 8]]></customer_address2> <customer_city><![CDATA[Happyville]]></customer_city> <customer_state><![CDATA[CA]]></customer_state> <customer_postal_code><![CDATA[92107]]></customer_postal_code> <customer_country><![CDATA[US]]></customer_country> <customer_phone><![CDATA[]]></customer_phone> <customer_email><![CDATA[test1@example.com]]></customer_email> <customer_ip><![CDATA[64.203.53.230]]></customer_ip> <shipping_first_name><![CDATA[]]></shipping_first_name> <shipping_last_name><![CDATA[]]></shipping_last_name> <shipping_company><![CDATA[]]></shipping_company> <shipping_address1><![CDATA[]]></shipping_address1> <shipping_address2><![CDATA[]]></shipping_address2> <shipping_city><![CDATA[]]></shipping_city> <shipping_state><![CDATA[]]></shipping_state> <shipping_postal_code><![CDATA[]]></shipping_postal_code> <shipping_country><![CDATA[]]></shipping_country> <shipping_phone><![CDATA[]]></shipping_phone> <shipto_shipping_service_description><![CDATA[: Customer Pickup]]></shipto_shipping_service_description> <purchase_order><![CDATA[Test PO #]]></purchase_order> <cc_number_masked><![CDATA[]]></cc_number_masked> <cc_type><![CDATA[]]></cc_type> <cc_exp_month><![CDATA[]]></cc_exp_month> <cc_exp_year><![CDATA[]]></cc_exp_year> <product_total><![CDATA[5.88]]></product_total> <tax_total><![CDATA[0]]></tax_total> <shipping_total><![CDATA[2.294]]></shipping_total> <order_total><![CDATA[8.174]]></order_total> <payment_gateway_type><![CDATA[purchase_order]]></payment_gateway_type> <receipt_url><![CDATA[https://example.foxycart.com/receipt?id=bcb9fdb7af94ef95b32de45f167bd89f]]></receipt_url> <next_transaction_date><![CDATA[]]></next_transaction_date> <subscription_end_date><![CDATA[0000-00-00]]></subscription_end_date> <sub_token_url><![CDATA[]]></sub_token_url> <taxes/> <discounts/> <customer_password><![CDATA[d41d8cd98f00b204e9800998ecf8427e]]></customer_password> <custom_fields> <custom_field> <custom_field_name><![CDATA[ga]]></custom_field_name> <custom_field_value><![CDATA[#__utma=1.1484107376.1255983648.1255983648.1255983648.1&__utmb=1.1.10.1255983648&__utmc=1&__utmx=-&__utmz=1.1255983648.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)&__utmv=-&__utmk=22470587]]></custom_field_value> </custom_field> <custom_field> <custom_field_name><![CDATA[example_hidden]]></custom_field_name> <custom_field_value><![CDATA[value_1]]></custom_field_value> </custom_field> <custom_field> <custom_field_name><![CDATA[Hidden_Value]]></custom_field_name> <custom_field_value><![CDATA[My_Name_Is_Jonas]]></custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name><![CDATA[Example Product]]></product_name> <product_price><![CDATA[10.00]]></product_price> <product_quantity><![CDATA[1]]></product_quantity> <product_weight><![CDATA[4.000]]></product_weight> <product_code><![CDATA[abc123zzz]]></product_code> <downloadable_url><![CDATA[]]></downloadable_url> <subscription_frequency><![CDATA[]]></subscription_frequency> <subscription_startdate><![CDATA[0000-00-00]]></subscription_startdate> <shipto><![CDATA[]]></shipto> <category_description><![CDATA[Discount: Price: Percentage]]></category_description> <category_code><![CDATA[discount_price_percentage]]></category_code> <product_delivery_type><![CDATA[shipped]]></product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name><![CDATA[color]]></product_option_name> <product_option_value><![CDATA[red]]></product_option_value> <price_mod><![CDATA[-4.000]]></price_mod> <weight_mod><![CDATA[0.000]]></weight_mod> </transaction_detail_option> <transaction_detail_option> <product_option_name><![CDATA[Price Discount Amount]]></product_option_name> <product_option_value><![CDATA[-2%]]></product_option_value> <price_mod><![CDATA[-0.120]]></price_mod> <weight_mod><![CDATA[0.000]]></weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> <shipto_addresses/> </transaction> </transactions>
</foxydata> </code>
FoxyCart v051 Datafeed
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <foxydata> <transactions> <transaction> <id>2699</id> <store_id>13</store_id> <transaction_date>2009-05-09 19:04:41</transaction_date> <processor_response>Authorize.net Transaction ID:2699</processor_response> <customer_id>116</customer_id> <customer_first_name>John</customer_first_name> <customer_last_name>Doe</customer_last_name> <customer_company>ACME Inc.</customer_company> <customer_address1>555 Mulberry Dr.</customer_address1> <customer_address2>#200</customer_address2> <customer_city>Pleasantville</customer_city> <customer_state>CA</customer_state> <customer_postal_code>90740</customer_postal_code> <customer_country>US</customer_country> <customer_phone>555-444-3333</customer_phone> <customer_email>test1@example.com</customer_email> <customer_ip>71.165.140.208</customer_ip> <shipping_first_name/> <shipping_last_name/> <shipping_company/> <shipping_address1/> <shipping_address2/> <shipping_city/> <shipping_state/> <shipping_postal_code/> <shipping_country>US</shipping_country> <shipping_phone/> <shipto_shipping_service_description/> <purchase_order/> <product_total>15.88</product_total> <tax_total>0.1</tax_total> <shipping_total>193.04</shipping_total> <order_total>209.02</order_total> <payment_gateway_type>authorize</payment_gateway_type> <receipt_url>https://example.foxycart.com/receipt?id=466f78a86b9e031f7ede4fb1600a0605</receipt_url> <next_transaction_date/> <subscription_end_date>2010-01-01</subscription_end_date> <sub_token_url/> <taxes> <tax> <tax_rate>3.0000</tax_rate> <tax_name>California</tax_name> <tax_amount>0</tax_amount> </tax> <tax> <tax_rate>5.0000</tax_rate> <tax_name>US</tax_name> <tax_amount>0</tax_amount> </tax> <tax> <tax_rate>1.0000</tax_rate> <tax_name>Global Tax</tax_name> <tax_amount>0</tax_amount> </tax> <tax> <tax_rate>1.0000</tax_rate> <tax_name>Global Tax</tax_name> <tax_amount>0.1</tax_amount> </tax> </taxes> <discounts/> <customer_password>517b823f9575bbad3268d7d1d6ed951c</customer_password> <custom_fields> <custom_field> <custom_field_name>hash</custom_field_name> <custom_field_value>testing12345</custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name>Example Product</product_name> <product_price>10.00</product_price> <product_quantity>1</product_quantity> <product_weight>4.000</product_weight> <product_code>abc123zzz</product_code> <downloadable_url/> <subscription_frequency/> <subscription_startdate>0000-00-00</subscription_startdate> <shipto>Me</shipto> <category_description>Discount: Price: Percentage</category_description> <category_code>discount_price_percentage</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>-4.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> <transaction_detail_option> <product_option_name>Price Discount Amount</product_option_name> <product_option_value>-2%</product_option_value> <price_mod>-0.120</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name>Example Subscription</product_name> <product_price>10.00</product_price> <product_quantity>1</product_quantity> <product_weight>4.000</product_weight> <product_code>xyz456</product_code> <downloadable_url/> <subscription_frequency>1m</subscription_frequency> <subscription_startdate>2009-12-01</subscription_startdate> <shipto>Me</shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>flat_rate</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>-4.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name>testing aa</product_name> <product_price>10.00</product_price> <product_quantity>1</product_quantity> <product_weight>0.000</product_weight> <product_code>046a</product_code> <downloadable_url>https://example.foxycart.com/path/to/file</downloadable_url> <subscription_frequency/> <subscription_startdate>0000-00-00</subscription_startdate> <shipto>mom</shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>flat_rate</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>0.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> <shipto_addresses> <shipto_address> <address_id>55</address_id> <address_name>Me</address_name> <shipto_first_name>John</shipto_first_name> <shipto_last_name>Doe</shipto_last_name> <shipto_company>ACME Inc.</shipto_company> <shipto_address1>555 Mulberry Dr.</shipto_address1> <shipto_address2>#200</shipto_address2> <shipto_city>Pleasantville</shipto_city> <shipto_state>CA</shipto_state> <shipto_postal_code>90740</shipto_postal_code> <shipto_country>US</shipto_country> <date_created/> <date_modified/> </shipto_address> <shipto_address> <address_id>56</address_id> <address_name>mom</address_name> <shipto_first_name>Madre</shipto_first_name> <shipto_last_name>Doe</shipto_last_name> <shipto_company/> <shipto_address1>1234 Calle de Carretas</shipto_address1> <shipto_address2/> <shipto_city>Madrid</shipto_city> <shipto_state>Madrid</shipto_state> <shipto_postal_code>28004</shipto_postal_code> <shipto_country>ES</shipto_country> <date_created/> <date_modified/> </shipto_address> </shipto_addresses> </transaction> </transactions> </foxydata>
FoxyCart versions prior to v051
Versions of FoxyCart prior to v051 the datafeed version was independent of the store version. Here are the datafeed versions available with v050 and prior.
Datafeed v0.8
- NEW FIELDS: store_id
- NEW FIELDS: processor_response
- NEW FIELDS: taxes
- tax
- tax_name
- tax_amount
- tax_rate
- NEW FIELDS: shipto_taxes
- shipto_tax
- shipto_tax_name
- shipto_tax_amount
- shipto_tax_rate
- undocumented fields in the sample XML?
- transaction/payment_gateway_type
- transaction/receipt_url
- transaction/transaction_details/transaction_detail/sub_token_url
<?xml version='1.0' encoding='UTF-8' standalone='yes'?> <foxydata> <datafeed_version>XML FoxyCart Version 0.8</datafeed_version> <transactions> <transaction> <id>2429</id> <store_id>13</store_id> <transaction_date>2009-03-06 11:16:36</transaction_date> <processor_response>Authorize.net Transaction ID:2429</processor_response> <customer_id>62</customer_id> <customer_first_name>John</customer_first_name> <customer_last_name>Doe</customer_last_name> <customer_company></customer_company> <customer_address1>555 Mulberry Dr.</customer_address1> <customer_address2></customer_address2> <customer_city>Happyville</customer_city> <customer_state>CA</customer_state> <customer_postal_code>90740</customer_postal_code> <customer_country>US</customer_country> <customer_phone></customer_phone> <customer_email>example@example.com</customer_email> <customer_ip>55.55.22.190</customer_ip> <shipping_first_name></shipping_first_name> <shipping_last_name></shipping_last_name> <shipping_company></shipping_company> <shipping_address1></shipping_address1> <shipping_address2></shipping_address2> <shipping_city></shipping_city> <shipping_state></shipping_state> <shipping_postal_code></shipping_postal_code> <shipping_country></shipping_country> <shipping_phone></shipping_phone> <shipping_service_description>UPS: 2nd Day Air</shipping_service_description> <purchase_order></purchase_order> <product_total>21.19</product_total> <tax_total>0.00</tax_total> <shipping_total>66.06</shipping_total> <order_total>71.95</order_total> <payment_gateway_type>authorize</payment_gateway_type> <receipt_url>https://example.foxycart.com/receipt?id=40880711ff2c02bc689b54f9b0159d1d</receipt_url> <taxes> <tax> <tax_rate>5.0000</tax_rate> <tax_name>US</tax_name> <tax_amount>0.0000</tax_amount> </tax> <tax> <tax_rate>3.0000</tax_rate> <tax_name>California</tax_name> <tax_amount>0.0000</tax_amount> </tax> </taxes> <discounts> <discount> <code>test1
<name>$5 off all orders over $5!</name> <amount>-5.00</amount> <display>-5.00</display> <coupon_discount_type>price_amount</coupon_discount_type> <coupon_discount_details>5-5</coupon_discount_details> </discount> <discount> <code>test2</code> <name>Testing Again</name> <amount>-1.00</amount> <display>-1.00</display> <coupon_discount_type>quantity_amount</coupon_discount_type> <coupon_discount_details>3-1</coupon_discount_details> </discount> </discounts> <customer_password>912ec803b2ce49e4a541068d495ab570</customer_password> <custom_fields> <custom_field> <custom_field_name>example_hidden</custom_field_name> <custom_field_value>value_1</custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name>Example Product</product_name> <product_price>10.00</product_price> <product_quantity>3</product_quantity> <product_weight>4.000</product_weight> <product_code>abc123zzz</product_code> <subscription_frequency></subscription_frequency> <subscription_startdate>0000-00-00</subscription_startdate> <next_transaction_date>0000-00-00</next_transaction_date> <shipto></shipto> <category_description>Discount: Price: Percentage</category_description> <category_code>discount_price_percentage</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>-4.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> <transaction_detail_option> <product_option_name>Price Discount Amount</product_option_name> <product_option_value>-5%</product_option_value> <price_mod>-0.267</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> <transaction_detail_option> <product_option_name>Quantity Discount</product_option_name> <product_option_value>-$0.67</product_option_value> <price_mod>-0.667</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name>Example Subscription</product_name> <product_price>10.00</product_price> <product_quantity>1</product_quantity> <product_weight>4.000</product_weight> <product_code>xyz456</product_code> <subscription_frequency>1m</subscription_frequency> <subscription_startdate>2009-12-01</subscription_startdate> <next_transaction_date>2009-12-01</next_transaction_date> <sub_token_url>https://example.foxycart.com/cart?sub_token=fb5dfbbb51c81bdc60b033665515884c</sub_token_url> <shipto></shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>-4.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> <shipto_addresses> </shipto_addresses> </transaction>
</transactions> </foxydata> </code>
Datafeed v0.7
- NEW FIELDS: discounts
- discount
- code
- name
- amount
- display
- coupon_discount_type
- coupon_discount_details
- NEW FIELDS: transaction
- customer_company
- shipping_company
- NEW FIELDS: shipto_address
- shipto_company
<?xml version='1.0' standalone='yes'?> <foxydata> <datafeed_version>XML FoxyCart Version 0.7</datafeed_version> <transaction> <id>2279</id> <transaction_date>2009-02-12 12:28:50</transaction_date> <customer_id>51</customer_id> <customer_first_name>John</customer_first_name> <customer_last_name>Doe</customer_last_name> <customer_company></customer_company> <customer_address1>555 Mulberry Ln</customer_address1> <customer_address2></customer_address2> <customer_city>Hapyville</customer_city> <customer_state>CA</customer_state> <customer_postal_code>55555</customer_postal_code> <customer_country>US</customer_country> <customer_phone> </customer_phone> <customer_email>example@example.tld</customer_email> <customer_ip>55.44.33.222</customer_ip> <shipping_first_name></shipping_first_name> <shipping_last_name></shipping_last_name> <shipping_company></shipping_company> <shipping_address1></shipping_address1> <shipping_address2></shipping_address2> <shipping_city></shipping_city> <shipping_state></shipping_state> <shipping_postal_code></shipping_postal_code> <shipping_country></shipping_country> <shipping_phone></shipping_phone> <shipping_service_description></shipping_service_description> <purchase_order></purchase_order> <product_total>115.00</product_total> <tax_total>2.05</tax_total> <shipping_total>57.75</shipping_total> <order_total>156.30</order_total> <discounts> <discount> <code>asdf
<name>$5 off all orders over $5!</name> <amount>-5.00</amount> <display>-5.00</display> <coupon_discount_type>price_amount</coupon_discount_type> <coupon_discount_details>5-5</coupon_discount_details> </discount> </discounts> <customer_password>fd2cc6c54239c40495a0d3a93b6380eb</customer_password> <custom_fields> </custom_fields> <transaction_details> <transaction_detail> <product_name>testing 03</product_name> <product_price>10.00</product_price> <product_quantity>1</product_quantity> <product_weight>1.000</product_weight> <product_code>003a</product_code> <subscription_frequency></subscription_frequency> <subscription_startdate>0000-00-00</subscription_startdate> <next_transaction_date>0000-00-00</next_transaction_date> <shipto>Me</shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>0.000</price_mod> <weight_mod>4.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name>testing 38</product_name> <product_price>10.00</product_price> <product_quantity>1</product_quantity> <product_weight>1.000</product_weight> <product_code>028a</product_code> <subscription_frequency>1m</subscription_frequency> <subscription_startdate>2012-03-01</subscription_startdate> <next_transaction_date>2012-03-01</next_transaction_date> <shipto>Me</shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>0.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> <transaction_detail> <product_name>lamerss 17</product_name> <product_price>10.00</product_price> <product_quantity>10</product_quantity> <product_weight>0.500</product_weight> <product_code>317a</product_code> <subscription_frequency></subscription_frequency> <subscription_startdate>0000-00-00</subscription_startdate> <next_transaction_date>0000-00-00</next_transaction_date> <shipto>Me</shipto> <category_description>Discount: Qty: Percentage</category_description> <category_code>discount_qty_percentage</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>red</product_option_value> <price_mod>0.000</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> <transaction_detail_option> <product_option_name>Quantity Discount</product_option_name> <product_option_value>-5%</product_option_value> <price_mod>-0.500</price_mod> <weight_mod>0.000</weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> <shipto_addresses> <shipto_address> <address_name>Me</address_name> <shipto_first_name>John</shipto_first_name> <shipto_last_name>Doe</shipto_last_name> <shipto_company></shipto_company> <shipto_address1>555 Mullberry Ln</shipto_address1> <shipto_address2></shipto_address2> <shipto_city>Happyville</shipto_city> <shipto_state>CA</shipto_state> <shipto_postal_code>55555</shipto_postal_code> <shipto_country>US</shipto_country> <shipto_shipping_service_description>UPS: 2nd Day Air</shipto_shipping_service_description> <shipto_subtotal>115.00</shipto_subtotal> <shipto_tax_total>1.44</shipto_tax_total> <shipto_shipping_total>57.75</shipto_shipping_total> <shipto_total>160.69</shipto_total> <shipto_custom_fields> </shipto_custom_fields> </shipto_address> </shipto_addresses> </transaction>
</foxydata> </code>
Datafeed v0.6
v0.6 added the hash of the customer's password, sent as an MD5 hash.
<?xml version='1.0' standalone='yes'?> <foxydata> <datafeed_version>XML FoxyCart Version 0.6</datafeed_version> <transactions> <transaction> <id>616</id> <transaction_date>2007-05-04 20:53:57</transaction_date> <customer_id>122</customer_id> <customer_first_name>John</customer_first_name> <customer_last_name>Doe</customer_last_name> <customer_address1>12345 Any Street</customer_address1> <customer_address2></customer_address2> <customer_city>Any City</customer_city> <customer_state>TN</customer_state> <customer_postal_code>37013</customer_postal_code> <customer_country>US</customer_country> <customer_phone>(123) 456-7890</customer_phone> <customer_email>someone@somewhere.com</customer_email> <customer_ip>71.228.237.177</customer_ip> <shipping_first_name>John</shipping_first_name> <shipping_last_name>Doe</shipping_last_name> <shipping_address1>1234 Any Street</shipping_address1> <shipping_address2></shipping_address2> <shipping_city>Some City</shipping_city> <shipping_state>TN</shipping_state> <shipping_postal_code>37013</shipping_postal_code> <shipping_country>US</shipping_country> <shipping_phone></shipping_phone> <shipping_service_description>UPS: Ground</shipping_service_description> <purchase_order></purchase_order> <product_total>20.00</product_total> <tax_total>0.00</tax_total> <shipping_total>4.38</shipping_total> <order_total>24.38</order_total> <customer_password>1aab23051b24582c5dc8e23fc595d505</customer_password> <custom_fields> <custom_field> <custom_field_name>My_Cool_Text</custom_field_name> <custom_field_value>Value123</custom_field_value> </custom_field> <custom_field> <custom_field_name>Another_Custom_Field</custom_field_name> <custom_field_value>10</custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name>foo</product_name> <product_price>20.00</product_price> <product_quantity>1</product_quantity> <product_weight>0.10</product_weight> <product_code></product_code> <subscription_frequency>1m</subscription_frequency> <subscription_startdate>2007-07-07</subscription_startdate> <next_transaction_date>2007-08-07</next_transaction_date> <shipto>John Doe</shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>blue</product_option_value> <price_mod></price_mod> <weight_mod></weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> <shipto_addresses> <shipto_address> <address_name>John Doe</address_name> <shipto_first_name>John</shipto_first_name> <shipto_last_name>Doe</shipto_last_name> <shipto_address1>2345 Some Address</shipto_address1> <shipto_address2></shipto_address2> <shipto_city>Some City</shipto_city> <shipto_state>TN</shipto_state> <shipto_postal_code>37013</shipto_postal_code> <shipto_country>US</shipto_country> <shipto_shipping_service_description>DHL: Next Afternoon</shipto_shipping_service_description> <shipto_subtotal>52.15</shipto_subtotal> <shipto_tax_total>6.31</shipto_tax_total> <shipto_shipping_total>15.76</shipto_shipping_total> <shipto_total>74.22</shipto_total> <shipto_custom_fields> <shipto_custom_field> <shipto_custom_field_name>My_Custom_Info</shipto_custom_field_name> <shipto_custom_field_value>john's stuff</shipto_custom_field_value> </shipto_custom_field> <shipto_custom_field> <shipto_custom_field_name>More_Custom_Info</shipto_custom_field_name> <shipto_custom_field_value>more of john's stuff</shipto_custom_field_value> </shipto_custom_field> </shipto_custom_fields> </shipto_address> </shipto_addresses> </transaction> </transactions> </foxydata>
Datafeed v0.5
<?xml version='1.0' standalone='yes'?> <foxydata> <datafeed_version>XML FoxyCart Version 0.5</datafeed_version> <transactions> <transaction> <id>616</id> <transaction_date>2007-05-04 20:53:57</transaction_date> <customer_id>122</customer_id> <customer_first_name>John</customer_first_name> <customer_last_name>Doe</customer_last_name> <customer_address1>12345 Any Street</customer_address1> <customer_address2></customer_address2> <customer_city>Any City</customer_city> <customer_state>TN</customer_state> <customer_postal_code>37013</customer_postal_code> <customer_country>US</customer_country> <customer_phone>(123) 456-7890</customer_phone> <customer_email>someone@somewhere.com</customer_email> <customer_ip>71.228.237.177</customer_ip> <shipping_first_name>John</shipping_first_name> <shipping_last_name>Doe</shipping_last_name> <shipping_address1>1234 Any Street</shipping_address1> <shipping_address2></shipping_address2> <shipping_city>Some City</shipping_city> <shipping_state>TN</shipping_state> <shipping_postal_code>37013</shipping_postal_code> <shipping_country>US</shipping_country> <shipping_phone></shipping_phone> <shipping_service_description>UPS: Ground</shipping_service_description> <purchase_order></purchase_order> <product_total>20.00</product_total> <tax_total>0.00</tax_total> <shipping_total>4.38</shipping_total> <order_total>24.38</order_total> <custom_fields> <custom_field> <custom_field_name>My_Cool_Text</custom_field_name> <custom_field_value>Value123</custom_field_value> </custom_field> <custom_field> <custom_field_name>Another_Custom_Field</custom_field_name> <custom_field_value>10</custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name>foo</product_name> <product_price>20.00</product_price> <product_quantity>1</product_quantity> <product_weight>0.10</product_weight> <product_code></product_code> <subscription_frequency>1m</subscription_frequency> <subscription_startdate>2007-07-07</subscription_startdate> <next_transaction_date>2007-08-07</next_transaction_date> <shipto>John Doe</shipto> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>blue</product_option_value> <price_mod></price_mod> <weight_mod></weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> <shipto_addresses> <shipto_address> <address_name>John Doe</address_name> <shipto_first_name>John</shipto_first_name> <shipto_last_name>Doe</shipto_last_name> <shipto_address1>2345 Some Address</shipto_address1> <shipto_address2></shipto_address2> <shipto_city>Some City</shipto_city> <shipto_state>TN</shipto_state> <shipto_postal_code>37013</shipto_postal_code> <shipto_country>US</shipto_country> <shipto_shipping_service_description>DHL: Next Afternoon</shipto_shipping_service_description> <shipto_subtotal>52.15</shipto_subtotal> <shipto_tax_total>6.31</shipto_tax_total> <shipto_shipping_total>15.76</shipto_shipping_total> <shipto_total>74.22</shipto_total> <shipto_custom_fields> <shipto_custom_field> <shipto_custom_field_name>My_Custom_Info</shipto_custom_field_name> <shipto_custom_field_value>john's stuff</shipto_custom_field_value> </shipto_custom_field> <shipto_custom_field> <shipto_custom_field_name>More_Custom_Info</shipto_custom_field_name> <shipto_custom_field_value>more of john's stuff</shipto_custom_field_value> </shipto_custom_field> </shipto_custom_fields> </shipto_address> </shipto_addresses> </transaction> </transactions> </foxydata>
Datafeed v0.4
<?xml version='1.0' standalone='yes'?> <foxydata> <datafeed_version>XML FoxyCart Version 0.4</datafeed_version> <transactions> <transaction> <id>616</id> <transaction_date>2007-05-04 20:53:57</transaction_date> <customer_first_name>John</customer_first_name> <customer_last_name>Doe</customer_last_name> <customer_address1>12345 Any Street</customer_address1> <customer_address2></customer_address2> <customer_city>Any City</customer_city> <customer_state>TN</customer_state> <customer_postal_code>37013</customer_postal_code> <customer_country>US</customer_country> <customer_phone>(123) 456-7890</customer_phone> <customer_email>someone@somewhere.com</customer_email> <customer_ip>71.228.237.177</customer_ip> <shipping_first_name>John</shipping_first_name> <shipping_last_name>Doe</shipping_last_name> <shipping_address1>1234 Any Street</shipping_address1> <shipping_address2></shipping_address2> <shipping_city>Some City</shipping_city> <shipping_state>TN</shipping_state> <shipping_postal_code>37013</shipping_postal_code> <shipping_country>US</shipping_country> <shipping_phone></shipping_phone> <product_total>20.00</product_total> <tax_total>0.00</tax_total> <shipping_total>4.38</shipping_total> <order_total>24.38</order_total> <purchase_order></purchase_order> <customer_id>122</customer_id> <custom_fields> <custom_field> <custom_field_name>My_Cool_Text</custom_field_name> <custom_field_value>Value123</custom_field_value> </custom_field> <custom_field> <custom_field_name>Another_Custom_Field</custom_field_name> <custom_field_value>10</custom_field_value> </custom_field> </custom_fields> <transaction_details> <transaction_detail> <product_name>foo</product_name> <product_price>20.00</product_price> <product_quantity>1</product_quantity> <product_weight>0.10</product_weight> <product_code></product_code> <subscription_frequency>1m</subscription_frequency> <subscription_startdate>2007-07-07</subscription_startdate> <next_transaction_date>2007-08-07</next_transaction_date> <category_description>Default for all products</category_description> <category_code>DEFAULT</category_code> <product_delivery_type>shipped</product_delivery_type> <transaction_detail_options> <transaction_detail_option> <product_option_name>color</product_option_name> <product_option_value>blue</product_option_value> <price_mod></price_mod> <weight_mod></weight_mod> </transaction_detail_option> </transaction_detail_options> </transaction_detail> </transaction_details> </transaction> </transactions> </foxydata>