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 these instructions 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 continue below.

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



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.)
  • Description: A description of the product that will display on your online store.
  • 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 (without the % symbol) for this product here. You can only enter VAT rates that are relevant in your country. (Optional.)
  • Visible online: YES if you want to sell the product online and from your POS app. NO if you only want to sell the product from your POS app.
  • SEO Title: Add a descriptive title for your product. The title will display as a link in search engine results. We recommend a title that is 70 characters or less.
  • SEO Description: This meta description is the short snippet of text that shows up under the title in search engine results. Make sure each product has a unique and compelling description to maximise clicks. Max. 320 characters.
  • Shipping weight in grams: If you are configuring real-time or weight-based shipping rates via iZettle E-commerce, the product weight is required. Otherwise leave this blank.
  • 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 product or variant’s price. Leave it blank if you want to enter the price at checkout. (Optional.)
  • Cost price: The cost price of the product or 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 product or 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.
  • Product ID: When adding new products, leave this column blank.
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
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
When your Excel file has uploaded, you have the chance to review the import. Any errors that are detected will be highlighted.
Make any changes necessary to your Excel file and upload it again. When you’re happy with the review, click Import Products.

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