XML Export Format

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

Locating QuickBooks Accounting Code Related Fields

Parent Element

Element

Description

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.

XSD Download

.