Meta Box

Extended Data for WooCommerce Products

Support › MB Custom Table › Extended Data for WooCommerce ProductsResolved

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • August 29, 2018 at 8:54 PM #11169
    Jason RyanJason Ryan
    Participant

    Hello -

    I am just getting started with this plugin and so far so good. Before I go deeper into the rabbit hole on this project I am working on, I want to make sure I am setting things up correctly.

    I understand the need for Custom Tables for performance, but my question is this:

    I am adding custom meta boxes to build out a fully customized WooCommerce Product Page. I want this additional data to be stored with the Products themselves so that if they ever wanted to export all of their products, the additional information entered through the Meta Boxes is also exported with the main product data.

    Would storing the Meta Box data in a separate db table keep the relationship with each product ID it was entered on, or is that relationship between the Product and the Meta Box data separated due to being in separate tables? Whats the best approach to something like this?

    Any insight would be much appreciated. Thanks.

    September 1, 2018 at 2:31 PM #11212
    Anh TranAnh Tran
    Keymaster

    I have answered these questions via email. I'll post them here in case anyone has a similar problem:

    Would storing the Meta Box data in a separate db table keep the relationship with each product ID it was entered on

    The answer for this is YES. There's a relationship between the products (posts table) and the custom table. Technically, the value of the custom table's ID column = product (post) ID.

    Whats the best approach to something like this?

    If what you meant is exporting the data in the custom table when using the export functionality of WordPress, then I have to say it's not supported. WP export feature seems to be limited to custom fields that stored in the post_meta table only.

    I have no good solution for this at the moment, as the task of exporting and importing data from custom table along with the product data seems to be complicated. It's best to use some tools or plugins to export the whole database to SQL file. But I guess it's not what you want.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.