@extends('layouts.dashboard') @section('content') @include('customers._theme')
← Back to Customers

Focus Customer Import

Import Focus Name + Code lists. Preview matches first; uncertain records are held for review without changing existing records.

@if(session('error'))
{{ session('error') }}
@endif @if($errors->any())
{{ $errors->first() }}
@endif
@csrf

Safe merge: Existing exact Focus codes are matched first. Unique legacy CUS- code/name matches in the same region may have their code updated. Ambiguous and duplicate Focus codes are skipped for review.

New customers use the selected city as their initial area. You can later move them in bulk from Customers. No existing order or invoice references are deleted.

Sharjah & Ajman: Separate those two regions into different imports; do not assign the mixed file to one city.

Unassigned salesman: Imported customers can remain unassigned. They start as Prospects until their account is reviewed.

@if(session('focus_result')) @php($r = session('focus_result'))

{{ $r['mode'] === 'imported' ? 'Import completed' : 'Preview results (no changes made)' }}

@foreach(['rows'=>'Rows','create'=>'New','update'=>'Existing / code update','review'=>'Needs review','duplicate'=>'Duplicate codes'] as $key => $label)
{{ $label }}
{{ $r[$key] }}
@endforeach
@if(count($r['samples']))

Review examples

    @foreach($r['samples'] as $sample)
  • {{ $sample }}
  • @endforeach
@endif

For full review, correct the spreadsheet and preview again. Customer codes are unique in SNYT.

@endif
@endsection