Pyle

How to Bulk Edit Vendor Mappings with Excel ​

What This Task Does ​

This task exports the vendor mapping workbook, lets you edit it in Excel, and sends you back to the packaged import flow to apply the changes.

Use it when many mappings need to be created, updated, reviewed, or synchronized at once.

Before You Start ​

Make sure:

  • the vendor already exists
  • you know which vendor you want to work on
  • you are comfortable editing the workbook carefully
  • you know that imports are run from Tools > Excel, not from the vendor page itself

Steps ​

  1. Open the vendor record and go to Mappings.
  2. Use Export Mappings to download the workbook for that vendor.
  3. In the workbook, review the sheets you need:
    • product_vendor_mappings
    • catalog_items_without_mapping
  4. For existing mappings, work in product_vendor_mappings:
    • use mapping_id
    • set action to update, delete, review, unreview, calculate, or sync
    • only edit multipliers and is_source when you are updating
  5. For unmapped staged vendor items, work in catalog_items_without_mapping:
    • set action to create
    • fill in vendor_item_id
    • fill in product_manufacturer_code
    • fill in product_sku
    • set price_multiplier, inventory_multiplier, and is_source as needed
  6. Leave the workbook structure intact and save the file.
  7. Go to Tools > Excel in the admin.
  8. Choose the vendor mappings import workflow.
  9. Upload the workbook and run the import.
  10. Return to the vendor mappings page and verify the results.

What Happens Next ​

After a successful import:

  • mappings can be created, updated, reviewed, unreviewed, calculated, synced, or deleted in bulk
  • downstream canonical inventory can change if sync actions are part of the import

Common Mistakes ​

  • Editing the wrong sheet.
  • Forgetting to set the action column.
  • Trying to create a mapping on the wrong sheet instead of catalog_items_without_mapping.
  • Uploading the workbook from the vendor page instead of Tools > Excel.
  • Expecting the import to succeed when required IDs or product SKUs are wrong.

Sources ​

  • packages/admin/resources/views/components/vendor/mappings/page.blade.php
  • packages/admin/src/Livewire/Admin/Tools/Excel/ImportDialog.php
  • packages/framework/src/Exports/ProductVendorMapping/BulkEditor/ProductVendorMappingsExport.php
  • packages/framework/src/Imports/ProductVendorMapping/BulkEditor/ProductVendorMappingsImport.php