Import Products: Correcting Errors

You have entered a higher level packaging item, and have entered a GTIN-14 in the GTIN column. However, you must select “N” in the IsPurchasable column to indicate that this product is for shipping purposes only.

Visit the Manage Products screen and enter this GTIN to view that specific product detail record, and confirm that it’s the same product as the one you’re trying to import. You don’t have to take any additional steps, as the other items in the update file were successfully imported.

If you believe that the GTIN was previously assigned, and you have In Use products with the same GTIN, you will need to assign a new GTIN to one of the products, then communicate this new GTIN both internally and externally to your trading partners.

Here are two other common reasons for this error:

Reason #1: Column names were moved or changed.
You may have changed a column name, rearranged the columns, or deleted a column. To correct this error, click the Download All Available GTINs template again, and enter this content or paste the content from the company’s source file, without altering any columns in the template. Then save and resubmit this update file.

Reason #2: Hidden Characters are in the data
If you pasted this product data from another spreadsheet of software, GS1 US Data Hub may be detecting that this data contained hidden line breaks or hidden characters, such as hidden carriage returns.

To remove this hidden data, click the Download All Available GTINs template again, then cut and paste the data from your company’s product source file into this new template. But this time, when you paste the data, select the “Paste as Values” option. Then click CTRL + H to display the “Find and Replace” window. In the “Find” box, type the CTRL and J keys. You will see a flashing dot in the box. Keep the “Replace” box empty. Then click “Replace All.” Save this update file and submit again.