Profile: Boyko
User posts
Hello -
Could someone guide me on how product specific Tab data (which appears to be stored in dbo.SS_QT_Tab) is mapped to products (dbo.Products)? I cannot see a simple mapping table in the database.
I want to produce product specifications and store them as a Tab. I want to do this in bulk via the SQL Server but I cannot figure out how Tabs are mapped to products in SQL Server.
Thank you in advance
Could someone guide me on how product specific Tab data (which appears to be stored in dbo.SS_QT_Tab) is mapped to products (dbo.Products)? I cannot see a simple mapping table in the database.
I want to produce product specifications and store them as a Tab. I want to do this in bulk via the SQL Server but I cannot figure out how Tabs are mapped to products in SQL Server.
Thank you in advance
Hi DrDray,
Our mapping library uses a table called "SS_MAP_EntityMapping".
Simply map a tab to several products and then examine the records added into that table to get an idea how to do that with a script.
Could someone from nopTemplates reply to say if any of these features have been implemented? Specifically feature 2.
This plugin looks a good fit for me with the exception of the sale price calculation. All the products on my site use the OldPrice field for the MSRP price and most of the time the selling price is less than this.
Currently the plugin seems to copy the price field to the OldPrice field and then calculate the sale price. I need the plugin to leave the OldPrice field alone and just modify the price field by the additional percentage configured in the campaign.
As it works at the moment I may be advertising a product at 15% below MSRP as my standard selling price, but when a sales campaign starts it looks like I am then only discounting by say 5% when in fact it is 20% below MSRP.
This plugin looks a good fit for me with the exception of the sale price calculation. All the products on my site use the OldPrice field for the MSRP price and most of the time the selling price is less than this.
Currently the plugin seems to copy the price field to the OldPrice field and then calculate the sale price. I need the plugin to leave the OldPrice field alone and just modify the price field by the additional percentage configured in the campaign.
As it works at the moment I may be advertising a product at 15% below MSRP as my standard selling price, but when a sales campaign starts it looks like I am then only discounting by say 5% when in fact it is 20% below MSRP.
Hi shoecake,
No, we haven't changed that logic in the plugin. It still uses the Old price to store the original price before the campaign starts and then use it again to revert the prices after the campaign has ended. Maybe you should use some other filed for the MSRP price rather than the Old price and thus leave he old price empty.
You can try to delete the Mega Menu that you have and create a new one with the same menu items.
2 years ago
We're working in Nop 3.9. Is it possible to display the correct color of the product, based on which color has been chosen on the filter? Meaning it should display the image color red if the color red has been chosen.
I'm a developer, I just need a heads up in which files to update.
Looking forward for an answer.
I'm a developer, I just need a heads up in which files to update.
Looking forward for an answer.
Hi andreasp,
This is not possible as there could be multiple colors selected not just one.
2 years ago
Is pavilion theme and plug-ins ultimate collection available for 4.6?
Yes, they are available for nopCommerce 4.6.
2 years ago
When we get an update for 4.6 version of nopcommerce?
The Emporium theme is already available for nopCommerce 4.6 so you should be able to download it from your accounts.
3 years ago
I cant access the extra settings menu for the theme, it does not show up under the Nop-Templates side bar, there are only plugins there, not themes "Administration -> Nop-Templates -> Themes -> Avenue -> Settings.
Trying to go directly to *my-site/admin/AvenueThemeAdmin/Settings I get a 404 error.
I´m using Nopcommerce 4.3 and the theme is working fine.
Trying to go directly to *my-site/admin/AvenueThemeAdmin/Settings I get a 404 error.
I´m using Nopcommerce 4.3 and the theme is working fine.
Hi JRon,
You need to make sure the Avenue theme plugin is installed (see the list of installed plugins) as if it is not installed you won't see the extra menu.
3 years ago
Anywhere Sliders plugin 4.5 is generating database error:
Short message Invalid column name 'PauseOnHover'.
Full message Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'PauseOnHover'.
at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__207_0(Task`1 result)
It seems that the nop-templates db upgrade scripts are having issues.
Is anyone else aware of this or experiencing problems? Awaiting resolution to upgrade system
Short message Invalid column name 'PauseOnHover'.
Full message Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'PauseOnHover'.
at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__207_0(Task`1 result)
It seems that the nop-templates db upgrade scripts are having issues.
Is anyone else aware of this or experiencing problems? Awaiting resolution to upgrade system
Hi Ladd,
Please see my reply here.
3 years ago
MissingMethodException: Method not found: 'Void Nop.Web.Factories.CatalogModelFactory..ctor ...
Please do not modify the constructor but resolve any dependencies directly or use Property injection instead as described here.
3 years ago
Hi,
I guess you are missing some files or maybe the versions of the plugins and the Core plugin are different.
Please make sure you have the Core plugin as well all other plugins having the same version.
Simply download the product package from our website and update them.
