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 ?