Request Support
  1. Cahoot
  2. Shipping Software
  3. Inventory

Menu

Save time using the product import feature to create or update multiple items at once.  

 

Note: Product Catalogs can also be imported directly from your sales channel. However, if you ship on multiple sales channels, only 1 product catalog can be imported, not all of them, so be thoughtful which channel to import. Notify Cahoot Support if you would like to use this method.

Important Reminder: Orders containing SKUs that don't exist in Cahoot will be created automatically using information received from the Sales Channel, so make sure your Alias SKUs are configured in Cahoot in advance of listing them for sale to avoid orphaning a product from its parent listing. Learn more about Alias SKUs.

 

Step-by-Step Guide

1. Go to Products > Import Products.

 

2. Download the Import Template and Legend. 

 

3. The Template file includes all the available columns that can be imported, and the Legend defines each column, what formats are supported, and which columns are required fields. Fill out the template file accordingly and Save it to your computer. Non-required fields can be left blank; do not delete or rearrange any columns and do not rename column headers.

  • Importing files containing Products that don't exist will CREATE new products.
  • Importing files containing Products that already exist will UPDATE them.

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

 

Beware: 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.

 

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

mceclip0.png

 

4. Go back to Import Products page, click Select files, browse to your saved CSV 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 the Status column on the Import Products page for any issues with your import. If any of the rows failed or errors were found, click "Download report" in the Action column to review and fix the error(s) for re-import. The row number in the report is the precise row from the CSV file already accounting for headers.

 

 

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
  • Ready to Ship As Is
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