Orders Download XML DTD

Screen: ShopSite > Orders > Download Orders
Orders Download XML DTD

When you select to download orders in XML format, ShopSite creates a text file that contains your store’s order information with XML markup, based on the DTD below. You should be able to import this file into any XML-aware application. On the Database Download screen, you should set the file extension to .xml.
Document Type Definition for ShopSite Orders

<?xml version="1.0"?>
<!DOCTYPE ShopSiteOrders [
<!ELEMENT ShopSiteOrders (Response, Order*)>

<!ELEMENT Response (ResponseCode, ResponseDescription)>
<!ELEMENT ResponseCode (#PCDATA)>
<!ELEMENT ResponseDescription (#PCDATA)>
    
<!ELEMENT Order (OrderNumber, ShopSiteTransactionID, OrderDate, Billing, Shipping, 
                 Payment, Totals, Coupon*, GiftCertificate*, Other)> 
<!ELEMENT OrderNumber (#PCDATA)>
<!ELEMENT OrderDate   (#PCDATA)>
<!ELEMENT ShopSiteTransactionID (#PCDATA)>

<!ELEMENT Billing (FullName, NameParts, Email, Company, Phone, Address)>
<!ELEMENT Email  (#PCDATA)>

<!ELEMENT Shipping   (FullName, NameParts, Company, Phone, Address, GiftCertificate*, Products)>
<!ELEMENT Products   (Product)+>
<!ELEMENT Product    (ProdType, Name, SKU, Taxable, Quantity, ItemPrice, Total, Weight?, Dimension?,
                       OrderOptions*, CustomerText, QBImport*, GiftCertificatePurchase?)> 
<!ELEMENT ProdType   (#PCDATA)>
<!ELEMENT SKU        (#PCDATA)>
<!ELEMENT Quantity   (#PCDATA)>
<!ELEMENT ItemPrice  (#PCDATA)>
<!ELEMENT Taxable    (#PCDATA)>
<!ELEMENT Weight     (#PCDATA)>

<!ELEMENT Dimension  (Length?, Width?, Height?)>
<!ELEMENT Length     (#PCDATA)>
<!ELEMENT Width      (#PCDATA)>
<!ELEMENT Height     (#PCDATA)>

<!ELEMENT OrderOptions  (OrderOption)*>
<!ELEMENT OrderOption   (SelectedOption, OptionPrice)>
<!ELEMENT SelectedOption  (#PCDATA)>
<!ELEMENT OptionPrice     (#PCDATA)>

<!ELEMENT CustomerText  (#PCDATA)> 
<!ELEMENT QBImport      (#PCDATA)>

<!ELEMENT GiftCertificatePurchase  (EmailTo*, From, To, Message)>
<!ELEMENT EmailTo    (Email)+>
<!ELEMENT From       (#PCDATA)>
<!ELEMENT To         (#PCDATA)>
<!ELEMENT Message    (#PCDATA)>

<!ELEMENT Payment  (CreditCard | COD | Check | eCheck | PurchaseOrder | Generic1 | Generic2 |
                     PayPal | WorldPay)>
<!ELEMENT CreditCard  (Issuer?, Number?, VerificationValue?, FullName?, Company?, ExpirationDate?,
                       PaymentGateway?, PaymentStatus?, OrderProcessingInfo?)>
<!ELEMENT Issuer  (#PCDATA)>
<!ELEMENT Number  (#PCDATA)>
<!ELEMENT VerificationValue   (#PCDATA)>
<!ELEMENT ExpirationDate      (#PCDATA)>
<!ELEMENT PaymentGateway      (#PCDATA)>
<!ELEMENT PaymentStatus       (#PCDATA)>
<!ELEMENT OrderProcessingInfo (#PCDATA)>

<!ELEMENT COD EMPTY>

<!ELEMENT Check (RoutingNumber, AccountNumber)>

<!ELEMENT eCheck  (RoutingNumber, AccountNumber, BankName, NameOnAccount)>
<!ELEMENT BankName      (#PCDATA)>
<!ELEMENT NameOnAccount (#PCDATA)>

<!ELEMENT PurchaseOrder (PurchaseNumber)>
<!ELEMENT PurchaseNumber  (#PCDATA)>

<!ELEMENT Generic1  (Field1, Field2, Field3, Field4)>
<!ELEMENT Generic2  (Field1, Field2, Field3, Field4)> 

<!ELEMENT PayPal    (OrderProcessingInfo?)>
<!ELEMENT WorldPay  (OrderProcessingInfo?)>

<!ELEMENT Totals  (ProductTotal, Discount, Subtotal, Tax, GrandTotal, ShippingTotal, Surcharge*)>
<!ELEMENT ProductTotal  (#PCDATA)>

<!ELEMENT Discount  (Type?, Percent?, Amount?, ApplyDiscount?)>
<!ELEMENT Type          (#PCDATA)>
<!ELEMENT Percent       (#PCDATA)>
<!ELEMENT Amount        (#PCDATA)>
<!ELEMENT ApplyDiscount (#PCDATA)>

<!ELEMENT Subtotal      (#PCDATA)>

<!ELEMENT Tax   (TaxName?, TaxRate?, TaxAmount?, TaxShipping?)>
<!ELEMENT TaxName       (#PCDATA)>
<!ELEMENT TaxRate       (#PCDATA)>
<!ELEMENT TaxAmount     (#PCDATA)>
<!ELEMENT TaxShipping   (#PCDATA)>

<!ELEMENT GrandTotal    (#PCDATA)>
<!ELEMENT Surcharge     (Total?, Description?)>
<!ELEMENT ShippingTotal (Total?, Description?)>

<!ELEMENT Coupon  (Name?, Status?, Total?, ApplyCoupon?)>
<!ELEMENT Status      (#PCDATA)>
<!ELEMENT ApplyCoupon (#PCDATA)>

<!ELEMENT GiftCertificate (ID?, AmountUsed?, AmountRemaining?)>
<!ELEMENT ID                (#PCDATA)>
<!ELEMENT AmountUsed        (#PCDATA)>
<!ELEMENT AmountRemaining   (#PCDATA)>

<!ELEMENT Other (CustomerID?, Associate?, OrderInstructions?, Comments?, OrderUTC?,
                 IpHostname?, TotalOrderWeight?, EmailList?, CustomCheckoutField*)>
<!ELEMENT CustomerID					    (#PCDATA)>
<!ELEMENT Associate               (#PCDATA)>
<!ELEMENT OrderInstructions       (#PCDATA)>
<!ELEMENT Comments                (#PCDATA)>
<!ELEMENT OrderUTC                (#PCDATA)>
<!ELEMENT IpHostname              (#PCDATA)>
<!ELEMENT TotalOrderWeight        (#PCDATA)>
<!ELEMENT EmailList               (#PCDATA)>

<!ELEMENT CustomCheckoutField (FieldName?, FieldValue?)>
<!ELEMENT FieldName   (#PCDATA)>
<!ELEMENT FieldValue  (#PCDATA)>

<!ELEMENT RoutingNumber (#PCDATA)>
<!ELEMENT AccountNumber (#PCDATA)>

<!ELEMENT Name          (#PCDATA)>
<!ELEMENT Description   (#PCDATA)>
<!ELEMENT Total         (#PCDATA)>

<!ELEMENT FullName  (#PCDATA)>

<!ELEMENT NameParts (Title, FirstName, MiddleName, LastName, Suffix)>
<!ELEMENT Title       (#PCDATA)>
<!ELEMENT FirstName   (#PCDATA)>
<!ELEMENT MiddleName  (#PCDATA)>
<!ELEMENT LastName    (#PCDATA)>
<!ELEMENT Suffix      (#PCDATA)>

<!ELEMENT Company   (#PCDATA)>
<!ELEMENT Phone     (#PCDATA)>

<!ELEMENT Address (Street1, Street2, City, State, Code, Country)>
<!ELEMENT Street1   (#PCDATA)>
<!ELEMENT Street2   (#PCDATA)>
<!ELEMENT City      (#PCDATA)>
<!ELEMENT State     (#PCDATA)>
<!ELEMENT Code      (#PCDATA)>
<!ELEMENT Country   (#PCDATA)>

<!ELEMENT Field1    (#PCDATA)>
<!ELEMENT Field2    (#PCDATA)>
<!ELEMENT Field3    (#PCDATA)>
<!ELEMENT Field4    (#PCDATA)>
]>
ShopSite Help and Resource Center
Last updated: January 23, 2007
Give Feedback