Woo to Wave products import under broad term?

[basslion]

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 invoices in Wave, the invoices in Wave will just show the category as the line item and not the actual product name?

For Example:

Order contains the following

Product 1 which is associated with Category (Group) 1 price is 59.99
Product 1 with variation which is associated with Category (Group) 1 price is 69.99

Product 2 which is associated with Category (Group) 2 price is 99.99
Product 2 with variation which is associated with Category (Group) 2 price is 109.99

The invoice should look as follows:

Item Price
Category (Group) 1 59.99
Category (Group) 1 69.99
Category (Group) 2 99.99
Category (Group) 2 109.99

Any help is greatly appreciated

 

[ArshilAhmad]

Hi @basslion,

Please follow the steps shown in the video below to capture a new multi-product order in the WooCommerce trigger step. Once you've done that, let us know so we can look into the possibility of your use case. Ignore the action step shown in the video.

 

[basslion]

I tried to follow the video, however at 9:56 of the video it asks to find unit price, but i could not find a line that says Price: . The only values that showed price was the Subtotal: and Meta Data Value Initial Price: as show in screenshot here: https://prnt.sc/sSOYyaMQw_Ed

 

[ArshilAhmad]

You are receiving the Price field in the Line Itemizer action step.

 

[basslion]

Hello thank you for pointing that out. Ok so i have followed the video and setup everything except for the Action for air table. Can you look into the possibility of our use case? The workflow is Multi Product Test Workflow

 

[Preeti Paryani]

Hello @basslion,

We have recorded a detailed video explaining the key points we observed in your workflow after reviewing it.

Please go through the video and share your responses to the questions mentioned, so we can guide you further accordingly.

 

[basslion]

I appreciate that. may i ask where the video is so i can watch it?

 

[ArshilAhmad]

Hello thank you for pointing that out. Ok so i have followed the video and setup everything except for the Action for air table. Can you look into the possibility of our use case? The workflow is Multi Product Test Workflow

Pabbly

connect.pabbly.com

Could you please confirm whether you are receiving the 'Group' information you mentioned in your initial query? If yes, kindly share a screenshot showing the same.

 

[basslion]

Pabbly

connect.pabbly.com

Could you please confirm whether you are receiving the 'Group' information you mentioned in your initial query? If yes, kindly share a screenshot showing the same.

I am not sure if i am receiving it as i dont know what to look for. The initial video at the top of this thread just showed me how to extract information from an order ie: Product Name, Quantity and Price and then to replace comma with new line.

 

[basslion]

Hello @basslion,

We have recorded a detailed video explaining the key points we observed in your workflow after reviewing it.

Please go through the video and share your responses to the questions mentioned, so we can guide you further accordingly.

May i ask where is the recorded video you mention?

 

[ArshilAhmad]

I am not sure if i am receiving it as i dont know what to look for. The initial video at the top of this thread just showed me how to extract information from an order ie: Product Name, Quantity and Price and then to replace comma with new line.

That was just to check whether you are receiving the desired 'Category (Group)' information from WooCommerce, since you mentioned that you wanted to create the invoice using the 'Category (Group)' instead of the product name. Do you want to create the invoice based on the product name, since you’re not receiving the 'Category (Group)' data?

May i ask where is the recorded video you mention?

We have asked Preeti to share the video; you will receive it shortly.

 

[basslion]

That was just to check whether you are receiving the desired 'Category (Group)' information from WooCommerce, since you mentioned that you wanted to create the invoice using the 'Category (Group)' instead of the product name. Do you want to create the invoice based on the product name, since you’re not receiving the 'Category (Group)' data?

I was hoping to put each product in a group in Woocommerce and have that group name show in the data transformer along with other info ie: quantity, price, subtotal, discounts, shipping etc.

That way in Wave, we just set the products as groups ie: Clothes

ie: if someone orders a shirt and pants and socks, it will be under "clothes"

and in Wave invoice it would show:

Clothes 59.99
Clothes 89.99
Clothes 19.99

 

[Preeti Paryani]

Hello @basslion,

Please find below the video mentioned in my previous reply:

Multi Product Test Workflow | Pabbly Connect

www.awesomescreenshot.com

You can also refer to the tutorial on how to create an invoice in Wave.