How To

Table of Deletable Fields

If you need to delete large amounts of data, or data from the fields of several inventory items at one time, you can use the upload process to remove inventory information in bulk.  By using the ChannelAdvisor Upload Spreadsheet  you can submit the command "_Delete_" (include the _underscores_) as a field value and the information currently stored in the inventory item field will be removed. 

Prerequisites


You should be familiar with the following topics before continuing:

Fields that Can and Cannot be Deleted Using "_Delete_" 


 

The table below lists all the fields that can and cannot be deleted using _DELETE_.

Fields that CAN use _Delete_   Fields that CANNOT use _Delete_
Notes
Item Title SKU (Item Number)SKU is the unique identifier for all inventory in ChannelAdvisor. All items MUST have a SKU.
Starting Bid Relationship NameTo delete a relationship between items, like Parent/Child, use the delete command in the Variation Parent SKU field.
Reserve Price Ad Template NameAds should be managed using the Ad Upload Spreadsheet
Weight Posting Template NameAds should be managed using the Ad Upload Spreadsheet
ISBN Schedule NameAds should be managed using the Ad Upload Spreadsheet
UPC eBay Category ListAds should be managed using the Ad Upload Spreadsheet
EAN eBay Store CategoriesAds should be managed using the Ad Upload Spreadsheet
ASIN Attribute[X]NameAn Attribute cannot be deleted from the upload.  To delete an entire attribute and its value, use the Attributes view in ChannelAdvisor.
MPN Do Not ConsolidateChanges to Shipping information must be made directly in ChannelAdvisor.
Short Description Ship Zone NameChanges to Shipping information must be made directly in ChannelAdvisor.
Description Ship Class NameChanges to Shipping information must be made directly in ChannelAdvisor.
Manufacturer Ship Carrier NameChanges to Shipping information must be made directly in ChannelAdvisor.
Brand Ship Rate First ItemChanges to Shipping information must be made directly in ChannelAdvisor.
Condition Ship Handling First ItemChanges to Shipping information must be made directly in ChannelAdvisor.
Warranty Ship Rate Additional ItemChanges to Shipping information must be made directly in ChannelAdvisor.
Labels: Labels can also be removed by using a negative (-) in front of the label name value. For example, submitting "-Shoes" will remove the Shoes label from the item. Ship Handling Additional ItemChanges to Shipping information must be made directly in ChannelAdvisor.
DC Code: The delete command will revert the Distribution Center to the account default location.   
Seller Cost   
Product Margin   
Buy It Now Price   
Retail Price   
Second Chance Offer Price   
Picture URLs   
Tax Product Code   
Supplier Code   
Supplier PO   
Warehouse Location   
Received in Inventory   
Inventory Subtitle   
Variation Parent SKU   
ChannelAdvisor Store Title   
ChannelAdvisor Store Description   
Store Meta Description   
ChannelAdvisor Store Price   
ChannelAdvisor Store Category ID   
Classification   
DC Code   
Attribute[X]Value   
Harmonize Code   
Height   
Length   
Width   

If you need to delete large amounts of data, or data from the fields of several inventory items at one time, you can use the upload process to remove inventory information in bulk.  By using the ChannelAdvisor Upload Spreadsheet  you can submit the command "_Delete_" (include the _underscores_) as a field value and the information currently stored in the inventory item field will be removed. 

Prerequisites


You should be familiar with the following topics before continuing:

Fields that Can and Cannot be Deleted Using "_Delete_" 


 

The table below lists all the fields that can and cannot be deleted using _DELETE_.

Fields that CAN use _Delete_   Fields that CANNOT use _Delete_
Notes
Item Title SKU (Item Number)SKU is the unique identifier for all inventory in ChannelAdvisor. All items MUST have a SKU.
Starting Bid Relationship NameTo delete a relationship between items, like Parent/Child, use the delete command in the Variation Parent SKU field.
Reserve Price Ad Template NameAds should be managed using the Ad Upload Spreadsheet
Weight Posting Template NameAds should be managed using the Ad Upload Spreadsheet
ISBN Schedule NameAds should be managed using the Ad Upload Spreadsheet
UPC eBay Category ListAds should be managed using the Ad Upload Spreadsheet
EAN eBay Store CategoriesAds should be managed using the Ad Upload Spreadsheet
ASIN Attribute[X]NameAn Attribute cannot be deleted from the upload.  To delete an entire attribute and its value, use the Attributes view in ChannelAdvisor.
MPN Do Not ConsolidateChanges to Shipping information must be made directly in ChannelAdvisor.
Short Description Ship Zone NameChanges to Shipping information must be made directly in ChannelAdvisor.
Description Ship Class NameChanges to Shipping information must be made directly in ChannelAdvisor.
Manufacturer Ship Carrier NameChanges to Shipping information must be made directly in ChannelAdvisor.
Brand Ship Rate First ItemChanges to Shipping information must be made directly in ChannelAdvisor.
Condition Ship Handling First ItemChanges to Shipping information must be made directly in ChannelAdvisor.
Warranty Ship Rate Additional ItemChanges to Shipping information must be made directly in ChannelAdvisor.
Labels: Labels can also be removed by using a negative (-) in front of the label name value. For example, submitting "-Shoes" will remove the Shoes label from the item. Ship Handling Additional ItemChanges to Shipping information must be made directly in ChannelAdvisor.
DC Code: The delete command will revert the Distribution Center to the account default location.   
Seller Cost   
Product Margin   
Buy It Now Price   
Retail Price   
Second Chance Offer Price   
Picture URLs   
Tax Product Code   
Supplier Code   
Supplier PO   
Warehouse Location   
Received in Inventory   
Inventory Subtitle   
Variation Parent SKU   
ChannelAdvisor Store Title   
ChannelAdvisor Store Description   
Store Meta Description   
ChannelAdvisor Store Price   
ChannelAdvisor Store Category ID   
Classification   
DC Code   
Attribute[X]Value   
Harmonize Code   
Height   
Length   
Width   
0
Your rating: None
0
Your rating: None
Tags