I want to get all woocommerce product name with their prices and want to show to a custom core php file which is not a wordpress.

Note: I have successfully connected to the woocommerce project's database i need custom sql query to show all woocommerce products on my core php homepage.


WooCommerce stores the product data as custom post type. You find the data in the wp_post and wp_postmeta table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.