CSV Warehouse

Setting Up CSV Warehouse

1.1 min read

| September 14, 2024

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

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.

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.

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.




     

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"

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.

 


 

 

Not finding the help you need?

Contact Support