Logo
Request Support Sign in
  1. Cahoot
  2. Shipping Software
  3. Manage Orders

Menu

Manual Order Import

Once you connect your stores to Cahoot, all orders will be imported to Cahoot automatically. However, Cahoot allows you to import orders manually via CSV. This is useful when you ship orders from a sales channel that Cahoot does not yet support, or if you need to import custom orders.

Note: Manually Imported orders will not connect to outside sales channels to update shipment status, receive channel-specific notifications, or provide inventory adjustments to non-Cahoot systems. 
Important Reminder: Cahoot does not start processing any orders and creating shipping labels until 4am PT daily, and stops after the same-day shipping cutoff time. So orders manually imported at 10pm PT, for example, will not start processing until 4am PT the next business day. 


Video
Walkthrough



Step-by-Step Guide

1. Go to Orders> Import Orders.

mceclip1.png

 

2. Download Import Template. You can find the Import Legend below. 

2.png

 

3. The Template file includes columns you need to fill out to import your orders and the Legend shows you what each column means and what formats are supported. Fill out your template file and save it to your computer. You can leave non-required fields blank.

If you have a multi-line order, you'll need to enter in the same order and customer data for each SKU; fill out the data row for the first SKU, then copy it to the line below; keep the Sales Channel Order ID, shipping dates, and Customer data the same, and update the product details for the next SKU on the order: 

Note: Excel likes to trim leading 0's out of ZIP codes; example: 06604 > 6604. Orders will still import but this will prevent the order from automatic processing. Please ensure leading 0's are not being removed by Excel. 

1. Select the cells on your worksheet where you'll be adding the data.
2. Right-click anywhere in the highlighted cells, and then on the shortcut menu, click Number Format > Text > OK.
3. Type or paste the numbers in the formatted cells.

mceclip0.png

Note: When importing Amazon orders you must leave the Sales Channel column blank. Do NOT put "Amazon" as the Sales Channel because errors will be found. 

 

4. Go back to Import Orders page, click Select files, browse to your saved template file(s), select them and click Submit to upload.

3.png

 

5. Once the import is complete, Cahoot will begin processing the import file and adding orders to Cahoot. This can take up to 30 minutes.

Note: Make sure you check back on the Import Orders page to see if there were any issues with your import. If the import failed or errors were found, click "Download report" to see more details about the error(s). 

mceclip2.png

 

Import fields legend

* denotes a required field

 

Field

Description

Sales Channel Order ID*

Order ID of the Order in its Sales Channel. If an order has multiple products, repeat the order ID in each separate line.
Cahoot: Order ID is unique; once you have imported an order at a Sales Channel, you cannot import another order with that Order ID. You cannot add products to existing orders. 

Sales Channel

The order’s Sales Channel. While this is not required, if you enter a value, it must be from this list of currently allowed values:
"B2B", "BigCommerce", "ChannelAdvisor", "eBay", "GeekSeller", "Google Shopping", "Inventory Transfer", "Magento", "Pulse Commerce", "Shopify", "Walmart", "Woocommerce", "Zentail", "Custom".

Earliest Ship By Date

Earliest ship date requested by the marketplace
We recommend that orders are imported before 10:00 AM PT for same-day shipping. Any errors in import will delay processing.

Latest Ship By Date

Latest ship date requested by the marketplace

Earliest Deliver By Date

Earliest delivery date required by the Sales Channel
If blank, Cahoot will pick cheapest label allowed.

Latest Deliver By Date

Latest delivery date required by the Sales Channel
If blank, Cahoot will use the Earliest Deliver By Date for this field.

Customer Requested Carrier

Enter the Carrier the customer specified or leave blank
Allowed values: “UPS”, “FedEx”, and “USPS”

Customer Requested Service

Enter the Shipping Service the customer specified or leave blank
Examples: Ground Shipping, 2 Day, First Class Mail

Customer First Name*

Customer’s Ship To address first name

Customer Last Name*

Customer’s Ship To address last name

Company Name

Ship To address company name

Address Line 1*

Ship To address line 1

Address Line 2

Ship To address line 2

Address Line 3

Ship To address line 3

City*

Ship To city

State or Province*

State or province name. For US states, two letter state code is required. For Canadian addresses, two letter province code is preferred. See here for a full list

Postal Code*

Ship to ZIP or postal code

Country Code*

Country’s two letter code. See here for a full list

Item SKU*

Ordered item’s SKU
Cahoot: If the order has multiple SKUs, enter one row of data in the import file for each distinct SKU. So for example, an order with 3 different products will take 3 rows in the import; one for each SKU/Qty combination

Item Name

Ordered item’s name
Cahoot: If the order has multiple SKUs, enter one row of data in the import file for each distinct SKU. So for example, an order with 3 different products will take 3 rows in the import; one for each SKU/Qty combination

Quantity Ordered*

Ordered item’s quantity

Unit Price*

Ordered item’s price
Cahoot: Include numbers with up to 2 digits of decimals. Do not enter a "$" or other currency symbol. Note that Cahoot only deals in USD.

Customer Notes

Any notes for this customer

Return to top

Related articles

  • Using Scan Verification
  • Order Statuses
  • Creating Inbound Shipments
  • Order Grids
  • Scanning Cahoot End of Day Forms

Company

  • About Us
  • Contact Us
  • Terms of Use
  • Privacy Policy

Platforms

  • Shipping Optimization
  • Label Optimization
  • Inventory Optimization
  • Post Purchase Optimization

Resources

  • Testimonials
  • Partners
  • News & Events
  • Blog

Copyright © Cahoot. All Rights Reserved.

Zendesk Theme Designed by Diziana