How to Automate WooCommerce Orders in Google Sheets?
Vložit
- čas přidán 21. 05. 2023
- In this video, I’m going to show you the easiest and fastest solution to manage and sync your WooCommerce orders using Google Sheets. I’ll also show you how you can manually import WooCommerce order details with a single click, sync orders 2 ways between WooCommerce and Google Sheets, export unlimited order details automatically from WooCommerce etc. with just the help of a plugin.
✅ Get the awesome order sync plugin:
Order Sync with Google Sheets for WooCommerce (Save 20% using coupon WPSH20 ): wcordersync.com/pricing/
Blocksy and Kadence are currently two of the best WordPress themes. So, if you’re interested, then you can grab:
🅱️ Blocksy theme wpsimplehacks.com/blocksy (SAVE 10% Coupon WPSH10)
🔵 Kadence theme here: wpsimplehacks.com/kadence (SAVE 10% Coupon SIMPLEHACKS)
✅ If you want to be the first to be notified about the new tutorials then please subscribe to this channel. / @wpsimplehacks
✅ BEST WORDPRESS THEMES:
Blocksy theme: wpsimplehacks.com/blocksy (SAVE 10% Coupon WPSH10)
Kadence Theme: wpsimplehacks.com/kadence (SAVE 10% Coupon SIMPLEHACKS)
Astra Theme: wpsimplehacks.com/astra
GeneratePress: wpsimplehacks.com/generatepress
OceanWP: wpsimplehacks.com/oceanwp (SAVE 10% Coupon WPSH10)
✅ MY FAVORITE WEBHOSTING PROVIDER:
Verpex Hosting wpsimplehacks.com/verpex (SAVE 22% Coupon WPSH22)
✅ AWESOME WORDPRESS PLUGINS:
WPCodeBox wpsimplehacks.com/wpcodebox (SAVE 20% Coupon WPSH20)
Flowmattic no-coding automation plugin wpsimplehacks.com/flowmattic (SAVE 15% Coupon WPSH15)
ShopLentor Elementor/Gutenberg add-on wpsimplehacks.com/woolentor (SAVE 20% Coupon WPSH20)
Best Wordpress Backup, Migration and Staging plugin - WpVivid Pro wpsimplehacks.com/wpvidid (SAVE 20% Coupon WPSH20)
Best Gutenberg Blocks addon - Kadence Blocks wpsimplehacks.com/kadenceblocks (SAVE 10% Coupon SIMPLEHACKS)
Best forms plugin - Fluent Forms: wpsimplehacks.com/fluentforms (SAVE 20% Coupon: WPSH20)
WP Social Ninja wpsimplehacks.com/socialninja (SAVE 20% Coupon: WPSH20)
Best for email marketing - Fluent CRM: wpsimplehacks.com/fluentcrm (SAVE 20% Coupon: WPSH20)
Best for creating tables - Ninja Tables wpsimplehacks.com/ninjatables (SAVE 20% Coupon: WPSH20)
Best events calendar and ticket selling plugin - WP Eventin wpsimplehacks.com/wp-eventin (SAVE 20% Coupon: WPSH20)
Best Wordpress LMS - Tutor LMS wpsimplehacks.com/tutorlms (SAVE 20% Coupon thmwelcome20)
Best Wordpress SEO plugin - SEOPress wpsimplehacks.com/seopress
Image Map Pro - wpsimplehacks.com/imagemap
✅ AWESOME WOOOCOMMERCE EXTENSIONS:
Best Woocommerce Swiss Knife tool - Kadence Shop Kit wpsimplehacks.com/wooextras (SAVE 10% Coupon SIMPLEHACKS)
Best visual sales funnel builder - WpFunnels wpsimplehacks.com/wpfunnels10 (SAVE 10% Coupon WPSH10)
Advanced Dynamic Pricing Pro wpsimplehacks.com/dynamic-pri... (SAVE 20% Coupon: WPSH20)
Phone orders For Woocommerce Pro wpsimplehacks.com/phone-order... (SAVE 20% coupon: WPSH20)
Advanced Orders Export Pro wpsimplehacks.com/export-orde... (SAVE 20% coupon: WPSH20)
Location Picker at Checkout for WooCommerce wpsimplehacks.com/lpac (SAVE 15% coupon: WPSH15)
Best Woocommerce sidecart plugin - Woocommerce Cart in One wpsimplehacks.com/cartinone - Jak na to + styl
✅ Get the awesome order sync plugin:
Order Sync with Google Sheets for WooCommerce (Save 20% using coupon WPSH20 ): wcordersync.com/pricing/
thank you, is it possible to add your own custom columns to the Google sheet in between the automatic columns that this creates. for example a column for who is processing the order positioned between order status and total items columns?
your intro and the telling what will be inside the video in short - i REALY LIKE. thank you.
Thank you for the feedback :)
Thank you. Interesting plugin.
Indeed it is :)
Hi, great video! Can you update tracking numbers on this sheet?
Probably not, but it would be wise to ask about it from the plugin support team.
Did you come up with any ideas,
I have a question, what if you order 3 items, will the items put in new rows for each of the items or it will be like this in one cell (comma seperated): Item 1, Item 2, Item 3
Each Google Sheets row represents an order. So if you order 3 items they will be stored as comma-separated in one cell (exactly as you mentioned!).
@@ahmrhydwan1247 ohhh i see, I hope they can add an option where the multiple items can go on each row
Do you know is there a way to make it work in a way that every product is on separate row?
Hi, currently there is no such option. But it's an important feature and already on our roadmap!
May I ask if you still recommend WPSyncSheets for product sync?
I haven't used it for a while but when I did then it was solid.
@@wpsimplehacks thaaaank you! Are there other product sync ones that you know of?
It depends on what exactly you would like to sync. Flowmattic allows you to sync all sorts of thins. See this video czcams.com/video/wwc5B7Lkd6s/video.html
@@wpsimplehacks i want to sync VARIABLE products mainly 🤩
@sakrum7 Stock Sync for WooCommerce with Google Sheets should work for you.
Can I link same sheet to multi Woocommerce and of course I will manage the data from sheet ?!!
I haven't used it wit multisite Woocommerce, so it would be wise to ask about it from the plugin support team.
can i create custom field in the checkout field, and sync it to spreadsheet also?
I haven’t tried. Try to ask about it from the plugin support team.
@risyadhrp6968 Can we add? Have you confirmed ?
Hi, yes. You can sync custom checkout fields with Google Sheets with the Ultimate version of our plugin.
thank you very much
You're welcome 😊
Thanks!
Thanks 🙂
I have issues in the installation process it says can't update the plugin
It would be wise to ask about it from the plugin support team. :)
@@wpsimplehacks yeah I think I should, thank you so much
good plugin, but pro version is too expensive if you are not from US/EU 👍
🙂
hi, copy the Script Code button is not working i can't copy the scripte
It would be wise to ask about it from the plugin support team
You do everything but the customer's name cannot be imported too, why?
It would be wise to ask about it from the plugin support team
You can import customer’s name, address, phone, and email with the Ultimate version of the plugin.
It does not sync the phone number which make the task pointless
I need the phone to work over orders
It would be wise to ask about it directly from the plugin support. Maybe there’s something wrong with the settings or so.
Hi, you can sync ustomer’s name, address, phone, and email with the Ultimate version of our plugin.
Thanks @wpsimplehacks for sharing! ❤
You're welcome 😊