Resolving Order Guide Import Type Errors

If you received an import type error while uploading an order guide, it may be due to one of the following issues:

•  
  • You selected a vendor template, but the data in your file does not match the template.
     
  • The file you’re trying to import has no extension (e.g., missing .csv, .txt, or .xlsx).
     
  • You are attempting to import an Excel file, but the file is not actually in Excel format.
     
  • The file is saved as .xls instead of .xlsx.
    • To fix this, open the file in Excel, go to File > Save As, and choose .xlsx. Then reimport the file.
       
  • The Excel workbook contains more than one sheet. Delete any extra sheets or move them to a new workbook. Only import one sheet at a time.
     
  • The Excel file contains too many items. Vendors sometimes send full catalogs with 30,000+ items. You only need the items you actually order.

Special Character Issues in Order Guide Imports

If your file contains unsupported characters, the import may fail.

Characters that often cause errors:

• Circumflex letters: ê, î, ô, û
• Latin letters with accents: é, ñ, ü, ç
• Technical symbols: ±, ∞, ≈, √, ∑
• Trademark and copyright symbols: ©, ®, ™

Characters that are generally accepted:

• Letters and numbers: A–Z, a–z, 0–9
• Common punctuation: !@#$%^&*()
• Standard punctuation marks: . , ; : ' " ? ! - _ ( ) [ ] { }

Tip: If your file includes unsupported characters, remove or replace them before reimporting.