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?