Articles on: Developers

Relevant Data in MySQL Database

Chamevo Product Designer stores all customizable product data (products, categories, templates, etc.) in its own dedicated MySQL tables. All tables are prefixed with fpd_.

1. Database Tables

Table	Explanation
`fpd_categories`	Product categories created in Chamevo
`fpd_category_products_rel`	Linked products assigned to a category
`fpd_orders`	Orders made via shortcode (⚠️ not WooCommerce orders)
`fpd_products`	Chamevo products
`fpd_templates`	Saved templates
`fpd_views`	Product views

2. WooCommerce Orders

When an order is created in WooCommerce, the related Chamevo order data is stored in:

Table: woocommerce_order_itemmeta
Field key: _fpd_data

This ensures WooCommerce orders are linked with the product designer’s customization data.

3. User Accounts

If the option “Account Product Storage” is enabled for the Save action, customized products will be stored in the usermeta table.

Field key: starts with fpd_saved_product

This allows users to access and manage their saved designs directly from their account.

4. Deleting All Database Tables (Reset to Scratch)

If you want to delete all Chamevo Product Designer tables upon deactivation (reset everything), you’ll need to edit the plugin’s code:

Open class-install.php inside the /inc folder.

Go to line 16 — it looks like this:

//register_deactivation_hook( FPD_PLUGIN_ROOT_PHP, array( &$this,'deactive_plugin' ) );

Uncomment the line by removing the // at the beginning:

register_deactivation_hook( FPD_PLUGIN_ROOT_PHP, array( &$this,'deactive_plugin' ) );

Save the file.

Now, when you deactivate the plugin, all created products, categories, views, and templates will be permanently deleted.

Updated on: 04/11/2025

Was this article helpful?

Thank you!