Help with Woocommerce > Google Sheets

Hi @joyryde ,

We can definitely help. Keep in mind that each action in a recipe can only output 1 row per recipe run, so what’s important is that your trigger targets the product purchased rather than the order completion. When it’s a product trigger, we run the recipe once per produce purchase, but when it’s order based, you’ll get 1 line with the products grouped.

I wonder if you could provide a screenshot of the edit recipe page with all details expanded, so we can see what tokens you’re using and how you’re sending data. What you’re describing sounds order-based, so let’s dig further into the recipe.

Right now we can’t send tax per product, it’s based on the order. That’s a good suggestion though; we’ll see if we can get that into an upcoming release.

Hi!

I can’t see any way to expand the recipe any more than I did in the screenshot above?

I’m sorry, I didn’t even notice that you could click into the image and scroll down.

Okay, for the product-based trigger, our team confirmed you should be using the “A product?has its associated order set to?a specific status” trigger instead. This is in our Pro version though, and I’m not sure if you’re using Pro. With that trigger, however, it will fire for every product in the order and create a separate row in Google Sheets specific to the product that was purchased. It does still have order tokens too that you can include in other columns.

• This reply was modified 1 year, 6 months ago by Uncanny Automator. Reason: typo

OK!

So if we purchase the Pro version, will it properly parse the product price + sales tax + shipping fee onto each row of the spreadsheet when there are multiple products on one order? How will it handle the costs so they are accurate?

For example, 1 item on an order might have sales tax and free shipping. Another item might have sales tax but free shipping. Our staff enters the total per item in the google sheet manually, will the automator be able to replicate hat the staff has to do manually?

And will the pro version be able to assist with the questions we had about shipment tracking above?

We are happy to pay for it if it can automate everything our staff has to do manually all day long!

Sorry about the confusion.

The trigger that will help you get each product in an order into separate rows in Google Sheets is in Automator Pro.

A token for tax by product is still a feature request. You can see available tokens for that trigger by visiting our WooCommerce integration page (https://automatorplugin.com/integration/woocommerce/) and clicking the + icon to the right of the trigger. You will unfortunately see that there is nothing available for tax at a product level. Shipping details are unfortunately also only at the order level, not product.

It’s also not on the Automator side that a tracking number could be pushed from Google Sheets to an Automator recipe that updates the order meta record with the tracking number. You would need to set up a web app in Google Sheets that could send the data via webhook.

I’m afraid that Automator will get you close to what you want, but there are still some gaps that would either require custom development or that might be available in a future release.

Sorry about that.

OK!

So I guess the pro version won’t do anything more than what the free version is doing, except put each product on a new row, but the prices will still all be wrong, so I guess we will keep it as-is for now.

I don’t think you saw the part above where we mentioned that the automator is duplicating every single product on a row where the buyer ordered more than one product?

Fiamma F45S 260/450 Awning Right Hand Leg Fixing Kit Female (98655-550), Fiamma F45S 260/450 Awning Left Hand Leg Fixing Kit Female (98655-549) (Fiamma F45S 260/450 Awning Right Hand Leg Fixing Kit Female (98655-550) x 1 | Fiamma F45S 260/450 Awning Left Hand Leg Fixing Kit Female (98655-549) x 1)

• This reply was modified 1 year, 6 months ago by joyryde.

We tested Zapier over the weekend and their automation is able to successfully separate line items into google sheets, and add sales tax and shipping; hopefully you guys can do the same soon.

How do we fix the plugin flaw where every Woocommerce order with more than 1 product is all entered onto one line in the sheet, but then every item is entered twice on the saw row; once with a comma between each product, and then a second time with a | between each product.

Example:

Fiamma F45S 260/450 Awning Right Hand Leg Fixing Kit Female (98655-550), Fiamma F45S 260/450 Awning Left Hand Leg Fixing Kit Female (98655-549) (Fiamma F45S 260/450 Awning Right Hand Leg Fixing Kit Female (98655-550) x 1 | Fiamma F45S 260/450 Awning Left Hand Leg Fixing Kit Female (98655-549) x 1)

• This reply was modified 1 year, 5 months ago by joyryde.

Hi @joyryde , thanks for your patience. We needed our dev team to take a closer look here.

Okay, with regard to tax, our team says this is a Woo constraint rather than something we simply don’t support on the Automator side. That does unfortunately make the possibility of us being able to support it in future less likely.

With regard to the duplicate entry, our team says the “Product title (Product quantity)” token is returning an unexpected value because there are 2 products and then it fires product title x quantity. If you switched it to the “Order products and quantity” token instead, then you would get something in this format: Product A x1 | Product B x 3. If you are routing through Zapier, you could use it to parse the data and return results individually. They provided this screenshot example: https://cln.sh/tcTCbFKR

The Pro trigger though is still recommended as it avoids the issue and gives you everything separated by row by product.

And with the shipping method, if there’s webhook support, you could listen to incoming data from the shipping company and update a Google Sheets row based on the order ID, though that would require Pro too.

We hope the above is helpful!

Thank you! This is very helpful!

This is helping with our orders for single products but we are gong to struggle with now having to re-adjust every order where there are multiple items because each item from a different vendor goes on a separate row. Is this something we could upgrade to the pro plugin and then pay to have built for us? What about also paying to have this integrated with Trackship?

Trackship?/?Advanced Shipment Tracking Pro?allows the input of tracking numbers both via API and via CSV import. We really want to integrate with them so that when a tracking number is entered onto a row in Google sheets, the automator can push the tracking number to that order in?Trackship?/?Advanced Shipment Tracking Pro, or if that’s not possible, do it the other way around and when an order has tracking in Woocommerce, automate that back to the corresponding order in Google Sheets.

https://www.zorem.com/product/woocommerce-advanced-shipment-tracking/

• This reply was modified 1 year, 5 months ago by joyryde.

We are still considering upgrading today, can you assist with integrating with Zorem so that we can sync tracking with Google Sheets?

https://www.zorem.com/product/woocommerce-advanced-shipment-tracking/

Hi @joyryde

Sorry for the late reply.

I’m afraid we aren’t able to help with custom development ourselves, but if you do have a developer we have a lot of documentation available and we’re happy to help with minor questions if they get stuck. We will track the Zorem integration as a feature request, but I’m afraid it’s not something we would be able to do on our side immediately or as a custom request.

We upgraded to the paid version, and now the plugin is adding a date to google sheets from Woocommerce that isn’t formatted how it was before?

https://tinyurl.com/2c29kmpg

Hi @joyryde , that’s something we haven’t seen before. So this is exactly the same recipe, the only change you made is activating Pro, and those alone have changed the date format? Just in case, could we get an updated screenshot of the edit recipe page to see if we can reproduce it?

Do you know if other plugins have been updated at all, and can you confirm your Automator Free and Pro versions?

Thanks

Version 4.15.1 | By Uncanny Automator, Uncanny Owl

Version 4.13 | By Uncanny Owl

Not sure about other plugins, we have over 70.

We didn’t change the recipe, we just upgraded. I believe I found what is going on as well. We added a new single blank row at the bottom of the sheet below where Automator is adding new rows, and then formatted the entire column to have the date format we wanted; now when a new row is added, Sheets is keeping them formatted. Without the blank row, new rows aren’t formatted properly.

So I think this is working for now.

Oh, that’s interesting… and does likely explain it. Thanks for the update!