Along with direct shopping cart integrations, CartRover allows the loading of order files in CSV format. CartRover allows you to map up your own custom CSV order format, or you can choose from a few pre-set standard CSV formats. 

Follow these instructions to map up your own custom format:

1. Under the Carts tab, (If you have not done so already) click on New Setup and select CSV Files. 
   
   
   
   
   
   
2. Then click the OK button at the bottom of the screen. 
   
   
   
   
3. You should now see the screen below. Next, click on the Edit Setup button. 
   
   
   
   
4. Change the setting "CSV File Format" to Custom
   
   
   
   
5. Next, click on the "Manage CSV Formats" button. Click OK on the pop-up message. 
   
   
   
   
   
6. Click on the "Order" button and then on the "New Order File" button. 
   
   
   
   
   
   
7. It is recommended that you upload a sample file in the format you would like to map. To do this, click "Choose File"
   
   
   
   

8. Browse for and select your sample file. Then click the "Upload" button. 
   
   
   
   

   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.

   
   
   

9. You will now see your sample file on the screen. Click on "Map CSV Fields" and select your CSV Delimiter, whether your files will have a header row, and if your file will be in Vertical or Horizontal format. 
   
   
   
   
10. For each column in your file, please select the field you would like to map it to. 
    
    
    
    
11. You may need to map a sub-field. For instance: Map the customers company name to "cust_company" and "ship_company"
    
    
    
12. Once you have mapped all fields, name your custom format, and then click "Save Mapping" at the top of the screen. 
    
    

    
    

    Important!

    Due to current limitations, the field containing your order number should be mapped to both cust_ref and cust_po_no. Below is a screenshot showing how this should look when setup correctly:

    

    To do this, set one of the fields, then click the link icon () and select the other field. The link allows you to map a single field in the csv file to multiple fields in CartRover.

    
    If your csv file is Horizontal, you must click the Red dot() at the end of the product information for the first product. For example, if there is a product code, quantity, and price, click the red dot corresponding to the first product's price. CartRover will then know to expect additional products after that in the same order.

    Additionally, at the bottom of the page you can set Constant Values. These lets you pass a value to CartRover which is not actually in the CSV file. Just select the CartRover field and enter what data should be put in it.