New orders created
Triggered when a new order is created in the SAP Business One
About this template
What this workflow does
Automatically sync SAP Business One item prices to both Shopify and Pipedrive simultaneously, ensuring consistent pricing across ecommerce and CRM platforms. 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.
Key benefits
- Multi-channel price synchronization
- Smart create-or-update logic
- Bidirectional ID tracking
- Significant price change alerting
Keep exploring
More templates for creativity
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Build your own version of this workflow
Every module in this template is fully customisable. Add triggers, swap actions, or extend the logic using appse ai's no-code visual builder.
Inside the flow
How the template works
appse ai runs this workflow end to end for SAP Business One — automatically, every single day. Here is exactly what happens when this template runs.
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.
Business benefits
More than moving data between apps — here is the measurable impact this automation delivers for your team.
01
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.
02
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.
03
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.
04
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.
05
Currency-aware Pipedrive sync
Airtable integration provides currency mapping for accurate Pipedrive product pricing, ensuring correct multi-currency support.
01
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.
02
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.
03
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.
04
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.
05
Currency-aware Pipedrive sync
Airtable integration provides currency mapping for accurate Pipedrive product pricing, ensuring correct multi-currency support.
Questions & answers
Frequently asked questions
Everything you need to know about this template before you deploy it.
What triggers this workflow?
The workflow is triggered when item prices are updated in SAP Business One, checked every 3 minutes via a scheduled trigger.
How does it handle new vs existing products?
What happens when prices change significantly?
How are systems linked together?
Why is Airtable used in the workflow?
Why businesses love appse ai
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Their quick updates and improvements have boosted our productivity, allowing us to focus on making better products. Highly recommend for any manufacturer seeking efficiency.
Hans Engstrom
Operations Manager, Christiana Bikes
appse ai enabled us to automate processes and achieve real-time efficiency with their ready-to-use solution. Their responsive support and customizations were exactly what we needed.
Peter Grueterich
President, Bernardo 1946
Rapidly growing companies, to get to that level of establishment, you need a solution like appse ai to bridge the connections between disparate systems.
Robert Donnelly
CEO and Co-Founder, Nine Line
The platform syncs data between our applications and it simply just works. This saved us a lot of time we used to spend manually synchronizing data from one system to another.
Sankar Thiagasamudram
Founder and CEO
Their quick updates and improvements have boosted our productivity, allowing us to focus on making better products. Highly recommend for any manufacturer seeking efficiency.
Hans Engstrom
Operations Manager, Christiana Bikes
appse ai enabled us to automate processes and achieve real-time efficiency with their ready-to-use solution. Their responsive support and customizations were exactly what we needed.
Peter Grueterich
President, Bernardo 1946
Rapidly growing companies, to get to that level of establishment, you need a solution like appse ai to bridge the connections between disparate systems.
Robert Donnelly
CEO and Co-Founder, Nine Line
The platform syncs data between our applications and it simply just works. This saved us a lot of time we used to spend manually synchronizing data from one system to another.
Sankar Thiagasamudram
Founder and CEO
appse ai helped us to manage our inventory and invoices in SAP and WooCommerce. With appse ai our job is much easy as everything is automated and we have better control on our inventory.
Kaywan Pour
Niagara Warenhandels GmbH
appse ai is making our operations easy! They make the customer experience much better. It costs us less human effort to proceed our orders.
Ramez Tacrity
Technical Sales Specialist, Digitech
I was impressed by how easy appse ai is to use and their ability to customize the platform to meet our clients specific requirements.
Vainick Oliveri
Golden Toys
appse ai transformed our business by automating the sync between SAP Business One and WooCommerce. What used to be a time-consuming, manual process is now seamless. We add products in SAP, and everything syncs automatically to the website.
Maher Ataya
Founder, Italparts SRL & Italparts LLC
appse ai helped us to manage our inventory and invoices in SAP and WooCommerce. With appse ai our job is much easy as everything is automated and we have better control on our inventory.
Kaywan Pour
Niagara Warenhandels GmbH
appse ai is making our operations easy! They make the customer experience much better. It costs us less human effort to proceed our orders.
Ramez Tacrity
Technical Sales Specialist, Digitech
I was impressed by how easy appse ai is to use and their ability to customize the platform to meet our clients specific requirements.
Vainick Oliveri
Golden Toys
appse ai transformed our business by automating the sync between SAP Business One and WooCommerce. What used to be a time-consuming, manual process is now seamless. We add products in SAP, and everything syncs automatically to the website.
Maher Ataya
Founder, Italparts SRL & Italparts LLC
appse ai truly helped us transform our business processes. Now with the integration, it has become really smooth, everything just flows better. It really helped our team save time, streamline processes and honestly boost productivity more than we expected.
Jason Mitchell
MD, All Marine Spares
Since we started using appse ai as our middleware, everything has been way smoother. It saved us about 10-20 hours a week, which is huge. The team is super responsive and easy to work with.
Dan Gerber
CEO, Designer Boys
appse ai truly understood our needs and delivered a seamless integration between SAP and Shopify. Their team is highly knowledgeable and capable, ensuring the solution perfectly aligned with our requirements.
Columb McCluskey
Sales Director, Trimwel
appse ai is fantastic, it works really well and is easy to use! Its visual interface makes it simple to see what is happening, and I especially liked the visual mapping of process flows. The teams professionalism also really impressed me.
Richard Grew
Renegade Brewery
appse ai truly helped us transform our business processes. Now with the integration, it has become really smooth, everything just flows better. It really helped our team save time, streamline processes and honestly boost productivity more than we expected.
Jason Mitchell
MD, All Marine Spares
Since we started using appse ai as our middleware, everything has been way smoother. It saved us about 10-20 hours a week, which is huge. The team is super responsive and easy to work with.
Dan Gerber
CEO, Designer Boys
appse ai truly understood our needs and delivered a seamless integration between SAP and Shopify. Their team is highly knowledgeable and capable, ensuring the solution perfectly aligned with our requirements.
Columb McCluskey
Sales Director, Trimwel
appse ai is fantastic, it works really well and is easy to use! Its visual interface makes it simple to see what is happening, and I especially liked the visual mapping of process flows. The teams professionalism also really impressed me.
Richard Grew
Renegade Brewery
Deploy this workflow in minutes
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.
SOC 2
SAP Certified Partner
ISO/IEC 27001
GDPR