You have no items in your shopping cart.

Tuesday, June 2, 2020 12:57:55 AM

General Discussion

Avatar

Posted: 7 years ago

#66 Quote

Support

Posted: 7 years ago

#66 Quote
Here you can discuss plug-in operation.

Posted: 7 years ago

#72 Quote
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
Avatar

Posted: 6 years ago

#92 Quote

Support

Posted: 6 years ago

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

Posted: one year ago

#8272 Quote

michaelm@gogbs.com

Posted: one year ago

#8272 Quote
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!
Avatar

Posted: one year ago

#8278 Quote

Support

Posted: one year ago

#8278 Quote
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.


Avatar

Posted: one year ago

#8321 Quote

michaelm@gogbs.com

Posted: one year ago

#8321 Quote
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.
Avatar

Posted: one year ago

#8322 Quote

Support

Posted: one year ago

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

Powered by nopCommerce

Copyright © 2019 FoxNetSoft. All rights reserved