[Libin V Babu]

Got it.

$product_name = $wpdb->get_results( "SELECT * FROM wp_wp_eStore_tbl WHERE id ='$product_id'");

foreach ($product_name as $row)

{

echo $row->name;

}

Its working fine. Hope the usage is correct.

[Libin V Babu]

Thank you so much. That was really helpful. Now it is working.

I got the code to call the “add to cart” button from that topic.

<?php echo get_button_code_for_product($product_id); ?>

I wants to include the products details at different places in my template. So How can I display a product’s name, price, availability separately with the product_id?

I tried to do this:

$product_name = $wpdb->query($wpdb->prepare( "SELECT name FROM wp_wp_eStore_tbl WHERE id ='$product_id'"));

echo $product_name;

But it is not working.

[Libin V Babu]

Hey, Thanks admin. I just edited the function “function show_wp_eStore_fancy3” inside the eStore-extra-shortcodes/shortcode_include.php

I made 3 changes there. changed the price variable to “$show_price=0”. Also commented the below lines.

$output .= '<div class="eStore-fancy3-price-tag"><strong>'.ESTORE_PRICE.': '.print_digi_cart_payment_currency($ret_product->price, WP_ESTORE_CURRENCY_SYMBOL, ".").'</strong></div>';

$output .= eStore_extra_show_button_based_on_condition($id,$ret_product,$button_type,$restriction);

Now there is thumbnail and product name only. Will this tweak affect any other function? Just let me know.

Thanks once again.

[Libin V Babu]

Yeah… Thank you. I just found that shortcode. Its almost close to what i need. Can we do a little bit tweak in code just to display the thumbnail and name only?

[Libin V Babu]

Ok Thank you. I just handled it using eStore Categories.

[Libin V Babu]

Can I use wordpress “sub-categories” for eStore?

I need to list main category in the main page and need to list the sub category in sub page. Is it possible?

[Author]

Posts