Lista De Productos De Ferreter%c3%ada Y Sus Precios En Peru Excel -
El precio del acero es volátil en Perú. Es vital tener una columna de "Fecha de actualización".
| Producto | Diámetro / Uso | Unidad | Precio Referencial (S/.) | | :--- | :--- | :--- | :--- | | Corrugado de 1/2" (Grado 60) | 12 mm | Varilla (9m) | 32.00 – 38.00 | | Corrugado de 3/8" | 9.5 mm | Varilla (9m) | 18.00 – 22.00 | | Alambre Negro N° 16 | Amarre | Kg | 5.50 – 6.50 | | Malla Electrosoldada (2.4x6.1m) | 6mm / 15x15 | Plancha | 85.00 – 95.00 |
| Column | Name | Example | |--------|------|---------| | A | Código | TAL-001 | | B | Producto | Taladro percutor 650W | | C | Marca | Bosch | | D | Unidad | Unidad | | E | Precio Unitario (PEN) | 189.90 | | F | Precio por Mayor (PEN) | 169.00 | | G | Proveedor | Promart / Sodimac / Maestro | El precio del acero es volátil en Perú
This is an empty template. It includes columns for Código, Producto, Unidad, Precio de Compra, Precio de Venta, and Stock Mínimo. These are valuable for structuring your own business, but they contain no data.
Instead of downloading a dead file, build a dynamic one. Here is the Excel architecture recommended for Peruvian hardware vendors: This is an empty template
Step 1: Source Raw Data
Visit the B2B portals of Mercado Libre Perú (filter by "Mayoristas") or Linio Business. Scrape or manually input top 100 SKUs.
Step 2: The Formula Column
Create a column called Precio de Venta Sugerido. Use the formula: = (Costo_Importe * 1.18) * (1 + Margen_Ganancia). In Peru, hardware margins typically range from 15% (for cement/iron) to 50% (for tools/imported fixtures).
Step 3: The IGV Trap
Crucially, your Excel must separate Base vs. IGV (18%). Many amateurs mix total price. A professional list includes:
When users search for this term, they typically stumble upon three types of files: Precio de Compra
Tener una lista de productos de ferretería en Excel actualizada te da tres poderes inmediatos en el mercado peruano:
Large distributors like Massa, Promart Homecenter, or Importadora H&H sometimes leak or offer PDFs that users convert to Excel. These are useful but distorted (they reflect retail or medio mayorista prices, not true wholesale).
You can update the Excel file with real-time prices from:
