I need to output product data from SQL to a CSV file. I have created an example file showing the fields that need to be exported.
I have marked the cells on the spreadsheet, to show where the data needs to come from.
Green = wp_posts
Yellow = wp_postmeta
Red = wp_woocommerce_order_items
The Task:
• Write SQL query in PHP that prints data on the screen in table format
• JOIN data on [login to view URL], wp_postmeta.post_id, wp_woocommerce_order_items.order_id
• Add an export to CSV button that downloads the table of data
• Data from "wp_woocommerce_order_items" if "order_item_type" is equal to "line_item" then print the value from the column "order_item_name". If there is more than one item, each item should be printed in a new column.
• Data from "wp_posts", print all columns
• Data from "wp_postmeta", print the value from "meta_value" for all "meta_key" shown in the example excel file.
• Must be complete by 17:00 (Dubai time) Monday 16th November 2015
Hello, I understood your requirement and I can make the PHP script to export the data from SQL to a CSV file based on your requirements (basically export the products in woocommerce to a csv). I can complete it by this morning without doubts. Thank you.
$30 USD w 0 dzień
5,0 (41 opinii)
4,9
4,9
2 freelancerzy składają oferty o średniej wysokości $43 USD dla tej pracy
Hello sir
I am interested in this project
i have 3 years experience in
PHP/MYSQL
framework codeigniter cakephp
javascript JQUERY jquery ui ajax
i can help you
ready to start