Volusion provides a special export for integration with Monsoon Stone Edge through the Volusion API. This export will generate an XML file containing data from your store's Customers, Orders, or Products databases.

For detailed integration information, see "Monsoon Stone Edge Integration With Volusion API".

This document will list each XML variable provided through the three types of exports available for Monsoon Stone Edge via the Volusion API and the purpose of each variable.

Monsoon Stone Edge Download Customers

This export contains specific fields from the Customers table within the Volusion database plus headers and some fields required for use within Monsoon Stone Edge.

RESPONSE

ResponseCode
A response code specific to Monsoon Stone Edge.

Response Description
A success or failure header for use by Monsoon Stone Edge.

CUSTOMER

WebID
This relates to the CustomerID field in the Volusion Customers database.

UserName
This is the customer's name they use to log into the Volusion system - represented by their email address. Password This field, provided according to the Monsoon Stone Edge template, passes no value. Passwords are encrypted.

AffiliateID
This contains the CustomerID provided the customer has been made an affiliate. 

SHIPADDR

FirstName
Equivalent to the FirstName field in the Volusion Customers database table 

LastName
Equivalent to the LastName field in the Volusion Customers database table

Email
Equivalent to the EmailAddress field in the Volusion Customers database table 

Company
Equivalent to the CompanyName field in the Volusion Customers database table 

Phone
Equivalent to the PhoneNumber field in the Volusion Customers database table 

Addr1
Equivalent to the BillingAddress1 field in the Volusion Customers database table 

Addr2
Equivalent to the BillingAddress2 field in the Volusion Customers database table 

City
Equivalent to the City field in the Volusion Customers database table

State
Equivalent to the State field in the Volusion Customers database table

Zip
Equivalent to the PostalCode field in the Volusion Customers database table

Cou
Equivalent to the Country field in the Volusion Customers database table

BILLADDR

The following fields are identical to the equivalent fields reported for under the ShipAddr header within the XML export. Volusion's Customer database table does not record alternate customer data based on shipping address vs. billing address but simply reports the same set of data for both types.

FirstName
LastName
Email
Company
Phone
Addr1
Addr2
City
State
Zip
Cou 

Monsoon Stone Edge Download Orders

This export contains specific fields from the Orders table within the Volusion database plus headers and some fields required for use within Stone Edge. The fields exported are as follows:

RESPONSE

ResponseCode
A response code specific to Monsoon Stone Edge.

Response Description
A success or failure header for use by Monsoon Stone Edge.

ORDER

OrderNumber
This relates to the OrderID field in the Volusion Orders database.

OrderDate
This relates to the OrderDate field in the Volusion Orders database.

Password
This field, provided according to the Monsoon Stone Edge template, passes no value. Passwords are encrypted.

AffiliateID
This relates to the CustomerID field in the Volusion Orders database. This field is an affiliate's ID if the customer account has been flagged with the affiliate access key.

BILLING

FullName
A combination of the BillingFirstName and BillingLastName fields in the Orders table.

Email
Equivalent to the EmailAddress field in the Volusion Customers database, lined to through the CustomerID value in the Orders table.

Company
This relates to the BillingCompanyName field in the Volusion Orders database. 

Phone
This relates to the BillingPhoneNumber field in the Volusion Orders database. 

ADDRESS

Street1
This relates to the BillingAddress1 field in the Volusion Orders database.

Street2
This relates to the BillingAddress2 field in the Volusion Orders database.

City
This relates to the BillingCity field in the Volusion Orders database.

State
This relates to the BillingState field in the Volusion Orders database.

Code
This relates to the BillingPostalCode field in the Volusion Orders database.

Country
This relates to the BillingCountry field in the Volusion Orders database.

SHIPPING

FullName
A combination of the ShipFirstName and ShipLastName fields in the Orders table. 

Company
This relates to the ShipCompanyName field in the Volusion Orders database.

Phone
This relates to the ShipPhoneNumber field in the Volusion Orders database. 

ADDRESS

Street1
This relates to the ShippingAddress1 field in the Volusion Orders database.

Street2
This relates to the ShippingAddress2 field in the Volusion Orders database.

City
This relates to the ShippingCity field in the Volusion Orders database.

State
This relates to the ShippingState field in the Volusion Orders database.

Code
This relates to the ShippingPostalCode1 field in the Volusion Orders database. 

Country
This relates to the ShippingCountry field in the Volusion Orders database.

Product**

LineID
Equivalent to the OrderDetailsID field in the Volusion OrderDetails database table - linked to through the Orders table.

ProdType
This value is set to either Download or Tangible depending on the value of the ProductWeight field in the Volusion OrderDetails database table, linked to from the Orders table. If ProductWeight is set to 0, this value is reported as Download". Otherwise, the value is returned as Tangible".

Name
Equivalent to the ProductName field in the Volusion OrderDetails database table - linked to through the Orders table.

SKU
Equivalent to the ProductCode field in the Volusion OrderDetails database table - linked to through the Orders table.

Taxable
Equivalent to the TaxableProduct field in the Volusion OrderDetails database table - linked to through the Orders table.

Quantity
Equivalent to the Quantity field in the Volusion OrderDetails database table - linked to through the Orders table.

Item Price
Equivalent to the ProductPrice field in the Volusion OrderDetails database table - linked to through the Orders table.

Total
Equivalent to the TotalPrice field in the Volusion OrderDetails database table - linked to through the Orders table.

Weight
Equivalent to the ProductWeight field in the Volusion OrderDetails database table - linked to through the Orders table.

CustomerText
Equivalent to the ProductNote field in the Volusion OrderDetails database table - linked to through the Orders table.

PAYMENT**

CREDITCARD**

Issuer
Equivalent to the PaymentMethodID field in the Volusion Orders database table. 

AVS
Equivalent to the AVS field in the Volusion Orders database table.

TransID
Equivalent to the CreditCardTransactionID field in the Volusion Orders database table.

TOTALS

ProductTotal
Equivalent to the TotalPrice field in the Volusion OrderDetails database table - linked to through the Orders table.

SubTotal
Equivalent to the TotalPrice field in the Volusion OrderDetails database table - linked to through the Orders table.

GrandTotal
Equivalent to the PaymentAmount field in the Volusion Orders database table. 

DISCOUNT**

Type
Equivalent to the DiscountType field in the Volusion OrderDetails database table - linked to through the Orders table.

Amount
Equivalent to the TotalValue field in the Volusion OrderDetails database table - linked to through the Orders table.

ApplyDiscount
This is a static value returned via the XML export. It is always set as Pre".

Description
Equivalent to the Name field in the Volusion Discounts database table - linked to through the Orders - OrderDetails table by the DiscountAutoID".

TAX

TaxShipping
This is a static value returned via the XML export. It is always set as Yes".

TaxAmount
This value is the total sum of the values in the SalesTax1", SalesTax2 and SalesTax3 fields in the Volusion Orders database table.

TaxRate
Equivalent to the SalesTaxRate field in the Volusion Orders database table. 

TaxExempt
The value returned is either Y or N", based on the value set in the PaysStateTax field in the Volusion Customers database table, linked to from the Orders table.

TaxID
Equivalent to the TaxID field in the Volusion Customers database table, linked to from the Orders table.

SHIPPINGTOTAL

Total
Equivalent to the TotalShippingCost field in the Orders table.

Description
Equivalent to the ShippingMethodID field in the Volusion Orders database table. 

OTHER

Comments
Equivalent to the Order_Comments field in the Volusion Orders database table. 

IPHostname
Equivalent to the Customer_IPAddress field in the Volusion Orders database table. 

TotalOrderWeight
Equivalent to the ProductWeight field in the Volusion OrderDetails database table - linked to through the Orders table.

WebCustomerID
Equivalent to the CustomerID field in the Volusion Orders database table. 

Monsoon Stone Edge Download Prods

This export contains specific fields from the Products table within your store database plus headers and some fields required for use within Monsoon Stone Edge. The fields exported are as follows:

RESPONSE

ResponseCode
A response code specific to Monsoon Stone Edge.

Response Description
A success or failure header for use by Monsoon Stone Edge.

PRODUCT

Code
Equivalent to the ProductCode field in the Volusion Products database table

WebID
Equivalent to the ProductID field in the Volusion Products database table

Name
Equivalent to the ProductName field in the Volusion Products database table

Thumb
This is the URL for the product image thumbnail.

Image
This is the URL for the main product image

Discontinued
This is a value that Volusion does not handle. This value will always be, No".

QOH
Equivalent to the StockStatus field in the Volusion Products database table

Price
Equivalent to the ProductPrice field in the Volusion Products - Products_Extended database table.

Cost
Equivalent to the VR_Price field in the Volusion VendorRules table, linked to via the Products table.

Weight
Equivalent to the ProductWeight field in the Volusion Products - Products_Extended database table.

Description
Equivalent to the ProductDescription field in the Volusion Products - Products_Descriptions database table.

Summary

Volusion's Monsoon Stone Edge integration is straightforward but specialized XML export designed for use with Monsoon Stone Edge software and services. All possible values and naming conventions of elements that can be exported from Volusion using this feature are listed above.

Did this answer your question?