Get all products with variants

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.4.24
-- Browser(s) name and version -- : Chrome 41.0.2272.118

Hi,

Wondering if there is a script or a sql query to get all products with or without variants?

I want to get a list of all the products and associated variants with the product.

Would be nice if the product had multiple variants to list them beside each other:
.e.g
Product ID, Product Name, Variant 1, Variant 2

Dummy text:
1, T Shirt (main product)
2, T Shirt, Small, Black (Variant)
3, T Shirt, Medium, Black (Variant)
4, T Shirt, Large, Black (Variant)
5, T Shirt, Small, Blue (Variant)
6, T Shirt, Medium, Blue (Variant)
7, T Shirt, Large, Blue (Variant)

etc

Thanks

Hi,

So you want one line for the main product and then one line for each variant ?*
In that case, just click on the "export" button of the products listing and you'll get jsut that.