Creating products with variations in Wave to match Woocommerce

[basslion]

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 Hoodie: Variations: Color: Blue Size: Large Price: 19.99
Long Sleeve Hoodie: Variations: Color: Red Size: Small Price: 14.99
Long Sleeve Hoodie: Variations: Color: Blue Size: Large Price: 14.99

When we create the matching products in Wave, it asks for

Product Name, Description, Price, Income Account and sales tax

For each of the 4 products above, how would we enter these products in Wave for Pabbly to differentiate each product to bring the proper product to the invoice?

 

[ArshilAhmad]

If Wave doesn’t have a field for entering product variations—such as color and size—you can include the variation details in the product name itself. This way, each variation will be treated as a separate product rather than as variations of the same product.

 

[basslion]

If Wave doesn’t have a field for entering product variations—such as color and size—you can include the variation details in the product name itself. This way, each variation will be treated as a separate product rather than as variations of the same product.

But in Woocommerce there is only 1 name field for the product and each variation of the product does not have its own name. How would i include seperate variations of the product to the 1 name field in Wave?

If a customer orders 2 of the same product but each with different variations and each with different price, when Pabbly sends invoice to Wave, how does Wave know which one to put in invoice as they both have the exact same name.

As we are not at all concerned with list items on the invoice, the only values we need are as follows

1. Name for all products on Wave invoices can be inputted as "Cash Sale"
2. Quantity of each item (This shows in the response received from Woo)

3. Shipping Total (This shows in the response received from Woo)

3. Tax (This shows in Response Received" also and shows like this:

So we would need the tax total and shipping tax total to be added together before inputted in Wave
Also orders from 1 province in Canada will have 2 sales taxes as seen in image above (BC GST) & (BC PST), so the totals for each would need to be inputted to Wave invoice seperately.

Example:

BC GST $22.91
BC PST $32.07

Other Provinces would just have the GST (ie: ON GST / AB GST / NFLD GST)

4. Discounts (This shows in the response received from Woo)

And i think that is it. Any help is greatly appreciated!

 

[ArshilAhmad]

You can try adding a Code (Pabbly) action step to your workflow to merge the product name and variation (Meta Data Value), and then pass the resulting value to Wave.

Pabbly

connect.pabbly.com

import json

# Input strings
string1 = "Strawberry Banana CBD Vape Juice 600MG-1200MG 60ml,Strawberry Banana CBD Vape Juice 600MG-1200MG 60ml,Best Full Spectrum CBD Oil - Organic No THC,Best Full Spectrum CBD Oil - Organic No THC"
string2 = '["600mg (10mg/mL)","75%VG/25%PG",1],["1200mg (20mg/mL)","75%VG/25%PG",1],["Original","Hemp Seed Oil","1500MG","Yes Please",1],["Mint","Hemp Seed Oil","3000MG","No Thanks",1]'

# Prepare string2 as a proper JSON array
formatted_string2 = "[" + string2 + "]"
data2 = json.loads(formatted_string2)

# Split string1 into list
data1 = string1.split(",")

# Merge corresponding entries
merged = []
for item1, item2 in zip(data1, data2):
    merged.append(item1 + " " + " ".join(str(x) for x in item2))

# Final result
result = ", ".join(merged)
print(result)

 

[basslion]

If we can bypass the whole product name variation and just have all orders go under Cash sale in Wave, is this possible?

So each line item regardless of product name will show as "Cash Sale" in wave

 

[Preeti Paryani]

Please share what Cash sale would refer to, if it's the payment method, please let us know so we can better understand the use case and assist you.

If we can bypass the whole product name variation and just have all orders go under Cash sale in Wave, is this possible?

So each line item regardless of product name will show as "Cash Sale" in wave

 

[basslion]

Thanks for the reply. So we would setup in Wave a product called Cash Sale and all order coming from Woocommerce would convert product names to Cash Sale with their respective prices.

Item Qty Price
Cash Sale 1 59.99
Cash Sale 1 69.99
Cash Sale 1 99.99
Cash Sale 1 109.99

 

[ArshilAhmad]

Thanks for the reply. So we would setup in Wave a product called Cash Sale and all order coming from Woocommerce would convert product names to Cash Sale with their respective prices.

Item Qty Price
Cash Sale 1 59.99
Cash Sale 1 69.99
Cash Sale 1 99.99
Cash Sale 1 109.99

To test the possibility of this, we may need to create a few (2-3 products) products named 'Cash Sale' in your Wave account. Do we have your permission to proceed?

 

[basslion]

To test the possibility of this, we may need to create a few (2-3 products) products named 'Cash Sale' in your Wave account. Do we have your permission to proceed?

Absolutely it is ok. Appreciate any help we can get.

 

[ArshilAhmad]

Can you confirm if a multi-product invoice was created in your Wave account? If yes, please share a screenshot. It should contain two 'Cash Sale' products.

 

[basslion]

It looks like it worked?

 

[ArshilAhmad]

Pabbly

connect.pabbly.com

Please enter or map the Invoice Date, Invoice Title, Due Date, select Sales Tax ID, and test your workflow now.

 

[basslion]

Pabbly

connect.pabbly.com

Please enter or map the Invoice Date, Invoice Title, Due Date, select Sales Tax ID, and test your workflow now.

Ok i think i filled out everything properly. The tax field, it shows AB tax, but we dont want to this tax to be inputted on all invoices as we have 13 provinces in our country all with their own taxes ie: BC Tax, ON Tax, QUE Tax etc. How do we get it to call whatever tax will be on the incoming orders?

Also there is no mention of shipping in the fields for Wave, how can i have it fetch the shipping charges?