WooCommerce
WooCommerce
Appiworks WooCommerce Connector is a Looker Studio connector that helps to connect Looker Studio with WooCommerce and use it as a data source in Looker Studio.
Appiworks WooCommerce Connector turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable.
WooCommerce is a free and open-source e-commerce plugin for WordPress that transforms a standard WordPress website into a fully functional online store. It provides all the necessary features to sell products, including adding products, setting up shipping and payment methods, managing inventory, and handling orders.
Step 1: Choose "WooCommerce Appiworks" connector by Jivrus Technologies from Looker Studio Partner Gallery
Step 2: Click on 'AUTHORIZE' button for authorizing your google account.
Step 3: Once you click Authorize button, you can provide access with your Google account .
Step 4: Click on 'Allow' button for Access google Account.
Step 5: Once you are authorized to Google account then you need to authorize for third-party service. In this case, WooCommerce Appiworks.
Step 6: Click on 'AUTHORIZE' button for authorizing your WooCommerce Appiworks account.
Step 7: Once you click on authorize, you need to log in with your Appiworks Account.
Log in with Google or provide the required email and password for login.
Step : After log in with the google account, you have to create connection for WooCommerce in Appiworks. Click on "Create new Connection" button.
If you have created connections already in Appiworks, you can choose it and proceed.
Step 8: To create new connection provide all required credentials.
Consumer Key
Consumer Secret
Store link
Once after you gave credentials click on Connect button. Then choose this connection and click on "Confirm Selection".
In your WordPress app, choose WooCommerce, click on Settings
Then select Advanced option -> RESR API
Then select 'Add key'
Provide description and permission for your key and select 'Generate API Key' button.
It will generate Consumer Key and Consumer secret. Use these for authentication.
To get the store URL, copy the URL from the browser URL as shown in the screenshot.
Step 9: After authorizing Appiworks account. You will see the configuration page shown as in the image. Select your connection and click on "Next" button.
To manage your connections click on the link given for connection management.
Step 10: Connection management link will again ask you to authorize. Sign in with your google account or credentials
Step 11: In connection management, you can create or edit connections.
Step 12: In the configuration page, choose connection, select an object
Then Click on "Connect" button.
Step 13: The available fields from the Customers Object are listed.
Step 14: Use this as a data source and continue normally with designing your report in Looker Studio.
Step 15: Click on the 'Create Report' button.
Step 16: You can customize the dashboard as you want.