Display MySQL data from WordPress / migrate Data two times a day into MetaBox

This topic has 1 reply, 2 voices, and was last updated 1 year, 11 months ago by Peter.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
December 9, 2022 at 8:20 PM #39644

Joo
Participant

Hello,
i'am using an Amazon Affiliate Plugin for WordPress/Woocommerce which is pulling data from Amazon products into the wordpress Database (like images, price, desciptions and all that stuff). I don't want to use Woocommerce because i want to create a new layout with all the data. So my idea is using Metabox + visual designer for that, but i need to update all data 2 times a day for the correct price.

1. Does someone know a solution to display mysql data, with a visual designer ( for beginners) ?
2. Is there a solution to copy two times a day the data from a wordpress table into a metabox table and keep it uptodate ? I only need the price field uptodate. Like a migration tool or something ?

greetings

Add New Note to this Reply

December 11, 2022 at 9:49 AM #39678

Peter
Moderator

Hello Joo,

Thanks for reaching out.

1. This question might need an answer from a page builder plugin, if you want to use a page builder, you can read more on this article https://metabox.io/best-wordpress-page-builders/

2. Meta Box saves the field value to the standard table of WordPress wp_postmeta, so it does not make sense to migrate data from WordPress to Meta Box.

If you are a developer, you can use the custom table and store the price field there. I recommend following our documentation
https://docs.metabox.io/extensions/mb-custom-table/
and this article https://metabox.io/move-custom-fields-data-to-custom-tables/
But please notice that, the builder will not work with the data stored in the custom table, you have to use the code to output the field value.

Add New Note to this Reply
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.