General Discussion

Here you can discuss plug-in operation.

Hi.

Is it possible to modify plugin's stored procs according to a changes I have made in  the nopCommerce db schema?  
I'm using extra fields in the nopCommerce DB.  

Cheers
John

Yes, you can modify stored procedures, add new fields to tables (you must add new fields to class).
etc.

Hi,

May I know which stored procedure(s) loads the Categories for NOP's Category Model.

For performance, we will update the stored procedure to exclude Child Categories from a certain ParentCategoryID.

Thanks!

nop 3.90/4.0
We use the next naming
FNS_{what_service/factor_we_changing}
FNS_CatalogModelFactory_PrepareCategorySimpleModels

This procedure has some problems for my opinion.
I tried to do it for most stores... you can remove many unnecessary codes (mutistore/localization, etx.)

About another problem I didn't solved it from the box.
Plugin uses the next logic. It creates category tree and save it to cache.
But if you have to many categories plugin will takes this cached tree and try to find subtree,
it's better to create subtree too and cached it too. I don't know. I don't have good solution.

When I click the "Test Plugin Operation..." button

What should be my next action if I see these:

GetProductManufacturersByProductId(30,false) - Error: 1=productmanufacturers.count()=0
GetProductManufacturersByProductId(30,true) - Error: 1=productmanufacturers.count()=0
GetProductManufacturerById(2) - Error:Object reference not set to an instance of an object.
PrepareManufacturerModel() - Error:Value cannot be null. Parameter name: manufacturer


Does it mean I need to add at least one manufacturer and assign it to at least one product, to make the plugin perform better?  We make our own products, so there is really no manufacturer for us.

Thanks.

I did these tests for standard nopcommerce default database.
I checked if nopcommerce returns corrected values.
You can ignore warning messages.