We are ROlandd
We make super nice software

Set the access level for the custom field

Possible options

1:Public
2:Registered
3:Special

Joomla user group name to access

Activation code of Joomla user

This field is Obsolete and not used in PhocaCart now but this field is to display products which are not more active but still to display them in shop.

Additional attributes for a form field. Not used by PhocaCart anymore.

Address information of ordered user

Address information of ordered user

alias of the category

This field is not used now in PhocaCart but in future this field is for allowing upload of e.g. images when ordering a product - e.g. upload logo image when ordering t-shirt

Amount given back as change

Amount to be paid

Amount paid by user

Product availability

Available quantity of coupons or discounts

Available quantity of coupons or discounts per user

Background image to be used for discounts

If billing address and shipping address are same

If the user is blocked

Possible options

1:Yes
0:No

Gross amount of ordered product

Type of calculation for coupons and discounts

Possible options

1:Percentage
0:Fixed amount

Field to delete category during import

Possible options

Y:Yes
N:No

If include or exclude category filter in coupons or discounts

Possible options

1:Yes
0:No

Name of the category product belongs to.

The category path specifies in which category a product belongs

Creating one category

"category_path"
"Parent/Child"

Creating multiple categories

"category_path"
"Parent/Child|Second Parent/Second Child"

Id of the category

The ID of the user who has the item checked out.

The time the item has been checked out.

Name of the city of user

Set CSS class name for form field

Discount or coupon code

Number of columns if form field is a textarea

Custom field to be used for combine of fields

User comment on the order placed.

Company name of the user

Condition of the product

Possible options

0:New
1:Refurbished
2:Used

Field not used in PhocaCart anymore.

User country name who placed the order

Two letter code of the country name

Three letter code of the country name

Country name

Date and time when the count of product has been incremented in a category.

Number of products in a category

Alias of coupon

Total amount of the coupon

Gross amount of the coupon without tax.

Code of the coupon

Discount amount of the coupon.

Net amount of the coupon.

Title of the coupon

Total amount of the coupon.

Date and time on which product or category has been created

Set the user who created the product or category.

Not used by PhocaCart anymore. it was prepared for specific payment plugin.

Currency code value.

Exchange value of the currency.

RO CSVI custom field used in exports.

Group name which product or form field or use belong to

This field is not used by PhocaCart anymore.

Discount amount of ordered product.

Date when a product or category or manufacturer or order or user has been added. If the import operation is for product then date value will be set to product.

Date when product has been last updated or modified.

Subtotal of ordered product after discount.

Default value of the form field.

Field not used by PhocaCart anymore.

Set default language of frontend to be used for orders.

Points received by a user by ordering a product.

Default price when the item was ordered (as the items can be changed in time the default value is stored at the time of order)

Assigned country tax when the item was ordered (as the items can be changed in time the default value is stored at the time of order)

Assigned region tax when the item was ordered (as the items can be changed in time the default value is stored at the time of order)

Default tax rate when the item was ordered (as the items can be changed in time the default value is stored at the time of order)

Set product delivery date.

Short description about the product

Elobarate description about the product

Value of the coupon. Coupon value to be used as discount.

Alias of the discount

Total amount of the discount

Gross amount of the discount(Without tax)

Code of the discount

Value of discount.

Net amount of the discount

Title of the discount

Total amount of the discount

Set if the form field will be displayed in User Account edit form.

Possible options

1:Yes
0:No

Display or hide add to cart button for the group.

Possible options

1:Yes
0:No

Display or hide attributes for the group.

Possible options

1:Yes
0:No

Set if the form field will be displayed in billing form.

Possible options

1:Yes
0:No

Not used by PhocaCart anymore.

Display or hide price for the group.

Possible options

1:Yes
0:No

Not used by PhocaCart anymore.

Set if the form field will be displayed in shipping form.

Possible options

1:Yes
0:No

Net amount after discount is applied on ordered product.

Set count of days when the download will expire for a product.

Set download file for a product.

Tokenised folder name for downloadable product so the url to download file is not predictable

Number of times the downloadable product was downloaded.

Token for download so the path to file is not predictable.

Tax after discount is applied on ordered product.

Type of discount applied on ordered product.

European Article Number of a product

User email address

Contact Email of user ordered the product.

Set external product key

Set external link. If enabled in Options, external link will be displayed instead of Add To Cart button in PhocaCart.

Set external link 2. If enabled in Options, external link will be displayed instead of Add To Cart button in PhocaCart.

Set external link title. If enabled in Options, external link will be displayed instead of Add To Cart button and external link title is name for the button.

User fax

Set the product as a featured product.

Possible options

1:Featured
0:Not featured

Set featured product background image.

Features of a product.

• Original HP 643A Toner Cartridges deliver legendary HP print quality.
• - Depend on Original HP 643A Toner Cartridges designed specifically for your HP printer.
• - HP 643 toner cartridges work with: HP LaserJet 4700
• - 1 Black (~11,000 pages)
• - Original HP color printer toner cartridges tested produced, on average, 22% more usable pages than non-HP color cartridges

Image URL of a product.

Thumb image URL of a product.

Filter of the form field.

Field is not used in PhocaCart anymore.

Set the value to Y if the form field has to be deleted on import.

Set if the discount or coupon entitles the customer to get free payment.

Possible options

1:Yes
0:No

Set if the discount or coupon entitles the customer to get free shipping.

Possible options

1:Yes
0:No

Set height of the product.

Order history date. Date and time when order is modified or updated.

Set the number of hits the product or category has received

Set icon class for a category.

Set ID of form field. Not used anymore in PhocaCart.

Set an image for a product or category or manufacturer or user.

Set the order of the image. This is used incase of multiple images are imported.

Set invoice date. As default, invoice date is order date.

Set invoice due date. As default, invoice due date is calculated by days set in Phoca Cart Options.

Invoice number of the order

Payment reference number of a invoice.

Set invoice specific bottom description

Invoice has to be paid without any delay to avoid extra charges.

Set invoice specific middle description

Check the product details

Set invoice specific top description

Invoice of order

Set date of taxable supply (time of supply)

Ip address detail of user

International Standard Book Number of a product.

Set JAN (Japanese Article Number) of a product.

Set label of form field.

Set language of category or coupons or discounts or form fields or groups or manufacturers or orders

Last reset time of user

User last visted date and time

Set length of a product.

Set full path (including http:// or https://) of manufacturer's website.

Loyalty card number used when ordering - this is mostly in case of POS where vendors add loyalty card number of customer (who is not logged in).

Name of the manufacturer of a product

Maximum length of form field

Set the meta data for the category or product.

Set the meta description for a category or product.

Set the meta keywords for the category or product.

Set the meta title for the category or product.

Set minimal sum of purchases.

Set minimum multiple of ordered quantity of the current product. For example: If you set 6, then customers will be able to order 6 or 12 or 18, etc. products but not e.g. 15.

Minimum order quantity for product.

Set how minimum quantity of ordered products will be checked. If it will be compared to main product or to each product variation.

Modified time of category or product or order.

Set the user who modified the category or product last

Describes the manufacturer part number of a product

Name of the user.

Set degree of a user.

First name of the user

User last name

User middle name

Net amount of ordered product.

Set if newsletter will be activated for user when making an order in checkout view and checking newsletter checkbox.

This is specific description which can be displayed in specific part of order, invoice or delivery note documents in billing address.

This is specific description which can be displayed in specific part of order, invoice or delivery note documents in shipping address.

Set the ordering of category or product or coupons or discounts or form fields or manufacturers or orders or users.

Set unique order number for an order.

Set title of order status as language string.

Set order token for an order.

Total amount of an order.

Set which exchange rate of currency (in order) will be used. Order amounts are displayed with currency in which they were made. But in database, amounts are stored in default currency. When displaying order data, amounts are converted to currency which was set by placing an order.

There are three fields in order products table item_id, item_id_c and item_id_r.

order_total_item_id is the VAT tax id.

order_total_item_id_c is the VAT tax id based on country(extended tax id)

order_total_item_id_r is the VAT tax id based on region(extended tax id)

There are three fields in order products table item_id, item_id_c and item_id_r.

order_total_item_id is the VAT tax id.

order_total_item_id_c is the VAT tax id based on country(extended tax id)

order_total_item_id_r is the VAT tax id based on region(extended tax id)

Title of order total calculation.

Language string title of order total calculation.

Language string to be used as suffix in order total title.

Language string to be used as suffix 2 in order total title.

Order total type. netto or brutto.

one time emergency passwords

Two factor authentication key

Parameters of category or product or discounts or coupons or form fields or manufacturers or orders.

PhocaCart uses subforms to load all feeds at once and to store them only to one column in product table Example: Plugin zbozi_cz plugins\pcf\zbozi_cz\models\forms\item.xml is linked by dynamically created form in administrator/components/com_phocacart/models/phocacartitem.php in preprocessForm() function. In preprocssForm PhocaCart builds the XML Form inclusive the subform XML of all feed plugins. That is stored in params_feed column.

Payment params stored in orders table.

Shipping params stored in orders table.

password for user login

Set pattern of a form field.

Alias name of payment method.

Currency used in payment

User phone number details

User phone number details

User mobile phone number details

Image URL of a product.

Thumb image URL of a product.

Set number of points which are needed to buy a product.

Set number of points the buyer receives for purchasing a product.

Set predefined values. Separate each value with comma(,). Note that all values must match the type set in the Type parameter.

Set the title for the first option in select box. It is usually 'Select ...'.

Set icon as prefix for a form field.

Set price of a product.

Set original price for a product.

Set price with tax for a product.

Has privacy policy been agreed or not

Possible options

1:Yes
0:No

Gross amount of ordered product.

Product can have attributes and values or combination of all the attributes. These different attributes are stored in key, so each product variation is identified by this key.

Net amount of ordered product.

Set URL of the product where product details are explained

Set public download file. This file is accessible for all in frontend. For example, it can be used for downloading free product user manuals

Title of the public download file.

Set public file to play.

Set the state of the item.

Possible options

1:Published
0:Unpublished

Field not used by PhocaCart anymore.

Set the number of items from which the discounts or coupons will apply.

Set the number of items to which the discounts or coupons will apply.

Set queue number. Format of this number is set in Phoca Cart Options.

If the form field is read only field or not

Possible options

1:Yes
0:No
2:Yes For Registered Users, No For Guests

Set receipt number for an order

Not used by PhocaCart anymore. it was prepared for specific shipping plugin.

Not used by PhocaCart anymore. it was prepared for specific shipping plugin.

Not used by PhocaCart anymore. it was prepared for specific shipping plugin.

Region name for order address

Region 2 letter code for order address

Region 3 letter code for order address

Region name for order address

Date user registered on site

Set registration key of a product

Set if a form field is required or not.

Possible options

1:Yes
0:No

Require user to reset password on next login

Possible options

1:Yes
0:No

Count of password reset since last reset time

Number of rows for textarea form field

Set how many times the product was viewed. This number is automatically created based on the number of product sales

Send email to Joomla user

Possible options

1:Yes
0:No

Set serial Numbe for a product

Set alias of shipment method so to find the shipping id and assign it to the order

Size of the form field

RO CSVI custom field to skip a column

Stock keeping unit value of a product

Set amount of available products in stock

Set how stock will be checked. Set whether it will be compared to main product or to each product variation. Supported values are 0-Main product, 1-Product variations, 2-Advanced stock management 3-Advanced stock and price management

Tax rate for ordered product

Set tax calculation method. Set if the price (which is added to a product) includes tax (Brutto) or it does not include tax (Netto)

Gross total amount for Tax recapitulation

Net total amount for Tax recapitulation

Different type of VATs can be extended through country TAXES

Different type of VATs can be extended through region TAXES

Tax recapitulation title

Language string to be used as title for Tax recapitulation

Language string to be used as suffix for Tax recapitulation

Language string to be used as second suffix for Tax recapitulation

Set type of tax recapitulation. Either it is rounding or trcrounding or brutto

If user accepted terms for an order or not

Title of User

Set title or ID of external XML feed server category which is assigned to this category

Total amount of coupon or discount

Order shipped date

Along with tracking_title and tracking_link_custom these are items for storing information about tracking the packet.

Along with tracking_description_custom and tracking_title these are items for storing information about tracking the packet.

Order tracking number

Along with tracking_description_custom and tracking_link_custom these are items for storing information about tracking the packet. NOT USED BY PhocaCart for now.

Type of category or coupon or discount or formfields or groups or orders or products or users

Specific type of product category used in XML feed (for example by Google products: g:google_product_category)

Phoca Cart has few predefined form fields (default types) not created by user but created when installing Phoca Cart. Set this field value to 1 says the form field is a predefined field. If the field value is set to 0 then it means form field was created by user.

specific type of products used in XML feed (for example by Google products: g:product_type)

If the form field is unique

Unit for price of a product

Unit for size of a product

Unit value of a product

Unit for volume of a product

Unit for weight of a product

Universal product code of a product

Group name which user belong to

Login name of user

Name of an HTTP user agent

Joomla user group of the user placed the order

Language to generate document for user

16 digit random token for a user for an order

If the form field should be validated. Check if value is required or not.

Date time from which coupon or discount are valid

Date time till which coupon or discount are valid

In some countries there are two different identifications numbers for the firm, so this is standard VAT number of the firm

Second identification number for a firm.

if the user is VAT payer and the VAT was checked. Mostly used if the user is a company.

Email of the vendor

Video of the product

Specifies the weight of the product

Specifies the weight of the product

Specifies the width of the product

Zip code of user