I am trying to create an order management system for my Shopify store. I previously posted in the forum with a question of how to combine some information that the Shopify pack brought into my doc. The problem was successfully solved, however, I then realized that the pack wasn’t bringing in all my orders. There is a size limit to the orders that coda will bring in. A lot of my orders are in the 50-100 item range with some being larger than that. These large orders are the hardest to manage and the most important so the fact that they couldn’t be brought into coda using the Shopify pack was a bummer.
I have found a workaround to getting the data in. You can create a Zap that pulls in new orders. This doesn’t have a size limit and all my orders get pulled in. However the data is formatted differently and the formula I used to combine data with the Shopify pack no longer works and I cannot figure out a solution.
I am trying to combine 3 columns. Vendor, Item and, quantity. The data in each column is a list of values separated by commas. When the data is combined I need the first item in each list to be paired together then havea comma then the second item in each list combined then a comma. The shopify pack formula that worked is:
thisRow.Order.LineItems.FormulaMap(Concatenate(CurrentValue.Vendor," “,CurrentValue.Name,” x",CurrentValue.Quantity))
Here is the link to my first topic that solved my initial problem.
The Formula that I am using on the data pulled from shopify using the Zap is:
thisRow.FormulaMap(Concatenate(thisRow.Vendor," “, thisRow.Item,” x",thisRow.Quantity))
This is just putting one list in front of the next instead of pairing up the values.
The doc is here:
Any help is appreciated.