The challenge
A French-speaking maple products producer runs its operation on Zoho. It makes maple syrup, maple butter and maple sugar, plans production in Zoho Creator and keeps stock in Zoho Inventory. Between those two apps, a lot of work happened by hand.
Each finished batch had to become a stock adjustment in Zoho Inventory, and for traceability that adjustment needed to say what went in: how many litres of organic maple syrup, how many kilograms of maple sugar and maple butter, and the lot number of each. Planning a run meant breaking every composite product into its components and adding up the quantities. Orders came from English and French-speaking clients, so product details had to be right in both languages.
Then there were the sales channels. Each new product had to be created again by hand in Square, the point of sale, and in Ecwid, the online store. The project docs name the cost: wasted time, incorrect product entries and inconsistent data between systems.
What we built
Amatec connected Zoho Creator, Zoho Inventory and Zoho Sheet with Deluge scripts, then used Make.com to push products out to Square and Ecwid. The work ran in stages between 2024 and 2026.
Production records with automatic lot numbers. In Zoho Creator, when a planned run is set to “Produit”, a script creates a draft record in the Production form with the date, the quantity produced, the items and the production lot number. Lot numbers generate themselves. The script finds the highest existing number and adds one, starting at 10000.
Stock adjustments that carry input lots. When a production record is saved as “Complété”, Creator posts it to a Zoho Inventory incoming webhook. A Deluge function in Zoho Inventory looks for an existing adjustment whose reference is that production lot number. If it finds one, it updates it. If not, it creates a new adjustment with the reason “Production” and the quantity made. Custom fields on the adjustment record the inputs:
- Litres of organic maple syrup, with its input lot number and notes
- Kilograms of maple sugar, with its input lot number and notes
- Kilograms of maple butter, with its input lot number and notes
Zoho’s API documentation gave no format for writing custom fields on a stock adjustment. So we pulled an existing adjustment through the API, read how its custom fields came back, and built the request in the same shape. It worked.
Bill of materials straight into Zoho Sheet. Submitting a production order in Creator explodes each composite product in Zoho Inventory into its components, multiplies by the quantity ordered and merges repeats across products into one total. The result lands in a new Zoho Sheet workbook. Its “BOM” tab shows each component’s quantity, stock category, lead time in days, standard order quantity and preferred supplier. A second tab, “Liste prod”, is the production log. Each line gets a number from a running counter, with columns for the packing date, pH, time at 90°C, bag temperatures, bagging start time and freezer timings. The first version in 2024 produced only the component list, and the 2025 version added the production log.
A bilingual order form. The Creator order form filters the product dropdown by the selected language. Picking a product fills in its name, description and price, so French-speaking clients see French product information automatically.
Square and Ecwid kept in step through Make.com. One Make.com scenario creates every new Zoho Inventory item in Square in real time. A second sends items to Ecwid whenever they are created or updated. It structures the data for the Ecwid API, updates the product if it already exists so the store never gets duplicates, then downloads the product image from Zoho Inventory and uploads it to the listing.
The results
The clearest number is on the order form. The project doc records “Reduced manual input time by 80%”, with “Accurate product details every time” and clients reporting “a smoother, quicker ordering process”. The form is also “ready for adding more languages in future”.
On the production side, every finished batch now reaches Zoho Inventory as a stock adjustment tagged with its production lot number and the lot numbers of the syrup, sugar and butter that went into it. Saving the same record again updates that adjustment instead of adding a second one. Planning a run now starts from numbers that are already totalled. The component list, supplier and lead time come out of Zoho Sheet next to a numbered production log.
For the sales channels, the Square doc reports that “Manual work has been completely removed” and “The risk of human error is reduced”. The Ecwid doc confirms that whenever an item is created or updated in Zoho Inventory, it is “automatically synchronized in ECWID with the correct data and images”. One product record in Zoho Inventory now feeds the till, the web store and production planning.