I’ve got Shopify orders with each product as a line item, and each product possibly having additional line items (properties) on each one. An order may look like this:
Previously when I was building and testing using only products with properties, this article helped in getting it working:
I was able to loop through each product and parse out the properties to eventually map with.
However, adding a product without any properties is throwing off the order of how things are parsed.
In the above example, the formatter would only find 2 properties sets instead of 3, meaning the Test eCard properties are attaching to the Test nonCard, and Physical Card properties are attaching to the Test eCard.
Is there way to assign a null value before the formatting occurs?
I’ve tried the methods in this thread but the Spreadsheet formula did not work, as it didn’t recognize that it was blank.