← Parts

Import / export products (CSV)
@if (session('import_errors'))

Nothing was imported: {{ session('import_error_count') }} {{ Str::plural('problem', session('import_error_count')) }} found

Fix these in your file and upload it again. The whole file is saved only when every row is correct.

Download error report (CSV)
@foreach (session('import_errors') as $e) @endforeach
RowColumnValueProblem
{{ $e['row'] }}{{ $e['column'] }} {{ Str::limit($e['value'], 40) }}{{ $e['problem'] }}
@if (session('import_error_count') > count(session('import_errors')))

Showing the first {{ count(session('import_errors')) }}. The report has all of them.

@endif
@endif

Import

  1. Download the template, or export your products below.
  2. Fill it in Excel. Save as CSV UTF-8.
  3. Upload it here.
@csrf

Export

All product details in the same columns, ready to change and import again. Includes cost prices.

Export products in use Export all (with turned-off)

How the import works

  • A row with a code that already exists updates that product. A new code, or a blank code, adds a product (blank = made from the category, e.g. DSP-00013).
  • Only the columns in your file are changed. Leave a column out to keep what is saved. An empty cell clears that value.
  • If any row has a problem, nothing is saved and you get an error report.
  • Stock is not imported: use Stock in or Stock count. Add photos on the product page.
  • Price changes are saved in each product's price history.
@foreach ($headers as $h) @endforeach
ColumnWhat to write
{{ $h }} {{ $help[$h] ?? 'Price for the '.Str::of($h)->after('price_')->headline().' level (blank = same as Retail)' }}