3PL Warehouse Manager

Updated on August 9th, 2023

  • Extensiv Hub
    Popular Articles Getting Started Using Hub Technical Issues & FAQs Extensiv's Ideas Portal
  • 3PL Warehouse Manager
    Receiving Operations Inventory Management Shipping Operations System Configuration Scanning Operations Integrations Content Best Practice Resources Release Notes Popular Articles Troubleshooting Guides
  • Warehouse Management
    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 Popular Articles Reporting
  • Order Management
    Dashboard Orders Inventory Purchase Orders Shipments Customers Products Analytics Settings API API Integrations Accessing and Navigating Order Manager Error Messages Order Manager Popular Articles Accounting Integrations
  • Integration Management
    Getting Started with Integration Manager General Support Troubleshooting Extras & Addons API Documentation Popular Articles Order Sources Order Destinations
  • FAQs
  • Network Manager
    Getting Started Order Routing Management Technical Issues Shopping Carts Settings Settings, Products, and Orders
  • Billing Manager
    Getting Started Using Billing Manager
  • Release Notes
    Extensiv Sandbox Extensiv Extensiv Hub 3PL Warehouse Manager Integration Management Warehouse Management Order Management Billing Manager
  • Fulfillment Marketplace
    Getting Started
  • Sandbox
    Getting Started
+ 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
        • Consulting Services
        • Ask the Expert
        • Best Practice Consultation
        • Custom Report
        • Add a Customer
        • On-Site Visit
        • Developer Enablement
        • Premium Account Services
    • Customer Central
        • Subscription Invoice and Billing FAQs
        • Navigating the Help Center
        • Navigating the Support Portal
        • Support Portal FAQs
    • Dashboards and Analytics
        • Warehouse Productivity Dashboard FAQs
        • Understanding Dashboard Sync Time
        • Recent Enhancements for Labor Analytics Dashboard
        • Understanding the Warehouse Productivity Dashboard
        • Understanding the Labor Analytics Dashboard
    • Data Imports
        • Import Template FAQs
        • Troubleshooting Import Template Errors
        • Import Templates
    • Classic Reporting
        • Understanding Reports
        • Customizing Reports
        • Stock Status Report
        • Transactions Reports
        • Items Reports
        • Locations Reports
        • Management Reports
    • 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
  • July 29, 2020 – Minor Release Notes
  • May 30, 2020 – Minor Release Notes

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