Sync retail product prices between Shopify and WooCommerce with alerts

Retail Price Sync Automation for Shopify & WooCommerce

This workflow automates the synchronization of product prices across Shopify and WooCommerce platforms to ensure retail consistency. It triggers when a price change is detected in either system, applies platform-specific pricing rules (such as psychological rounding) and updates the secondary platform. The workflow also includes a threshold-based alerting system via Gmail for major price drops and logs every change to a Google Sheets master file for auditing.

Quick Implementation Steps

1. Set the priceChangeThreshold in the Shopify Configuration and WooCommerce Configuration nodes. 2. Connect your Shopify Access Token credentials to the Shopify trigger and update nodes. 3. Connect your WooCommerce API credentials to the WooCommerce trigger and update nodes. 4. Link your Google Sheets OAuth2 and Gmail OAuth2 credentials for logging and notifications. 5. Specify the documentId for your pricing log in the Log Price Changes node.

What It Does

This workflow acts as a bridge between two major e-commerce platforms, ensuring that a price update in one is intelligently reflected in the other. It goes beyond simple mirroring by:

1. Threshold Monitoring: Detecting if a price change exceeds a set limit (e.g., $150 or $500) to trigger immediate management alerts. 2. Platform-Specific Logic: Automatically formatting prices for different environments—for example, rounding WooCommerce prices to the nearest .99 for psychological pricing while using standard rounding for Shopify. 3. Audit Trail Creation: Maintaining a centralized record of all price migrations in Google Sheets, including SKUs, old vs. new prices and timestamps. 4. Team Communication: Sending automated email notifications to ensure the team is aware of successful syncs or critical price volatility.

Who’s It For