Get items with their variants using SuiteQl
Hello everyone, I am new to Netsuite.
I’m trying to link an ecommerce website to netsuite using suiteql.
From importing product from Netsuite to my store, the store is expecting a payload that looks like this :
{
“product”:
{
“name”: “Tshirt”,
“options”: [
{ “name”: “Color” },
{ “name”: “Size” }
],
“variants”: [
{ “option1”: “Red”, “option2”: “L” }, { “option1”: “Green”, “option2”: “Small” }
]
}
}
is there any way i can get this structure from matrix items or just something close to this ?
Thank you in advance.



