Product Exports With Volusion API

Volusion’s API is a powerful tool that enables both Volusion users and developers to easily integrate Volusion with third-party web services and applications. Volusion already provides API integration with various providers, including QuickBooks, StoneEdge, and Endicia. On top of that, Volusion provides easy access for developers to create their own custom XML exports, allowing you to extend Volusion’s functionality and integrate it with other third-party software and services.

Accessing the Product Export

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

  1. Log into the Volusion store's Admin Area.
  2. Go to Inventory > Import/Export.
  3. Click on the Volusion API tab to enter the main API page.
  4. To access the settings for an export, click Run next to the one of the following export headings: Generic\Products, Generic\Orders, or Generic\Customers.

Generating the Export

There are a few things users must keep in mind when using Volusion’s Product 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 Products Export will export products from Product ID ABC100 to ABC199). 
  • 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 Product IDs ABC100-ABC199 and will then need to generate a second export if they also require one for Product IDs ABC200-ABC299). 
  • 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 products exported via XML – possibly for use with a for marketing purposes or to enter their product data into another database outside of Volusion’s. In this case, the user may wish to export their products’ names, ID numbers and their prices. The following instructions will explain how to do this:

  1. 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.
  2. Click on the Volusion API link on that page. Within the main Volusion API page, click the Run button next to the Generic\Products heading. Users should now see the Generic Products Export table.
  3. In the select column, check the boxes corresponding to the fields p.ProductID, p.ProductName,and pe.ProductPrice.
  4. 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 API Integration: Sample Code (Developer).

Fields Exported in the Generic Products Export

The Generic Products export within the Volusion API can export values from any field within the Volusion Products, Product Details, Products Extended and Product Memo tables. These are the same values that can be imported/exported using other import/export method within Volusion. The Products, Product Details, Products Extended and Product Memos tables are all joined within the Volusion database and thus are available for export together here. The fields that can be exported are as follows:

p.AutoDropShip
p.DisplayBeginDate
p.DisplayEndDate
p.DoNotAllowBackOrders
p.HideProduct
p.HomePage_Section
p.IsChildOfProductCode
p.IsChildOfProductCode_ProductID
p.LastModBy
p.LastModified
p.Options_Cloned_From
p.Options_Cloned_From_ProductID
p.Photos_Cloned_From
p.Photos_Cloned_From_ProductID
p.ProductCode
p.ProductID
p.ProductName
p.ProductPopularity
p.Share_StockStatus_With
p.Share_StockStatus_With_ProductID
p.StockStatus
p.Vendor_PartNo
p.WarehouseAisle
p.WarehouseBin
p.WarehouseCustom
p.WarehouseLocation
pd.ProductDescription
pd.ProductDescriptionShort
pe.Accessories
pe.Additional_Handling_Indicator
pe.AddtoCartBtn_Replacement_Text
pe.AddToPO_Now
pe.Affiliate_Commissionable_Value
pe.AllowPriceEdit
pe.Availability
pe.Book_ISBN
pe.CustomField1
pe.CustomField2
pe.CustomField3
pe.CustomField4
pe.CustomField5
pe.custom_label_0
pe.custom_label_1
pe.custom_label_2
pe.custom_label_3
pe.custom_label_4
pe.DiscountedPrice_Level1
pe.DiscountedPrice_Level2
pe.DiscountedPrice_Level3
pe.DiscountedPrice_Level4
pe.DiscountedPrice_Level5
pe.DiscountedRecurringPrice_Level1
pe.DiscountedRecurringPrice_Level2
pe.DiscountedRecurringPrice_Level3
pe.DiscountedRecurringPrice_Level4
pe.DiscountedRecurringPrice_Level5
pe.DiscountedSetupCost_Level1
pe.DiscountedSetupCost_Level2
pe.DiscountedSetupCost_Level3
pe.DiscountedSetupCost_Level4
pe.DiscountedSetupCost_Level5
pe.DownloadFile
pe.EnableMultiChildAddToCart
pe.EnableOptions_InventoryControl
pe.EstShip_2ndDay
pe.EstShip_Ground
pe.EstShip_Overnight
pe.Fixed_ShippingCost
pe.Fixed_ShippingCost_Outside_LocalRegion
pe.FreeShippingItem
pe.GiftWrapCost
pe.Google_Adult_Product
pe.Google_Age_Group
pe.Google_Availability
pe.Google_Color
pe.Google_Gender
pe.Google_Material
pe.Google_Pattern
pe.Google_Product_Category
pe.Google_Product_Type
pe.Google_Size
pe.Google_Unique_Identifier_Exists
pe.Height
pe.Hide_FreeAccessories
pe.Hide_When_OutOfStock
pe.Hide_YouSave
pe.HowToGetSalePrice
pe.Inv_LastVerified
pe.Inv_Verify_QtyOnHand
pe.LastPO_Date
pe.LastPO_Qty
pe.Length
pe.ListPrice
pe.ListPrice_Name
pe.MaxQty
pe.METATAG_Description
pe.METATAG_Title
pe.MinQty
pe.Oversized
pe.Package_Type
pe.Photo_AltText
pe.Photo_SubText
pe.PhotoURL_Large
pe.PhotoURL_Small
pe.Price_SubText
pe.Price_SubText_Short
pe.Private_Section_Customers_Only
pe.ProductCategory
pe.ProductCondition
pe.ProductKeywords
pe.ProductManufacturer
pe.ProductNameShort
pe.ProductPrice
pe.ProductPrice_Name
pe.ProductWeight
pe.Quickbooks_Item_Accnt
pe.Quickbooks_Item_AssetAccnt
pe.Quickbooks_Item_CogsAccnt
pe.Recurring_Pricing_Text
pe.RecurringDuration
pe.RecurringHowOften
pe.RecurringPrice
pe.RecurringStartDuration
pe.RecurringStartPrice
pe.Reward_Points_Given_For_Purchase
pe.SalePrice
pe.SalePrice_Name
pe.SelectedOptionIDs
pe.SetupCost
pe.SetupCost_Name
pe.SetupCost_Title
pe.Ships_By_Itself
pe.ShoppingDotCom_Category
pe.StockLowQtyAlarm
pe.StockReOrderQty
pe.TaxableProduct
pe.UPC_code
pe.Uses_Product_KeyTypes
pe.VAT_Percentage
pe.Vendor_Price
pe.warehouses
pe.Width
pe.Yahoo_Category
pe.Yahoo_Medium
pm.CUSTOM_METATAGS_OVERRIDE
pm.ExtInfo
pm.METATAG_Keywords
pm.OrderFinished_Note
pm.ProductDescription_AbovePricing
pm.ProductFeatures
pm.TechSpecs
Did this answer your question?