Overview
| Excerpt |
|---|
Information-rich product pages can help drive sales. But sometimes, not all the desired data are provided by your ERP. No problem. You can add custom fields to product and category pages as part of product maintenance. |
Uses for custom fields might include:
- product or category-related freight information for oversized items
- special features or benefits, such as certification logos.
...
The Custom Fields features lets you add non-standard fields from these database tables: Articles, Banners, Categories, Products and Users. |
| Info | ||
|---|---|---|
| ||
'field' is a database term. All the bits of information that your website uses are contained and managed in a database dedicated to your business. In this database, information is organised in a collection of tables. A table is a container for data of an identified function or feature your website needs. Some examples are Users, Products, and Orders. Think of the table as organised in a spreadsheet, with columns and rows. A column contains a data type relevant to that table. For instance, the 'Users' table will come with many standard columns - Email Address, User Name, Role, etc. When you read a row, you are looking at information ('a record') for an specific user. You can also think of a column as a field. Custom fields are fields that are not used or created in a standard version of the Customer Self Service eCommerce Platform. |
We recognise that your website may benefit from adding custom fields that are important to your business needs. You can add custom fields to certain tables in the CMS:
- Articles
- Banners
- Categories
- Products
- Users
The process for adding custom fields is simple:
- Identify the table you want to create a custom field for. (A table groups a set of related data. For example, 'Products' data make up a table, 'Categories', another, etc.)
- Create the new custom field for the table.
- Edit a table's record to include the new data.
- Add the new product field widget to the Product Detail and/or Product List templates.
Step-by-step guide
1. Create a New Custom Field
- In the CMS, navigate to Advanced Content → Custom Fields.
- Select the table you wish to add your custom field to (e.g. Categories, Products, Users).
In this example, we'll add our field to the Products table.- The page will load, displaying any existing custom fields for the table you selected.
- Click the Add New Custom Field button.
- Populate the Custom Field Details as specified:
- Field Name - a code to associate with this field in the database. Alphanumeric only, with no spaces or special characters.
- Prompt - the field prompt/title which displays to Administrators on the Product Maintenance screen.
- Help - additional information which displays to Administrators on the Product Maintenance screen.
- Data Type:
- Text - alphanumeric characters, including spaces, special characters, and html.
- Integer - whole numbers
- Decimal - numeric data including fractional components
- DateTime - calendar dates and times
- Boolean - 2 values, e.g. True/False
- Allow Unlimited Text (for data type 'Text' only) - ticking this box removes the character limit from the field.
- Length (for data type 'Text' only) - where unlimited data has NOT been allowed, this sets the maximum field length.
- Display Type - the interface which displays to Administrators on the Product Maintenance screen. Options here will change depending on the Data Type selected earlier. Possibilities include TextBox, DropDownList, and DateTimePicker.
- Mandatory - ticking this box makes the custom field required in Product Maintenance.
- Active - ticked by default. Leave as is.
- Click Save to create the custom field.
...