Pyle

Excel Import / Export ​

What This Is ​

Excel Import / Export is the admin tool your team uses to move large amounts of structured data into or out of Pyle through spreadsheet templates and reports.

In the inspected shared package, this lives under Tools > Excel.

When You Would Use It ​

Use Excel Import / Export when you need to:

  • bulk import records from a spreadsheet
  • generate a spreadsheet template or report
  • review the status of an import or export run
  • download a completed export
  • inspect row-level import errors

Before You Start ​

Make sure:

  • you have the right spreadsheet template
  • the file is in the allowed format
  • you know whether you are running an import or an export
  • you understand which sheet names or parameters the selected template expects

Some import templates support multiple sheets, and some export templates expose extra parameters such as selected sheets or manufacturer/vendor filters.

How To Use It In The Admin ​

  1. Open Tools > Excel.
  2. Choose the right tab:
    • Import
    • Export
  3. Pick the template or report you want.
  4. For imports, upload the spreadsheet file and set any template-specific options.
  5. For exports, choose any required filters or parameters.
  6. Submit the run.
  7. Watch the table for status updates:
    • pending
    • processing
    • completed
    • failed
  8. If the run is an import and logs are available, open the logs view to inspect row-level errors.
  9. If the run is an export and it completed successfully, download the file from the row action.

What It Changes In The Product ​

Imports can create or update records in bulk.

Exports do not change the product data. They generate a spreadsheet file from the current data state.

Common Tasks ​

  • import product data from a prepared workbook
  • import shipping services or shipping zones
  • import promotions or product groups
  • export products, customers, shipping, promotions, or vendor-related reports
  • review failed import rows and correct the source file

Rules, Limits, And Things To Watch ​

  • Imports and exports run asynchronously after you submit them.
  • Import source files are not meant to stay around as a permanent file archive after processing.
  • Completed exports can be downloaded, but failed rows usually need to be reviewed through logs.
  • The available templates can vary by project.

Troubleshooting ​

The import failed ​

Open the logs view first. Row-level validation errors are usually the fastest way to find the bad sheet, row, or column.

The export is still processing ​

Wait for the queued run to complete, then refresh the table.

The export completed but there is no download ​

Check whether the row has logs or a failure state instead of a finished file.

For the full operator recovery checklist, see How to troubleshoot a failed import.

Sources ​

  • packages/admin/routes/web.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/Page.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/DataTable.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/ImportDialog.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/ExportDialog.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/Row.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/LogsDialog.php
  • packages/framework/src/Models/ExcelImport.php
  • packages/framework/src/Models/ExcelExport.php
  • packages/framework/src/Actions/Excel/ExcelImporter.php
  • packages/framework/src/Actions/Excel/ExcelExporter.php