HomeResourcesMigration guide
Migration guide

Bring your catalog with a CSV import.

Choose a CSV or Excel file with up to 500 rows, review duplicates and errors, and decide which rows to save. Puntovivo recognizes the exact tested export layouts for Loyverse, Alegra, Siigo and World Office; changed or unknown layouts fall back to generic mapping. Every path still requires your confirmation before saving.

Up to 500 rows per file CSV / XLSX import Review before saving
Where are you coming from?
From Loyverse→ Puntovivo · through a reviewed file · duration depends on the data
Plan in five steps

What migrating takes, step by step.

  1. 01 In the source system

    Export your current catalog

    Export a CSV or XLSX file. Name and SKU are required; description, barcode, price, cost, opening stock, minimum stock, VAT and lot tracking are optional. Each file accepts up to 500 rows and 10 MB.

    • Name and SKU present
    • One batch of up to 500 rows per file
    • VAT in a separate column when applicable
    • Create an encrypted backup before saving real data
  2. 02 Before upload

    Clean duplicates and number formats

    Puntovivo detects repeated SKUs and barcodes inside the file and against the business catalog. Choose the correct decimal format and prevent the spreadsheet from converting long codes to scientific notation.

    • No duplicate SKU
    • Barcode preserved as text
    • Decimal format confirmed
  3. 03 In Puntovivo

    Upload the CSV to the importer

    In Settings → Import data, choose real-data mode, select the CSV or XLSX file and confirm the field mapping. The file stays in the browser until you request the preview.

    • Name and SKU mapped
    • Decimal format selected
    • Active business and site reviewed
  4. 04 Review required

    Review the preview and confirm

    The server validates every row again and shows which are ready, duplicated or invalid. Only ready rows are saved after your explicit confirmation; there is no one-click batch undo.

    • Duplicates and invalid rows reviewed
    • Current encrypted backup confirmed
  5. 05 Controlled cutover

    Reconcile and open the register

    Import with the previous system stopped for that cutover, or reconcile every sale made after the export separately. Then perform a physical count, compare opening stock and complete a test sale before adopting Puntovivo as the system of record.

    • Physical count done at the main site
    • Opening with a base you define
    • First test sale completed
Compatibility

Four tested profiles plus generic mapping.

A source profile activates only when the file matches its tested header signature. Changed vendor exports and unknown files fail closed to the generic mapper. The operator always confirms every field before preview and save.

SystemExpected fileSKUNameCostPriceVATStockStatus
LoyverseItems export · tested v1 layoutSKU → skuName → nameCost → costPrice → priceReview manuallyIn stock → stockProfile available · confirm
AlegraInventory export · tested v1 layoutCódigo → skuNombre → nameCosto unitario → costPrecio de venta → pricePorcentaje impuesto → tax rateCantidad inicial → stockProfile available · confirm
SiigoProducts export · tested v1 layoutCódigo producto → skuNombre producto → nameCosto → costPrecio de venta → pricePorcentaje impuesto → tax rateExistencia → stockProfile available · confirm
World OfficeInventory export · tested v1 layoutCódigo artículo → skuDescripción artículo → nameCosto promedio → costPrecio venta → pricePorcentaje IVA → tax rateExistencia → stockProfile available · confirm
Generic import.csv / .xlsxSKU / Code → skuName → nameCost → costPrice → priceVAT → tax rateOpening stock → stockAvailable · confirm
Our own format

This is the generic format.

One row per product, headers in the first row and up to 500 data rows. Import each batch from the site that should receive its opening stock.

catalogo.csv Download template
nombre,sku,descripcion,codigo de barras,precio,costo,stock inicial,stock minimo,iva,controlar lotes
Arepa de queso · Pack 12,ARQ-12-PV,Paquete de 12 unidades,7705412000123,9500,5800,24,6,5,no
Café tinto molido 500 g,CAF-500-TIN,Café tostado y molido,7702045009982,19900,12200,18,4,5,no
Bolsa reciclable mediana,BLS-M-RCY,Bolsa para entrega,7705781100456,1200,420,50,10,19,no
Leche larga vida 1 L,LCH-1L-LV,Caja de un litro,7702521011234,5400,3400,0,6,0,si
VAT zero? Leave the column at 0. For exempt items use EX.
Frequently asked

What people ask before starting.

How long does it take to migrate a single site?+
There is no guaranteed duration. It depends on file quality, the number of 500-row batches, duplicates and the physical count. Preview first and plan a controlled cutover.
Do I have to stop selling while I migrate?+
Plan a controlled cutover. The export is a point-in-time snapshot: if you keep selling in the previous system after exporting, reconcile those sales before making Puntovivo the system of record.
What if my catalog exceeds 500 rows?+
Split the file into batches of up to 500 rows and review each preview. The current importer does not split files automatically.
What happens to my sales history?+
Sales history is not imported. Keep the previous system reports according to your accounting obligations and start the new record in Puntovivo from the agreed cutover.
Stuck on your file?

Catalog doesn't fit the format?

If your export has an odd structure, open an issue on GitHub with a sample (no sensitive data) and we'll work through it in the open.

Ask on GitHub Read the full guide