Last updated: March 01, 2010
Give Feedback
ShopSite Shopping Cart Software
Screen: ShopSite > Orders > Download Orders
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.
<?xml version="1.0"?>
<!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, Products)>
<!ELEMENT Products (Product)+>
<!ELEMENT Product (ProdType, Name, SKU, Taxable, Quantity, ItemPrice, Total, Weight?, Dimension?,
OrderOptions*, CustomerText, QBImport*, DobaItemID?, GiftCertificatePurchase?)>
<!ELEMENT ProdType (#PCDATA)>
<!ELEMENT SKU (#PCDATA)>
<!ELEMENT Quantity (#PCDATA)>
<!ELEMENT ItemPrice (#PCDATA)>
<!ELEMENT Taxable (#PCDATA)>
<!ELEMENT Weight (#PCDATA)>
<!ELEMENT DobaItemID (#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 (ItemType?, ItemName?, ItemDesc?, SalesAccount?)>
<!ELEMENT ItemType (#PCDATA)>
<!ELEMENT ItemName (#PCDATA)>
<!ELEMENT ItemDesc (#PCDATA)>
<!ELEMENT SalesAccount (#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 | PayPalExpress | WorldPay | Google | NetBanx | Solo | Switch |
Delta | UKE | JCB)?)>
<!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 PayPalExpress (OrderProcessingInfo?)>
<!ELEMENT WorldPay (OrderProcessingInfo?)>
<!ELEMENT Google (OrderProcessingInfo?)>
<!ELEMENT NetBanx (OrderProcessingInfo?)>
<!ELEMENT Solo (OrderProcessingInfo?)>
<!ELEMENT Switch (OrderProcessingInfo?)>
<!ELEMENT Delta (OrderProcessingInfo?)>
<!ELEMENT UKE (OrderProcessingInfo?)>
<!ELEMENT JCB (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?, BuySafeAmount?,
BuySafeText?, BuySafeCartID?, DobaShipping?, DobaOrderInfo?,
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 BuySafeAmount (#PCDATA)>
<!ELEMENT BuySafeText (#PCDATA)>
<!ELEMENT BuySafeCartID (#PCDATA)>
<!ELEMENT DobaShipping (#PCDATA)>
<!ELEMENT DobaOrderInfo (#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: March 01, 2010 Give Feedback |
ShopSite Shopping Cart Software |