Update Product Pricing From SAP Business One To Shopify And Pipedrive
SAP B1 → Shopify, Pipedrive
Apps Required
No-code and low-code platform
Explore how the templates work
Trigger on item price updates in SAP B1
The workflow starts when item prices are updated in SAP Business One, using a scheduled trigger that checks for updated records every 3 minutes.
Decision: Check if product exists in Shopify
Evaluates the SAP B1 item's U_WebID field to determine if the item is already linked to a Shopify product.
Create new product in Shopify and update pricing
If the product does not exist in Shopify, a new product is created using the item name. SAP B1 is then updated with the Shopify product and variant IDs (U_WebID, U_VarId) and last price. Finally, the Shopify variant pricing is updated.
Update existing product pricing in Shopify
If the product already exists in Shopify, the variant pricing is updated directly using the stored Shopify IDs. SAP B1 is then updated with the last price for tracking.
Decision: Check if product exists in Pipedrive
Evaluates the SAP B1 item's U_PipeID field to determine if the item is already linked to a Pipedrive product.
Create new product in Pipedrive
If the product does not exist in Pipedrive, currency information is fetched from Airtable, then a new product is created in Pipedrive with the item code, name, description, and pricing. SAP B1 is updated with the Pipedrive product ID (U_PipeID) and last price.
Update existing product pricing in Pipedrive
If the product already exists in Pipedrive, currency information is fetched from Airtable, then the Pipedrive product pricing is updated. SAP B1 is updated with the last price for tracking.
Filter significant price changes
A code step filters items where the price has changed by 30% or more compared to the last recorded price, identifying significant pricing movements.
Send email alert for significant price changes
Filtered items are aggregated and a Gmail notification is sent containing item codes, new prices, and previous prices to alert stakeholders of significant pricing changes.
Select an App to View Supported Features
| Modules | Trigger |
|---|---|
| Business partners updated | Triggered when a business partner is updated in the SAP B1 |
| New returns created | Triggered when a new return request is created in the SAP B1 |
| New quotations created | Triggered when a new quotation is created in the SAP B1 |
| New AR invoices created | Triggered when a new AR invoice is created in the SAP B1 |
| New business partners created | Triggered when a new business partner is created in the SAP B1 |
| New service calls created | Triggered when a new service call is created in the SAP B1 |
| New incoming payments created | Triggered when a new incoming payment is created in the SAP B1 |
| New orders created | Triggered when a new order is created in the SAP Business One |
| New Credit Note created | Triggered when a new AR credit note is created in the SAP B1 |
| Items price updated | Triggered when a existing item prices are updated in the SAP B1 |
| New items created | Triggered when a new item is created in the SAP B1 |
| New deliverynotes created | Triggered when a new delivery note is created in SAP Business One. |
| Items updated | Triggered when a existing item is updated in the SAP B1 |
| New activities created | Trigger when new activities are created in SAP Business One. |
Streamline Your Order Process with Automation
Multi-channel price synchronization
Automatically sync SAP Business One item prices to both Shopify and Pipedrive simultaneously, ensuring consistent pricing across ecommerce and CRM platforms.
1
2
Smart create-or-update logic
Built-in decision nodes check if products exist in each platform using stored IDs, creating new products or updating existing ones as needed to prevent duplicates.
Bidirectional ID tracking
SAP B1 items are updated with Shopify product and variant IDs (U_WebID, U_VarId) and Pipedrive product IDs (U_PipeID) for seamless cross-reference between all systems.
3
4
Significant price change alerting
Price changes of 30% or more are automatically detected, aggregated, and emailed to stakeholders via Gmail, ensuring visibility into major pricing movements.
Currency-aware Pipedrive sync
Airtable integration provides currency mapping for accurate Pipedrive product pricing, ensuring correct multi-currency support.
5
1
Multi-channel price synchronization
Automatically sync SAP Business One item prices to both Shopify and Pipedrive simultaneously, ensuring consistent pricing across ecommerce and CRM platforms.
2
Smart create-or-update logic
Built-in decision nodes check if products exist in each platform using stored IDs, creating new products or updating existing ones as needed to prevent duplicates.
3
Bidirectional ID tracking
SAP B1 items are updated with Shopify product and variant IDs (U_WebID, U_VarId) and Pipedrive product IDs (U_PipeID) for seamless cross-reference between all systems.
4
Significant price change alerting
Price changes of 30% or more are automatically detected, aggregated, and emailed to stakeholders via Gmail, ensuring visibility into major pricing movements.
5
Currency-aware Pipedrive sync
Airtable integration provides currency mapping for accurate Pipedrive product pricing, ensuring correct multi-currency support.
Related Templates
Frequently Asked Questions
Common questions about this automation template.
Automate anything with appse ai
Automate smarter with an AI-native platform designed for the way mid-market businesses really work.
SOC 2
SAP Certified Partner
ISO/IEC 27001
GDPR