If condition on product category with Wp-Ecommerce

bump

I am looking for the same thing

Bump

A reference for WP-ECommerce conditional tags would be suuuuuuuuuuuper handy!

how about this :

$wpsc_query = new WPSC_Query(array('category_id' => <the category id>));
<?php while (wpsc_have_products()) :  wpsc_the_product(); ?>
<-- BLA BLA BLA -->
<?php endwhile; ?>

or using this query :

$sql = 'SELECT ' . WPSC_TABLE_PRODUCT_CATEGORIES . '.id, name FROM '. WPSC_TABLE_PRODUCT_ORDER . ' ';
	$sql .= 'LEFT JOIN ' . WPSC_TABLE_PRODUCT_CATEGORIES . ' ON ' . WPSC_TABLE_PRODUCT_ORDER . '.category_id = ' . WPSC_TABLE_PRODUCT_CATEGORIES . '.id ';
	$sql .= 'WHERE product_id = ' . $product_id . '';

Hi Guys, hi Sulaeman, thanks for the feedback!

I tried your code in a page (content0.php), it goes like this:

<?php
$wpsc_query = new wpsc_query(array('category_id' => 8));
while (wpsc_have_products()) :  wpsc_the_product(); ?>
TRalala
<?php endwhile; ?>

Is this all right?

Here is the error message I have:
Fatal error: Class 'wpsc_query' not found in ...\wp-content\themes\default\content0.php on line 113

Again, thanks.

We’d love to close this topic guys, nobody can answer please?

I’d like to know the answer to this one also. The WP E-commerce documentation is very insufficient.

I would reall like to use this as well

I need to use that plugin but I’m really afraid. Documentation is really lacking and support forum hasn’t directly partecipation of plugin programmer.

I’m trying to translate base products_page.php loop, but it’s not so easy. Moreover I check a bug that we can’t add custom template for plugin ??

(version 3.7.5.3)

@tomasi514

WPSC_Query not wpsc_query, so

<?php
$my_wpsc_query = new WPSC_Query(array('category_id' => 8));
while (wpsc_have_products()) :  wpsc_the_product(); ?>
TRalala
<?php endwhile; ?>

I’ve to little questions for you, my saviors. I’ve wp ecommerce with gold cart.

• how may I print all subcategories of a selected category?
• how may I print all products of a selected category and all its subcategories

Thank you very much!

you can get all thoose code that you need at iCreativeLabs latest released wordpress free theme for wp-e-commerce at here https://bit.ly/dnU4Ky, which is developed by me.

it’s not a promotion, but i’m quite lazy to show the code ^_^

@sulaeman: it’s one of best thing I see for wp e-commerce, now I’ll try to check script I need. Now I can’t change theme, ’cause a graphic team is still working in it. I need only script for subcategories and query for list all products of a categories and its subcategories.

Thanks.

@sulaeman: hei man, thank you very much to address me to that template. I’m studying it and many of my troubles become features.
On little note: function libraries inside wp template are not very good. Can’t move them on plugin folder or plugin template folder?

Thanks.Thanks.Thanks.

[fix] In icl_utility.php I replace:
$new_prefix = sprintf($prefix, get_option('siteurl').'/products-page/'.$this->get_category_nicename($category['id'], TRUE))$;
with
$new_prefix = sprintf($prefix, wpsc_category_url($category['id'], TRUE));
so I can mantain the permalink (with subcategories structure).

If you are looking for a single product conditional tag try this: https://getshopped.org/forums/topic.php?id=8531.