XML Export Format
XML Export Format
This document provides more details about the XML export format for orders generated by UltraCart.
Schema Visualization
Below is a picture of the entire schema. Elements shown in dashed lines are optional and may not exist in your XML.Â
The XSD schema is attached at the bottom of this document and a live copy is here: Â
http://secure.ultracart.com/xml/ultracart.xsd
Understanding the Nested Structures
The Order XML is a set of nested data structures represented in XML fashion. At a high level you have:
- Order
- Item
- Option
- Lot
- Coupon
- Customer Profile
- Transaction Details
- Transaction Detail
- Item
Locating QuickBooks Accounting Code Related Fields
Parent Element | Element | Description |
---|---|---|
order | gift_charge_accounting_code | QuickBooks code associated with the gift charge fee. |
order | gift_wrap_accounting_code | QuickBooks code associated with the gift wrap fee. |
order | surcharge_accounting_code | QuickBooks code associated with the surcharge fee. |
order | shipping_method_accounting_code | QuickBooks code associated with the shipping method. |
order | payment_method_accounting_code | QuickBooks code associated with the payment method. |
order | payment_method_deposit_to_account | QuickBooks deposit to account associated with the payment method. |
order | tax_country_accounting_code | QuickBooks code associated with the country tax (deepest level code used by UltraBooks) |
order | tax_state_accounting_code | QuickBooks code associated with the state tax (deepest level code used by UltraBooks) |
order | tax_county_accounting_code | QuickBooks code associated with the county tax (deepest level code used by UltraBooks) |
order | tax_city_accounting_code | QuickBooks code associated with the city tax (deepest level code used by UltraBooks) |
order | tax_postal_code_accounting_code | QuickBooks code associated with the postal code tax (deepest level code used by UltraBooks) |
item | accounting_code | QuickBooks code associated with the item |
coupon | coupon_accounting_code | QuickBooks code associated with the coupon. |
customer_profile | qb_code | QuickBooks customer name to import these orders for the customer profile. |
customer_profile | qb_class | QuickBooks customer class field for the customer profile used on the order. |