Google Sheets integration
under review
Stavros Mitchelides
We need to have tracking numbers sent to AST Pro from a Google Sheet, or, we need to have the plugin send tracking numbers from Woocommerce back to a Google Sheet.
Currently our staff has to copy and paste hundreds of tracking numbers from emails into rows of a google sheet to correlate them to an order. Then they have to open Woocommerce and paste the tracking numbers into AST Pro a second time.
Ideally we would like to simply paste tracking numbers once time either into AST Pro or into the spreadsheet, and then have them synced.
We can set up the sheet to have the fields that AST Pro might need in order to correlate the tracking number to the correct order and SKU's.
Currently our sheet has a column with the order number and another column with the products and SKU's that ship together in one shipment, so the order number and SKU's will correlate to one tracking number in the tracking column. The green rows in the screenshot have no tracking yet, the white rows had tracking entered, for example.
Zorem
under review
Stavros Mitchelides
Zorem: We'd be happy to enter tracking into AST Pro in Woocommerce first, and then have it pushed back into the spreadsheet as well...wither way works!
Stavros Mitchelides
Zorem: Perhaps you can integrate with UNCANNY AUTOMATOR plugin? https://wordpress.org/support/topic/help-with-woocommerce-google-sheets/#post-16769642
Zorem
Stavros Mitchelides: We checked the option to import tracking information from Google Sheets to WooCommerce using the WooCommerce API and it's possible by creating a script in Google Sheets which is out of scoop to our development, we offer a shipment tracking endpoint that you can use for that. We will also check the option to export tracking info to Google sheets but I am not sure we can implement your requirement to export it into a custom format. We will update you here on the result of our investigation.
Stavros Mitchelides
Zorem: We wold be happy to pay for assistance with a Google Sheets Script.
Stavros Mitchelides
Still need to get this working.