WooCommerce prices location in DB

All the data like different prices of a product custom post type are store (for each product) in postmeta table. To find the post id of all products you have to use this query on posts table: SELECT * FROM ‘posts’ WHERE ‘post_type’ = ‘product’ For each product id (post_id), you can retrieve all related … Read more

How to modify navigation menu of the “My Account” page in WooCommerce

For that, you do not need to modify the woocommerce/templates/myaccount/navigation.php. The best way to customize the “My Account” navigation menu items is to use: woocommerce_account_menu_items filter hook to add new items to the menu. array_slice() to reorder them the way you want. This way, by using woocommerce_account_menu_items filter hook, you integrate perfectly your own items … Read more

How do you access the Product Short Description in a WooCommerce email template? [closed]

I finally tried using var_dump() on $item and $_product, which are both used in the email-order-items.php template. $_product revealed a post object, which itself has a post_excerpt property, which looks like it holds the contents of the “Product Short Description” from the WooCommerce product form. So, to add the description beneath the item name, I … Read more