...
Note |
---|
As a Table Maintenance solution is always custom, consultation with Commerce Vision is required to implement this feature. |
Table of Contents |
---|
Overview
Multiexcerpt | ||||
---|---|---|---|---|
| ||||
Implement and maintain custom tables and fields for custom business functions or projects on your website. |
As you may know, much of the The content published on your website, whether for products, users etc, are stored as records in database tables. Each record contains data organised across several fields. Certain tables and fields come standard for functions and features of your Customer Self Service eCommerce Platform website. For instance, product details are stored in a table with specific fields for description, images, product code, and so on. Your site may already be using some non-standard (custom) fields and field groups for some pages. These may have been created in the CMS or integrated from the ERP. Here are some examples: a warehouse field to add warehouse info for products in product maintenance, a toggle field to enable/disable user access to a business sensitive custom database like a price book.
What if your business wants to be able to maintain an entire non-standard table online? This is what the Table Maintenance feature caters fordoes. It provides a simple integrated way to create and maintain custom tables in the CMS. What a custom table is for depends on your specific business needs! It could be a table from the ERP that certain staff can access and edit online, such as an existing price book. Or the price book could be a completely new table that will be maintained and accessed entirely online. Both possibilities and more can be custom Table Maintenance solutions.
...
Search List page | Record page |
---|---|
This is an example of the Search List page. When the custom table was set up, permission to add records was enabled. | This example is a record from our price book. Users with access can edit all fields since the Administrator has set them to editable. * indicates mandatory fields. |
Configure Table Maintenance Settings
NOTE - This guide assumes that Commerce Vision has configured the required custom tables and fields to be made available for selection in the CMS. In order to demonstrate the feature's functionality, the examples shown use generic fields.
...
Table Maintenance settings are configured by Administrators.
1. Enable Table Maintenance
- In the CMS, navigate to Settings → Feature Management → Advanced.
Toggle ON Table Maintenance to enable it in the CMS. (If you have any tables set up already, they will now be visible in the CMS navigational menu.)
- Click Configure.
- In the Table Maintenance Features Settings screen, toggle ON Enable Table Maintenance to switch on Table Maintenance on your site and enable Table Maintenance settings.
- To save this setting, click Save or Save & Exit. Table Maintenance is now enabled in the CMS and on your website.
2. Create and configure a table
NOTES - Table Maintenance must be enabled (Step 1). Available tables from the ERP have been flagged for editing only by Commerce Vision. They cannot be created or deleted.
...
Once your tables have been set up as you want them, its records can be accessed via the CMS navigation menu.
Allow a CMS User access to Table Maintenance
Administrators can specify which CMS Users can access to Table Maintenance. This is based on Role settings.
...
Refer to the CMS User guide for help in setting a Role for a CMS User,
Additional Information
Multiexcerpt | ||||
---|---|---|---|---|
| ||||
-- |
...
Minimum Version Requirements |
| |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Prerequisites |
| |||||||||||
Self Configurable |
| |||||||||||
Business Function |
| |||||||||||
BPD Only? |
| |||||||||||
B2B/B2C/Both |
| |||||||||||
Ballpark Hours From CV (if opting for CV to complete self config component) |
| |||||||||||
Ballpark Hours From CV (in addition to any self config required) |
| |||||||||||
Third Party Costs |
| |||||||||||
CMS Category |
|
Related help
Content by Label | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...