Skip to content

How to import items and bulk update them

Who can do this: Importing needs permission to create products. Bulk updating needs permission to edit products. · Available on: Mobile · Web

Instead of adding products one by one, you can fill in an Excel file and upload it. Use Import items to add new products. Use Bulk update items to change existing products, which Seroly finds by their SKU.

Before you start

  • You need an Excel file in .xlsx format. Other formats (such as .xls or .csv) are not accepted.
  • The first row of the file must contain these column names: sku, name, buying price and selling price. Capital letters don't matter, and you can write selling_price or selling-price instead of selling price.
  • For a bulk update, each row's sku must match the SKU of a product that already exists.

Steps

  1. Go to the Inventory tab and tap the menu (⋮) at the top right. (On web: Inventory → Products, then More.)
  2. Tap Import items to add new products, or Bulk update items to change existing ones.

Screenshot coming soon: Inventory menu — Import items and Bulk update items

  1. Check the Required columns section. It lists the column names your file must have.
  2. Under Template, tap View to preview the template, or tap Download to save or share a blank template. When it is ready, you will see Template ready. Fill the template in with your products.
  3. Under Import name (or Update name), enter a Name for this upload, for example March price list. If you leave it blank, Seroly fills it in from the file name when you pick the file.
  4. Under Excel file, tap Tap to select .xlsx file and choose your file. Seroly checks the column names straight away. When the file is accepted, you will see Ready to import (or Ready to update). To pick a different file, tap Change. To clear it, tap Remove.

Screenshot coming soon: Import items — file selected and ready to import

  1. Tap Import items (or Update items).
  2. If your business asks for a PIN, enter it.

What happens next

  • You will see Items imported successfully (or Items updated successfully), and the product list refreshes.
  • Imported products have the SKU, name, buying price (cost) and selling price from your file. To add a category, barcodes, units or other details, open each product and edit it. See Add a product.

Tips & common issues

  • "Only Excel (.xlsx) files are allowed": save your file as an Excel Workbook (.xlsx) and try again.
  • "Missing required column(s): ...": the first row of your file is missing one or more of the required column names. Compare it with the template and fix the header row.
  • "Could not find a header row in the file" or "The selected file is empty": the file has no data, or the first row is empty. Put the column names in row 1.
  • "Please enter a name for this import" / "Please enter a name for this update": fill in the Name field.
  • "Please select an Excel file to continue": pick a file before you tap the import or update button.