You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Error messages appears as ??? in the ???? 



The incorrect cells are highlighted in red. Probably you have:

  • Used e characters like '&', '-', '+' or '%' in your MFPN. Please use letters and numbers only.

  • Your EAN is too long or your EAN is not a valid EAN.

  • You forget to fill in a required cell/column. A red N/A appears in the product overview.

  • Your short description or long description contains too many characters.

  • You use letters in fields where numbers are required, for example in the columns 'Stock', 'Price' or 'EAN (GTIN)'.

    A full overview on all mandatory and optional product data fields can be found in the Product Manager - Product data file guidelines.



In this case, you have tried to upload a file with a duplicate SKU.

  • Use CTRL + F in your Excel sheet to lookup the SKU's listed.

  • Single buyer: Make sure the SKU is unique in your file. Multi buyer: Make sure that per SKU (for all different buyers) all the information is the same. Except for the price, the price can be different per Buyer.

  • You can delete the duplicate products or change one of the SKU's if its multiple separate products.

  • You can find duplicates in your sheet with the function under 'Conditional Formatting > Highlight Cells Rules > Duplicate Values'.

  • Make sure you select the column SKU, and the duplicate values will be highlighted.







You can face this error when you have multiple buyers and you share product information with these multiple buyers.

Product specific information should always be the same:

  • You provide the same SKU, MFPN and descriptions to all your buyers.

Buyer specific information should be buyer specific:

  • In the column Buyer (GLN) you fill in the specific GLN for the buyer;
  • In the column Price you share the specific price for the buyer.

Another error that is not in this Q&A? Please contact support@onetrail.com to help you.

  • No labels