Good Afternoon.
The mssql select query on the mdb database to check for the offering type is:
USE mdb
GO
SELECT offering_id,parent_id,status,offering_name,description,type
FROM dbo.usm_offering
Where:
Type = 0 for ShoppingCart
Type = 3 for One-Click
Thanks and kind regards, Louis van Amelsfort.