• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Creating products with variations in Wave to match Woocommerce

basslion

Member
We have reset your tasks. You can test the workflow now.
I appreciate that very much :)

Ok so we added the total to the item price in hopes of capturing the shipping costs as well but it did not work
1752298655178.png

As you can see the comparison of the store side in admin and the Wave invoice result below:



1752298617136.png


Is there a way to treat shipping as a product itself?
 

basslion

Member
We have made some changes and added the shipping cost as a product. Please test your workflow now.
Ok i ran one invoice and everything matches 100%. :)

Can you tell me how many tasks i would be charged for running this automation each time i import a new invoice to wave so i can get an idea of how many tasks i will consumer per month so i can pick the appropriate plan?
 

ArshilAhmad

Moderator
Staff member

This workflow will consume 5 tasks for each invoice created for the current orders in your WooCommerce account. For example, if you have 100 orders, it will consume approximately 500 tasks to create an invoice for each one.
 

basslion

Member

This workflow will consume 5 tasks for each invoice created for the current orders in your WooCommerce account. For example, if you have 100 orders, it will consume approximately 500 tasks to create an invoice for each one.
Ok, so we have 5000+ invoices to import, and then after we would be importing approx 100 orders per month.
Can we buy a set number of tasks to complete the 5000+ import and then hop on a plan monthly?
 

ArshilAhmad

Moderator
Staff member
Apologies for the miscommunication. I mistook it for an INR payment. Yes, USD payments are recurring, but you can cancel the subscription to avoid auto-billing.

 

basslion

Member
Apologies for the miscommunication. I mistook it for an INR payment. Yes, USD payments are recurring, but you can cancel the subscription to avoid auto-billing.

Hello. Ok i purchased the 30k tasks and all is good. Another question:

When i run the workflow, it will capture data and then create invoices in Wave. If i stop the execution and check to make sure invoices are proper and then re-run the workflow, will it skip the ones already created, or will it run into an error saying invoice ### already exists and stop the workflow from running?
 

ArshilAhmad

Moderator
Staff member
No, it won't skip the ones already created. If you re-run the workflow, it will start all over again and create duplicate invoices in Wave.
 

basslion

Member
No, it won't skip the ones already created. If you re-run the workflow, it will start all over again and create duplicate invoices in Wave.
Ok so i ran about 50 invoices and ran into some errors. When i click on the Task History ID i see all the tasks that were run.

1. Why is the Iterator only run once at the top of the task list, shouldnt it be run each time the workflow runs?

Scrolling down in the list i see errors at the Wave step. It doesnt happen with all orders though

Variable "$input" got invalid value "" at "input.items[2].quantity"; Expected type "Decimal". Value is not a valid Decimal:
Variable "$input" got invalid value "" at "input.items[2].unitPrice"; Expected type "Decimal". Value is not a valid Decimal:
Variable "$input" got invalid value "" at "input.items[3].quantity"; Expected type "Decimal". Value is not a valid Decimal:
Variable "$input" got invalid value "" at "input.items[3].unitPrice"; Expected type "Decimal". Value is not a valid Decimal:
Variable "$input" got invalid value "" at "input.items[4].quantity"; Expected type "Decimal". Value is not a valid Decimal:
Variable "$input" got invalid value "" at "input.items[4].unitPrice"; Expected type "Decimal". Value is not a valid Decimal:

2.Why does this happen for some invoices and not others?

Also on Invoice 34647 as shown in screenshot, it is instructed to take the subtotal as the line item price, but i think this is wrong, because the subtotal is the amount x quantity. this is the reason the invoice in Wave shows $239.97 x 4 when it should be $59.99 x 4. So the Item Price in the Wave step cant be 6. Subtotal:,

3. What can i choose for it to match the item line single unit price?
1-screenshot-001.jpg
 
Last edited:

ArshilAhmad

Moderator
Staff member
There seem to be products in your WooCommerce account with commas in their names that are breaking the JSON structure in Wave and causing this issue. Essentially, when such a product is passed to Wave, it is treated as multiple separate products. Could you please share a list of WooCommerce products that contain commas? If possible, please remove the commas from the product names or replace them with another character.

1752425453797.png


=========================================================================

We have added a Python code to your workflow which will divide the subtotal with quantity and pass it to the Item Price field in Wave. This should give you the correct amount.
1752425360758.png
 

basslion

Member
There seem to be products in your WooCommerce account with commas in their names that are breaking the JSON structure in Wave and causing this issue. Essentially, when such a product is passed to Wave, it is treated as multiple separate products. Could you please share a list of WooCommerce products that contain commas? If possible, please remove the commas from the product names or replace them with another character.

View attachment 58571

=========================================================================

We have added a Python code to your workflow which will divide the subtotal with quantity and pass it to the Item Price field in Wave. This should give you the correct amount.
Ok sorry i found comma's in the product variation for 1 product, i have taken the comma's out of the said product.

Also if we correct the product names, will this apply to all existing invoices?

I see you are pointing to the description section in the screenshot, is the issue with the description or product name?

Thank you for the python code to correct the price issue.
 
Last edited:

ArshilAhmad

Moderator
Staff member
We are passing the WooCommerce product name in the Item Description field of the Wave action step. The issue lies in the product name fetched from WooCommerce.
1752433235198.png


No, it won't be applied to the existing invoices in Wave. Any changes you make in WooCommerce will not affect the existing invoices in Wave. Your workflow is set up to create new invoices in Wave.

When you run the workflow again, new invoices will be created, and the updated product name will be visible only in those new invoices.
 

basslion

Member
We are passing the WooCommerce product name in the Item Description field of the Wave action step. The issue lies in the product name fetched from WooCommerce.View attachment 58573

No, it won't be applied to the existing invoices in Wave. Any changes you make in WooCommerce will not affect the existing invoices in Wave. Your workflow is set up to create new invoices in Wave.

When you run the workflow again, new invoices will be created, and the updated product name will be visible only in those new invoices.
So if we are trying to import old invoices, it will continue to run into error seeing the comma and therefore unable to create the invoices for those older orders?
 
Top