Custom Fields

If you want to add custom fields to your customer forms, VPCART allows you to do this using the Shop Configuration:

 

Xcustomerotherfields

This is a comma-delimited list of the fields you want to add. These need to correspond to the new fields you have created in your database. For example - accountno,section.

Xcustomerothercaptions

This is a comma-delimited list of captions for the fields you have added. For example - Account Number,Department

Xcustomerotherfieldsinorder

Setting this to Yes means that the customer fields are placed both in the customers table and in the orders table. No means they are stored only in the customers table.

Xcustomerotherrequired

This is a comma-delimited list of the fields listed in xcustomerotherfields that are required to be filled in by the customer.

Xshippingotherfields

If you want to add extra fields to the shipping form, this is a comma-delimited list of fields to add to the shipping form. These need to be added to the customer and orders tables in your database as well.

Xshippingothercaptions

This is a comma-delimited list of captions for the fields you have added to the shipping form.

xshippingotherrequired

This is a comma-delimited list of the fields listed in xshippingotherfields that are required to be filled in by the customer.

 

Note:This facility can only be used for text fields (not dropdown lists or radio buttons). The extra fields are always placed under the last field in the left-hand column.

To setup the configurations, please follow these steps below :

1.  In the top menu select Advanced Settings , then Software Configurations from the dropdown.

 

2.  Enter the config in search box and press the “Search” button.

ScreenShot093

 

 

3.  Change the value and click Continue.

 

You need to manually create the extra fields to the customers and orders table in your database before making these changes to your configuration.VPCART does not alter the structure of the database, it simply generates the form and updates the fields. If you do not add the fields to the database, you may receive errors such as

 

ADODB.Recordset (0x800A0CC1)

Item cannot be found in the collection corresponding to the requested name or ordinal.

 

It means that you have told VPCART to use a new field name, but the actual field is not in the database.