New products created
Trigger when new products are created in WooCommerce.
About this template
What this workflow does
Automatically sync pending WooCommerce orders to SAP Business One with duplicate prevention, complete line item mapping, shipping charges, and full order traceability.
Key benefits
- Zero-Touch Order Processing
- Built-In Duplicate Prevention
- Complete Line Item and Shipping Mapping
- Full Traceability from Storefront to ERP
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 WooCommerce — automatically, every single day. Here is exactly what happens when this template runs.
Detect New WooCommerce Orders
A scheduled trigger polls WooCommerce every three minutes for newly created orders. Each order payload includes the order ID, customer ID, order date, line items with SKUs, quantities, and subtotals, shipping lines, tax lines, and the current order status.
Filter for Pending Orders Only
A filter node passes only orders with a status of 'pending', ensuring that only new, unprocessed orders continue through the workflow. Completed, cancelled, or already-processed orders are dropped at this stage.
Check for Duplicate Order in SAP Business One
The workflow searches SAP Business One for an existing sales order that matches the WooCommerce order ID using a custom field (U_WEBORDID) and the customer reference number (NumAtCard). This prevents the same WooCommerce order from being entered into the ERP more than once.
Decide: New Order or Already Exists
A decision node evaluates the SAP search result. If a matching document number (DocNum) is found, the order already exists and the workflow stops. If no match is found, the workflow proceeds to create a new sales order in SAP Business One.
Create Sales Order in SAP Business One
A new sales order is created in SAP Business One with comprehensive field mapping. The WooCommerce order date becomes the document date, the customer ID is prefixed to form the SAP card code, and the WooCommerce order ID is stored in both the customer reference field and a custom web order ID field for traceability. Document lines include each product line item with its SKU, quantity, unit price, and tax code, plus a separate line for shipping charges with the shipping method as the item code.
Business benefits
More than moving data between apps — here is the measurable impact this automation delivers for your team.
01
Zero-Touch Order Processing
Every pending WooCommerce order is automatically captured and entered into SAP Business One as a sales order—eliminating manual data entry and reducing order processing time from hours to minutes.
02
Built-In Duplicate Prevention
Before creating any order, the workflow searches SAP for an existing record matching the WooCommerce order ID. This ensures no order is entered twice, even if the trigger picks up the same order in consecutive polling cycles.
03
Complete Line Item and Shipping Mapping
Product line items with SKUs, quantities, prices, and tax codes are mapped directly from WooCommerce, and shipping charges appear as a separate document line—giving finance and warehouse teams a complete picture of every order.
04
Full Traceability from Storefront to ERP
The WooCommerce order ID is stored in both the customer reference field and a custom web order ID field in SAP, creating a clear audit trail that links every ERP sales order back to its original eCommerce transaction.
01
Zero-Touch Order Processing
Every pending WooCommerce order is automatically captured and entered into SAP Business One as a sales order—eliminating manual data entry and reducing order processing time from hours to minutes.
02
Built-In Duplicate Prevention
Before creating any order, the workflow searches SAP for an existing record matching the WooCommerce order ID. This ensures no order is entered twice, even if the trigger picks up the same order in consecutive polling cycles.
03
Complete Line Item and Shipping Mapping
Product line items with SKUs, quantities, prices, and tax codes are mapped directly from WooCommerce, and shipping charges appear as a separate document line—giving finance and warehouse teams a complete picture of every order.
04
Full Traceability from Storefront to ERP
The WooCommerce order ID is stored in both the customer reference field and a custom web order ID field in SAP, creating a clear audit trail that links every ERP sales order back to its original eCommerce transaction.
Questions & answers
Frequently asked questions
Everything you need to know about this template before you deploy it.
How does the workflow prevent duplicate orders in SAP?
Before creating a sales order, the workflow searches SAP Business One for existing orders matching the WooCommerce order ID via a custom field (U_WEBORDID) and customer reference number. If a match is found, the creation step is skipped entirely.
Which WooCommerce order statuses are processed?
How are shipping charges handled in the SAP sales order?
How often are new WooCommerce orders picked up?
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