> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://staging.chrisp.chat/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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_.

|  |
| 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.

1. Open class-install.php in the inc folder of the plugin.
2. Go to line 16, looks like that:

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

3. 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' ) );****

4. Save the php file.

Now when you deactivate the plugin, all your created Fancy Products etc. will be deleted.