Moving custom fields' data to custom tables

WooCommerce
8 April, 2023 00:19:18
eliodata
Topics: 16
Messages: 49
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
8 April, 2023 01:37:39
E2Pdf
Support
Topics: 7
Messages: 3335
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!