Setting Up CSV Warehouse

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 provided

Step-by-step guide

  1. Choose your FTP Server Type
    1. FTP Passive, FTP Active, or SFTP
  2. Put the server, username and password into the appropriate boxes in the Extensiv Integration Manager setup.
  3. Enter the FTP Port.
    1. Default for FTP is 21
    2. Default for SFTP is 22
    3. Default for FTPS varies
  4. If you have multiple clients, Integration Manager can drop files into a different directory for each client. the Directory Order option defines which folder comes first. The Client specific folder, or the Warehouse specific folder. If you won't be using one of those settings, this field doesn't matter.
  5. Enter the directories that files should be picked up from and dropped off to. Leave blank to use the main directory.
    1. Under each Merchant's settings, you will also see a list of directories. Those directories let you define the client specific folders to use.
    2. For example, if your order directory structure is: /CLIENTNAME/Orders
      1. Choose "Login to client then WMS" since the client folder comes first.
      2. Enter "Orders" in the WMS "Order Directory"
      3. Enter CLIENTNAME in the Merchant "Order Directory"
  6. Select the File Formats from the dropdown.
    1. Select Customize CSV Fields at the bottom of the screen to setup any format you need.

 

See here for instructions on mapping up your custom CSV formats.


Manual Shipment File Creation
If you will be creating or editing your shipment files by hand in Excel, Excel will corrupt your tracking number field. To prevent this from happening you can prefix the tracking number with a tick mark (not a quote): `
Integration Manager will remove the tick when loading the tracking record, but the tick will trick Excel and prevent it from converting the field into scientific notation.

    • Related Articles

    • 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 ...
    • Setting Up SnapFulfil WMS

      Required Parameters Credentials from Snapfulfil that are needed to setup this connection to CartRover. See below for instructions on how to request/obtain these credentials.  Live/Test API URL Live/Test API Username  Live/Test API Password Warehouse ...
    • 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 ...
    • How to set up a shopping cart connection (Warehouse Users)

      Warehouse users can easily set up and configure new shopping cart connections for any of their merchants. You must have a merchant set up first before you can create a shopping cart integration. See how here. Step-by-step guide Step 1: To start, go ...
    • Setting Up ShipStation WMS

      Integration Specs: Supported functions: Order Send Cancel Order in WMS Shipment Confirmation Pickup - Detailed Required Parameters Shipstation Username & Password Step-by-step guide Go to Extensiv Integration Manager and login to your account. Click ...