--- title: Product Import Failure Troubleshooting description: Troubleshooting the reasons why your product bulk import is failing --- [Skip to content](https://support.thegoodtill.com/product-import-failure-troubleshooting#main-content) English Show submenu for translations ![sumup logo-modified.png\]](https://support.thegoodtill.com/hs-fs/hubfs/sumup%20logo-modified.png?height=40&name=sumup%20logo-modified.png) - [Default HubSpot Blog](https://thegoodtill-8238028.hs-sites.com/blog) Open main navigation Close main navigation - [Default HubSpot Blog](https://thegoodtill-8238028.hs-sites.com/blog) - English Show submenu for translations - Home Home Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Support Knowledge Base](https://support.thegoodtill.com/?hsLang=en) 2. [Back End](https://support.thegoodtill.com/back-end?hsLang=en) 3. [Products](https://support.thegoodtill.com/back-end?hsLang=en#products) # Product Import Failure Troubleshooting ## Troubleshooting the reasons why your product bulk import is failing If you want to import products into your POS system in bulk, you can do this by uploading a CSV file into your back office under **Products** \> **Import Products**. Please see below for the most common errors and how to avoid or fix them. ### Incorrect column header The most common reason for a failed import is a mistake in the column headers. Please download [our template here](https://support.thegoodtill.com/hubfs/Support%20Import%20Templates%20(2022)%20-%20Product%20Import.csv?hsLang=en) for the correct headers - just remember to delete row 1 before importing. You also do not need all headers/columns in the upload - please delete any empty columns before importing. Please note it is mandatory to have the product\_name column.  ### Duplicate column header This means that you might have the same header repeated somewhere. For example "product\_name" listed on column A and column C - just delete the duplication. ### **Import error** The error will say "This section is for importing new products into the system. Please do not use this to update any current products". Ensure that you're not updating existing products on the system - if you want to make bulk changes to your existing products, please send an email to pos.support.uk.ie@sumup.com and the support team will be able to assist you.  Otherwise, remove any headers in your file that say "id" or "product\_id". ### **File error** The error may say "Something is wrong with the file. Please check and try again". Ensure that the file you are uploading is a CSV file. We recommend that you work with Google Sheets - so in Google Sheets, go to **File \> Download \>** selectComma Separated File (.CSV).  ### Validation error Download the error report which will show the row and the validation issues for each row. Common mistakes are: - VAT rates incorrectly formatted - for example it should be '5% VAT' or '15% VAT' or '17.5% VAT' or '20% VAT' **not** just "5%". - Selling prices including currency signs (£) - it should just be the number entered. - Whitespaces - blank spaces before or after the VAT name. Just use Google Sheets remove whitespace function to easily delete them. If you're unsure what to enter in, have a look at our explainer of the columns in row one of the [sheet here](https://support.thegoodtill.com/hubfs/Support%20Import%20Templates%20(2022)%20-%20Product%20Import.csv?hsLang=en).      - [Front End](https://support.thegoodtill.com/front-end?hsLang=en#main-content) - [Download And Login](https://support.thegoodtill.com/front-end?hsLang=en#download-and-login) - [Sales](https://support.thegoodtill.com/front-end?hsLang=en#sales) - [Tables](https://support.thegoodtill.com/front-end?hsLang=en#tables) - [Options](https://support.thegoodtill.com/front-end?hsLang=en#options) - [App Refresh](https://support.thegoodtill.com/front-end?hsLang=en#app-refresh) - [FAQ](https://support.thegoodtill.com/front-end?hsLang=en#faq) - [Tips](https://support.thegoodtill.com/front-end?hsLang=en#tips) - [Delivery](https://support.thegoodtill.com/front-end?hsLang=en#delivery) - [Refunds](https://support.thegoodtill.com/front-end?hsLang=en#refunds) - [Ticket/Receipt printouts](https://support.thegoodtill.com/front-end?hsLang=en#ticket-receipt-printouts) - [Back End](https://support.thegoodtill.com/back-end?hsLang=en#main-content) - [Dashboard](https://support.thegoodtill.com/back-end?hsLang=en#dashboard) - [Products](https://support.thegoodtill.com/back-end?hsLang=en#products) - [Ingredients](https://support.thegoodtill.com/back-end?hsLang=en#ingredients) - [Sales](https://support.thegoodtill.com/back-end?hsLang=en#sales) - [Customers](https://support.thegoodtill.com/back-end?hsLang=en#customers) - [Setup](https://support.thegoodtill.com/back-end?hsLang=en#setup) - [Users](https://support.thegoodtill.com/back-end?hsLang=en#users) - [Add-ons](https://support.thegoodtill.com/back-end?hsLang=en#add-ons) - [Settings](https://support.thegoodtill.com/back-end?hsLang=en#settings) - [Change Store](https://support.thegoodtill.com/back-end?hsLang=en#change-store) - [Logout](https://support.thegoodtill.com/back-end?hsLang=en#logout) - [Reports](https://support.thegoodtill.com/back-end?hsLang=en#reports) - [Hardware](https://support.thegoodtill.com/hardware?hsLang=en#main-content) - [Printer Setup](https://support.thegoodtill.com/hardware?hsLang=en#printer-setup) - [Printer Troubleshooting](https://support.thegoodtill.com/hardware?hsLang=en#printer-troubleshooting) - [SumUp](https://support.thegoodtill.com/hardware?hsLang=en#sumup) - [Zettle](https://support.thegoodtill.com/hardware?hsLang=en#zettle) - [PaymentSense](https://support.thegoodtill.com/hardware?hsLang=en#paymentsense) - [Supported Hardware](https://support.thegoodtill.com/hardware?hsLang=en#supported-hardware) - [Scanners](https://support.thegoodtill.com/hardware?hsLang=en#scanners) - [iPad](https://support.thegoodtill.com/hardware?hsLang=en#ipad) - [Modules](https://support.thegoodtill.com/modules?hsLang=en#main-content) - [Advanced Stock](https://support.thegoodtill.com/modules?hsLang=en#advanced-stock) - [Pro](https://support.thegoodtill.com/modules?hsLang=en#pro) - [Advanced Loyalty](https://support.thegoodtill.com/modules?hsLang=en#advanced-loyalty) - [KDS](https://support.thegoodtill.com/modules?hsLang=en#kds) - [Integrations](https://support.thegoodtill.com/integrations?hsLang=en#main-content) - [Built-In](https://support.thegoodtill.com/integrations?hsLang=en#built-in) - [Third Party](https://support.thegoodtill.com/integrations?hsLang=en#third-party) - [Custom](https://support.thegoodtill.com/integrations?hsLang=en#custom) - [Reporting](https://support.thegoodtill.com/reporting?hsLang=en#main-content) - [Advanced Reports](https://support.thegoodtill.com/reporting?hsLang=en#advanced-reports) - [Reports](https://support.thegoodtill.com/reporting?hsLang=en#reports) - [Reporting FAQs](https://support.thegoodtill.com/reporting?hsLang=en#reporting-faqs) - [Goodeats](https://support.thegoodtill.com/goodeats?hsLang=en#main-content) - [Goodeats - Table Ordering](https://support.thegoodtill.com/goodeats?hsLang=en#goodeats-table-ordering) - [Goodeats - Delivery](https://support.thegoodtill.com/goodeats?hsLang=en#goodeats-delivery) - [Fulfilment Options](https://support.thegoodtill.com/goodeats?hsLang=en#fulfilment-options) - [Stripe](https://support.thegoodtill.com/goodeats?hsLang=en#stripe) - [Goodeats](https://support.thegoodtill.com/goodeats?hsLang=en#goodeats) - [Payment Options](https://support.thegoodtill.com/goodeats?hsLang=en#payment-options) - [Extras](https://support.thegoodtill.com/extras?hsLang=en#main-content) - [Extras](https://support.thegoodtill.com/extras?hsLang=en#extras) - [Resources](https://support.thegoodtill.com/extras?hsLang=en#resources) - [Redirects](https://support.thegoodtill.com/extras?hsLang=en#redirects) - [MISC](https://support.thegoodtill.com/extras?hsLang=en#misc) - [Deposit Return Scheme](https://support.thegoodtill.com/extras?hsLang=en#deposit-return-scheme) - [System scenarios](https://support.thegoodtill.com/system-scenarios?hsLang=en) - [SumUp Connect](https://support.thegoodtill.com/sumup-connect?hsLang=en) - [Default HubSpot Blog](https://thegoodtill-8238028.hs-sites.com/blog) [![Chill listening crop-3](https://support.thegoodtill.com/hs-fs/hubfs/sumup%20logo-modified.png?width=24&height=24&name=sumup%20logo-modified.png "Chill listening crop-3")](http://thegoodtill.com) SumUp Point of Sale Support Copyright © 2026, SumUp