Relevant data in MySQL database

Modified on Wed, 25 Nov 2020 at 12:23 PM

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.