Request Support
  1. Cahoot
  2. Shipping Software
  3. Manage Orders

Menu

Once you connect your stores to Cahoot, all orders will automatically create new products into Cahoot. However, Cahoot allows you to import products manually via CSV. This is useful when you have specific product data you want to add in bulk, rather than let products be created as orders come in. 

Note: Manually Imported products

Step-by-Step Guide

1. Go to Products > Import Products.

 

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

 

3. The Template file includes columns you need to fill out to import your products 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.

Each product should be on its own line; ensure data from one product does not spill over into other lines, or it will update the wrong product.

Note: Excel likes to trim leading 0's out of number fields; example: 0123456789 > 123456789. Please ensure leading 0's are not being removed by Excel. This is especially important for Barcodes.

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

4. Now that our Product Import csv is complete, go back to Import Products page, click Select files, browse to your saved template file(s), select them and click Submit to upload.

 

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

Note: Make sure you check back on the Import Products 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). 

 

 

Import fields legend

* denotes a required field

 

Field

Description
SKU*

Product SKU value
Cahoot: SKUs are unique per sales channel. SKUs can be any values excluding special characters
Channel Name*

The SKU's Sales Channel. This must be from this list of currently allowed values:
"Acenda", "Amazon", "B2B", "BigCommerce", "ChannelAdvisor", "Custom", "eBay", "eBay US", "Flxpoint", "GeekSeller", "Google Shopping", "Inventory Transfer", "Linnworks", "Macys", "Magento", "MagentoV2", "Nordstrom", "Pulse Commerce", "Sellercloud", "Shopify", "Walmart", "Woocommerce", "Zentail"
Item Name*

This is the Name of the item. 
Max character limit is 2000 characters. 
ASIN

Amazon ASIN value for the product
UPC

Product UPC
Any value excluding special characters. Best practice is to enter using a barcode scanner instead of manually entering values
Barcode

Barcode for the product. 
Any value excluding special characters. Best practice is to enter using a barcode scanner instead of manually entering values
Alternate Barcode

Alternative Barcode for the product. 
Any value excluding special characters. Best practice is to enter using a barcode scanner instead of manually entering values
Bin Location

Used to show product location on packing slips.
Length*

Enter in inches, up to 2 decimal places. 
Any numeric value.
Width*

Enter in inches, up to 2 decimal places. 
Any numeric value.
Height*

Enter in inches, up to 2 decimal places. 
Any numeric value.
Weight*

Any numeric value, up to 2 decimal places.
Weight Unit*

"lbs" or "oz"
Preferred Packaging*

Select preferred packaging for the product.

  • Poly bag
  • Bubble mailer
  • Box
Units Per Master Case

Enter number of units per master case.
Master Case Per Pallet

This is number of master cases per pallet.
Special Storage Instructions

Enter special storage instructions, if any.
Sale Price

Enter sale price.
Manufacturer Product manufacturer name.
Brief Product Description

Enter product description.
Harmonized Code

This is harmonized code for the product.
This is necessary for international shipping; this field is needed before the product can be shipped internationally
Country of Origin

Enter country of origin for product as two letter code. See here for a full list
This is necessary for international shipping; this field is needed before the product can be shipped internationally.
Open for Label Generation

Default is "Yes"
Disable 3D Packaging Label Automation

Default is "No"
Disable from MLMQ Auto-Label Generation

Default is "No"
Size Name

Cosmetic description value. Examples: "X-Large", "Size 9"
Color Name

Cosmetic description value. Examples: "burgundy", "gray"
Flavor Name

Cosmetic description value. Examples: "strawberry", "savory"
Scent Name

Cosmetic description value. Examples: "citrus", "lavender"
ChannelAdvisor SKU

Enter ChannelAdvisor SKU if any.
Magento SKU

Enter Magento SKU if any.
Shopify SKU

Enter Shopify SKU if any.
Bigcommerce SKU

Enter BigCommerce SKU if any.
Product Description

Enter product description.
Condition Type*

Enter item condition.

  • New
  • Used
  • Collectible
  • Refurbished
  • Preorder
  • Club
Brand Name

This is brand name of the product.
Main Image URL

Enter image URL for the product
URL must be complete or full length; no partial URLs
External Product Id

Enter any additional product IDs associated with the product. This is a descriptive field; primary ASIN, UPC values should be entered into the dedicated fields earlier in the template.
External Product Id Type
  • ASIN
  • UPC
  • EAN
  • ISBN
  • JAN
  • GTIN
  • MPN
  • SKU
Hazmat*
  • Dangerous Goods
  • Lithium Batteries (UN3090)
  • Lithium Batteries (UN3091 - Packaged with Equipment)
  • Lithium Batteries (UN3091 - Packaged in Equipment)
  • Lithium Batteries (UN3480)
  • Lithium Batteries (UN3481 - Packaged with Equipment)
  • Lithium Batteries (UN3481 - Packaged in Equipment)
  • Biological Material
Standard Price

Enter standard price for product.
List Price

Enter list price for product.
Generic Keywords

Enter generic keywords to describe the product.

 

Related articles