Populated OsCommerce

[marcoren]

I used easyPopulate to put all my data into the database how I want it. Using admin, everyhting looks perfect. I can navigate thru categories exactly as I wanted. The problem is, I get to the bottom of a category and it doesn't show any products. If I do sql on the database, I see the associations between the products and the categories.

 

Does anyone know why OSCommerce doesn't show products?

 

 

If this isn't enough information, please ask and I'll provide it.

[marcoren]

I was looking further at this and I'm still not sure what's going on.

 

 

Using phpMyAdmin, I see 1710 products listed(the exact # of products).

 

There are 1710 associations between categories and products.

 

However, when I actually use oscommerce, only 2 products are listed out of the original 1700?

 

Perhaps I messed up my easyPopulate install? I'm not sure how since all of the products got listed and associated. Is there another table that needs to be populated which isn't?

[Guest]

here is the support thread, most if not all answers are in there. did you create individual product model #s and assign every product to a category?

[marcoren]

here is the support thread, most if not all answers are in there.  did you create individual product model #s and assign every product to a category?

<{POST_SNAPBACK}>

 

 

John,

 

I created individual model #'s and assigned each to a category. What's really perplexing is that I can see all the products associated properly if I use the admin interface.

 

When I use the storefront, I don't see the products. I'm not sure that this is an easyPopulate issue.

 

 

I've searched the forum and I'm coming up short on answers.

 

Thank you,

Marc

[Guest]

John,

 

I created individual model #'s and assigned each to a category.  What's really perplexing is that I can see all the products associated properly if I use the admin interface. 

 

When I use the storefront, I don't see the products.  I'm not sure that this is an easyPopulate issue.

I've searched the forum and I'm coming up short on answers.

 

Thank you,

Marc

<{POST_SNAPBACK}>

 

what is the status of the products? if they are inactive (red light) they will show up in the backend but not the frontend.

[marcoren]

CarreraRod, that was it. I was putting "Active" into v_status instead of 1 for active. I changed my data and reran easypopulate and boom, everything showed up.

 

Thank you for all your help.