Online store · Custom tool · Integration
Shama Revestimientos
Floor and wall covering store with a calculator that turns square meters into boxes and materials, and inquiries recorded automatically in the CRM.
The challenge
A floor or wall covering is chosen by the square meter, but it is sold by the box. In a physical store the salesperson bridges that gap; in an online store it ends one of two ways: the customer asks before buying or buys wrong. If they come up short on boxes, they have to order again and sometimes the batch no longer matches in shade; if they have too many, there are returns.
How I solved it
- I did the box calculation for the customer. On each product page, the person types in the square meters of their room and the calculator returns the boxes they need. It always rounds up, because being one box short is worse than having a little extra.
- I loaded the coverage data into each product. Each product sheet stores how many square meters a box covers and the calculator reads that value, so adding a new product requires no code changes.
- I added adhesive and grout to the same calculation. Using a standard consumption per square meter, the calculator also estimates how much of each is needed. That way the customer does not forget them or buy them elsewhere: they appear at the moment of decision.
- I connected every inquiry to the CRM. Each inquiry and each purchase is recorded with its data, with no manual entry. The integration adapts to whichever CRM the company uses (GoHighLevel, HubSpot, Zoho or another), because the logic of what is sent and when is the same and only the connector changes.
Screenshots
