3PL Warehouse Manager

Updated on January 23rd, 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

Import Template FAQs

This article answers the most common questions we receive about using import templates.

If you are experiencing import errors, please reference our article for Troubleshooting Import Template Errors. In addition, we ask that you please make sure you are using the latest versions of our Import Templates, follow the instructions noted in the template, and review our troubleshooting steps and FAQs below before contacting Support.

 

What are import templates used for and where can I find them?

Import templates are used as an alternative to manual data entry, allowing you to quickly upload large amounts of data into the system. You can find our full list of import templates here.

What is a Flex Header template and when am I supposed to use it?

A Flex Header template is available for both order and receipt imports, allowing you a degree of customization in regards to what data you want to include in the import.

If you need more fields than what the standard import template provides, such as those needed for fulfillment invoicing, or you have a specific workflow that requires customer users to edit transactions after upload, use a Flex Header Import Template. If not, we recommend you use the standard Order or Receipt Import Template for most cases.

Can I import an order with no line items?

If you are using a Flex Header Import Template, yes. 

The background process associated with .txt Import Parser (used for standard templates) does not allow for blank values in required fields. However, the .xlsx Import Parser (used for flex header templates) only looks at the headers in the file, which allows you to import empty values under certain columns.

This can create a “0” quantity line item if a cell under the 'Qty' column is left empty, and the system will allow you to close the order as such. Please always double-check your import templates to ensure the data is as you need it to be for your purposes.

How can I ensure my formatting and parsers are correct?

Inexact formatting and incorrect parsers are common error causes. There are several important steps you can take to ensure your formatting and parsers are appropriate before you attempt to import the file.

  1. Confirm that the import parsers are correct under Orders > Order Import Preferences and Receipts > Receipt Import Preferences in 3PL Warehouse Manager.
    • Unless specifically directed otherwise, we recommend uploading standard import templates in 'WMS tab-delimited' format.
    • For Flex Header Import Templates, you are required to upload in 'WMS header based (txt-tab, xlsx)' format.
  2. Make sure your file is saved as the appropriate file type with the correct header formatting. Each import template contains specific guidelines on how to format and save the import file in the Instructions sheet. Column header notes also typically contain formatting guidelines and examples.
    • If a column header has a red ribbon in the top-right corner of the cell, hover over the cell to view the note.
    • To expand a note, right-click the cell, then select Show/Hide Note—take the same action if you want to hide a note.
  3. Remove any extra spaces or tabs and try to limit the number of blank rows beneath the cells with data. We recommend never exceeding 300 rows of text. You can read more about how to remove extra data in the next question below.

What are some useful Excel tips?

There are several built-in Excel functions you can use to avoid formatting errors.

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

  • Magento 2.x Shopping Cart Connection
  • Managing Item Images
  • February 26, 2020 – Minor Release Notes
  • Setting Up FTP Email Notifications

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