- Pabbly Connect
- Shopify
- WooCommerce
- Google Sheets
- Real project
Shopify & WooCommerce Order Management /Real Project
Syncs Shopify and WooCommerce orders and stock into one sheet
Created Shopify and WooCommerce order management automations using Pabbly Connect. Includes webhook integration to capture new and canceled orders, data formatting, and Google Sheets sync to log order statuses, cancellations, and inventory updates.
- Timeline
- 4 days
- Rating
- ★ 4.6
- Category
- Automations
At a glance
- Problem
- The client ran stores on both Shopify and WooCommerce but had no unified way to track orders, cancellations, and inventory across platforms.
- What I built
- Built order management automations using Pabbly Connect that capture every new order and cancellation from both platforms via webhooks.
- Tools
- Pabbly Connect, Shopify, WooCommerce, Google Sheets
- Result
- Client rating ★ 4.6 out of 5
The problem
The client ran stores on both Shopify and WooCommerce but had no unified way to track orders, cancellations, and inventory across platforms. Staff were manually checking each platform and copy-pasting order data into spreadsheets — leading to missed cancellations and inventory mismatches.
How it works
- 01Webhooks configured on Shopify and WooCommerce for new orders and cancellations
- 02Pabbly Connect receives the webhook and normalizes the data format
- 03Order details — product, quantity, status, customer — are extracted
- 04Google Sheets is updated with the new order or cancellation status
- 05Inventory counts recalculate automatically based on order activity
- 06Daily summary email sent to the team with order volume and cancellation rate
What I built
Built order management automations using Pabbly Connect that capture every new order and cancellation from both platforms via webhooks. The system formats the data, syncs it to a central Google Sheets tracker, and updates inventory counts in real time.
Stack
- Pabbly Connect
- Shopify
- WooCommerce
- Google Sheets