Relevant data in MySQL database
Fancy Product Designer is storing all data (customizable products, categories etc.) in own tables in the MySQL database. All these tables are starting with the prefix fpd_.
Table | Explanation |
|---|---|
fpd_categories | FPD Product Categories |
fpd_category_products_rel | The linked products to a category. |
fpd_orders | Orders made with shortcode. No WooCommerce orders! |
fpd_products | FPD products |
fpd_templates | FPD templates |
fpd_views | FPD product views |
WooCommerce
When an order is made with WooCommerce, the relevant order data of FPD is stored in a field with the key __fpd_data_ in the _woocommerce_order_itemmeta_ table.
User Account
When you enable the option "Account Product Storage" for the Save action, the customized product will be saved in a field _meta_key_ and starts with _fpd_saved_product_ in the _usermeta_ table.
Deleting all database tables to start from scratch
If you want to delete all database tables that are created by the plugin when deactivating the plugin, you need to uncomment one line of code.
- Open class-install.php in the inc folder of the plugin.
- Go to line 16, looks like that:
//register_deactivation_hook( FPD_PLUGIN_ROOT_PHP, array( &$this,'deactive_plugin' ) );
- Remove the first two trailing slashes to uncomment the line, so it looks like this:
register_deactivation_hook( FPD_PLUGIN_ROOT_PHP, array( &$this,'deactive_plugin' ) );
- Save the php file.
Now when you deactivate the plugin, all your created Fancy Products etc. will be deleted.
Updated on: 06/08/2025
Thank you!