Creating products with variations in Wave to match Woocommerce

[basslion]

You will find the IDs in the Wave action step. Please watch the video we shared here, where we are copying the ID from the Wave action step.

google_screen_recording_2025-06-29T17-23_07.877Z.webm

drive.google.com

I have added all the taxes to the lookup table, however in the Wave step, it still shows "nothing selected" under Sales Tax ID

How do we populate this field?

 

[Preeti Paryani]

Hello @basslion,

Please turn on the Map button for the specific field and map the Result value key received from the Lookup step under the field.

 

[basslion]

Hello @basslion,

Please turn on the Map button for the specific field and map the Result value key received from the Lookup step under the field.

STEP 1: I turned on the map button for the field and received this

STEP 2: In the lookup table i see the result value key

Do i paste this below the text in STEP 1 or do i remove the text in STEP 1 and replace it with the Result Value?

 

[ArshilAhmad]

We have mapped the 'Sales Tax ID' field on your behalf.

 

[basslion]

We have mapped the 'Sales Tax ID' field on your behalf.
View attachment 58379

Thank you for that, truly appreciate it.

So i think all fields are filled out properly. Can you take a quick look through the automation and tell me if it is properly prepared to create invoices in Wave and how i can have this automation run a few test orders instead of all orders. Is there a way instead of "List All Orders", to list orders starting from a particular order number? I remember in Make.com we could actually pick an order number to start from.

 

[ArshilAhmad]

Pabbly

connect.pabbly.com

The workflow setup looks correct.


Unfortunately, there is no option to run only a few orders. As a workaround, we have added a Delay step to your workflow, which ensures a 1-minute delay between the creation of each invoice in your Wave account.

So, when you run your workflow, you can monitor it for a few orders and stop the execution from your Task History if needed. You will get the 'Stop Execution' button here when the automation is run.

 

[basslion]

So, when you run your workflow, you can monitor it for a few orders and stop the execution from your Task History if needed. You will get the 'Stop Execution' button here when the automation is run.
View attachment 58389

Can you tell me how you got that popup screen and you have an arrow pointing to Re-Execute and Auto Re-Execution Settings. What one do i click on to stop the workflow? I am currently on the Task History for the workflow and my screen looks like the one on the left of the screenshot you sent.

 

[ArshilAhmad]

You need to click on the Task History ID generated when you run the workflow. The one shown in the screenshot below is an old Task History ID from when the workflow was run on 25th June. You’ll get a similar ID when you run the workflow again. Just click on it, and you’ll see the 'Stop Execution' button next to the 'Auto Re-execution Setting' button. It's not visible in the screenshot above, but it will appear during your run

 

[basslion]

You need to click on the Task History ID generated when you run the workflow. The one shown in the screenshot below is an old Task History ID from when the workflow was run on 25th June. You’ll get a similar ID when you run the workflow again. Just click on it, and you’ll see the 'Stop Execution' button next to the 'Auto Re-execution Setting' button. It's not visible in the screenshot above, but it will appear during your run

Ok thanks for this help.

I ran the workflow and encountered an error at the Wave step.

Error Message
Variable "$input" got invalid value "2025-07-09T11:18:26" at "input.invoiceDate"; Expected type "Date". Value type is not a valid Date ('yyyy-MM-dd' format expected): 2025-07-09T11:18:26

The value received and the expected format seem to be the same or am i wrong? i think i need to remove the time stamp on the date somehow

 

[ArshilAhmad]

You were passing the Invoice Date along with the time. We have added a Text Formatter to remove the time. Please test the workflow now.

 

[basslion]

i think i need to remove the time stamp on the date somehow

You were passing the Invoice Date along with the time. We have added a Text Formatter to remove the time. Please test the workflow now.
View attachment 58481

Hello. Thanks for this. i actually did the same as you did and then saw you already put it there, so i am learning

My only issue now is shipping. For some reason in Wave step there is no field to map shipping costs for the order. Where can i find this?

 

[ArshilAhmad]

Wave doesn't appear to have any fields for the shipping amount in the 'Create Invoice' endpoint.

https://developer.waveapps.com/hc/en-us/articles/360019968212-API-Reference#invoicecreateoutput

As a workaround, you can try passing the Total in the Item Price field instead of the Subtotal. Essentially, the Item Price will then include the shipping amount.

 

[basslion]

Wave doesn't appear to have any fields for the shipping amount in the 'Create Invoice' endpoint.

https://developer.waveapps.com/hc/en-us/articles/360019968212-API-Reference#invoicecreateoutput

As a workaround, you can try passing the Total in the Item Price field instead of the Subtotal. Essentially, the Item Price will then include the shipping amount.
View attachment 58488

I added the total price to the section of wave for Item price, but when I try to run the workflow, it gets to step 6 and then goes back to step 4 and keeps looping there. Was working before but for some reason wont advance to Step 7

Futher looking at Step 6 it shows Error

 

[ArshilAhmad]

Task History ID - IjU3NjUwNTY4MDYzNTA0MzM1MjZlNTUzMTUxMzU1MTYzNTQzMTBmMzAi_pc
Your workflow is set up such that an invoice will only be created if the Status is 'Completed' and the creation year is after 2019. So, the next steps will only execute if both of these conditions are met. Any order that does not have the Status as 'Completed' or has a creation year of 2019 or earlier will not result in an invoice being created in Wave.

Ignore the error message in the Filter step — that's just how it looks when the filter conditions aren't met.

 

[basslion]

Task History ID - IjU3NjUwNTY4MDYzNTA0MzM1MjZlNTUzMTUxMzU1MTYzNTQzMTBmMzAi_pc
Your workflow is set up such that an invoice will only be created if the Status is 'Completed' and the creation year is after 2019. So, the next steps will only execute if both of these conditions are met. Any order that does not have the Status as 'Completed' or has a creation year of 2019 or earlier will not result in an invoice being created in Wave.


Ignore the error message in the Filter step — that's just how it looks when the filter conditions aren't met.

But how are the conditions not met? They were met before when i ran the workflow and all of our store orders are marked as completed and are after the year 2019. We have over 4000 orders to run.

 

[ArshilAhmad]

It doesn't look like all your orders are marked as 'Completed'—we can see a few with a different status. It seems you've stopped the workflow from executing; you'll need to let it run until it reaches the orders with the 'Completed' status.

google_screen_recording_2025-07-11T17-46_49.453Z.webm

drive.google.com

 

[basslion]

It doesn't look like all your orders are marked as 'Completed'—we can see a few with a different status. It seems you've stopped the workflow from executing; you'll need to let it run until it reaches the orders with the 'Completed' status.

google_screen_recording_2025-07-11T17-46_49.453Z.webm

drive.google.com

Ok im seeing the processing orders now. i will get these orders to completed and then run the workflow.

 

[basslion]

It doesn't look like all your orders are marked as 'Completed'—we can see a few with a different status. It seems you've stopped the workflow from executing; you'll need to let it run until it reaches the orders with the 'Completed' status.

google_screen_recording_2025-07-11T17-46_49.453Z.webm

drive.google.com

Ok i got all orders completed status and ran the workflow and received this error on the Wave step
{
"errors > 0 > extensions > code": "VARIABLE_VALUE",
"errors > 0 > extensions > id": "fbf1f2ce-64b3-44f4-8772-191d74d94862",
"errors > 0 > message": "Variable \"$input\" got invalid value \"\" at \"input.items[1].unitPrice\"; Expected type \"Decimal\". Value is not a valid Decimal: ",
"errors > 0 > locations > 0 > line": 1,
"errors > 0 > locations > 0 > column": 10
}

 

[ArshilAhmad]

You need to map the data in the 'Item Price' field from Step 7. Which one of these is the correct price? Essentially, the price needs to be passed for each individual product. For example, if the order contains two products, the 'Item Price' field should also include two corresponding values.

 

[basslion]

You need to map the data in the 'Item Price' field from Step 7. Which one of these is the correct price? Essentially, the price needs to be passed for each individual product. For example, if the order contains two products, the 'Item Price' field should also include two corresponding values.

Ok i added the total to the Wave field instead of the Sub-total as per message #32 of this thread so it looks like this

We are out of tasks and are being asked to upgrade. I would like to make sure this workflow will work before we commit to a year long plan. Is it possible to add tasks to our account so we can finish testing this workflow?