Meta Box

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

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • December 9, 2022 at 8:20 PM #39644
    JooJoo
    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

    December 11, 2022 at 9:49 AM #39678
    PeterPeter
    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.

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