nopCommerce version 3.0
From the SEO prospective, we want search engines to index those products that perhaphs are unavailable at the moment but we will restock it in the near future.
I keep the product published = 1 and deleted = 0 but the available date is in the future.
The store procedure doesn't return these items therefore search engines get Page Not found
i did replace:
IF @ShowHidden = 0
BEGIN
SET @sql = @sql + '
AND p.Published = 1
AND pv.Published = 1
AND pv.Deleted = 0
AND (getutcdate() BETWEEN ISNULL(pv.AvailableStartDateTimeUtc, ''1/1/1900'') and ISNULL(pv.AvailableEndDateTimeUtc, ''1/1/2999''))'
END
with
IF @ShowHidden = 0
BEGIN
SET @sql = @sql + '
AND p.Published = 1
AND pv.Published = 1
AND pv.Deleted = 0
'
END
but that may not be an ideal solution