CSV Warehouse Mapping Instructions

CSV Warehouse Mapping Instructions

To setup your own custom CSV format for sending orders from CartRover 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 CartRover 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 CartRover. 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 CartRover Support if you don't have your own FTP server and need one provided ...
    • CSV Cart Mapping Instructions

      To setup your own custom CSV format for loading orders into CartRover, 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 the Manage CSV Formats ...
    • 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 CartRover. Extra Order Fields Select extra_order_field in the CSV mapping field list. Enter the ...
    • 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 ...
    • Supported CSV Formats

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