Title: Export-Import Problem
Last modified: February 27, 2021

---

# Export-Import Problem

 *  Resolved [loopforever](https://wordpress.org/support/users/loopforever/)
 * (@loopforever)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/export-import-problem-2/)
 * Hello ,
    In the product export process, non-existent products are also included
   in the table. How can I delete this?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [Stef](https://wordpress.org/support/users/serafinnyc/)
 * (@serafinnyc)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/export-import-problem-2/#post-14108875)
 * Are you saying that products that are no longer on the site are showing up in
   the spreadsheet? If that’s the case you’ll have to enter the database and delete
   them manually.
 *  Thread Starter [loopforever](https://wordpress.org/support/users/loopforever/)
 * (@loopforever)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/export-import-problem-2/#post-14109733)
 * Yes. Exactly.
    What table can I find in the database?
 *  [Stef](https://wordpress.org/support/users/serafinnyc/)
 * (@serafinnyc)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/export-import-problem-2/#post-14110077)
 * Products are located mainly in the following tables:
 * wp_posts table with post_type like product (or product_variation),
 * wp_postmeta table with post_id as relational index (the product ID).
 * wp_wc_product_meta_lookup table with product_id as relational index (the post
   ID) | Allow fast queries on specific product data (since WooCommerce 3.7)
 * wp_wc_order_product_lookuptable with product_id as relational index (the post
   ID) | Allow fast queries to retrieve products on orders (since WooCommerce 3.7)
 * Product types, categories, subcategories, tags, attributes and all other custom
   taxonomies are located in the following tables:
 * wp_terms
 * wp_termmeta
 * wp_term_taxonomy
 * wp_term_relationships – column object_id as relational index (the product ID)
 * wp_woocommerce_termmeta
 * wp_woocommerce_attribute_taxonomies (for product attributes only)
 * wp_wc_category_lookup (for product categories hierarchy only since WooCommerce
   3.7)
 * Product types are handled by custom taxonomy product_type with the following 
   default terms:
    **simple** **grouped** **variable** **external**
 * Some other product types for Subscriptions and Bookings plugins:
    **subscription****
   variable-subscription** **booking**
 * Since Woocommerce 3+ a new custom taxonomy named product_visibility handle:
 * The product visibility with the terms exclude-from-search and exclude-from-catalog
   
   The feature products with the term featured The stock status with the term outofstock
   The rating system with terms from rated-1 to rated-5 Particular feature: Each
   product attribute is a custom taxonomy…
 * Review [this](https://github.com/woocommerce/woocommerce/wiki/Database-Description)
   for further explanation.
 *  [Nicola Mustone](https://wordpress.org/support/users/nicolamustone/)
 * (@nicolamustone)
 * Automattic Happiness Engineer
 * [5 years, 2 months ago](https://wordpress.org/support/topic/export-import-problem-2/#post-14170633)
 * We haven’t heard back from you in a while, so I’m going to mark this as resolved–
   if you have any further questions, you can start a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Export-Import Problem’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [Nicola Mustone](https://wordpress.org/support/users/nicolamustone/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/export-import-problem-2/#post-14170633)
 * Status: resolved