After the database feature is enabled, content management provides a visual interface to edit, update, and maintain the data in your data tables.
The system provides two types of data tables:
Pre-built data table: For common use cases like blogs and product showcases, the system offers ready-to-use features such as article management and product management.
AI-powered custom data table: Describe your business needs in natural language, and the system automatically generates a dynamic data table schema for your business functions. You can then preview, edit, and maintain content to meet evolving business requirements.
Article management
Create and manage articles displayed on your website, such as company news, blog posts, and industry updates.
View and filter articles
On the article management page, find articles in the following ways:
Search for articles: In the search box above the list, enter keywords from the article title to run a fuzzy search.
Filter articles: Filter by article category, status (published/unpublished), or modification date range.
Batch operation: After selecting multiple articles, the only supported batch operation is Delete.
Add and edit articles
On the article management page, click Add article, or click Edit in the actions column for an existing article.
Fill out or modify the article's information.
Parameter
Required
Description
Cover image
No
Upload a cover image for the article. You can upload from your computer or select from your assets.
Article title
Yes
The title of the article, which serves as its primary identifier.
Article summary
No
A brief summary of the article, typically displayed in list views.
Article category
No
Select a category for the article. Only single-level categories are currently supported.
URL alias
No
Customize the URL path for the article.
Article details
Yes
Use the rich text editor to compose the body of the article.
After editing, perform one of the following actions:
Save: Saves the current content with an unpublished status. The article is not displayed on the live website.
Publish now: Saves the content and immediately publishes it to your website. The status changes to published.
Publish and unpublish articles
Articles can have a status of published or unpublished. You can change the status directly from the Status column in the article list:
Publish: Click the Publish button to make an unpublished article visible on your website.
Unpublish: Click the Unpublish button to hide a published article from your live website. Its content is retained in the admin console.
Delete articles
Remove articles that are no longer needed.
In the article list, find the article and click Delete in its actions column.
In the confirmation dialog box, click OK. The article is moved to the Recycle Bin.
Items in the Recycle Bin are automatically and permanently deleted after 30 days and cannot be recovered. To restore an article deleted by mistake, restore it from the Recycle Bin promptly.
Product management
Create and manage product or service information on your website. The process is nearly identical to article management.
On the product management page, click Add product, or click Edit in the actions column for an existing product.
Fill out or modify the product's information.
Parameter
Required
Description
Cover image
No
Upload a cover image for the product.
Product name
Yes
The name of the product.
Product summary
No
A brief summary of the product.
Product category
No
Select a category for the product. Only single-level categories are currently supported.
Product price
No
Set the product price (unit: CNY).
Rule: The price must be greater than 0 and have no more than two decimal places.URL alias
No
Customize the URL path for the product.
Product details
Yes
Use the rich text editor to write a detailed product description.
After editing, click Save to save the content as a draft, or click Publish now to publish it to the live website.
AI custom data table
When the pre-built article management and product management features do not meet your business needs, you can use the AI to create a custom data table.
For example, if you need an "Offline Stores" list with fields like "Store Name," "Address," "Phone Number," and "Business Hours," you can create it with this feature.
Create an AI custom data table
Provide a prompt: In the chat conversation, clearly describe the data table schema you need.
Example 1 (Create a store table): "I need a store list that includes store name, address, phone number, and business hours."
Example 2 (Create a course table): "Help me create a course table with five fields: course name, course summary, instructor, price, and start date."
Generation: Based on your description, the system automatically generates a corresponding data table and its management interface under the Content Management menu.
Manage a custom data table
Once created, the data table appears in the left-side menu under Content Management. You can then describe new requirements in the left-hand chat panel to adjust the table.
Linking content to frontend pages
Content managed in the admin console (such as articles, products, and custom data) must be bound to a component on a frontend page to be displayed.
Bind a data source: In the page editor, select an "Article List," "Product List," or a custom data table as the data source. For detailed instructions, see Select Data Source.
Best practices
Plan ahead: Before entering content, plan the data structures you need.
For example, an education website might need a "Course Table," "Instructor Table," and "Article Table." You can use the AI-powered custom data table feature to create the "Course" and "Instructor" tables, and use the pre-built article management feature to publish educational news.
Use AI effectively: Use clear and specific prompts when interacting with the AI. Clearly state the name of the data table you want to create in your prompt, and the system will add it automatically.
For example, instead of saying, "I need a list," say, "Help me create a course table with five fields: course name, course summary, instructor, price, and start date."
Maintain regularly: Periodically use the Filter feature to review drafts that have been unpublished for a long time. Use a batch operation to Delete them, which moves them to the Recycle Bin and helps keep your admin console organized and efficient.
FAQ
How to switch to pre-built tables
If you created a custom product or article table using AI, we recommend switching to the system's pre-built product management and article management features. The pre-built tables are optimized for these common scenarios, offering more complete field settings and a better user experience.
You can send the following prompt to the AI in the chat, and the system will automatically make the switch:Use the article/product table and article/product category table from supabase-ddl/assets/cms_tables.sql to replace the current article/product and article/product category tables in the database. Synchronize the data from the old tables to the new ones, and align the columns of the article/product table with the schema in supabase-ddl/assets/cms_tables.sql by modifying its columns.