How To

ChannelAdvisor Upload Spreadsheet Fields Reference

The ChannelAdvisor Upload Spreadsheet contains all of the reserved fields or attributes that are pre-configured in your account. Some fields have very specific data requirements in order to upload your data successfully. The table below outlines some of these requirements.

 

Prerequisites


You should be familiar with the following task before continuing:


Link to ChannelAdvisor Upload Spreadsheet

Note: If you have trouble downloading the template, please right-click and use the Save As... feature in your browser to download the file.

If you are an eBay QuickStart user you can download this simplified Bulk Upload Spreadsheet and use for item creation. The file doesn't contain any eBay ad related information.

 

Upload Spreadsheet Fields Reference Table
Auction Title

Inventory Item Product Title has a 120 character limit although some marketplaces have specific requirements:

  • eBay – 80 character limit
  • Amazon – 500 character limit. Note: To optimize for Amazon Mobile, use 80 characters.
  • Rakuten.com / Buy.com – 250 character limit
Inventory Number

An ID (50 character max number) used to uniquely identify a product, most often your SKU number or inventory tracking number (required).

  • eBay – no limit
  • Amazon – 40 character limit
  • Rakuten.com US / Buy.com – 50 character limit
  • Newegg – 40 character limit
  • Sears – 50 character limit
  • One Stop Plus – 25 character limit
Quantity Update Type

Type of quantity update to perform. The accepted values are explained on the Inventory Update Type page.

  • * Required if updating quantity
  • If this item is new to ChannelAdvisor, the Quantity Update Type is irrelevant.
  • * Required if quantity is used in the spreadsheet upload, else the default is assumed to be unshipped.
  • The values submitted are NOT case sensitive. You can submit the value in ALL CAPS, or in lower case, and the value will be processed.
Quantity The number of this item available.
DC Quantity

Used to set different quantity amounts for your item held at different Distribution Centers (DCs). If you supply one or more values for this column, any values specified in the "Quantity" column will be ignored.

To use this field, you must follow the following convention:
{DC Code 1}={Quantity for DC1}, {DC Code 2}={Quantity for DC2}, ...
For example:
NYC=1, Atlanta=3

Only values for Seller-Managed DCs will be allowed. Any values for Externally-Managed distribution centers, such as Amazon FBA, will result in a warning for that item and the quantity update for that DC will be ignored. Since ChannelAdvisor is notified of the quantity held at Amazon FBA from Amazon directly, you can not set the quantity on an Externally-Managed DC via this Inventory Upload.

DC Quantity Update Type

Used in combination with DC Quantity (required). You define in this field, if you only want to update quantity for DC from this upload file or if you want to update all DCs of an inventory item. Two values are available:

  • partial dc list – Recommended option. Only DC quantity of distributions centers in this file, specifically the ones from field DC quantity, are updated.
  • complete dc list – Will zero out your quantity for all DCs that you do not provide quantity for, so you should only use to wipe out inventory at other distribution centers.

If your account is not enabled for this feature, we will return an error if you provide DC Quantity Update Type.

Bundle Components

This field can be used to create bundle products. To use this field, you must follow the following convention:

{Component SKU 1}={Quantity for Component 1}, {Component SKU 2}={Quantity for Component 2}, ...

For example:

  • SKU_A=1,SKU_B=2 - This would create a bundle containing 1x of SKU_A and 2x of SKU_B.
  • SKU_A,SKU_B=2 - This would create a bundle containing 1x of SKU_A and 2x of SKU_B. Note that if the quantity is omitted, a value of 1 will be used.
Bundle DCs

If this field is populated with a list of DC codes (comma separated), bundle quantity will be restricted to these DCs.

Block External Quantity Setting this flag to true will prevent listing and fulfillment from Externally-Managed DCs.
Starting Bid Starting bid for each auction of this item
Reserve Reserve price for each auction of this item
Weight

Weight of this item

  • Do not include abbreviations such as "lbs or "oz"
ISBN International Standard Book Number is the unique numeric book identifier.
UPC Universal Product Code
EAN

European Article Number

  • Do not submit more than what a standard EAN length is.
ASIN Amazon Standard Identification Number is a unique identification number assigned by Amazon.com and its partners for product identification within the Amazon.com organization.
MPN Manufacturer Part Number
Short Description Used as the upsell item description. 1000 character limit.
Description Description of the item (HTML-supported). 32,000 character limit.
Manufacturer Name of the company that manufactures the product
Brand Kind or make of the item.
Condition

New, Used, Refurbished, Reconditioned, Like New.

Warranty Guarantee that the product meets certain criteria
Flag Flag type to apply to the sku: NoFlag, ExclamationPoint, QuestionMark, NotAvailable, Price, BlueFlag, GreenFlag, RedFlag, YellowFlag, ItemCopied
Flag Description Example: This item is backordered. 80 character limit.
Seller Cost The price that the seller paid for this item
Product Margin Profit margin for a product
Buy It Now Price Buy It Now price for each auction of this item
Retail Price Retail price for this item
Second Chance Offer Price Price above which you wish to offer underbidders of this item a second chance offer.
Picture URLs

Comma-separated list of picture URLs for this item.

  • This can be names of images uploaded via FTP or the UI, or full URLs hosted on your own website.
  • Because ChannelAdvisor uses commas to separate multiple images assigned to the same SKU URLs should not contain commas.
  • Any URLs with commas in the string will not upload properly.
  • Replace any commas with the following code "%2C" in order to correct this issue.
Tax Product Code

Tax product code for this item.

Supplier Code

Code for the supplier of this item

  • Must be created in ChannelAdvisor prior to use
Supplier PO Supplier purchase order number
Warehouse Location

Location of this item in the warehouse.

  • 80 character limit
Received in Inventory

Date a seller received a product into inventory.

  • The date/time can be in the format of:
  1. YYYY/MM/DD
  2. YYYY-MM-DD
  3. MM/DD/YYYY (or DD/MM/YYYY based on locale's preferred date format)
  4. MM-DD-YYYY (or DD-MM-YYYY based on locale's preferred date format)
  5. MM-DD-YY (or DD-MM-YY based on locale's preferred date format)
  6. MM/DD/YY (or DD/MM/YY based on locale's preferred date format)

 

Inventory Subtitle

Inventory item subtitle.

  • 100 character limit.
Relationship Name

Variation relationship that this item belongs to.

  • 50 character limit.
Variation Parent SKU

If a variation parent, us "PARENT". If a variation child, use the Item Number of the desired variation parent.

  • 50 character limit.
Description Template Name

Name of the description template (former name was "ad template") that should be used for this ad

  • Must be created in ChannelAdvisor prior to us.
  • * Required if you specify a Posting Template.
Posting Template Name

Name of the posting template that should be used for this ad

  • Must be created in ChannelAdvisor prior to use
  • * Required if you specify an Ad Template.
Schedule Name Name of the schedule that should be used for this ad must be created in ChannelAdvisor prior to use
eBay Category List

List of eBay categories that should be used for this ad.

  • eBay Category ID numbers are supported.
  • Maximum of two categories, separated by a comma
  • You cannot submit anything but an integer for this value.
eBay Store Category Name

Name of the eBay store category that should be used for this ad. eBay Category ID numbers are supported. 

  • Must be imported in ChannelAdvisor prior to use. See Marketplace > eBay > eBay settings > eBay Store Settings
  • * R equired if you specify a posting Template
  • If you want to use two eBay store categories, format them like this: category1::category2
Labels

List of Labels to add to this item.

  • 50 character limit
  • A minus sign in front of a label name will remove it from the item.
  • The list must be separated by a comma.
DC Code

Distribution Center Code

  • The DC Code must exist in ChannelAdvisor prior to use
  • To create an items as "Fulfillment by Amazon (FBA)", submit the value "Amazon FBA" in this field
  • NOTE: Beginning with the release on February 12th, 2013 , the valid FBA designation is no longer "Amazon FBA" and will become one of following:
  • For more information on uploading inventory for specific FBA scenarios, please see Designating SKUs for FBA SSC page.
Do Not Consolidate Specify if this item cannot be consolidated with other items. Accepted values are True, False, 1, 0, Yes, No
ChannelAdvisor Store Title

ChannelAdvisor Store Title

  • 120 character limit
ChannelAdvisor Store Description

ChannelAdvisor Store Description

  • 32,000 character limit
Store Meta Description

ChannelAdvisor Store Meta Description

  • 200 character limit
ChannelAdvisor Store Price The price of your item as it should appear in the ChannelAdvisor Store
ChannelAdvisor Store Category ID ChannelAdvisor Store Category ID
Classification

The inventory classification you would like to assign to this item

  • 35 character limit
  • You do not need to have the classification set prior to uploading inventory items.
Attribute (x) Name

Name of the attribute for this item.

  • This column can be repeated for up to 50 attributes and is paired with the Attribut (x) Value field.
  • Column headers are repeatable using an incremented number, for example Attribute1Name, Attribute1Value, Attribute2Name, Attribute2Value, etc.
  • 32 character limit
  • See the upload template file for an example.
Attibute (x)Value

Value of the classification specific attribute for this item.

  • This column can be repeated for up to 50 attributes and is paired with the Attribute(x)Name field.
  • Column headers are repeatable using an incremented number, for example " Attribute1Name, Attribute1Value, Attribute2Name, Attribute2Value, etc.
  • 32,000 character limit
  • See the upload template file for an example.

 

Harmonized Code International standard code for custom tariffs
Height

Height of a product when prepared for shipping

  • Decimal positive only.
Length

Length of a product when prepared for shipping

  • Decimal positive only.
Width

With of a product when prepared for shipping

  • Decimal positive only.
Ship Zone Name

Shipping zone applicable for upcoming rate

  • Must be created in ChannelAdvisor prior to use
  • 50 characters limit
Ship Carrier Code

Shipping carrier code.

  • The list of valid carriers in your account are listed in Sales > Shipping > Account Shipping Carriers
  • Carrier codes must be created in ChannelAdvisor prior to use
  • * Required if you specify a Ship Zone Name
  • 50 characters limit
Ship Class Code

Shipping class code.

  • The list of valid carriers in your account are listed in Sales > Shipping > Account Shipping Carriers
  • Class codes must be created in ChannelAdvisor prior to use
  • * Required if you specify a Shipping Carrier
  • 50 characters limit
Ship Rate First Item

Shipping amount for first item in a group

  • Decimal positive only.
Ship Handling First Item

Shipping handling amount for first item in a group

  • Decimal positive only.
Ship Rate Additional Item

Shipping amount for each additional item in a group

  • Decimal positive only.
Ship Handling Additional Item

Shipping amount for each additional item in a group

  • Decimal positive only.
(repeat) Repeat last 7 ship fields as needed for additional zone carrier class rates.

 

The ChannelAdvisor Upload Spreadsheet contains all of the reserved fields or attributes that are pre-configured in your account. Some fields have very specific data requirements in order to upload your data successfully. The table below outlines some of these requirements.

 

Prerequisites


You should be familiar with the following task before continuing:


Link to ChannelAdvisor Upload Spreadsheet

Note: If you have trouble downloading the template, please right-click and use the Save As... feature in your browser to download the file.

If you are an eBay QuickStart user you can download this simplified Bulk Upload Spreadsheet and use for item creation. The file doesn't contain any eBay ad related information.

 

Upload Spreadsheet Fields Reference Table
Auction Title

Inventory Item Product Title has a 120 character limit although some marketplaces have specific requirements:

  • eBay – 80 character limit
  • Amazon – 500 character limit. Note: To optimize for Amazon Mobile, use 80 characters.
  • Rakuten.com / Buy.com – 250 character limit
Inventory Number

An ID (50 character max number) used to uniquely identify a product, most often your SKU number or inventory tracking number (required).

  • eBay – no limit
  • Amazon – 40 character limit
  • Rakuten.com US / Buy.com – 50 character limit
  • Newegg – 40 character limit
  • Sears – 50 character limit
  • One Stop Plus – 25 character limit
Quantity Update Type

Type of quantity update to perform. The accepted values are explained on the Inventory Update Type page.

  • * Required if updating quantity
  • If this item is new to ChannelAdvisor, the Quantity Update Type is irrelevant.
  • * Required if quantity is used in the spreadsheet upload, else the default is assumed to be unshipped.
  • The values submitted are NOT case sensitive. You can submit the value in ALL CAPS, or in lower case, and the value will be processed.
Quantity The number of this item available.
DC Quantity

Used to set different quantity amounts for your item held at different Distribution Centers (DCs). If you supply one or more values for this column, any values specified in the "Quantity" column will be ignored.

To use this field, you must follow the following convention:
{DC Code 1}={Quantity for DC1}, {DC Code 2}={Quantity for DC2}, ...
For example:
NYC=1, Atlanta=3

Only values for Seller-Managed DCs will be allowed. Any values for Externally-Managed distribution centers, such as Amazon FBA, will result in a warning for that item and the quantity update for that DC will be ignored. Since ChannelAdvisor is notified of the quantity held at Amazon FBA from Amazon directly, you can not set the quantity on an Externally-Managed DC via this Inventory Upload.

DC Quantity Update Type

Used in combination with DC Quantity (required). You define in this field, if you only want to update quantity for DC from this upload file or if you want to update all DCs of an inventory item. Two values are available:

  • partial dc list – Recommended option. Only DC quantity of distributions centers in this file, specifically the ones from field DC quantity, are updated.
  • complete dc list – Will zero out your quantity for all DCs that you do not provide quantity for, so you should only use to wipe out inventory at other distribution centers.

If your account is not enabled for this feature, we will return an error if you provide DC Quantity Update Type.

Bundle Components

This field can be used to create bundle products. To use this field, you must follow the following convention:

{Component SKU 1}={Quantity for Component 1}, {Component SKU 2}={Quantity for Component 2}, ...

For example:

  • SKU_A=1,SKU_B=2 - This would create a bundle containing 1x of SKU_A and 2x of SKU_B.
  • SKU_A,SKU_B=2 - This would create a bundle containing 1x of SKU_A and 2x of SKU_B. Note that if the quantity is omitted, a value of 1 will be used.
Bundle DCs

If this field is populated with a list of DC codes (comma separated), bundle quantity will be restricted to these DCs.

Block External Quantity Setting this flag to true will prevent listing and fulfillment from Externally-Managed DCs.
Starting Bid Starting bid for each auction of this item
Reserve Reserve price for each auction of this item
Weight

Weight of this item

  • Do not include abbreviations such as "lbs or "oz"
ISBN International Standard Book Number is the unique numeric book identifier.
UPC Universal Product Code
EAN

European Article Number

  • Do not submit more than what a standard EAN length is.
ASIN Amazon Standard Identification Number is a unique identification number assigned by Amazon.com and its partners for product identification within the Amazon.com organization.
MPN Manufacturer Part Number
Short Description Used as the upsell item description. 1000 character limit.
Description Description of the item (HTML-supported). 32,000 character limit.
Manufacturer Name of the company that manufactures the product
Brand Kind or make of the item.
Condition

New, Used, Refurbished, Reconditioned, Like New.

Warranty Guarantee that the product meets certain criteria
Flag Flag type to apply to the sku: NoFlag, ExclamationPoint, QuestionMark, NotAvailable, Price, BlueFlag, GreenFlag, RedFlag, YellowFlag, ItemCopied
Flag Description Example: This item is backordered. 80 character limit.
Seller Cost The price that the seller paid for this item
Product Margin Profit margin for a product
Buy It Now Price Buy It Now price for each auction of this item
Retail Price Retail price for this item
Second Chance Offer Price Price above which you wish to offer underbidders of this item a second chance offer.
Picture URLs

Comma-separated list of picture URLs for this item.

  • This can be names of images uploaded via FTP or the UI, or full URLs hosted on your own website.
  • Because ChannelAdvisor uses commas to separate multiple images assigned to the same SKU URLs should not contain commas.
  • Any URLs with commas in the string will not upload properly.
  • Replace any commas with the following code "%2C" in order to correct this issue.
Tax Product Code

Tax product code for this item.

Supplier Code

Code for the supplier of this item

  • Must be created in ChannelAdvisor prior to use
Supplier PO Supplier purchase order number
Warehouse Location

Location of this item in the warehouse.

  • 80 character limit
Received in Inventory

Date a seller received a product into inventory.

  • The date/time can be in the format of:
  1. YYYY/MM/DD
  2. YYYY-MM-DD
  3. MM/DD/YYYY (or DD/MM/YYYY based on locale's preferred date format)
  4. MM-DD-YYYY (or DD-MM-YYYY based on locale's preferred date format)
  5. MM-DD-YY (or DD-MM-YY based on locale's preferred date format)
  6. MM/DD/YY (or DD/MM/YY based on locale's preferred date format)

 

Inventory Subtitle

Inventory item subtitle.

  • 100 character limit.
Relationship Name

Variation relationship that this item belongs to.

  • 50 character limit.
Variation Parent SKU

If a variation parent, us "PARENT". If a variation child, use the Item Number of the desired variation parent.

  • 50 character limit.
Description Template Name

Name of the description template (former name was "ad template") that should be used for this ad

  • Must be created in ChannelAdvisor prior to us.
  • * Required if you specify a Posting Template.
Posting Template Name

Name of the posting template that should be used for this ad

  • Must be created in ChannelAdvisor prior to use
  • * Required if you specify an Ad Template.
Schedule Name Name of the schedule that should be used for this ad must be created in ChannelAdvisor prior to use
eBay Category List

List of eBay categories that should be used for this ad.

  • eBay Category ID numbers are supported.
  • Maximum of two categories, separated by a comma
  • You cannot submit anything but an integer for this value.
eBay Store Category Name

Name of the eBay store category that should be used for this ad. eBay Category ID numbers are supported. 

  • Must be imported in ChannelAdvisor prior to use. See Marketplace > eBay > eBay settings > eBay Store Settings
  • * R equired if you specify a posting Template
  • If you want to use two eBay store categories, format them like this: category1::category2
Labels

List of Labels to add to this item.

  • 50 character limit
  • A minus sign in front of a label name will remove it from the item.
  • The list must be separated by a comma.
DC Code

Distribution Center Code

  • The DC Code must exist in ChannelAdvisor prior to use
  • To create an items as "Fulfillment by Amazon (FBA)", submit the value "Amazon FBA" in this field
  • NOTE: Beginning with the release on February 12th, 2013 , the valid FBA designation is no longer "Amazon FBA" and will become one of following:
  • For more information on uploading inventory for specific FBA scenarios, please see Designating SKUs for FBA SSC page.
Do Not Consolidate Specify if this item cannot be consolidated with other items. Accepted values are True, False, 1, 0, Yes, No
ChannelAdvisor Store Title

ChannelAdvisor Store Title

  • 120 character limit
ChannelAdvisor Store Description

ChannelAdvisor Store Description

  • 32,000 character limit
Store Meta Description

ChannelAdvisor Store Meta Description

  • 200 character limit
ChannelAdvisor Store Price The price of your item as it should appear in the ChannelAdvisor Store
ChannelAdvisor Store Category ID ChannelAdvisor Store Category ID
Classification

The inventory classification you would like to assign to this item

  • 35 character limit
  • You do not need to have the classification set prior to uploading inventory items.
Attribute (x) Name

Name of the attribute for this item.

  • This column can be repeated for up to 50 attributes and is paired with the Attribut (x) Value field.
  • Column headers are repeatable using an incremented number, for example Attribute1Name, Attribute1Value, Attribute2Name, Attribute2Value, etc.
  • 32 character limit
  • See the upload template file for an example.
Attibute (x)Value

Value of the classification specific attribute for this item.

  • This column can be repeated for up to 50 attributes and is paired with the Attribute(x)Name field.
  • Column headers are repeatable using an incremented number, for example " Attribute1Name, Attribute1Value, Attribute2Name, Attribute2Value, etc.
  • 32,000 character limit
  • See the upload template file for an example.

 

Harmonized Code International standard code for custom tariffs
Height

Height of a product when prepared for shipping

  • Decimal positive only.
Length

Length of a product when prepared for shipping

  • Decimal positive only.
Width

With of a product when prepared for shipping

  • Decimal positive only.
Ship Zone Name

Shipping zone applicable for upcoming rate

  • Must be created in ChannelAdvisor prior to use
  • 50 characters limit
Ship Carrier Code

Shipping carrier code.

  • The list of valid carriers in your account are listed in Sales > Shipping > Account Shipping Carriers
  • Carrier codes must be created in ChannelAdvisor prior to use
  • * Required if you specify a Ship Zone Name
  • 50 characters limit
Ship Class Code

Shipping class code.

  • The list of valid carriers in your account are listed in Sales > Shipping > Account Shipping Carriers
  • Class codes must be created in ChannelAdvisor prior to use
  • * Required if you specify a Shipping Carrier
  • 50 characters limit
Ship Rate First Item

Shipping amount for first item in a group

  • Decimal positive only.
Ship Handling First Item

Shipping handling amount for first item in a group

  • Decimal positive only.
Ship Rate Additional Item

Shipping amount for each additional item in a group

  • Decimal positive only.
Ship Handling Additional Item

Shipping amount for each additional item in a group

  • Decimal positive only.
(repeat) Repeat last 7 ship fields as needed for additional zone carrier class rates.

 

0
Your rating: None Average: 3 (2 votes)
0
Your rating: None Average: 3 (2 votes)
Tags