![]() To create a new category, simply add one with a unique name. Category: The option to add a product to a new or existing category, to be able to use filters and get better insights through sales reports.After you have imported the Excel file you will see the new stock balance in the Inventory tab. If you fill in an amount, the inventory tracking for this item will automatically be activated. In stock: The stock quantity of the item.An SKU is the unique ID you assign to an item for inventory tracking purposes. SKU: The SKU (Stock Keeping Unit) of the variant.Then you can scan the product in the Zettle Go app, enter numerical or alphabetical values. Barcode: If you have products with barcodes, you can add the barcode number to this column.Cost price: The price you bought the item for, enter a numerical value.Leave it blank if you want to enter the price at checkout, or enter a numerical value. Learn more about variants in our Product Library FAQ You can add up to three options per product and have 100 variants per product in total. Option 2 Value: Blue, Purple, Green (each on a different row) Option 1 Value: Small, Medium, Large (each on a different row) The combination of options and values will result in a list of variants.Įxample: If you sell a T-shirt that comes in a few different sizes & colours you would fill in the following information: If you have products with different variants, you can add those directly in the file and import them by filling in the type of variant under Option 1 Name, and then fill in the values for that Option 1 under Option 1 Value.Fill in the column with the correct rate, for example 20. VAT: This column contains the VAT setting that is set for your account.Unit names can’t be longer than 4 alphabetical characters. Otherwise, you can enter units like g (grams), m (metres), or hrs (hours) here. Custom unit: If your product is sold as individual items, you can leave this column blank.The only mandatory column is product name but we recommend to add as much information as possible to get the most value out of sales reports and the Zettle app.Įxample of template file with product information Columns explained You may leave the cells blank if you don't wish to add more details to the product. Use the empty cells below the correct header cell, to add additional information. The template file contains one header row with multiple columns. Highlighted file identifier that should not be edited. ![]() Already assigned images are not affected when importing a product again.Īdding information to the Excel file Important note: Please do not remove, rename or reorder the columns or the headers, as this will make the import fail. There is no support for uploading images.Up to 10.000 products can be imported per day. If you want to import more products than this, please upload them in batches. We can only accept files with less than 2000 rows.Please do not add more than one tab in the file or change the tab name.Existing folder assignments are kept as-is after import. Folders can’t be edited using this sheet.VAT rates are applied to products, and must be the same for variants – hence the order of the columns. ![]() If there are no mistakes on our end or yours, your products will import and result in an updated Product Library! Press Import if there are no mistakes to fix.Review the changes, or correct any mistakes if needed (follow the instructions under the section “Review your upload”). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |