We are ROlandd
We make super nice software

Activation code of Joomla user

Name of the city of user

Company name of the user

User country name

If the address is a default address

Possible options

Y:Yes
N:No

User fax

First name of the user

Primary Key id value of the address

User last name

User middle name

Zip code of user

Set the state of the address.

Possible options

1:Published
0:Unpublished

State name for address

User shipping address details

User shipping address details

User first telephone number

User second telephone number

User title for the address

Primary key id value of user, it should match with Joomla user table id

VAT details of the address

Set which dates should be shown in the datepicker.

Possible options

all:All dates
past:Only past dates
future:Only future dates

The attributes to assign to a field type.

The access level to the badge

If need to include category children to the badge

Possible options

1:Yes
0:No

Category id set to the badge

Discount id set to the badge

End date of the badge

Horizontal distance in pixels

Primary key value of HikaShop badge table

Image set for the badge

If need to keep the size of the badge

Possible options

1:Yes
0:No

Margin for the badge

Name of the badge

Order of the badge

The position, chosen among 4 choices, where the badge will be positionned.

The id of the product for which badge has to be applied

Choose to publish your badge by setting to "Yes" else otherwise.

Possible options

1:Published
0:Unpublished

if you enter a number to quantity, that will restrict the badge to show only to that stock amount. So for example, if you want to display a "no stock left" badge, you can put 0 in that field so that the badge display on the products image only when there is no stock left.

This size defines the size of the badge compared to the size of the product image. It means that the badge will adapt itself automatically.

The date when the display of the badge will start.

This field will make badge clickable and redirect the customer to the given url

This distance is between the top or the bottom of the image and the same part of the badge.

User billing city name

Billing Company name of the user

User billing country name

If the address is a default address

User billing fax number

User billing first name

User billing last name

User billing middle name

Zip code of billing address

Set the state of the address details

Possible options

1:Published
0:Unpublished

State name of the billing address

User billing address details

User billing address details

User billing telephone number 1

User billing telephone number 2

User billing address title.

Billing address vat

Billing country name 2 letter code

Billing country name 3 letter code

Billing country zone name

Billing country zone name in English

Billing State name 2 letter code

Billing State name 3 letter code

Billing state zone name

Billing state zone name in English

Zone type for billing

If the user is blocked

Possible options

1:Yes
0:No

The brand name for a product

Set the access level for the category.

A unique alias for the category.

The url which is used to access the category at its best. it is used in SEF.

The creation date of the category convert to time.

The level of the category from the root category

Description of a category.

The primary key value of categories table

Meta information of the category

Layout of the category

Specifies the left position in the nested set.

Menu for a category

Meta description for a category

Set the id of the user modified the category

Name of the category

The unique name key of the category

The order in which to show the category.

Title of the category page

Sets the parent to which category belongs to.

The category path specifies in which category an item belongs.

Set the published state of the category.

Possible options

1:Product published
0:Product unpublished

The number of category to be listed in a layout

The right value where category lies between.

Set the site id of the category.

Type of category, for brands set the value of field as manufacturer, for tax category set it as tax, for product category set it as product and for order status set it as status.

Characteristics of a product

Alias name of characteristic

Field to delete characteristic during import

Possible options

Y:Yes
N:No

Display method of a characteristic

Display type for a characteristic

Primary key value of characteristic table

Set the ordering of characteristic

Parameters of characteristic

Parent characteristic alias name

Parent id of the characteristic

Value of the characteristic

The number of columns to use on a textarea.

This is a special field to allow you to combine fields into a single field.

Possible options

This field is only used when setting up your template fields.

Comment on order

Code of the country name

Code of the country name

Country name

The 3-letter currency code.

Currency name for price

Custom

Possible options

CSVI custom field for a export

Set the limit a coupon or a discount to joomla groups of users

Discount affiliate

If set to Yes the system will load the coupon in the cart on the checkout

Category child ids for which the discount to be applied

Id of the product category for which the discount to be applied.

Code number of a discount which is used at checkout process

Set if coupon can be used again

If the coupon to be used only on products

Possible options

Y: Yes
1: Yes
N: No
0: No

Currency id of the discount

Field to delete discount during import

Possible options

Y:Yes
N:No

Set an ending date for a coupon or a discount.

Set an amount for discount in the currency needed.

Primary key field value of discount table

If set, a coupon won't be accepted if the total amount of the products in the order is under this value

If set, a coupon won't be accepted if the total number of the products in the order is under this value.

Amount discount in percentage

Id of the product to apply discount

If the discount is published or not

Possible options

Y: Yes
1: Yes
N: No
0: No

The alloted value of a discount

The alloted dscount for a user

Site id of the discount

Set an start date for a coupon or a discount.

Tax id for the discount

Type of discount, if it is discount or coupons

Number of times discount has been used

Zone id for which discount has been set

Email id of the user

A custom error message to show for a field set to required.

ICECat product features

A comma-separated list of usergroups allowed to access the field.

If set to Yes, you will be able to change this information on the back end. Usually it should be always Yes.

Possible options

Y: Yes
1: Yes
N: No
0: No

If set to Yes, the value of the field will be displayed as an additional column on listings on the back end. Note that this only applies to user and product custom fields.

Possible options

Y: Yes
1: Yes
N: No
0: No

For custom fields of the tables "Category", "Product" or "Item", you can restrict the display of the custom field to only some categories.

Designates this field as a core field.

Possible options

Y: Yes
1: Yes
N: No
0: No

A default value for the custom field.

Delete the custom field.

Possible options

Y: Yes
1: Yes
N: No
0: No

A semi-colon separated list of field options and values.

If set to Yes, address and user customer fields will be used during the checkout process to ask more information about the customer. Product custom fields will be displayed as specifications on the product page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Primary key value of field table

Set the display option Back-end Cart details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Front-end Cart details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Checkout.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Product edition form in order.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Invoice.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Front-end order details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Order administrator notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Order creation notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Back-end order details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Order notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Order status notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Payment notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Cart Module.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Front-end Product Listing.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Product Page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Shipping Invoice.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option Front-end Cart details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

This is the column name of the field and is the unique key for CSVI.

This is a serialized string of data used to store a number of options used by a field.

If the order is a front end order

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the ordering of the field.

Set the display option for Order administrator notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Checkout.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order creation notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order additional information.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order edition form.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Invoice.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Back-end Listing.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Payment notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Shipping Invoice.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Front-end order details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order status notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

A comma-separated list of product IDs to which the field is limited to.

Set the display option for Back-end Cart details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Front-end product details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Comparison page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Product Edition page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Front-end Cart details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Front-end Listing.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Invoice.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Back-end Listing.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order administrator notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order creation notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Back-end Order details page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Order status notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Payment notification.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Shipping Invoice.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the display option for Product page.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set if the field should be published or not.

Possible options

Y: Yes
1: Yes
N: No
0: No

The label of the field.

If set to Yes, the field will be required to be filled out.

Possible options

Y: Yes
1: Yes
N: No
0: No

The table for which the field is to be created.

Possible options

Address:address
User:user
Product:product
Category:category
Contact:contact
Order:order
Item:item
Entry:entry

The type of field it is.

Possible options

Text:text
Link:link
Text area:textarea
WYSIWYG:wysiwyg
Radio button:radio
Checkbox:checkbox
Single Dropdown:singledropdown
Multiple Dropdown:multipledropdown
Simple date picker:date
Zone:zone
Coupon:coupon
File:file
Image:image
Ajax File:ajaxfile
Ajax Image:ajaximage
Custom text:customtext

The values belonging to the field types:

• Radio Button
• Checkbox
• Single Dropdown
• Multiple Dropdown

mr::Mr.::0

mr::Mr.::0|mrs::Mrs.::0

Set the display option for Including sub categories.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the description for a media file

Set the name of the media file

Ordering of the media item

The path of the media item

Set the option Input filtering

Possible options

Y:Yes
1:Yes
N:No
0:No

First name of the user

Set the option Format for the date picker.

The order amount

Date of order created

Details about the order

Primary key value of hikashop history table

Ip address from where order has been processed

The recent status of an order

If the order change has been notified

The order id

The id of the package

The id of the payment method

Name of the payment method

Reason of the order status change

History type

User id of the order

Id of the Joomla user table

Last reset time of user

User last visted date and time

Last name of the user

limit_to_parent

Possible options

All:all

The value to use is the field_namekey value of the custom field that is part of the same table.

To use the All option set the value to all.

Set the Maximum length option.

Name of the user

Billing address id for an order

Date and time when order was created

Currency id of the order

Currency information of an order

Discount code for an order

Amount of discount on an order

Tax amount on discount for an order

The total amount of the order once everything has been factored in.

Primary key field value of order table

Date and time when order invoice was created

Invoice id of an order

Invoice number of an order

ip address of the user placed the order

Date and time when order is modified

This order number is generated from the id of the order.

Affiliates currency id

Affilitae partner id

If affilitae partner has been paid

Price amount to be paid to affiliate partner

Payment id of the order

Name of the payment method selected by the customer during the checkout process.

Parameters of order payment

Order payment price

Order payment tax amount

SKU of the product placed as an order

Id of the product placed in the order

Name of the product placed in the order

Options of a product in the order

Options parent id of a product

Product price in an order

Number of products placed in the order

Shipping id of an order

Shipping method name for an order

Parameters of shipping of an order

Product shipping price

Shipping tax amount for a product in an order

Product tax amount of an order

Tax information of an order

If the product has been saved in wishlist then its wishlist id

Shipping address id of the order

Shipping method id for an order

Shipping method name for an order

Shipping parameters of an order

Shipping price for an order

Shipping tax for an order

Site id of an order

Status of an order

Tax information of an order

Type of order

Id of the user placed the order

one time emergency passwords

Two factor authentication key

The English name of the zone to override the tax zone.

Joomla user parameters

The value of the item selected in Display limited to.

password for user login

for importing md5 hash password

Image URL of a product

Thumb image URL of a product

The placeholder to show for a Text field.

Set the Add a 'Please select' value

Possible options

Y:Yes
1:Yes
N:No
0:No

Set the usergroup to have access to the price

If need to update the current usergroup set the new usergroup name in this field and old usergroup name in price_access field

Set the currency id of the price

Delete a price when doing a import

Possible options

Y: Yes
1: Yes
N: No
0: No

Primary key value from HikaShop price table

Minimum quantity of price

primary key field of product price table

Price site id

Price amount of a product

If price of a product needs to be updated put the new price in this field and old price value in price_value field

Price value with tax included

Restrict the display of the product to only some user groups.

Unique name for a product

Average score a product has earned

Link of the product to list the product details. This is used for optimized product search rank.

The unique code for a product

Set to display a contact button on the front end product page to allow customers to contact for more information on the product

Possible options

Y or 1:Yes
N or 0:No

Product created date and time

Delete a product when doing a import

Possible options

Y:Yes
N:No

Description of a product

Unit to measure product dimensions

If the product quantity field to be displayed on front end

If need to group the products after purchase

Height of the product

Number of hits product has got

Primary key field value of product table

Keywords for meta information

Last seen date of the product

Layout product need to use on front end

Length of a product

Manufacturer id of a product

Maximum products can be ordered in a order

Meta description of a product

Minimum products that can be ordered

Modified date and time for a product

Name of the product

Set the products to be used as options, multiple products separated by |

Title of the product page

The product code of the parent item. This is only used when importing variants.

Parent product id

The price of the product.

The product import only hanldes a single price per product. To import multiple prices per product, use the Price import.

Price of product in percentage

Set the published state of the product

Possible options

1:Product published
0:Product unpublished

The number of items in stock.

Possible options

-1:Unlimited
X:Actual value

Unlimited

-1

10 items in stock

10

Set the layout to display the product quantity

Product sale end date

Product sale start date

Tax amount of a product

Tax categories you want to be used for the calculations of the taxes on a product

Tax id of a product

Total number of votes product has got

The type of product.

Possible options

main:The main product
variant:A product variant

Set URL of the product where product details are explained

Set the field option for For the value.

Possible options

Y: Yes
1: Yes
N: No
0: No

Vendor id for the product

If the product has been put in waitlist

Primary key field for HikaShop warehouse table

Weight of the product

Unit to measure product weight

Width of the product

Set the readonly status for a field.

Possible options

Y: Yes
1: Yes
N: No
0: No

You can enter here a regular expression so that if your custom field is required, the data entered by the user in the field will have to match the regular expression here.

Date user registered on site

Related products of a product

Require user to reset password on next login

Possible options

1:Yes
0:No

Count of password reset since last reset time

The 3-letter currency code to restrict the shipping rule to. Multiple currencies are separated by the pipe-symbol.

The number of rows to use on a textarea.

Send email to Joomla user

Possible options

1:Yes
0:No

Delete a shipping rate when import

Possible options

Y or 1:Yes
N or 0:No

Set the access for shipping

User shipping city name

shipping Company name of the user

User shipping country name

If the address is a default address

User shipping fax number

User shipping first name

User shipping last name

User shipping middle name

Zip code of shipping address

Set the state of the address details

Possible options

1:Published
0:Unpublished

State name of the shipping address

User shipping address details

User shipping address details

User shipping telephone number 1

User shipping telephone number 2

User shipping address title.

Shipping address vat

Shipping country name 2 letter code

Shipping country name 3 letter code

Shipping country zone name

Shipping country zone name in English

Currency of the shipping

Currency id of the shipping

Billing state zone name

Billing state zone name in English

A comma-separated list of images to show for the shipping rate.

The shipping method can be available for only orders below a maximum price.

You can set a maximum quantity so that orders over it won't be able to be shipped with the current shipping method. The quantity of the order will be calculated based on the quantity of each products in it.

Maximum voulme that can be shipped

You can set a maximum weight so that orders over it won't be able to be shipped with the current shipping method. The weight of the order will be calculated based on the weight of each products in it.

You can restrict your shipping methods to only post codes within a certain range whereby this is the maximum possible value.

The shipping method can be available for only orders above a minimum price. This price uses the shipping method price currency even if the price is 0.

You can set a minimum quantity so that orders below it won't be able to be shipped with the current shipping method. The quantity of the order will be calculated based on the quantity of each products in it.

Minimum volume that can be shipped

You can set a minimum weight so that orders below it won't be able to be shipped with the current shipping method. The weight of the order will be calculated based on the weight of each products in it.

You can restrict your shipping methods to only post codes within a certain range whereby this is the minimum possible value.

A unique name of the shipping rule.

The order in which to show the shipping rule.

Set if an override should be used for the shipping address.

Possible options

0:No
1:Your shop address
2:Hide
3:Text version
4:HTML version

Specify the overriden shipping address

Street 10

12345 Hometown

Parameters of shipment method

Additionally to the price of the field above, you can also set here a percentage of the total of the order's products. The result amount will be added to the price so that you can have a fix minimum price and a percentage fee on top of it.

Activate the price per product system for that shipping method.

Possible options

Y or 1:Yes
N or 0:No

The price set for the shipping method.

Configure a fixed shipping price for each product added to the cart which will be summed up and added to the main price of the shipping method.

The price restriction can be set on the taxed price or the price without tax depending on this option.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the shipping rule enabled.

Possible options

Y: Yes
1: Yes
N: No
0: No

Set the unit of measurement for size.

Possible options

m
dm
cm
mm
in
ft
yd

Shipping State name 2 letter code

Shipping State name 3 letter code

Shipping state zone name

Shipping state zone name in English

Tax id of the shipping method

The element name of the shipping plugin.

If you activate this option, the price of virtual goods (no weight) is taken into account for the maximum and minimum price restrictions above as well as the percentage price calculation. Otherwise, only the real goods (with a weight) are taken into account.

Possible options

Y: Yes
1: Yes
N: No
0: No

Name of the warehouse

Set the unit of measurement for weight

Possible options

kg
g
mg
lb
oz
ozt

You can restrict your shipping methods to only post codes including such prefix with this option.

You can restrict your shipping methods to only post codes including such suffix with this option.

Shipping address zone name key

Shipping address zone type

The size of an input field.

The skip field is used to skip the field from being imported.

3 letter code of the state name

Name of the state of a country

Amount of tax on order

Tax amount on the coupon

The full path to the tax rule.

The tax category is a forward-slash separated string which starts at the base of the tax category structure. By default the base is taxation category and after that follows the setup taxation rules.

Name of the tax

Set the field to be translatable.

Possible options

Y:Yes
1:Yes
N:No
0:No

The name or names of user groups that the shipping rule is limited to. Multiple user groups are pipe-symbol separated.

Username of the user from Joomla user table

Joomla table user id

Date and time when user has been created

Ip address from where user has been created

Currency id of the user

Email of the user

Primary key field value of HikaShop customer table

Parameters of a user

If the affiliate partner activated or not

The currency in which the affiliate partner wishes to be paid with

The payment email of the affiliate partner

User id of the affiliate partner

If affiliate partner is paid or not

Possible options

Y or 1:Yes
N or 0:No

Amount to be paid to affiliate partner

Total unpaid amount for a user

Comment on user vote

Date when vote has been given

Email id of the user given the vote

Primary key field for vote table

User ip address from where vote has been given

Set the state of the vote

Possible options

Y or 1:Yes
N or 0:No

The rate given by the user for the item.

Reference id from user vote table

Type of the vote

If the vote is userful or not

Possible options

Y or 1:Yes
N or 0:No

Id of the user voted

The name of the warehouse to restrict the shipping rule to.

Warehouse name for a product

The English name of the zone to restrict the shipping rule to.

2 letters ISO code for a zone

3 letters ISO code for a zone.

Set the currency to apply on this zone

Primary key field value of zone table

Name of the zone

Name key of the zone.

English name of the zone

Set the state of the zone.

Possible options

Y or 1:Yes
N or 0:No

Set the zone type to use for the field type Zone.

Possible options

Countries:country
States:state
Tax zones:tax
Shipping zones:ship
Discount zones:discount
Payment zones:payment