Sage inventory and order automation with Make
Task
Create a Sage integration with WooCommerce using the Make.com automation system:
- Synchronization of order, customer, payment method, and inventory stock data (e.g., an order automatically goes into Sage and reduces inventory depending on the quantity of products ordered).
- VAT refund calculation (3 different VAT rates).
- Statement of all debits and credits (Trial Balance).
- Calculation of losses and profits (Loss & Profit).
Results
In the initial stage of the project, Zapier was used as the integration tool. We expected a smooth process, but encountered a significant technical hurdle. The main issue was the data transfer from Zapier to Sage due to a failure in their integration. This problem was identified as a general failure in the Zapier and Sage integration capabilities. Limited efforts to resolve the issue from Zapier led to the conclusion that solving the problem would require waiting for an update or fix from either Zapier or Sage – a timeline without a definite end date, which did not meet our project requirements.
Considering the nature of business operations integration, we chose Make.com. This decision proved to be very beneficial. Make.com offered more reliable integration options, especially in handling the complex data flow required for specific client needs.
Industry
Grills and accessories