sync orders from Woo to Wave past to present based on Order Completed

[basslion]

We have a Woocommerce store and Wave accounting software. We want to sync all invoices going back to 2019 and import them from Woocommerce to Wave. We want only orders with "Completed" status to be imported.

We dont care about customer details really and we only care about the numbers (ie: line totals, sub-totals, discounts, shipping, taxes).

Do you have a template to use for this scenario to work? Where can i start?

 

[Gunjan]

Hey @basslion,

You can sync your WooCommerce completed orders (from 2019 onward) to Wave using Pabbly in a one-time scheduled workflow.

• Trigger: Schedule by Pabbly
• Action: List orders from WooCommerce
• Filter: Orders where status is "completed" and date ≥ 2019
• Action: Create invoice in Wave using only numeric fields (line totals, sub-total, discounts, shipping, taxes)

Customer details can be skipped. If you need help setting this up, feel free to reach out at [email protected].

 

[basslion]

is it possible to group products under a category and have this category name go to Wave as the line item in the invoice?

ie: person orders a shirt and pants and these are all under category clothing so the invoice would show

Clothing 59.99
Clothing 109.99

 

[ArshilAhmad]

Your query is being addressed here:

Woo to Wave products import under broad term?

We would like to sync all orders to Wave from Woocommerce. Each product we have has variations so they will have different prices per product because of this. Our products fall into Categories Is it possible to group products in Woocommerce into categories and then when syncing orders to...

forum.pabbly.com

 

[Gunjan]

@basslion

The possibility of this is required to be checked within the workflow itself, since separating the products based on categories depends on the type of fields we are receiving.

If you want help in setting it up we can connect. You can connect with me over the shared email and I will help you with your concern.

 

[basslion]

Hey @basslion,

You can sync your WooCommerce completed orders (from 2019 onward) to Wave using Pabbly in a one-time scheduled workflow.

• Trigger: Schedule by Pabbly
• Action: List orders from WooCommerce
• Filter: Orders where status is "completed" and date ≥ 2019
• Action: Create invoice in Wave using only numeric fields (line totals, sub-total, discounts, shipping, taxes)

Customer details can be skipped. If you need help setting this up, feel free to reach out at [email protected].

I got to Step 3 "

• Filter: Orders where status is "completed" and date ≥ 2019

How do i filter? Do i use Filter by Pabbly? I cant find a filter option in Woo

 

[ArshilAhmad]

Pabbly

connect.pabbly.com

We have added an Iterator, a Text Formatter, and a Filter to your workflow. This should help you achieve the desired use case.

 

[basslion]

On the last step i checked the response on this and it shows: https://prnt.sc/9qkU8bVFWbeB

 

[Preeti Paryani]

Hello @basslion,

Please check the attached image to understand the reason.

 

[basslion]

Hello @basslion,

Please check the attached image to understand the reason.

So i changed status to complete equal to complete and the status is now "success'

If you look at my workflow called "Woo to Wave past to present based on Order Completed"

You will see i have all the steps to importing all orders from woocommerce to wave from 2019 to present.

After the last filter step where i received the success message, i add an Action for Wave and connected Wave

It is now asking me for Customer which i have set to Cash Sale as i want all invoices to go to a single Cash Sale customer

It then asks for Line Item Product ID, Item Description, Item Price, Item Qty, Currency, Invoice Date etc

All of these fields are required, but What data should i put into these fields for "All Orders" to be imported into Wave?

 

[Preeti Paryani]

Hello @basslion,

Please refer to the tutorial below and let us know if it helps.

 

[basslion]

After watching the video, i did gain some insight into how things work a bit better.

When Wave is asking for the following

1. Line Item Product ID
2. Item Description
3. Item Price
4. Item Quantity

All of this information shows in the Iterator - Process Arrays Step 3 of the workflow but it displays like this

How do i seperate this information so i can input each data into their respective fields that Wave is asking to complete?

 

[ArshilAhmad]

You can use the 'Data Transformer: Line Itemizer' to break the JSON into comma-separated values — that’s the easy part.

Wave requires us to pass comma-separated Product IDs in the 'Line Item Product ID' field. However, you won’t be able to pass multiple comma-separated Product IDs into this field, as there is no endpoint or tool available to support this. Therefore, creating an invoice with multiple products (line items) doesn’t seem to be possible.

 

[basslion]

You can use the 'Data Transformer: Line Itemizer' to break the JSON into comma-separated values — that’s the easy part.
Wave requires us to pass comma-separated Product IDs in the 'Line Item Product ID' field. However, you won’t be able to pass multiple comma-separated Product IDs into this field, as there is no endpoint or tool available to support this. Therefore, creating an invoice with multiple products (line items) doesn’t seem to be possible.

Im confused, so if i want to import all the orders from 2019 to present and many of these orders contain multiple products, then this is not possible? How am i to import all the orders to invoices then?

 

[ArshilAhmad]

Im confused, so if i want to import all the orders from 2019 to present and many of these orders contain multiple products, then this is not possible? How am i to import all the orders to invoices then?

We have added a Code (Pabbly) step to your workflow which should help you with this use case. Your concern is being addressed here:

Creating products with variations in Wave to match Woocommerce

I am told we need to create the products in Wave and the name must match the same product name we have in Woocommerce. We have products that have variations and some variations have the same prices example: Long Sleeve Hoodie: Variations: Color: Red Size: Large Price: 19.99 Long Sleeve...

forum.pabbly.com