Loading guides

Preparing the right Knowledge Base content for this platform.

Loading Support Center

Preparing the latest guides, releases, and feature request updates.

WordPress database structure | Chamevo Support Center

WordPress database structure

Reference for all MySQL tables, columns, and WooCommerce meta keys used by the Chamevo plugin.

Updated April 29, 20265 min read

Chamevo stores product data, orders, print jobs, and configuration in custom MySQL tables prefixed with {wp_prefix}fpd_. WooCommerce customization data is stored in WooCommerce's own order item meta tables.

Custom tables

All table names use the WordPress table prefix (default: wp_) followed by fpd_.

fpd_products

Stores Chamevo product definitions.

Column	Type	Description
`ID`	BIGINT(20)	Primary key
`title`	TEXT	Product name
`options`	TEXT	JSON-encoded product options (overrides for global settings)
`thumbnail`	TEXT	Base64 or URL of the product thumbnail
`user_id`	BIGINT(20)	WordPress user who created the product (null for admin)
`type`

WordPress hooks and filters referenceComplete reference of WordPress action hooks and filters provided by the Chamevo plugin for customizing behavior.REST API endpoints (chamevo/v1)Reference for the Chamevo WordPress REST API — authentication, order retrieval, and print-ready file webhook.Custom CSS for the product customizerHow to style the Chamevo product customizer using CSS custom properties and the ::part() pseudo-element.Chamevo glossaryDefinitions for key Chamevo terms, concepts, and components used throughout the product and documentation.

Column	Type	Description
`ID`	BIGINT(20)	Primary key
`product_id`	BIGINT(20)	Foreign key to `fpd_products.ID`
`title`	TEXT	View name (e.g., "Front", "Back")
`thumbnail`	TEXT	View thumbnail image
`elements`	LONGTEXT	JSON or serialized array of canvas elements
`view_order`	INT	Display order of the view
`options`	TEXT	JSON-encoded view-level option overrides

Column	Type	Description
`category_id`	BIGINT(20)	Foreign key to `fpd_categories.ID` (cascade delete)
`product_id`	BIGINT(20)	Foreign key to `fpd_products.ID` (cascade delete)

Column	Type	Description
`ID`	BIGINT(20)	Primary key
`title`	TEXT	Graphic name
`options`	TEXT	JSON-encoded graphic options
`thumbnail`	TEXT	Thumbnail image
`designs`	LONGTEXT	JSON array of design element data
`parent_id`	BIGINT(20)	Parent ID for nested categories (0 for root)
`sort_order`	INT(11)	Display order within the parent

Column	Type	Description
`id`	BIGINT(20)	Primary key
`name`	VARCHAR(255)	Profile name
`data`	TEXT	JSON-encoded print profile settings
`created_at`	TIMESTAMP	Creation date
`is_master`	TINYINT(1)	1 if this is the master (default) profile

Column	Type	Description
`ID`	BIGINT(20)	Primary key
`customer_name`	VARCHAR(300)	Customer name
`customer_mail`	VARCHAR(100)	Customer email
`views`	LONGTEXT	JSON-encoded customization data (all views)
`created_date`	TIMESTAMP	Order creation date
`print_order`	LONGTEXT	Print-ready file data

Column	Type	Description
`ID`	BIGINT(20)	Primary key
`guid`	TEXT	Unique identifier used to match webhook callbacks
`details`	TEXT	JSON-encoded job details (order ID, item ID, Printful variant)
`data`	TEXT	JSON-encoded design data sent for export
`status`	TEXT	Job status (e.g., `pending`, `completed`)
`order_item_key`	VARCHAR(255)	The WooCommerce order item meta key
`created_at`	TIMESTAMP	Job creation date

Meta key	Type	Description
`_fpd_data`	JSON	The complete customization data (product JSON, views, elements)
`_fpd_printful_options`	JSON	Printful-specific options selected by the customer
`_chamevo_product_thumbnail`	Text	Base64-encoded thumbnail of the customized product
`_fpd_printful_order_dashboard_url`	Text	URL to the Printful order dashboard (set after Printful order creation)

// Handles both legacy 'fpd_data' and current '_fpd_data' meta keys
$data = chamevo_wc_get_order_item_meta($item_id);

Meta key	Type	Description
`_fpd_printful_order_data`	Array	Printful order response data
`_fpd_printful_order_request`	Array	Printful API request payload (useful for debugging)

Option key	Description
`chamevo_api_token`	REST API authentication token
`chamevo_*`	Individual plugin settings (one row per setting)

Meta key pattern	Description
`fpd_saved_product*`	Saved customization designs per user

Function	Purpose
`chamevo_wc_get_order_item_meta($item_id)`	Get customization data from a WooCommerce order item (handles legacy meta keys)
`chamevo_has_content($post_id)`	Check if a post has Chamevo products assigned; returns content IDs or `false`
`is_chamevo_product($post_id)`	Check if a post is a Chamevo-enabled product (fires the `chamevo_designer_enabled` filter)
`chamevo_get_option($key)`	Get a Chamevo plugin setting value

Loading guides

Loading Support Center

Loading guides

WordPress database structure

Custom tables

fpd_products

Related articles

fpd_views

fpd_categories

fpd_category_products_rel

fpd_designs

fpd_print_profiles

fpd_pricing_rules

fpd_user_interfaces

fpd_orders

fpd_print_jobs

WooCommerce order item meta

WooCommerce order meta

WordPress options

User meta

PHP helper functions