1.8 No products showing up

Hi

I am using 1.8 and I hav'nt upgrade anything but still not getting the products showing.

We have over 50 products in our DB and they are mapped to 1 or more categories and mappinf is correct as they were working before.

you can check put at http://www.surgical.ie/]http://www.surgical.ie/

Categories are disolayed OK but the products are nor showing up at all. I tried with different grid options without a luck

Any Help?

Gurdeep

have you edited any of the category templates?

eg

templates/category/productsInGrid.ascx

or something else along these lines?

gurdeeptoor wrote:

Just need some clarification.

Was it working fine and then just stopped?

Can you see the products in the Admin section?

Are the products marked as published?

I just tried to manually access products using "/products/11-abcd.aspx" and it shot me back to home page which usually means the products aren't published.

See if you can directly access a products.

Thanks guys

To: haydie

Yes the only thing I did chnage was display 4 colums instead of 2 in all 3 category templates which are ProductsinGrid, ProductsInGridLine1 & ProductsInGridLine2. It worked after that. But i have tried after roll it back to columns 2 and still no show up.

To: dfwitdepartment

Yes it was working fine but after recent product addition it just stopped.
Yes we can see the products in admin section can preview them ok there.
Yes All products are published

Any other clue??

By The way you can click directly on below link to see the product
http://www.surgical.ie/products/215-amputation-2.aspx

But if you click on breadcrum to step back to category you wont be able to see product at all
http://www.surgical.ie/category/98-amputation.aspx

This is what happening with all other products we have.

Any help or be great.

gurdeeptoor wrote:

Thanks for the links, that helps.

I suspect that you have some unwanted data in your database which is causing it to be unable to pull the product information.

What is the last product # that you added?

I noticed that if I search on your site, only 1 product shows up for 'amp', it's like it's gives up on the rest.

Did the search function work before also?
Because the search function seems to not be working also, I think that it's choking on some data during the database query.

There is a stored procedure in the database that seems to take care of pulling product information, it's name is StoredProcedure [dbo].[Nop_ProductLoadAllPaged]


Check the recent product you added - make sure you don't have any unusual characters in the description or tags.
If you delete a product- it's still in the database and just flagged as deleted, so deleting it probably won't help.

Make sure that you have a product varient (just one at least, just to keep things normal).

Make sure that the products don't have an AvailableStartDateTime set for the future. Check the tags for any unusual characters.

If you copy/pasted the product information from somewhere, it may have brought over some unwanted data.

If you 'deleted' the product that seemed to cause the issue, go into the database table 'dbo.Nop_Product' and the last row, the column that is titled "Deleted" change the value to "False".

Thanks for detailed reply.

I could get away with work around. In stored procedure [dbo].[Nop_ProductLoadAllPaged] I hardcoded @ShowHidden = 1 and now its picking up the products. What it could be ?

Regards.

gurdeeptoor wrote:

that's used to flag products that have been marked as hidden, it's used in the following snippets
    AND  (
        @ShowHidden = 1 OR p.Published = 1
      )
    AND
      (
        @ShowHidden = 1 OR pv.Published = 1
      )
    AND
      (
        @ShowHidden = 1 OR pv.Deleted = 0


        @ShowHidden = 1
        OR
        (getutcdate() between isnull(pv.AvailableStartDateTime, '1/1/1900') and isnull(pv.AvailableEndDateTime, '1/1/2999'))

are you sure you don't have start or end dates assigned to your products?

p is for product and pv for product variant, check out the above mentioned fields in your products to see if something isn't set right.