CSV Warehouse Mapping Instructions

CSV Warehouse Mapping Instructions

To setup your own custom CSV format for sending orders from Extensiv Integration Manager to your warehouse, go to the WMS Setup tab. If you already have defined some formats, you can select them here, otherwise click the  Customize CSV Fields button at the bottom of the page. You don't need to fill out any of the other CSV settings fields to begin this process.

Select the file type you will be mapping (Order, Confirmation, or Inventory).

Click New Order File. You can come back here later and edit an existing format if needed. There will be another button displayed for editing.

If you have a sample file, choose it on the left and click Upload. If not, click Manually Set Up CSV Format on the right.

When uploading a sample file for mapping, large files are not allowed. If your file is too big, try uploading a smaller sample file or edit your file so it only contains a few orders.

You must next define the delimiter in the file (eg: comma), if the file will have a header row, and whether orders with multiple products will be listed Vertically (One item per line), or Horizontally (have additional products added at the end of the line). Double check these and make sure they are correct. An error here will cause your orders to be loaded incorrectly or could cause some records to be missed.


Next, for each column in the CSV file, you must select what type of data is there. Choose from the dropdown.

Important - Order Number
Both the  cust_ref and cust_po_no fields will contain a unique order number. Cust Ref is a shorter version guaranteed to be 16 digits or shorter. Cust Po No can be up to 45 characters. Choose the best value for your warehouse, or choose both!

If your csv file is Vertical each row in your CSV file must have exactly 1 item and contain the same number of columns. A new line is required for each additional item on an order with the order number repeated.

If your csv file is Horizontal, all the item fields must be at the end of the file. Just add the fields for the first item and Integration Manager will automatically append additional items after it as needed if you receive an order with multiple items.

Additionally, you can add Constant Values to the file where needed. This lets you pass a value to your warehouse which is not actually in Integration Manager. Just select the constant_value in the Order Field dropdown and enter what data should be placed in it.


Extra/Custom fields from specific Order Sources can also be passed to the warehouse. Instructions are available here: CSV Mapping - Extra Fields


    • Related Articles

    • Setting Up CSV Warehouse

      Integration Specs: Supported functions: Order Send Shipment Confirmation Pickup Inventory Sync Pickup Required Parameters FTP Server FTP Username FTP Password Contact Integration Manager Support if you don't have your own FTP server and need one ...

    • CSV Cart Mapping Instructions

      To setup your own custom CSV format for loading orders into Extensiv Integration Manager, in the CSV cart's settings, make sure the CSV File Format is set to Custom. If you already have defined some formats, you can select them, otherwise click ...

    • CSV Mapping - Extra Fields

      Extra Field values pulled from your Order Source may be passed in CSV order files to the warehouse. Enter the Extra Field name EXACTLY as displayed in Extensiv Integration Manager. Extra Order Fields Select extra_order_field in the CSV mapping field ...

    • CSV Warehouse Overview

      Extensiv Integration Manager can connect to any warehouse that accepts CSV files over FTP or SFTP. From Integration Manager you can load and map most CSV formats on the fly. If you need something really special contact Integration Manager Support and ...

    • Supported CSV Formats

      Extensiv Integration Manager has built in support for several existing CSV formats. If you can create files in one of these formats, just select the format in Integration Manager you want to use. Here is a list of all the standard formats supported: ...