February 13, 2004
Give Feedback
© 2007, ShopSite, Inc.
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"?>
<!DOCTYPE ShopSiteOrders [
<!ELEMENT ShopSiteOrders (Response, Order*)>
<!ELEMENT Response (ResponseCode, ResponseDescription)>
<!ELEMENT ResponseCode (#PCDATA)>
<!-- 1=success, 2=success but no order, 3=failure -->
<!ELEMENT ResponseDescription (#PCDATA)>
<!-- "success" if ResponseCode=1 or 2, otherwise error string -->
<!ELEMENT Order (OrderNumber, OrderDate, Billing, Shipping, Payment, Totals, Coupon*, Other)>
<!ELEMENT OrderNumber (#PCDATA)>
<!ELEMENT OrderDate (#PCDATA)>
<!-- YYYY-MM-DD HH:MM:SS -->
<!ELEMENT Billing (FullName, NameParts, Email, Company, Phone, Address)>
<!ELEMENT Email (#PCDATA)>
<!ELEMENT Shipping (FullName, NameParts, Company, Phone, Address, Products)>
<!-- If customer did not select separate shipping address -->
<!-- shipping values are copied from billing fields -->
<!ELEMENT Products (Product+)>
<!ELEMENT Product (ProdType, Name, SKU, Taxable, Quantity, ItemPrice, Total, Weight?, Dimensions?, OrderOption*, CustomerText, QBImport)>
<!ELEMENT ProdType (#PCDATA)>
<!-- "Tangible" or "Download" -->
<!ELEMENT Name (#PCDATA)>
<!ELEMENT SKU (#PCDATA)>
<!ELEMENT Taxable (#PCDATA)>
<!-- "Yes" if checked, otherwise "No" -->
<!ELEMENT Quantity (#PCDATA)>
<!ELEMENT ItemPrice (#PCDATA)>
<!-- Price per unit -->
<!ELEMENT Total (#PCDATA)>
<!-- ItemPrice * Quantity -->
<!ELEMENT Weight (#PCDATA)>
<!ELEMENT Dimensions (Length, Width, Height)>
<!ELEMENT Length (#PCDATA)>
<!ELEMENT Width (#PCDATA)>
<!ELEMENT Height (#PCDATA)>
<!ELEMENT OrderOption (SelectedOption, OptionPrice)>
<!ELEMENT SelectedOption (#PCDATA)>
<!ELEMENT OptionPrice (#PCDATA)>
<!ELEMENT CustomerText (#PCDATA)>
<!ELEMENT QBImport (#PCDATA)>
<!ELEMENT Payment (CreditCard | COD | Check | PurchaseOrder | Generic1 | Generic2 | PayPal | eCheck)>
<!ELEMENT CreditCard (Issuer, Number, VerificationValue, FullName, Company?, ExpirationDate, OrderProcessingInfo?)>
<!-- If not secure connection, or with no pay paramenter, -->
<!-- only Issuer tag will be included in output -->
<!ELEMENT Issuer (#PCDATA)>
<!-- "Visa" "MasterCard" "Discover" "American Express" -->
<!-- "Surefire Pay" "Diner’s Club/Carte Blanche" -->
<!ELEMENT Number (#PCDATA)>
<!ELEMENT VerificationValue (#PCDATA)>
<!ELEMENT Company (#PCDATA)>
<!ELEMENT ExpirationDate (#PCDATA)>
<!ELEMENT OrderProcessingInfo (#PCDATA)>
<!ELEMENT COD EMPTY>
<!ELEMENT Check (RoutingNumber, AccountNumber)>
<!-- If not secure connection, or with no pay paramenter, -->
<!-- only Check tag will be included in output -->
<!ELEMENT PurchaseOrder (PurchaseNumber)>
<!-- If not secure connection, or with no pay paramenter, -->
<!-- only PurchaseOrder tag will be included in output -->
<!ELEMENT PurchaseNumber (#PCDATA)>
<!ELEMENT Generic1 (field1, field2, field3, field4)>
<!-- If not secure connection, or with no pay paramenter, -->
<!-- only Generic1 tag will be included in output -->
<!ELEMENT Generic2 (field1, field2, field3, field4)>
<!-- If not secure connection, or with no pay paramenter, -->
<!-- only Generic2 tag will be included in output -->
<!ELEMENT PayPal EMPTY>
<!ELEMENT eCheck (RoutingNumber, AccountNumber, BankName, NameOnAccount)>
<!-- If not secure connection, or with no pay paramenter, -->
<!-- only eCheck tag will be included in output -->
<!ELEMENT BankName (#PCDATA)>
<!ELEMENT NameOnAccount (#PCDATA)>
<!ELEMENT Totals (ProductTotal, Discount, Subtotal, Tax, GrandTotal, ShippingTotal, Surcharge*)>
<!ELEMENT ProductTotal (#PCDATA)>
<!ELEMENT Discount (Type, Percent, Amount, ApplyDiscount)>
<!ELEMENT Type (#PCDATA)>
<!-- "Flat" or "Percent" -->
<!ELEMENT Percent (#PCDATA)>
<!-- If Type=Percent -->
<!ELEMENT Amount (#PCDATA)>
<!ELEMENT ApplyDiscount (#PCDATA)>
<!-- "Pre" indicates discount is applied before tax; no other values supported -->
<!ELEMENT Subtotal (#PCDATA)>
<!ELEMENT Tax (TaxName, TaxRate, TaxAmount, TaxShipping)>
<!ELEMENT TaxName (#PCDATA)>
<!ELEMENT TaxRate (#PCDATA)>
<!-- A percentage -->
<!ELEMENT TaxAmount (#PCDATA)>
<!ELEMENT TaxShipping (#PCDATA)>
<!-- "Yes" or "No" -->
<!ELEMENT GrandTotal (#PCDATA)>
<!ELEMENT ShippingTotal (Total, Description)>
<!ELEMENT Total (#PCDATA)>
<!ELEMENT Description (#PCDATA)>
<!ELEMENT Surcharge (Total, Description)>
<!ELEMENT Total (#PCDATA)>
<!ELEMENT Description (#PCDATA)>
<!ELEMENT Coupon (Name, Status, Total, ApplyCoupon)>
<!ELEMENT Name (#PCDATA)>
<!ELEMENT Status (#PCDATA)>
<!ELEMENT Total (#PCDATA)>
<!ELEMENT ApplyCoupon (#PCDATA)>
<!-- "Pre" indicates coupon is applied before tax; no other values supported -->
<!ELEMENT Other (Associate, OrderInstructions, Comments, IpHostname, TotalOrderWeight, EmailList, CustomCheckoutField*)>
<!ELEMENT Associate (#PCDATA)>
<!ELEMENT OrderInstructions (#PCDATA)>
<!ELEMENT Comments (#PCDATA)>
<!ELEMENT IpHostname (#PCDATA)>
<!ELEMENT TotalOrderWeight (#PCDATA)>
<!ELEMENT EmailList (#PCDATA)>
<!ELEMENT CustomCheckoutField (FieldName, FieldValue)>
<!ELEMENT FieldName (#PCDATA)>
<!ELEMENT FieldValue (#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)>
<!ELEMENT RoutingNumber (#PCDATA)>
<!ELEMENT AccountNumber (#PCDATA)>
]>
|
ShopSite Help and Resource Center February 13, 2004 Give Feedback |
© 2007, ShopSite, Inc. ShopSite Shopping Cart Software |