Importing WooCommerce Data
This guide will walk through how to pull data from the WooCommerce API and put it directly into Google Sheets.
Begin by acquiring an API key from WooCommerce, then setting up a request to pull order data using Phlorin in Google Sheets.
Getting Started
the API solution add-on from Google Marketplace.
To request order data you must first login into your desired WordPress account
- From the admin panel go into your WooCommerce settings (Woo Commerce > Settings)
2. Go into the Advanced tab, then in the sub tab click the REST API tab.
From here you can click Create an API key.
3. Next, you will be presented with a screen to generate the key. Enter a description and click Generate API Key.
4. The API key is now generated in the form of a Consumer key and Consumer secret.
Copy these to use with Phlorin in Google Sheets.
Pull WooCommerce data into Sheets
To get the most out of WooCommerce, use Phlorin to pull sales data seamlessly into Google Sheets.
1. In your desired Sheets document, open Phlorin and create a new request
Extensions > Phlorin > Open > Create a request
2. In the Application dropdown select or search for WooCommerce.
3. Next choose what endpoint you are seeking.
This example shows list all orders.
4. Enter the required parameters:
Input your site domain: (ex. shop.example.com)
If your site URL is: https://shop.example.com, enter without the prefix)
Input your Consumer key and Consumer secret from WooCommerce.
5. Select your desired sheet and click Run
Creating Custom Request
With Phlorin and WooCommerce API documentation you can create URLs to run custom requests. Search their documentation for the desired parameters and endpoints to adapt the URL to your needs.
This example shows how to use Phlorin to fetch order data from the WooCommerce plugin.
Application: Custom
Method: GET
Request URL: https://yourwebsite.com/wp-json/wc/v3/orders?consumer_key=abc12345&consumer_secret=zyx9876
Adapting the URL to your needs:
To adapt the URL to your website and WooCommerce, three things need to be updated: the website, consumer key, and consumer secretIn the example, the website: yourwebsite.com is specific to this user’s website. Replace it with the web address associated with the WooCommerce plugin.
The consumer key: abc12345, is specific to this user’s consumer key. Take the appropriate consumer key and replace it there.
The consumer secret: zyx9876, is specific to this user’s consumer secret. Take the appropriate consumer key and replace it there.
URL EXAMPLE: https://(WEBSITE-HERE).com/wp-json/wc/v3/orders?consumer_key=(CONSUMER-KEY-HERE)&consumer_secret=(CONSUMER-SECRET-HERE)
Handling Pagination
Stayed tuned. Detailed instructions coming soon.
Documentation
WooCommerce API official documentation: https://woocommerce.github.io/woocommerce-rest-api-docs/#introduction