There are no product-specific tables in the database

  • However, they disrespectfully deleted my comment. And they gave the excuse that it was a support request and it wasn’t. It was just a comment, but I will write it differently as a comment again. Until this time, they have no excuse to delete it. This is not a proper global team approach. Your disrespect will not be forgotten.

    one of the biggest weaknesses of this system is that there are no specific product tables in the database.
    Everything is mixed and the products are stored among the default WordPress post types. Products are stored in the same posts and pages, and this is not true. It should not be like this.
    This causes the speed to decrease and there is no direct and easy access to the tables. It also makes scalability or migration difficult.

    Also, if the users of this system have many products and posts on the site, they face a significant decrease in the loading speed of the site, they also do not have access to the tables, and everything becomes confusing and complicated. This makes it very difficult even when they want to write a dedicated plugin, or develop a plugin.

    This wrong approach existed from the beginning and is still continuing, if this wrong path is not stopped, it will continue and make the work harder and harder every day. This is something that should be paid attention to.

    I will give some examples. It needs separate dedicated tables like this.

    wc_products
wc_product_attributes
wc_product_attribute_values
wc_product_downloads
wc_product_relationships
wc_product_variation_attribute_values

    This is a topic that WooCommerce developers know, but because of laziness and hard work; They run away from it with different excuses!

Viewing 1 replies (of 1 total)
  • Plugin Support Sandip Mondal – a11n

    (@sandipmondal)

    Hi @paulvek,

    Thank you for sharing your concerns regarding the current structure of product data storage within WooCommerce and its impact on website performance, scalability, and ease of development. Your feedback is invaluable as it helps us understand the areas where WooCommerce can improve to better meet the needs of our users.

    We understand that moving away from using the default WordPress posts and postmeta tables for products represents a significant change. This is not only a considerable undertaking but also one that we approach with caution to avoid causing disruptions for businesses, developers, and the whole community who rely on WooCommerce.

    I see you have started a discussion on our GitHub repository as well. In that thread, our developers have shared insights into the complexities of implementing a new system for product data storage, similar to the High Performance Order Storage (HPOS) project. Introducing a change of this magnitude requires careful consideration of its impact on the entire WooCommerce ecosystem, including the need for stakeholders to update their code for compatibility and the potential increase in support queries during the transition.

    Moreover, we’re aware of the risks such changes could pose to merchant operations. Our priority is to ensure that any new solution we introduce is not only performant but also integrates seamlessly with existing WooCommerce stores without disrupting business operations.

    The decision to embark on this project will be based on a thorough understanding of the specific challenges our users face, as well as the potential benefits of the proposed changes.

    Please continue sharing your experiences and the specific issues you encounter. Detailed insights into the problems you’re facing, especially at different scales of operation, will greatly assist us in identifying the most effective solutions.

    As mentioned in our GitHub discussion, we’re committed to engaging with our community to explore all possible avenues for improvement. While we don’t have an immediate solution on our roadmap, please rest assured that your feedback is being taken seriously and will play a key role in our ongoing discussions and planning for future updates to WooCommerce.

    We appreciate your understanding and patience as we work towards enhancing WooCommerce’s functionality and performance!

Viewing 1 replies (of 1 total)
  • The topic ‘There are no product-specific tables in the database’ is closed to new replies.