Shopp Support » Setting Up Shopp
Setting Up Shopp
- RSS feed for this topic
21 posts
- Started 8 months ago by milomade
- Latest reply from Adam
Status
This topic is
resolvedTags
plugin ecommerce for wordpress
plugin ecommerce for wordpress
Shopp Support » Setting Up Shopp
resolved
Latest Products not showing up on shop homepage
Profile
My shop can be found here: http://www.milomade.co.uk/blog/shop/
I'm using <?php shopp('catalog','new-products','show=6&controls=false'); ?> to show the latest new products. However I just get the same 6 products each time I visit, despite adding new items to my shop. It seems to be showing the first 6 items I added a few days ago.
Whay won't it update to show the newer items?
Profile
I keep getting these lines showing up in the error log:
# 2009-06-26 13:22:45 - DB: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 - DB Query: SELECT slug FROM wp_shopp_product WHERE slug='safety-pin-bracelet-white-weave' AND id != LIMIT 1 [Flow.php, line 1040]
# 2009-06-26 13:22:45 - PHP WARNING: mysql_fetch_object(): supplied argument is not a valid MySQL result resource [DB.php, line 99]
# 2009-06-26 13:22:45 - PHP WARNING: mysql_free_result(): supplied argument is not a valid MySQL result resource [DB.php, line 102]
This occurs with every new product that I add ?
Profile
can anyone offer me advice on this??
why am I getting these errors each time I add a new product?
Why are the latest products not shoing up on my homepage?
Profile
I'm now getting this error repeating:
2009-06-28 07:49:30 - PHP WARNING: Invalid argument supplied for foreach() [functions.php, line 203]
Profile
It seems to be a bug as I am getting the same results. I'll create a ticket for it.
Profile
cool - thanks for replying - what do you mean by creating a ticket for it though?
Profile
are you getting the same kind of error messages?
Profile
Just a little mention on your shop: in safari, your gallery main image is going below the actual placeholder. It's just a little css thing but I can't remember what I did myself to correct this
Nice job btw.
Profile
He I just checked and it's the line-height css that needs to be at 0.
#shopp .gallery .previews li {line-height: 0px !important;}
cheers
Profile
thanks for that - I hadn't checked it in Safari. I'll insert that fix into the CSS.
What about the above error messages - are you getting the same?
Profile
I haven't stumbled on that yet. Nor see it on your website.
Randomguy3 probably created a ticket on our bugs/errors/enhancement ticket management system. It will probably be fixed in the next version, but I can't confirm yet. Hope it clears stuff out for you. Cheers.
Profile
I have the same problem on my catalog page - the "new items" actually shows all items in alphabetical order. I get the same error:
PHP WARNING: Invalid argument supplied for foreach() [functions.php, line 203]
But when you click on "by brand" I get a list of the brands, but below that I get all my products in order of newest first (with the drop down menu) This is what I want on the catalog page (minus the list of brands)
Can you move that code to the catalog page or something? If you can, where and how exactly (don't leave anything out because I don't know what I'm doing yet) Cheers and lovely.
http://www.treats787.com/shop
http://www.treats787.com/shop/category/brands/
Profile
and this error too:
2009-07-01 00:27:28 - Shopp: The shopp('customer') tag cannot be used in this context because the object responsible for handling it doesn't exist. [login.php, line 1]
that's all so far.
Profile
Actually, now I think about it, I would rather keep the shop page to "featured products" I know how to do that!
But, I would like an added feature - maybe someone could help:
When you click on the featured product there is one breadcrumb back to "shop" I would like to add another one that would be the name of the brand you are viewing so that you can click on it and go to that item's category page.
So, let's say in "featured items" you see a "kallusive" shirt - you then click on it and would see a link to all kallusive shirts. I'm going to try and figure it out myself of-course in the meantime.
Cheers.
Profile
Hi Kezpez,
You would have to create a custom page that lists the categories with images. Because featured products show items and not categories. If it's on your index page that you want to show "featured categories" you need to edit the catalogue.php file in a your custom template. Please refer to http://docs.shopplugin.net/Category_Tags in order to print out the right data.
Profile
Hi Milomade, to answer your question. Did you find anything on it yet? I don't know about your error logs, 'cause I'm not really a PHP/MySQL expert.
I can see different products just fine in your shop. So not just one product.
About the alphabetical order, did you looked at the "presentation settings" in your wp-admin?
And it would help us to understand your problem more if you can show what your code is in your catalog.php of where you've put the code to display your gallery.
Profile
the presentation settings in WP influence the way your products are displayed within your categories - not on the homepage of your shop. I have them set to rendomise and that's how they display if you select a category.
I have this code in my catalog.php:
<?php shopp('catalog','new-products'); ?>
And it deosn't display new products at all, it's just lists them all alphabetically.
Profile
This is fixed in 1.0.7, just tested it earlier today.
Profile
is 1.0.7 available?
Profile
Read my fix for this issue here:
http://forums.shopplugin.net/topic/how-do-you-remove-the-smart-categories#post-5951
Profile
No, 1.0.7 has not been released yet. It's in beta testing.
Reply
You must log in to post.