3PL Warehouse Manager

Updated on January 27th, 2023

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Extensiv Hub
    Getting Started Using Hub Technical Issues & FAQs
  • 3PL Warehouse Manager
    Receiving Operations Inventory Management Shipping Operations System Configuration Scanning Operations Integrations Content Best Practice Resources Release Notes
  • Warehouse Manager
    Getting Started Admin Console Shipping Order Picking & Packing Receiving Customer Portal Cycle Counting Kit Building Managing Users Barcode Scanner Import/Export Integrations Barcoding Wave Picking Bin Move Mobile Receiving and Picking Settings
  • Order Manager
    Dashboard Orders Inventory Purchase Orders Shipments Customers Products Analytics Settings API API Integrations Accessing and Navigating Order Manager Error Messages Order Manager
  • Integration Manager
    General Support Order Sources Order Destinations Troubleshooting API Documentation Extras & Addons
  • FAQs
  • Support
+ More
  • Help Center
  • 3PL Warehouse Manager
  • Best Practice Resources
  • Data Imports
  • Best Practice Resources
    • Technical Support
        • System Requirements
        • Managing PII
        • Understanding Sandbox
    • Professional Services
        • Getting Started with 3PL Warehouse Manager
        • Custom Consulting
        • Learning with 3PL Central University
        • Consulting Services
        • Ask the Expert
        • Best Practice Consultation
        • Custom Report
        • Add a Customer
        • On-Site Visit
        • Developer Enablement
        • Premium Account Services
    • Network Manager
        • Navigating Network Manager
    • Customer Central
        • Subscription Invoice and Billing FAQs
        • Navigating the Help Center
        • Navigating the Support Portal
        • Support Portal FAQs
        • Product Idea Policy
        • Suggesting Product Ideas
        • Product Idea FAQs
    • Dashboards and Analytics
        • Outbound Productivity Dashboard FAQs
        • Understanding the Outbound Productivity Dashboard
        • Understanding Dashboard Sync Time
        • Understanding The Labor Analytics Dashboard
    • Data Imports
        • Import Templates
        • Import Template FAQs
        • Troubleshooting Import Template Errors
    • Classic Reporting
        • Understanding Reports
        • Customizing Reports
        • Stock Status Report
        • Transactions Reports
        • Items Reports
        • Locations Reports
        • Management Reports
        • Inventory Reporting Beta End-of-Life FAQ
    • Best Practice Workflows
        • Pallet In/Pallet Out Workflow
        • Pallet In/Carton Out Workflow
        • Ecommerce Pick/Pack Workflow

Troubleshooting Import Template Errors

This article reviews how to resolve some of the most common errors experienced when uploading an import file. To learn more about import templates, please reference our list of Import Template FAQs.

If you receive an error code that is not reviewed below or you're unable to resolve using the provided steps, please click Show Details in the top-right corner of the error message, take a screen capture of the message, then reach out to Extensiv Support with the attached screen capture and import file.

 

Error messages

Does not exist

Problem: The specified SKU name is not recognized as an available active SKU for this customer.

Solution: Ensure that every SKU on the template is set up within the system before attempting to import.

Duplicate

Problem: The specified Reference Number is already in use for this customer.

Solution: Enter a different Reference Number, or cancel the associated transaction.

Problem: You've attempted to upload a standard receipt import file with a header-based parser enabled.

Solution: Import a header-based file, or change the import format under Receipt > Receipt Import Preferences.

Not parsable

Problem: The SKU cell has "invisible" formatting data. This is typical for copying and pasting from a PDF, webpage, email, or other source with special formatting that Excel doesn't make obvious. 

Solution: Highlight the SKU column, select the top Home tab, then select Clear > Clear Formats. You can read more about the format clearing functionality here.

Not supported

Problem: You've attempted to upload a standard order import file with a header-based parser enabled.

Solution: Import a header-based file, or change the import format under Order > Order Import Preferences.

Required

Problem: There is invalid SKU information.

Solution: Ensure that every SKU on the template is set up within the system before attempting to import. Also, check for any unintended spaces listed in the relevant SKU names under Items > Manage Items. If a SKU name is configured with an extra space, you cannot import that SKU as a receipt line item until you remove the space in the item setup or via a Batch Item Update.

Excel tips

Reformat scientific notations

When numerical values contain leading zeroes or exceed 11 characters, those values can automatically convert to scientific notation upon opening an Excel file. One method of avoiding this reformatting is saving the file, converting it to a .txt file, then importing the file back into Excel. To do this, open a blank worksheet, select the top Data tab, then specify to import 'From Text/CSV'.

Remove extra spaces

You can use the TRIM function to ensure that all extra spaces are removed from your template prior to upload. For further guidance, please see How to use the Excel TRIM function.

Remove unintended line breaks

One of the most common issues we find in "broken" import templates are unintentional line breaks in your data. To easily search and remove line breaks in your Excel document, do the following:

  1. Press < Ctrl + F > on your keyboard, then select the Replace tab.
  2. In the 'Find what' field, enter < Ctrl + J > to identify the line breaks in your sheet.
  3. Leave the 'Replace with' field empty, then click Replace All. If there were line breaks present, a confirmation message appears informing you how many replacements were made.

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Completing the API Integration Survey
  • Performing Inventory Audits

Not finding the help you need?

Contact Support
Solutions
  • Solutions for Brands
  • Solutions for 3PLs
  • Solutions for 4PLs
  • Solutions for B2B
Products
  • Extensiv 3PL Warehouse Manager
  • Extensiv Warehouse Manager
  • Extensiv Order Manager
  • Extensiv Integration Manager
  • Extensiv Network Manager
Products
  • Customer Success
  • Implementation
  • Consulting
Ecosystem
  • Fulfillment Marketplace
  • Integrations
  • Partners
  • Become a Partner
Resources
  • Resource Library
  • Blog
  • Market Insights
  • What is a 3PL?
  • What is a 4PL?
  • What is a WMS?
  • Why a Cloud-based WMS?
  • Glossary
Help
  • Help Center
  • API Documentation
  • Extensiv Univerisity
  • Community
  • System Status
  • Extensiv Logo
  • 100 N Pacific Coast Hwy, Suite 1100, El Segundo, CA 90245
  • |
  • Contact Us:
  • 83-EXTENSIV 888.375.2368 (main)
  • |
  • 310.844.7570 (local)
  • Copyright © 2023 Extensiv
  • |
  • All rights reserved.
  • Privacy Policy
  • |
  • Terms of Service
  • Follow Us:
Expand