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.).
foxy in order to indicate success. If anything other than foxy is returned by your datafeed processing script, FoxyCart will assume that your script errored, and you will be alerted.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).
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.
POST name of FoxyData. This is different than the subscription XML datafeed, which has a POST name of FoxySubscriptionData.For compatibility, FoxyCart uses ISO country codes in our XML:
CDATA tags added to most elements.is_test used to indicate if the transaction is a test transaction (or a live one) based on the store's payment processor settings.is_anonymouscc_number_maskedcc_typecc_exp_monthcc_exp_yearprocessor_response_details. Only used for Orbital and Cybersource. Child nodes vary per gateway.shipto_shipping_service_description was added back to the shipto_address node.sub_token_url is populated on the initial transaction's datafeed. At this point, it will populate with the sub_token of the first subscription in the transaction. If you have multiple distinct subscriptions in one transaction you may not want to rely on the sub_token sent in the initial datafeed.processor_response now 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>
<?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>
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.
<?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>
<?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>
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>
<?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>
<?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>