Data import
Import your product catalog from Excel using Caufix custom import.
Excel template
Download a spreadsheet with the recommended columns and sample rows for product import.
Download Excel templateUse Settings → Data → Custom import in the Caufix app to bulk-create products from an Excel or CSV file. This is the recommended way to migrate a catalog when you set up a new store.
Before you start
- Work on one store at a time (products are created for the current store’s company).
- Prepare one row per product in the first sheet of your file.
- Use
.xlsx,.xls, or.csv. - Column headers can be in English or Spanish — the import wizard maps them for you.
Download the template
Use the Download Excel template button at the top of this page. It includes the recommended column names and three example rows you can replace with your own data.
Import in Caufix
- Open Settings → Data and select the Custom import tab.
- Choose table Products.
- Upload your spreadsheet.
- Map each Caufix field to a column (required fields must be mapped).
- If your file lists product families that do not exist yet, choose whether to create them automatically.
- Start the import and review the result summary (imported, skipped, errors).
Duplicate SKU or barcode rows are skipped — the import does not update existing products.
Column reference
| Column | Required | Notes |
|---|---|---|
name | Yes | Product name. Aliases: nombre, producto. |
price | Yes | Sell price, number ≥ 0. Aliases: precio, pvp. |
sku | No | Internal code. Skipped if SKU already exists. |
barcode | No | EAN/UPC. Skipped if barcode already exists. Aliases: ean, ean13. |
currency | No | ISO code (CLP, EUR, USD). Defaults to store currency. Aliases: moneda. |
active | No | true/false, 1/0, yes/no. Default: active. |
description | No | Free text. |
family | No | Product family name. Aliases: familia, category. |
inventory | No | track_stock (default), do_not_track, made_to_order. |
weight | No | Weight in whole grams. Aliases: peso. |
color | No | Free text. |
sizes | No | Free text, e.g. S, M, L. |
materials | No | Free text. |
notes | No | Internal notes. |
secondarybarcodes | No | Comma- or semicolon-separated list. |
| Chile ILA | No | Column alias ila: values 27, 271, 26, 25, or 24. |
Stock quantities
The product import does not include stock quantities. After products exist:
- Set
inventorytotrack_stockfor items you want to count. - Add stock with Inventory → Intake (or adjust stock on the product page).
Tips
- Start with a small test file (5–10 rows) before importing thousands of products.
- Keep SKUs and barcodes unique across the file.
- Use
do_not_trackfor services or items without physical stock. - Fix rows reported in the error list and import again — successful rows are already created.