Import and export your products

Import products
Export & edit products
Good to know

If you want to add or edit a lot of products in your Product Library, you can use our import and export feature. Create or update your shop in a flash by adding product information to an Excel file and import to your Product Library.

Import products

1. Download the Excel template
Sign in to my.izettle.com and go to Products. Click the template file link to download an Excel file.
If you already have products in your library, you can access the template file by clicking “Import”. In the Import overlay you will find the example file link on the bottom left.

2. How to import products

a.) For iZettle Go app users (not applicable to iZettle E-Commerce)​

Follow the instructions below on how to add products if your business is only selling through the iZettle POS (point-of-sale) app, should you also use iZettle E-Commerce please follow these instructions instead.



The Excel file has the following columns, which is where you’ll add information about your products. To add a new product, just add information to the next available row in the spreadsheet.
  • Name: Your product’s name. (Mandatory.)
  • Custom unit: If your product is sold by piece, you can leave this column blank. Otherwise, you can enter units like g (grams), m (metres), or hrs (hours) here. Unit names can’t be longer than 4 characters. (Optional.)
  • VAT in %: Enter the VAT rate for this product here. You can only enter VAT rates that are relevant in your country: 0%, 5% or 20%. (Optional.)
  • Variant name: Variants of a product like colour, size or flavour are added here. To add a new variant, add a new row below the main product and keep the all fields to the left of “Variant name” blank. A product needs to have minimum 1 variant. (Mandatory.)
  • Price: Your variant’s price. Leave it blank if you want to enter the price at checkout. (Optional.)
  • Cost price: The cost price of the variant.
  • Barcode: If you have products with barcodes, you can add the barcode number to this column. Then you can scan the product in the iZettle Go app, if you have connected a supported barcode scanner. (Optional.)
  • SKU: The SKU (Stock Keeping Unit) of the variant.
  • In stock: The stock amount. If you fill in an amount, the inventory tracking for this item will automatically be activated. After you have imported the Excel file you will see the new stock balance in the Inventory tab. 
  • Variant ID: When adding new variants, leave this column blank. The ID is automatically generated and it’s iZettle’s way of knowing if a product is already in your product library. 
  • Product ID: When adding new products, leave this column blank. The ID is automatically generated and it’s iZettle’s way of knowing if a product is already in your product library.
WARNING!
Don’t change the names of the columns, remove columns, or change the order of the columns. Don’t change the Product ID or Variant ID. This is iZettle’s way of knowing if a product is already in your product library.

b.) For both iZettle Go app and iZettle E-commerce users​
Follow these instructions on how to add products if your business is selling both through the POS (point-of-sale) app and with iZettle E-commerce.

3. Import your Excel file
Save your spreadsheet in .xls or .xlsx format. Make sure that the sheet name matches the name in the template file. In my.izettle.com/products, click “Import Excel”. Drag and drop your Excel file onto your browser window, or choose the file from your computer.

4. Review your import
Save your spreadsheet in .xls or .xlsx format. Make sure that the sheet name matches the name in the template file. In my.izettle.com/products, click “Import Excel”. Drag and drop your Excel file onto your browser window, or choose the file from your computer.

Export & edit products

If you already have products in your Product Library that you want to edit, you can export your products, edit them using Excel, and import the changes.

1. Download your products
Sign in to my.izettle.com and go to Products. Click “Export Excel” to download a spreadsheet listing your products.

2. Edit information
Edit the information about your products in the columns listed above.
 
WARNING!
Don’t change the names of the columns, remove columns, or change the order of the columns. Don’t change the Product ID or Variant ID. This is iZettle’s way of knowing if a product is already in your product library.

3. Import your Excel file and review your changes
Save and import your file in the same way as above.

Good to know

  • All variants of the same product must have the same VAT rate.
  • Supported formats are .xls and .xlsx.
  • You can’t add, remove or edit folders using this feature.
  • Don’t rename the sheet or add more sheets / tabs in the Excel file.
  • Your Excel file can’t have more than 2,000 rows. If you want to import more products than this, import them in batches.

Need more help?

If you can't find what you're looking for, please get in touch. Our Support team is on duty 9:00 am - 5:00 pm on weekdays.

Call us on 0203 699 9934