Close

How are product specific Tabs mapped to Products in SQL Server?

DrDray
11 months ago
#22195 Quote
Avatar
  • 3
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
Boyko
10 months ago
#22196 Quote
Avatar
  • Moderator
  • 1570
DrDray wrote:
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


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.
Regards,
Nop-Templates.com Team
DrDray
10 months ago
#22199 Quote
Avatar
  • 3
Thank you - very helpful!