How to Sync Your Woocommerce Shop with Google Sheets (Easy 5 minute setup)
Vložit
- čas přidán 26. 07. 2022
- In this video I’m going to show you how to sync your WooCommerce shop orders, products, customers, coupons etc. into a single Google Spreadsheet. And then sync your stock, prices etc. back to the shop. Really nifty stuff.
WooCommerce Google Spreadsheet Addon is here www.wpsyncsheets.com/
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 FAVOURITE WEBHOSTING PROVIDERS:
Verpex Hosting wpsimplehacks.com/verpex (SAVE 22% Coupon WPSH22)
A2 hosting wpsimplehacks.com/a2-hosting
✅ AWESOME WORDPRESS PLUGINS:
WPCodeBox wpsimplehacks.com/wpcodebox (SAVE 20% Coupon WPSH20)
WooLentor 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 WooExtras wpsimplehacks.com/wooextras (SAVE 10% Coupon SIMPLEHACKS)
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)
Best Woocommerce sidecart plugin - Woocommerce Cart in One wpsimplehacks.com/cartinone - Jak na to + styl
You can buy WooCommerce Google Spreadsheet Addon here 1.envato.market/rnrZx5
BTW, that link you provide shows that the product is no longer available.
I just went straight to their site and purchased there and made a point of telling them YOU SENT ME ;-)
You're probably missing some well earned affiliate commissions.
Keep up the good work, thank you.
Recently been watching your channel A LOT. I really enjoy your no BS straight to the point videos.
Please keep up the great work, I have no doubt your subscribers are going to go once they find you.
Liked and Subscribed.
THANK YOU!
Thank you for your kind words :)
This plugin works, but i need the previous form detail to the spreadheets 😢 like the product packages, the size of cothes, etc.. can i do that?
I don’t know. It would be wise to ask about it from the plugin support team.
Hello. Do you have a video on how to recieve data to the google sheets via API? thanks
No, unfortunately I don't
hello could you recommend a plugin to distribute or synchronize woocommerce product to other platforms
If these platforms are able to import from CSV or XML, then use WP All Export to create a feed and use this feed to sync the information.
I'm not sure I understand your answer correctly since I don't speak English very well,
I explained my problem to you but I don't know if I expressed myself very well
there are two things I would like to do,
firstly I would like to sync the stock and also my listings from woocommerce to Amazon, eBay...
there is a free plugin called product feed pro but it does not work with Amazon eBay and also other Marketplaces
and the second thing is regarding analytics, so I would like to retrieve live the history of my sales made on these platforms, for it to be live it must be done with an API? I thought I understood in your response to my comment that you are talking to me about CSV but in this case it will not be synchronized?
Plugin nice. But did you test if the product images support webp?
No, I did not because my site generates webp files on the fly from the uploaded images.
@@wpsimplehacks Thank you. Since the method you use is paid, I asked for the free method, the webp installation method. Hello
How can we update woocommerce memebership for users and add a membership for a user?
Sorry, can’t help you with that.
Will it sync variable products also?
Yes, if you set your Google Sheets up that way.
Thanks for your reply. I just bought the plugin. It is really good. Thanks also for this valuable video.
@@wpsimplehacks Hi, can you please upload video how to setup (make) variabile product Google Sheets for sincing in this way ? Thanks in advance !! P.S. Nice and educative chanel, I find you today, and folow your work from now ;-)
Hello. The video won't start for me.. all other videos play normaly.
I just testes with 4 different browsers and works well everywhere.
@@wpsimplehacks I tested on few devices, accounts, app or browser, wasn't working. Now it works. I love your content, please keep it up!
Your licence key is visible 1:51
Thanks :)
How come you need to give permission to "see and download all your google drive files". Instead of just the sheets your working with.
I guess it’s because sheets are located on your drive. There’s also an alternative plugin which allows you to sync all sorts of information using automations. See here czcams.com/video/wwc5B7Lkd6s/video.html At 16:43 mark there’s a part about syncing info with Google Sheets.