You can use (according to docu over @wp-ecommerce) global $wpsc_query; to modify your query.
Resetting the loop can be done with wpsc_rewind_products(); right before the second call to while (wpsc_have_products()) : wpsc_the_product();
For the final solution, pls read the comments below.
Related Posts:
- WP-e-Commerce Adding A Product via Flash Button
- wp-e-commerce plugin – custom payment option
- WP ecommerce – How do I change the product image for each product variation?
- wp-e-commerce plugin – Second Test Gateway payment option [closed]
- How to edit products page of wp ecommerce plugin?
- Permalink issue only with numbers [closed]
- Code not looping over all products of a given category
- How to change the layout of a product page
- style being attatched to tag from outside of style sheets
- Arrays not working on a WP-Ecommerce product page [closed]
- Existing Ecommerce plugins with Custom Post Types [closed]
- Limit the number of results from wpsc_start_category_query
- How to sell an album for download
- Can WP ecommerce collect card info without charging?
- WPSC how do i output product per category on one page (wpsc-product-page)
- How to charge shipping in WP e-commerce based on a variant? [closed]
- WP-E Commerce: How to let user leave a personal message/instruction with each product from the products page [closed]
- Why does the first page of one category redirect to empty page 4?
- How to Match Orders to User Sessions in WPeC
- WP Ecommerce, Gold Cart and pagination
- How to organize products by collections with collections description?
- How to randomly generate products pop-up on click in store
- WP e-Commerce hook after creating order?
- WP E-commerce and Display Fancy Purchase Notifications
- insert order number into wp ecommerce order confirmation email
- Switching off shipping in WP-eCommerce
- Change how WP e-Commerce calculates price total at checkout [closed]
- In what files I can change country names of wp-ecommerce plugin? [closed]
- how to get extra info from checkout in wp-ecommerce
- how to get tax percentage in wp-ecommerce
- Sell photos through WordPress [closed]
- Where the variations are stored in the database when using wp-e-commerce plugin? [closed]
- shortcode outputs first before the page content [duplicate]
- remove missing image attachments
- Mysql Query to Delete Duplicate WordPress posts?
- Copy one CPT to another one in WordPress
- Real time Duplicate title check
- WordPress eCommerce plugin for books
- How to avoid duplicate posts on front page?
- What are WooCommerce starter themes? [closed]
- WP-e-Commerce and W3-Total-Cache integration problem [closed]
- Need Help Finding a WordPress E-Commerce Plugin That Utilises Custom Post Types [closed]
- All permalinks go to products page with WP E-Commerce plugin?
- How to change title tags on paginated posts?
- Copying Custom Meta Values from existing post to a duplicate post
- Is there any site where i can found good documentation of wp-ecommerce plugin?
- WP e-commerce: getting products by SKU
- How do I Import an RSS feed as WordPress posts without duplicates?
- Best way to prevent post duplication when using multiple loops
- How to show large image in checkout page using WP Ecommerce plugin [closed]
- modify a function filter
- MarketPress vs. other WP ecommerce solutions [closed]
- Prevent duplicate post from dynamic multiple loops
- Help alphabetically sorting $terms from get terms(‘wpsc_product_category’
- WordPress Jquery Confliction with Plugin
- Auto-create a pretty permalink for a bunch of posts
- How to append unique numbers to new duplicated post titles/urls?
- How-to Change Content with location change?
- How do display simple page for printing product info? [closed]
- Where sales manager of WP-Commerce plugin?
- Duplicate posts when posting nulls in records in phpMyAdmin [closed]
- Custom MySQL Query with logic
- Ajax loading duplicate post
- Send email on Job Dispatched from WP e-commerce [closed]
- Custom post type and taxonomy – show related posts
- WordPress Network (MU): Copy Main Site to Sub-Site
- How can I find out what items a user has purchased? [closed]
- Bulk Custom Menu and Wp-Ecommerce
- How to prevent duplicate posts with wp_insert_post on single.php?
- WP e-commerce: How to select the shipping costs calculation method according to delivery location
- How-To add Custom field in WordPress wp-ecommerce Categories?
- How to copy posts from one site to another in real time (not multisite)
- Content duplication issue with dynamic URLs
- Multi row post list
- wp e-commerce group product by category [closed]
- E-commerce for wordpress [closed]
- Can the WP e-Commerce Plugin Support a Large Number of Products? [closed]
- E commerce on WordPress [closed]
- Making tags appear as an Unordered list instead of a ‘cloud’
- How can I post exact same post but with a few things changed? (with some sort of Automation)
- WordPress plugin Post Creation [closed]
- wp e-commerce – theme problem – why won’t it load wpsc-single_product.php? [closed]
- How to show Best Selling WP E-Commerce Products
- Is there a built-in function to duplicate existing posts?
- WordPress Subcategory Creates 2 urls for same page (serious issue)
- WP_Query offset is returning post from prevois loop
- The best way to store variable across different widgets
- Ecommerce Single Product Next Product Link
- Check for duplicate custom field value before running wp_insert_post
- Convert featured images into “product images”
- Hook functions for Wp e-commerce? [closed]
- SQL query – get ids – Advanced Custom Fields / WPeC
- WP-ecommerce : Change the price before inserting it into the cart
- WP-eComerce Advance Meta Tag data in descending order [closed]
- product export and import using xml
- Widget content turns up before title
- GetShopped Ecommerce: hide checkout form from customer until shipping country selected [closed]
- Custom product fields in wp e-Commerce plugin [closed]
- WP E-Commerce creating categories programmaticaly [closed]
- Using Amazon Book Gallery Plugins in WordPress [closed]