2025Freelance Project

E-commerce for Pisos & Decks

Pisos & Decks

E-commerce system developed for a flooring and decking SMB that needed to replace its Airtable backend with a scalable web solution. The system includes a dual catalog (retail and wholesale), integration with Correo Argentino for automatic shipping cost calculation, automatic dispatch document generation, sales tracking, and integrated payments with Mercado Pago.

DURATION
2025 -
STATUS
In progress

Challenges

  • Migration and standardization of the legacy Airtable backend
  • Modeling dual prices (retail/wholesale) with real business rules
  • Integrating the postal API for shipping calculation by weight, dimensions, and destination
  • Automating dispatch document generation

Solutions

  • Data migration from Airtable to PostgreSQL with validation and standardization
  • Data model with customer profiles and a differentiated pricing table
  • Integration with the Correo Argentino API for real-time quotes
  • Automated dispatch PDF generation for every sale

Key Features

Retail and wholesale catalog with differentiated pricing
Automatic shipping calculation (Correo Argentino)
Automatic dispatch document generation
Sales tracking and follow-up
Payments with Mercado Pago
Admin panel for product and order management

Tech Stack

ReactTypeScriptNode.jsExpressPrismaPostgreSQLMercado PagoTailwindViteDockerJWTZod

Impact and Outcomes

Replaced a manual Airtable backend with a scalable web system
Faster sales and dispatch process with automatically generated documents
Differentiated catalog that makes selling to different customer profiles easier