Zebretaro Catalog & PDF Quoting Tool for a Distributor

Zebretaro, a division of Impresoras y Más Bajío, distributes Zebra printers, labels, ribbons and scanners to logistics, manufacturing and healthcare companies in Mexico's Bajío region. Before, quotes were handled over WhatsApp, phone and email against a catalog that lived in an Excel file, and every formal quotation was assembled and recalculated by hand.

We built the public site and the operation behind it. The customer finds the product with a search that tolerates typos, sees the price with VAT, stock, spec tables and reviews, and builds a quote cart that gets a folio number. It is not an online store: there is no payment or checkout, because that is not how a company buys. The sale closes with a quotation.

On the other side, the team manages products, categories, reviews and promotions, watches requests arrive in real time and produces the formal quotation from the same record. An AI assistant answers on the site from the live catalog, and the Google Merchant Center feeds are generated from the database, so Shopping listings show real stock.

The centerpiece is a single quotation pipeline. One record serves every quotation, wherever it was born: the customer starts it from the quote cart on the site, and an admin opens that same record in the quotation builder, adjusts line items, applies discounts and VAT and exports a branded PDF or image to send over WhatsApp. Nothing is keyed in twice, and the request from the site stays linked to the quotation that was sent.

The hard part was joining two models that used to be separate without losing history. Every line linked to the catalog keeps a live reference to the product, so prices can be refreshed in one click, plus a snapshot of the name, SKU and price at that moment, so an old quotation still says what it said. Free-form lines, such as installation or freight, are stored as items in their own right. The document was designed at a fixed print width: it scales on screen and exports accurately, product photos included, which are served through the site itself because external image hosts were blocking them.

The assistant answers from a snapshot of the whole catalog, with prices, stock and reviews, refreshed every half hour: it replies with real data without hitting the database on every question, and it is limited to four messages per session and to the catalog. Business rules such as folio numbering, anti-spam limits and rating recalculation live in the database rather than in the application; access to every record is decided by role, on the server.