Creating Multiple Line Items in a Quickbooks Invoice

I’m working on creating an automation that brings orders from Woocommerce over to Quickbooks. I’ve been able to make it work if there’s one product, but I need it to work if there’s several products.

The error I’m getting so far is: “Missing value of required parameter ‘Amount’.” I’m not sure where to find that.

I’ve realized that Quickbooks needs to map the ‘Item_ID’ So that’s why I search for products after the iterator module, and then bring it back into the aggregator.

Here’s some screenshots of what my automation looks like so far. The ‘Array’ used is from the aggregator where it puts the products list back into bundles.


If you’ve come across a video showing how to do this, or can help, Please let me know.

Hello! Welcome to the Make community!!
I don’t know if it will solve your issue, but at least, I can tell you that the “Source Module” in your Array Aggregator has to be “Iterate Products”, and not “QuickBook”, since you are aggregating back the line items from WooCommerce.
Then the error message seems to say that you simply didn’t map the Amount field in one of the arrays.
And also, I’m surprised to see “13.Array:Quantity” in your mapping for quantity. If it relates to the number of items in the order, it should be mapped with “Total Number of Bundles” of the Iterator. But this, I’m not sure.

Benjamin

1 Like