Orders Export

From DevWiki

Orders Exports With Volusion API

Volusion’s API is a powerful tool to enable both Volusion users and developers to easily integrate Volusion with 3rd party web services and applications. Volusion already provides API integration with various 3rd party services such as Quickbooks, StoneEdge, Edicia and more. On top of that, Volusion provides easy access to allow developers to create their own custom XML exports so that they can extend Volusion’s functionality and integrate it with other 3rd party software and services.

Accessing the Orders Export

To gain access to export the Volusion order table via XML, do the following:

• Log into the Volusion Administration Page.
• Click on the Inventory tab then, click on the Import/Export link within the green menu bar. This takes users to the Data Import/Export Tools page.
• Click on the Volusion API link to enter the main API page.
• To access the settings for an export, click on the blue, “Run” button next to one of the “Generic\Orders”heading.
  
  

Generating the Export

There are a few things users must keep in mind when using Volusion’s Orders Export:

When users run exports, the export will only output up to 100 records at one given time. The export will begin with the very first element in the database and export every element up to the 100th element (e.g. the Orders Export will export products from Order ID 1000 to 1099). Users with many elements in their database will be required to run multiple exports in order to export every element within the database (e.g. users will need to first generate an export for Order IDs 1000-1099 and will then need to generate a second export if they also require one for Order IDs 2000-2099). Once an export has been generated, Volusion assigns it a time-stamp. That export can only be generated once unless the user resets the export event. This process is described below.

The Generic Export pages consist of two main elements that users will interact with – the Export Tool Bar and the Export Table:

The Export Table consists of four columns described below

• Column Name: The items listed in this column are the names of the database values that can be exported from the Volusion store database. They are referred to in the export by the names given for each field here.
• SqlDbType: These are the data types of entities found in Column Name.
• SELECT_Columns: Checking a box in this column will set the corresponding database field in Column Name to be exported.
• WHERE_Value: Users can set a value in this field to instruct the API to export only values for the corresponding Column Name. Note: If used, this field must have an explicit value (e.g. 123, ABC). Users cannot set value ranges or operators such as ‘<’ or ‘>’ in this field.
  
  

The Export Tool Bar consists of three elements:

• Select Date: This drop-down allows users to select which export they wish to reset. All exports are assigned a time stamp which lists the date and time the export was generated.
• IDs: Once a time stamp from the Select Date field is chosen, this drop-down will be populated. The IDs drop-down will contain ID numbers for each primary key element that was exported on the date that the user has chosen. For example, within the Orders export, these IDs will be the Order ID number for each order in the export. Users can select one ID to reset or the ALL IDs value to reset all IDs within the selected export.
• Reset Export: This button will execute the export reset.
  
  

Using the Export

Some users may wish to have a list of their store’s orders exported via XML – possibly to view what orders have been generated within a particular time frame or to enter their customer’s data into another database outside of Volusion’s. In this case, the user may wish to export their orders’ ID numbers and their payment. The following instructions will explain how to do this:

• First, log into the Volusion Administration Page. Click on the Inventory tab and then click on the Import/Export link within in the green menu bar. Users should now be on the Data Import/Export Tools page.
• Click on the Volusion API link on that page. Within the main Volusion API page, click the Run button next to the Generic\Orders heading. Users should now see the Generic Orders Export table.
• In the select column, check the boxes relating to o.OrderID and o.PaymentAmount.
• Click the Run button just below the Export Tool Bar to run the export.
  
  

Once this process is complete, the API page will refresh. Below the Export Tool Bar, there now should be a link labeled, “Click Here to download the file”. Clicking on this link will load the now-generated XML file into a new window or tab within the web browser. Alternately, below this link is a text field that contains the URL for the XML. Users can copy this URL and use it link to this XML export from within 3rd party services or programs.

Note:
Once users click the link to download the XML file, it invalidates the URL presented in the text box. Users who have already downloaded the XML file will need to reset and the regenerate the XML export to gain valid access to the URL.

For further information on how to implement exports using various types of web scripting languages, please review this link within our wiki.

What elements are exported in the Generic Orders Export?

The Generic Orders export within the Volusion API can export values from any field within the Volusion Orders and Order Details tables. These are the same values that can be imported/exported using other import/export method within Volusion. Note that the Orders and Order Details tables are joined together within the Volusion database and as such, values from both fields can be exported (delineated by “o.” for orders and “od.” for orders details). A list of these fields are as follows:

o.OrderID
o.AccountNumber
o.AccountType
o.AddressValidated
o.Affiliate_Commissionable_Value
o.AVS
o.BankName
o.BatchNumber
o.BillingAddress1
o.BillingAddress2
o.BillingCity
o.BillingCompanyName
o.BillingCountry
o.BillingFaxNumber
o.BillingFirstName
o.BillingLastName
o.BillingPhoneNumber
o.BillingPostalCode
o.BillingState
o.CardHoldersName
o.CashTender
o.CC_Last4
o.CheckNumber
o.CreditCardAuthorizationDate
o.CreditCardAuthorizationNumber
o.CreditCardExpDate
o.CreditCardIssueDate
o.CreditCardIssueNumber
o.CreditCardTransactionID
o.Custom_Field_Custom1
o.Custom_Field_Custom2
o.Custom_Field_Custom3
o.Custom_Field_Custom4
o.Custom_Field_Custom5
o.Customer_IPAddress
o.CustomerID
o.CVV2_Response
o.DV_CreditCardNumber
o.GiftCardIDUsed
o.IsAGift
o.LastModBy
o.LastModified
o.Locked
o.MICR
o.Order_Comments
o.Order_Entry_System

o.OrderDate
o.OrderID_Third_Party
o.OrderNotes
o.OrderStatus
o.PaymentAmount
o.PaymentDeclined
o.PaymentMethodID
o.PONum
o.Printed
o.Processed_AutoEvents
o.RoutingNumber
o.SalesRep_CustomerID
o.SalesTax1
o.SalesTax2
o.SalesTax3
o.SalesTaxRate
o.SalesTaxRate1
o.SalesTaxRate2
o.SalesTaxRate3
o.ShipAddress1
o.ShipAddress2
o.ShipCity
o.ShipCompanyName
o.ShipCountry
o.ShipDate
o.ShipFaxNumber
o.ShipFirstName
o.ShipLastName
o.Shipped
o.ShipPhoneNumber
o.Shipping_Locked
o.ShippingMethodID
o.ShipPostalCode
o.ShipResidential
o.ShipState
o.Stock_Priority
o.Tax1_Title
o.Tax2_Title
o.Tax3_Title
o.Total_Payment_Authorized
o.Total_Payment_Received
o.TotalShippingCost
o.VendorID
od.OrderDetailID
od.Affiliate_Commissionable_Value
od.AutoDropShip

od.CategoryID
od.CouponCode
od.CustomLineItem
od.DiscountAutoID
od.DownloadFile
od.Fixed_ShippingCost
od.Fixed_ShippingCost_Outside_LocalRegion
od.FreeShippingItem
od.GiftTrakNumber
od.GiftWrap
od.GiftWrapCost
od.GiftWrapNote
od.IsKitID
od.KitID
od.LastModBy
od.LastModified
od.Locked
od.OnOrder_Qty
od.OptionID
od.OptionIDs
od.Options
od.OrderID
od.Product_Keys_Shipped
od.ProductCode
od.ProductID
od.ProductName
od.ProductNote
od.ProductPrice
od.ProductWeight
od.QtyOnBackOrder
od.QtyOnHold
od.QtyOnPackingSlip
od.QtyShipped
od.Quantity
od.Returned
od.Returned_Date
od.RMA_Number
od.RMAI_ID
od.ShipDate
od.Shipped
od.TaxableProduct
od.TotalPrice
od.Vendor_Price
od.Warehouses
odo.OptionID
odo.OrderDetailID