|
|
 |
 |
Joined: 5/28/2010
Posts: 471
|
|
|
I got mine resolved.... with the ability to add one product to multiple categories, I believe what is happening is that it's no longer looking at the category in the Product table, but instead looking solely at CategoryProduct.
If there are no entries in CategoryProduct for a category, it will by default show all products.
Anyway... I got mine fixed.
|
|
|
|
 | |
|
|
 |
Joined: 7/26/2010
Posts: 22
|
|
|
Good news for you...
I am still unresolved. How does something get in to CategoryProduct? I have added a product to all categories but it still doesn't work.
|
|
|
|
| |
|
|
 |
 |
Joined: 3/11/2010
Posts: 1979
|
|
|
The categoryproduct table gets populated when you are in the product setup screen and you assign category(s) to your product and save. Or it gets populated when you import from csv/xls.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 5/28/2010
Posts: 471
|
|
|
I just posted a SQL query that may resolve your problem in another thread.
|
|
|
|
| |
|
|
 |
 |
Joined: 8/1/2010
Posts: 252
|
|
|
dsmith wrote:
- Make sure your identity columns line up in the following tables
- Smith_Category
- Smith_Products
- Smith_CategoryProduct
- Try using the "Import Products" button from the store admin menu instead of doing the import from sql mgmt studio
The tables seem fine. Details below if interested.
Here's what I can't understand: Why is the category module not filtering, but the built-in categeories in the buy-now module works fine?
@Dave or @Scott : please comment on this.
Table details if interested...
Products IDs are 1-17. The category ID in the products table is NULL (I believe because it isn't used anymore with multiple categories).
Categories IDs are 1-7
CategoryProduct table looks fine:
Id CategoryID ProductID
| 3 |
3 |
3 |
| 4 |
3 |
4 |
| 5 |
4 |
5 |
| 6 |
5 |
5 |
| 7 |
3 |
8 |
| 8 |
7 |
8 |
| 9 |
6 |
6 |
| 10 |
5 |
7 |
| 11 |
6 |
7 |
| 12 |
2 |
9 |
| 13 |
4 |
10 |
| 14 |
5 |
10 |
| 15 |
6 |
10 |
| 16 |
7 |
10 |
| 17 |
5 |
11 |
| 18 |
7 |
11 |
| 19 |
7 |
12 |
| 20 |
7 |
13 |
| 21 |
7 |
14 |
| 22 |
7 |
16 |
| 24 |
1 |
2 |
| 25 |
1 |
1 |
|
|
|
|
| |
|
|
|
Joined: 7/26/2010
Posts: 22
|
|
|
Hi
I have now completed the clean install and have the same results.
I cannot use the category ID approach with hard links because when you use the "continue shopping" button it goes back to the first page, not the chosen category.
I do have the categories working within the BuyNow module (which I didn't earlier) but it only shows the top level categories (and I don't want them in here anyway).
I don't have SQL access without paying somebody, and quite frankly, as this is the most expensive module I've ever bought I don't expect to incur additional charges.
I have spent two weeks trying to get this to work. I am committed to getting it working and would appreciate some practical help.
Thank you
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
If you click the continue shopping button from the cart or product details page it will return you to the product listing page and it will not maintain the state of the category id you orginally passed in the querystring it will show all products.
I dont follow your question "but it only shows the top level categories (and I don't want them in here anyway)." Can you clarify this?
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 5/24/2010
Posts: 9
|
|
|
I just noticed something related.
An upload of new products to the existing product list created the new rows in the Smith_Product table, but it did not create any new entries into Smith_CategoryProduct table. Thus, the products don't show up in their proper categories, but they are in the store.
A manual entry of ProductIDs and CategoryIDs will probably fix this.
version 2.98
|
|
|
|
| |
|
|
|
|
Joined: 5/28/2010
Posts: 471
|
|
|
The other thing to check, especially if you do like me and have the category listing on a page with the featured items, but clicking on a category takes you to the buy now....
There is a setting in the Category menu that defines the page that the cart is on.
|
|
|
|
| |
|
|
|
|
Joined: 8/1/2010
Posts: 252
|
|
|
gbaughma wrote:
The other thing to check, especially if you do like me and have the category listing on a page with the featured items, but clicking on a category takes you to the buy now....
There is a setting in the Category menu that defines the page that the cart is on.
It's not that either. My category module is on the same page, and so the page setting is blank as I think it should be.
I'm stumped. The tables seem fine, the settings seem fine, but the category module doesn't filter (although the category menu built into the buy.now does work).
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
The category module filtering works I just tried it on 2 different test portals something must have gotten out of sync in your portal. Can you try downloading the latest cart module v3.05 and installing on a new dnn install to isolate if its just your portal that its not working in.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 8/2/2010
Posts: 10
|
|
|
Well..... good news for you guys!!!!! As per supports clear instructions and 8 hours uninstalling and re-installing the Smith Cart with 100+ products I found the issue STILL happening!!!! Un-installing and Re-installing will not fix this issue. 
The issue relates to a field in the Category Table. If there is any data in the dbo.Smith_Category, CatSEOURL or the (URL Keywords) field you will loose all ability to filter by that category. Remove the data from that field and filtering works again.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Interesting... thanks for clarifying the issue I will forward into programming now for them to take a look.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 8/1/2010
Posts: 252
|
|
|
Confirmed! Well done robwib. I have replicated this on the smith-cart test page.
I created a category called "People", with an SEO keyword "people". Then I created a product called "Daniel" and assigned it the category people. Now the "People" category is not filtering.
P.S. If you used the old version (not the category module, but the built-in categories in the buy-now settings) it will filter fine (but this old version isn't as good - it doesn't have sub-categories).
|
|
|
|
| |
|
|
|
Joined: 7/28/2009
Posts: 1452
|
|
|
On the www9 test site there are 5 different instances of the buynow module which one did you create your test categories and products on. Can you post the link to the store page and also the querystring you are using to filter the products.
At your service,
Dave Smith
|
|
|
|