[Plugin: Wp-e-commerce] Pagination for products not working

Just to make this a little easier when I use [wpsc_products category_url_name=’retro-cards’] or [wpsc_products category_url_name=’kids-cards’] etc etc these category specific page don’t display pagination where as the default product page [productspage] works fine with pagination.

Please help guys, I’m desperado!

Oh, I figured this darn thing out. Pretty good thing as I’ve search for help on this for days.

Anywayz, for anyone who may stumble across the same problem, here’s a solution –

In order for pagination to work on the category specific product pages i.e when you use [wpsc_products category_url_name=’yourproductname’] to call the products on another page other than the default product page, make sure the name of your category (created through wp ecommerce settings) matches the name of the page you are calling the products.

Example if you create a product group called magicians in wp ecommerce, make sure the page you display [wpsc_products category_url_name=’magicians’] is also called magicians and not magicians5 or something else.

I use custom permalinks /%category%/%postname%/ – I’m not sure if this makes a difference but there you go.

Sorry, I don’t know how to explain this better but if anyone needs help just PM me.

For those of you who land on this – follow batikandgift’s suggestion above

Found the solution,

Under wp_options table search for option_name = wpsc_category_url_cache
delete its contents and hopefully your pagination & categories link will be back to normal.

For those of you who don’t have a clue what he is on about (you were a few on here i see), you access your MySQL, then extend you database by clicking on it, and click on wp-options table.(literally) Then find
wpsc_category_url_cache in the option_name list. Click on the pencil to edit and empty the information in the comment box.
This just fixed things for me.
Good luck!

Pfffff, beppemarchetti it worked for me, thanks so much!

I have exactly the same issue that batikandgift had — double URL is causing a 404! BUT, i don’t have dufferent categories — all products are together. I therefore do not have a “wpsc_category_url_cache” in my DB and am at a complete loss as to how to proceed. I have tried de-activating and then re-activating wpsc to no avail. I’ve “fixed products URLs” , turned-off custom permalink structure.. nothing foxes this. Instinct does not respond. Re-installing the plug in will be a last resort as I will have to completely re-build the #$%^ store!

anyone?

Vezy – do you think there is a similar url cache for set-ups that do not use separate categories for the products?

batikandgift fix does the trick! I wasn’t at first able to find DB DB row with “wpsc_category_url_cache” — simply beacuse i didn;t se that there were more than one page to the table (!). Mine has 10 pages — row 803 held this value. Follow Vezy’s advise and erase the values in the comments block … btw, mine looked like:

a:3:{i:0;s:0:””;i:4;s:14:”lessons-on-dvd”;i:3;s:22:”lessons-for-ipodiphone”;}

you can try [wpsc_products category_url_name=’categoryname’ number_per_page=’10’]

Still having problems after reading all of your help:

Please check out here: https://www.luxembourgartistsforhaiti.lu/products-page/

I get “There are no products in this group.” ??

That’s the main products pagee – you shouldn’t need a shortcode to show products there.

How many products have you added in the admin area? What categories have you added them in, and what have you got set for “Select what product group you want to display on the products page” (Under Products >> Settings >> Presentation >> Product Page Settings)

Hi Lee, thanks for your quick response ??
OK, I took the shortcut away from the page again.

I have two products, a T-shirt and a cap and I have created under the categories group two new categories named tshirt and cap and I have selected (just now) all products under Product Page Settings – because it was on “exaumple brands” before…

But now, even the sentence:”here are no products in this group.” has disapeared and nothing is showing ??

Hi Lee again, It is showing now BUT I have a style problem and the products are way down there after scrolling a mile … puh!!! At least it IS working now and I have to find my styling Problem now :-/ … one problem at a time ??

I had this problem also, all i had to do was change my custom permalink to /%category%/ and that fixed my error with the pagination not going to the correct place

HI FRIENDS…
I have a problem, i hope you can help me.
when i click in the category link of products,I can’t see my store if i am logout, but if i am registred all work fine.
some one help?

Sheesh – 4 different posts across two sets of forums …

ALIENIGENA777 I’ve replied on the getshopped forums here:

https://getshopped.org/forums/topic.php?id=9395&replies=5#post-36733