Hi,

I am trying to get a list of all my product names (as they appear on the Umbraco marketing site - cms tables), as well as a few other Umbraco product properties (things that appear in Umbraco/cms tables), but also their (uCommerce) SKU, their price and their license period.

The main issue to understand here is how the Umbraco tables and the uCommerce tables are related, in reference to Umbraco Products on one hand, and uCommerce SKUs on the other.

Just to be clear, the solution I am trying to resolve is using SQL queries and not via Umbraco objects

I appreciate any help :)

Many thanks

Rotem