Customers

From DevWiki

Customers Info

Custom Fields

If Custom Fields are changed for customers you must do the following to have access to those fields.

The store owner must FTP into their store and go to the /vspfiles/schema/ directory and delete a file called Customers.xsd. Once this file is deleted the next time the API is called it will generate that file with the new Custom Fields. If this step is not done the API will have no access to those columns. This also applies to Orders.

Customers XSD

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="xmldata" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="xmldata" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
 <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
      <xs:element name="Customers">
        <xs:complexType>
          <xs:sequence>
              <xs:element msprop:TableNameXsd="Customers" name="CustomerID" msprop:SqlDbType="Int" msprop:IsIdentity="true"
minOccurs="0" />
             <xs:element name="AccessKey" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Allow_Access_To_Private_Sections" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="BillingAddress1" msprop:maxLength="75" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="BillingAddress2" msprop:maxLength="75" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="CatalogSubscriber" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Checkbox_For_New_Customers" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="City" msprop:maxLength="45" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="CompanyName" msprop:maxLength="100" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Country" msprop:maxLength="30" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Custom_Field_Custom1" msprop:maxLength="50" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Custom_Field_Custom2" msprop:maxLength="50" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Custom_Field_Custom3" msprop:maxLength="50" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Custom_Field_Custom4" msprop:maxLength="50" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Custom_Field_Custom5" msprop:maxLength="50" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Customer_IsAnonymous" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Customer_Notes" msprop:SqlDbType="Text" minOccurs="0" />
             <xs:element name="CustomerType" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="DiscountLevel" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="EmailAddress" msprop:maxLength="75" msprop:SqlDbType="VarChar" minOccurs="1" />
             <xs:element name="EmailSubscriber" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="FaxNumber" msprop:maxLength="30" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="FirstDateVisited" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="FirstName" msprop:maxLength="30" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="FirstOrderDate" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="ID_Customers_Groups" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="IsSuperAdmin" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="LastLogin" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="LastLoginAttempt" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="LastModBy" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="LastModified" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="LastName" msprop:maxLength="40" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="LoginAttempts" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="news1" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news10" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news11" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news12" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news13" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news14" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news15" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news16" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news17" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news18" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news19" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news2" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news20" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news3" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news4" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news5" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news6" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news7" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news8" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="news9" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Password" msprop:maxLength="64" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="PaysStateTax" msprop:maxLength="3" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="PercentDiscount" msprop:SqlDbType="Float" minOccurs="0" />
             <xs:element name="PhoneNumber" msprop:maxLength="35" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="PostalCode" msprop:maxLength="15" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="SalesRep_CustomerID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="State" msprop:maxLength="30" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="TaxID" msprop:maxLength="64" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="WebsiteAddress" msprop:maxLength="150" msprop:SqlDbType="VarChar" minOccurs="0" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
    </xs:complexType>
 </xs:element>
</xs:schema>

Sample XML