Thanks for your quick reply and email sent.
Cheers,
Sunny
Publish flag in nop is used by end user administrator to temporary disable the products showing up in the front end. Therefore, in our interest, end user customer should not be aware of their existence during their shopping experience, thus, should not be used as part of the filter.
If you think there maybe a performance issue, can you change the sproc so we can optionally supply that parameter, or an option in the plugin configure?
What is my other temporary get around options if our site is planning to go live this week?
We are on nopCommerce ver 3.3. with this plugin NopUltimatePluginCollection_3.3.528.11414.zip full version.
The executed sproc looks like this.
[dbo].[ProductLoadAllPagegNopAjaxFilters]
@CategoryIds = N'3',
@ManufacturerId = 0,
@StoreId = 0,
@VendorId = 0,
@PriceMin = 45,
@PriceMax = 50
In our setup, category id 3 have grouped product assigned to.
In the result set, one of the returned group products have 6 associated products. Out of the 6, 5 are not published and the 1 published has a special price of 29 and price of 45.
In my scenario, is this a bug that this group product returned in the result set or by design? If by design, what other way I can have it not returned in the result set?
Thanks in advance,
Sunny
Thanks BOYKO for your reply.
For those who are having the same issues and require a work around / temp solution.
The work around we found is to use a sproc to run regularly that will update any products with zero stock to Published = 0. This is now correctly shown in the category result page.
I noticed this plugin will create a sproc ProductLoadAllPagegNopAjaxFilters, The proper solution would be take in extra parameter ShowNoStock and taking the products out from the result set, but I don't have the source code for it, so I moved on.
Are there any work arounds for this issue? Where did the plugin controller get the products from? I put my own customizations in my project so ProductVariantAttributeCombination have a StockQuantity of 0 will not show in the category page, but the filters seems generated from a different result set.
The incorrect behaviour being not only the no stock products will show after a search, but the SpecificationAttribute filter is also generated from all products (stock / no stock) instead of stock products only (What I provided in the category page result set)
How about a reminding rule that will trigger on the month of Customer's Birthday?
Hello,
I am currently testing out the Smart SEO and 1 of the requirement is to do the followings.
In our product page meta descriptions, we would like to append the category information, but I can't seem to be able to do that.
Also, for the "Do Not override default meta data if there is one." setting, is that possible to do it by type but not global? I am only interested to override product default meta, but want to leave category meta untouched if there is a default.
Thanks,
Sunny