Bulk upload

If you need to add or update barcodes or storage locations for many products at once, you can upload a spreadsheet instead of editing them one by one.

What you can upload

  • Barcodes — Add or update the barcode for each product variant.
  • Storage locations — Assign warehouse bin or shelf locations to product variants.

Preparing your spreadsheet

Create an XLSX file (Excel format) with a header row and one row per product variant. You can download a sample template from the upload dialog in Scanpacker.

Your spreadsheet needs at least two columns:

  1. An identifier column to match each row to a product variant — either the variant ID, SKU, or barcode.
  2. A data column with the value you want to import — either a barcode or a storage location.

Example:

SKU Storage Location
SKU-001 A-1-1
SKU-002 A-1-2
SKU-003 B-2-1

To clear a value, enter - (a single dash) in the data column. Blank cells are skipped to prevent accidental deletion.

Uploading

  1. Go to the Storage Locations or Barcodes page in Scanpacker.
  2. Click the dropdown menu and choose Upload Storage Locations or Upload Barcodes.
  3. Select your XLSX file and upload it.

Mapping columns

After uploading, Scanpacker shows you a preview of your data and tries to automatically match your column headers to the right fields. If the automatic mapping isn’t right, you can adjust it manually using the dropdown selectors.

You also need to choose how Scanpacker should identify your variants:

  • Variant ID — The numeric Shopify variant ID. This is the most direct match and doesn’t require a lookup.
  • SKU — Scanpacker looks up each SKU in your product catalog to find the matching variant.
  • Barcode — Scanpacker looks up each barcode to find the matching variant.

Previewing and importing

Before the import runs, you’ll see a preview showing how your data will be interpreted. Review it to make sure the column mapping looks correct, then click Import to start.

The import runs in the background — you can continue using Scanpacker while it processes. For large files, this may take a few minutes.

Viewing results and errors

After the import finishes, you can check the results on the Upload Import History page. Each upload shows:

  • How many rows were processed
  • How many were successfully imported
  • How many were skipped due to errors

Click an upload to see detailed error information. Common reasons a row might be skipped:

  • The variant couldn’t be found (wrong ID, SKU, or barcode)
  • A required field was blank
  • The variant doesn’t exist in your Shopify catalog