Property Bulk Import and Data Migration in Tesoro

Step 1: Download template

1. Go to Properties → Import
2. Click 'Download CSV Template'
3. Open template in Excel/Google Sheets
4. Review all columns and required fields (marked with *)

Step 2: Prepare data

Required fields:

• Property Type (apartment/house/villa/land/commercial)
• Address (full address)
• City
• Country
• Price
• Currency (EUR/USD/GBP)

Recommended fields:

• Bedrooms, Bathrooms
• Total area (m²)
• Description (NL/EN/ES columns)
• Status (active/draft)
• Reference number

Optional fields:

• All property features (pool, garage, terrace, etc.)
• Energy certificate data
• Owner information
• Images (URLs comma-separated)

Step 3: Field mapping

1. Upload prepared CSV file
2. Tesoro detects columns automatically
3. Map CSV columns → Tesoro fields:
   • Auto-mapping for standard column names
   • Manual mapping for custom columns
   • Preview mapped data
4. Validate data (Tesoro checks for errors)

Step 4: Import execution

1. Review summary (X properties, Y errors)
2. Fix errors or skip invalid rows
3. Click 'Start Import'
4. Monitor progress (real-time)
5. Review results:
   • Success: X properties imported
   • Errors: Y rows failed (download error log)

Supported XML formats

Tesoro supports standard property XML formats:

• Idealista XML: Direct import from Idealista exports
• Fotocasa XML: Compatible with Fotocasa format
• Custom XML: Map custom XML schema to Tesoro fields

XML import workflow

1. Properties → Import → XML Feed
2. Select source:
   • Upload XML file (manual import)
   • Enter XML feed URL (scheduled imports)
3. Choose format (Idealista/Fotocasa/Custom)
4. Preview parsed data
5. Map fields (if custom XML)
6. Set duplicate handling:
   • Skip duplicates (by reference number)
   • Update existing properties
   • Create as new properties
7. Import

Scheduled XML imports

For recurring imports (e.g., daily portal syncs):

• Setup feed URL
• Configure schedule (daily/weekly/monthly)
• Enable auto-import
• Set error nietifications

Tesoro fetches updates automatically and imports new/changed properties.

Automatic validation checks

Tesoro validates data before import:

• Required fields: Check all required fields are present
• Data types: Price must be numeric, bedrooms integer, etc.
• Valid values: Property type must be valid value (niet random text)
• Format checks: Email format, phone number format
• Geocoding: Address validation via Mapbox (warning if niet found)

Common import errors

Missing required fields:

• Error: "Row 45: Missing property type"
• Fix: Add property type value in CSV

Invalid data types:

• Error: "Row 12: Price must be numeric"
• Fix: Remove currency symbols (€, $) - only numbers

Duplicate reference numbers:

• Error: "Row 67: Reference ABC123 already exists"
• Options:
  • Skip this row
  • Update existing property
  • Change reference number

Error handling options

• Stop on error: Import stops at first error (fix and retry)
• Skip errors: Import valid rows, skip invalid (recommended)
• Log errors: Download error CSV for batch fixing

After import, review error log and fix problematic rows for second import.