Moving custom fields' data to custom tables

Help Desk ›› How to ›› Moving custom fields' data to custom tables

WooCommerce

April 08, 2023 00:19:18

eliodata

Topics: 19

Messages: 57

Hello,

My DB becomes quite huge and I would like to move custom fields' data to custom tables. Like explained here:
https://docs.metabox.io/tutorials/move-data-to-custom-tables/

I have many pdf templates using current custom fields and custom posts, some with woocommerce ordres or woocommerce products...
I guess I'll have to redo the mapping for those fields. Will e2pdf find them if they are saved into custom tables? Some of these fields are dynamic, for example:
[e2pdf-wp id="dynamic" key="first_name"][e2pdf-wc-product key="fsbdd_user_formateurrel" meta="true" index="0" parent="true"][/e2pdf-wp]
Will these fields always generate once saved in the custom tables?

Best regards

April 08, 2023 01:37:39

E2Pdf

Topics: 7

Messages: 3614

Support

Hi,

In most cases, E2Pdf is using default "get_post_meta" to get metadata from the pages/posts so if the default function will return the data as before it must work as expected but unfortunately we can't give any guarantees as we didn't do tests in the described scope, it requires tests.

The only thing that we are sure will not work correctly is "Visual Mapper" - it will not be returning all meta keys as it uses the default WordPress meta table to detect which meta is available for mapping, and if not keys there - they will not be visible under "Visuall mapper".

If you wish, you can do a copy of the website and move it to some test environment, try to migrate data to see if it will be any further issues. If you will need a "test" License Key for that staging website - feel free to contact us directly so we can provide it for you: https://e2pdf.com/support/contact

As an alternative, you can review optimization to WordPress page / posts revisions functionality: remove old and add some limit to WordPress revisions to save it in DB.

We remain at your service.

We would really appreciate your feedback at WordPress.org!

All trademarks, service marks, trade names, product names, and logos appearing on this website are the property of their respective owners. The use of trademarks such as Formidable Forms®, Forminator Forms®, Gravity Forms®, JetFormBuilder®, WordPress®, WooCommerce®, WPForms® and others is solely for identification purposes (nominative use) and does not imply any affiliation, sponsorship, or endorsement by the respective trademark holders.