Bulk Update and Custom Export Column Headers

Amazon Columns:

 AmazonCategoryID  The numeric code associated with Amazon categories. 
 AmazonConditionNotes   Description of product condition to be sent to Amazon
 AmazonEnabled   Value of TRUE will send inventory. Value of FALSE will send a zero quantity.
 AmazonEnabledOn   The date that the SKU was set as "Amazon Enabled"
 AmazonEnableShippingOverride   Enables a selected template to override shipping map created in SellerCentral for a specific product.
 EnableAmazonPriceUpdate   Flags a specific product to be included in price feeds to Amazon. Note that the price feed isn't typically automated.
 AmazonFBASKU   Amazon FBA SKU (FNSKU) 
 AmazonFixedInventoryQty  When product is replenishable, this inventory value to be sent to Amazon.
 AmazonLabelFormat   Format type of label when shipping FBA (Unit Label, Case A, Case B, Case C, Case D, None)
 AmazonLabelRequired   Enabling this will require a label format selection when shipping FBA
 AmazonPrice   The selling price at which SKU will be listed on Amazon.
 AmazonMerchantSKU  The SKU with which Amazon relates a product to a seller. By default, SellerCloud will post the ProductID as the MerchantSKU when posting new products to Amazon.
 AmazonLabelUnits  Amount of units of FBA labels to print.
 AmazonPriceUseDefault   When enabled, this will use the product "Site Price" as the amazon price. When disabled this will allow user to enter a value to be used instead of the site price. user to enter a value to be used instead of the site price. 
 AmazonProductCondition   Amazon product condition
 AmazonPricingRuleID  Numerical ID of pricing rule to be included in feed to Channel Max.feed to Channel Max.
 AmazonProductType   Category of product as categorized by Amazon
 AmazonReleaseDate   The date from when the item will be available for sale on Amazon. The listing will display as a pre-order option.
 AmazonReleaseDateEnabled   When enabled, will allow the Amazon Release Date option. 
 AmazonRestricted  Flags item as Restricted on Amazon.
 AmazonSafetyQty   Value to be subtracted from available inventory quantity when sending available inventory to Amazon. This is used to prevent overselling. 
 AmazonSafetyQtyUseDefault   Value to be subtracted from available inventory quantity when sending available inventory to Amazon. This is used to prevent overselling. 
 AmazonShippingTemplate   Shipping template name as entered on the Amazon shipping price template page. (Company Settings)
 AmazonSpecialPrice  A sale price for Amazon  that runs through a specified date range.
 AmazonSpecialPriceEndDate  End date of the Amazon Special Price.
 AmazonSpecialPriceStartDate  Start Date of Special Price.
 AmazonTaxCode   A_GEN_TAX or A_GEN_NOTAX
 AmazonTitle   Title of Product for Amazon listing 
 AmazonUseFixedInventoryQty   Enabling this will set the inventory level as defined in Fixed Inventory Quantity
 ASIN   Amazon Standard Identification Number is a 10-character alphanumeric unique identifier assigned by Amazon.com for product identification.
 ExportedForAmazonOn  Date of product export for Amazon.
 FulfilledBy  Merchant or Amazon.
 FulfillmentLatencyForAmazon  Period of time from placement of order on Amazon until order is shipped to customer.
 FulfillmentLatencyForAmazonUseDefault   When enabled, will use default latency which is set at the company level.
 InventoryMaxQtyForAmazon  Maximum quantity to be allowed on Amazon
 InventoryMaxQtyForAmazonEnabled  Enables the Inventory Max Quantity. 
 ItemIncludesDescription  Separate description describing what's included in the item.
 GiftMessageAllowed  When enabled, will allow a gift message to be written on invoice.
 GiftWrapAllowed  When enabled, will allow Gift Wrapping option when placing the order on Amazon.
 NumberOfItems  The number of distinct items included in the product you are offering for sale as one product. For example, if you are selling a case of 5 packages of pens, and  each package contains 12 pens, the Number Of Items would be 60.
 PackageQty  The number of the same product contained within one package. For example, if you are selling a case of 5 packages of pens, the Package Quantity would be 5.
 ProductBullet
 ProductBullet2
 ProductBullet3
 Amazon Bullet Points. Up to 5.
 StopLossPrice  Minimum price allowed when using a repricer.
 UseStopLossPrice  Enables the Stop Loss Price.


Buy.com Columns:

 BDC_LeadTimeToShip   The time it takes from when order is received until shipped for Buy.Com orders.
 BDC_LeadTimeToShipUseDefault  Pulls lead time to ship from default settings on the Buy.com Settings page.
 BDC_MerchantSKU  ProductID sent to Buy.com. Defaults to regular ProductID.
 BDC_ProductCondition   Product Condition categories for Buy.com.
 BDC_ProductConditionNotes   Description of condition to be sent to Buy.com
 BDC_ShippingExpedited   Price for expedited shipping on Buy.com
 BDC_ShippingExpeditedIsFree   Enabling this will mark expedited shipping as free for specified SKU on Buy.com
 BDC_ShippingOneDay  Price for one-day shipping on Buy.com
 BDC_ShippingOneDayIsFree   Enabling this will mark one-day shipping as free for specified SKU on Buy.com
 BDC_ShippingStandard   Price for standard shipping on Buy.com
 BDC_ShippingStandardIsFree   Enabling this will mark standard shipping as free for specified SKU on Buy.com
 BDC_ShippingTwoDays   Price for two day shipping on Buy.com
 BDC_ShippingTwoDaysIsFree   Enabling this will mark two day shipping as free for specified SKU on Buy.com
 BDC_SKU   The product's Buy.com SKU
 BuyDotComCategoryID   The numeric code associated with Buy.com categories
 BuyDotComEnabled   When enabled, this will include specified SKU in Buy.com feeds
 BuyDotcomFixedInventoryQty   Inventory value to be sent to Buy.com regardless of products actual inventory. Note that this value will only be used as long as the actual inventory meets or exceeds it
 BuyDotcomFixedInventoryQtyEnabled   Enabling this will set the inventory level as defined in Fixed Inventory Quantity
 BuyDotcomFixedInventoryQtyUseDefault   When enabled will use default quantity for all products sent to Buy.com (set at company level)
 BuyDotComPrice   Price for specified SKU on Buy.com
 BuyDotComPriceUseDefault   When enabled, SellerCloud will send Site Price to Buy.com as product price
 BuyDotComSafetyQuantity   Value to be subtracted from available inventory quantity when sending available inventory to Buy.com. This is used to prevent overselling
 BuyDotComSafetyQuantityUseDefault   When enabled, this will use the company level default safety quantity as the safety quantity.


Catalog Column Headers 

 CompanyID  The numeric code associated with a company.
 CreatedBy  User name of who created product.
 CreationDate  Date of product creation.
 ListPrice  (MSRP) Sets  the Standard/List Price field on the Product Summary page. 
 LocationNotes  Text field indicating location of product
 LongDescription  Product's long description.
 Priority  Sets the Priority Level on a product for internal  purposes. 1-10
 ProductMasterSKU  The product ID of a SKU as it is identified in a Master Inventory system. 
 ProductName Name/title of the product. When updating product names in bulk, check if the client setting Ignore ProductName column in Bulk update for Existing Products is disabled.
 ProductTypeName  Name of the ProductType product to which product is assigned. (Internal Sellercloud category.) 
 ShadowOf  Shadow parent SKU (used when linking an identical existing product). For export use only. Read how to create shadows in bulk here
 KitParents  All kit parents of the exported product. For export use only. Read how to create kits in bulk here
 ShortDescription  Product description as displayed on a website landing page.
 SiteCost  Cost of product. 
 SitePrice  Price of product as sold locally (website, phone orders etc.) Channel prices can be set to default to site price.
 MAPPrice  Minimum Advertised Price
 EnforceMAPPrice   Sets the MAP as the sales price across all channels. While the change may not be visible on the interface, the price in the feed will be altered to the MAP.
 Status  Active or Disabled
 SpecialFeatures1 , SpecialFutures2..up to 9  You can list here up to 9 special features for your product


eBay Columns:

 BestOfferAutoAcceptLimit   Minimum offer price at which eBay item sale will be automatically approved
 BestOfferAutoRejecttLimit   Maximum offer price at which eBay item sale will be automatically rejected
 BuyItNowPrice   sets the price used for Fixed Price listings on eBay
 CurrentFixedPriceListingID  eBay listing ID for a Fixed-Price listing.
 DescriptionTemplateId   sets the HTML eBay DescriptionTemplate for a product, for the eBay Description
 DispatchTimeMax_InStock  For products that are NOT marked as replenishable. Set how long it will take you to ship an order once it's paid. Expected values are Day_1, Day_2, etc. (1, 2, 3, 4, 5, 10, 15, or 20)
 DispatchTimeMax_Replenishable  For products that are ARE marked as replenishable. Set how long it will take you to ship an order once it's paid.  Expected values are Day_1, Day_2, etc. (1, 2, 3, 4, 5, 10, 15, or 20)
 EBayBuyerReq_AllowOverride  Enable to override default buyer restrictions.  
 EBayBuyerReq_LinkedPayPalAccount  Restrict buyer who do not pay will PayPal. Must enable "EBayBuyerReq_AllowOverride"
 EBayBuyerReq_MaximumBuyerPolicyViolations_Count  Will restrict a buyer who has accumulated the set amount of eBay Policy violations. (4,5,6,7)
 EBayBuyerReq_MaximumBuyerPolicyViolations_Enabled  Entering TRUE will enable buyer restrictions based on eBay Policy Violations. 
 EBayBuyerReq_MaximumBuyerPolicyViolations_Period  The time period within which the buyer needs to have accumulated the given eBay Policy Violations in order to be restricted.(1,30,180,360,540 or Custom) 
 EBayBuyerReq_MaximumItemRequirements_Count  Blocks buyers who have purchased at set amount of items 1 - 10, 25, 50, 75, 100 in the past 10 days.Must enable "EBayBuyerReq_AllowOverride" and "EBayBuyerReq_MaximumItemRequirements_Enabled"
 EBayBuyerReq_MaximumItemRequirements_Enabled  Enables the requirement for maximum amount of items in a 10 day period.  
 EBayBuyerReq_MaximumItemRequirements_FeedbackScore  Feedback score required to allow purchase in conjunction with EBayBuyerReq_MaximumItemRequirements_Count. Must enable "EBayBuyerReq_AllowOverride",
eBayBuyerReq_MaximumItemRequirements_FeedbackScore_Enabled, EBayBuyerReq_MaximumItemRequirements_Count, and EBayBuyerReq_MaximumItemRequirements_Enabled.
 EBayBuyerReq_MaximumItemRequirements_FeedbackScore_Enabled  Enables the requirement for a feedback score.
 EBayBuyerReq_MaximumUnpaidItemStrikesInfo_Count  Restricts buyers with a specified count of Unpaid  Item cases. Must enable "EBayBuyerReq_AllowOverride" and "EBayBuyerReq_MaximumUnpaidItemStrikesInfo_Enabled".
 EBayBuyerReq_MaximumUnpaidItemStrikesInfo_Enabled  Enables the restriction of buyer with unpaid items cases.
 EBayBuyerReq_MaximumUnpaidItemStrikesInfo_Period  The period within which a buyer accumulated the Unpaid Item cases.
 EBayBuyerReq_MinimumFeedbackScore  Restricts buyers with a feedback score equal to or lower than a specified value.  Must enable "EBayBuyerReq_AllowOverride" and "EBayBuyerReq_MinimumFeedbackScore_Enabled".
 EBayBuyerReq_MinimumFeedbackScore_Enabled  Enables restriction of buyer based on minimum feedback score.
 EBayBuyerReq_ShipToRegistrationCountry  Block buyers with a primary shipping address to which you do not ship.
 EBayBuyerReq_ZeroFeedbackScore  Restricts buyers with a zero feedback score.  Must enable "EBayBuyerReq_AllowOverride"
 ebayCategory1   accepts a numeric value related to the eBay category
 eBayCatalogEntryType  The product identifier with which to associate a product with a catalog listing. (i.e. UPC,EAN, ISBN,ProductID,Product Reference ID) 
 eBayCatalogEntryValue  The exact catalog product identifier, such as the UPC number. 
 eBayDisconnectFromInventory  Entering TRUE will prevent future feeds from updating the inventory. 
 eBayEnabled  Enter TRUE to enable the product for listing on eBay.
 eBayEnableGlobalShippingProgram  Read about Global Shipping Program here.
 eBayEnableStrikeThroughPrices  When set to TRUE, will allow you to display on eBay one price with a strike through it and a sale price below it
 eBayEndListingInDays  Schedule expiration of listing. Numerical value of days by which listing should end.
 eBayEndListingInDaysEnabled  Enable or disable scheduling expiration of listing.
 eBayHitCounterType  Enter display format for Hit Counter Basic,Retro,Hidden)   
 EBayItemCondition  Condition of Item. Must match eBay conditions 


  • 1000 - New
  • 1500 - New other (see details)
  • 2000 - Manufacturer refurbished
  • 2500 - Seller refurbished
  • 3000 - Used 
  • 7000 - For parts or not working
 EBayItemConditionDescription  Additional text description of item condition.
 eBayMerchantSKU  Product ID sent to eBay. By default will be the regular product ID. (Enable in Client Settings)
 eBayPhotoDisplayMode  
 eBayPhotoDisplayModeUseDefault  
 eBayPostingDurationMin  Listing Duration for Auctions 1,3, 5, or 7. Enable with UseeBayPostingDurationMin 
 eBayProductReferenceID  EPID - eBay's catalog reference ID for the product
 eBayRefundOption  Must match eBay options - Money Back, Exchange, Merchant Credit, Money Back and Exchange. Must enable "eBayReturnPolicyOverride"
 eBayEnableOutOfStockListing   Enable the product for Out of Stock Listings. After setting the product, revise on eBay.  Read more about that here.
 eBayReturnAccepted  Allows returns. Must enable "eBayReturnPolicyOverride".
 eBayReturnPolicyDetails  Text of return policy details. Must enable "eBayReturnPolicyOverride"
 eBayReturnPolicyOverride  Overrides return policy on the eBay Settings page.
 eBayReturnShippingCostPaidBy  Sets who pays return shipping cost - Buyer or Seller. Must enable "eBayReturnPolicyOverride"
 eBayReturnWithinDays  Days_3 , Days_7, Days_14, Days_30
 eBaySafetyQty  Quantity reserved from listing quantity sent to eBay. Helps prevent overselling.
 eBaySafetyQtyUseDefault  Pulls safety quantity form eBay Settings page.
 eBaySellerProfileID_Payment  eBay business payment policy. Numerical ID is found on the Manage Business policies page (eBay General Settings page)
 eBaySellerProfileID_Returns  eBay business return policy. Numerical ID is found on the Manage Business policies page (eBay General Settings page)
 eBaySellerProfileID_Shipping  eBay business shipping policy. Numerical ID is found on the Manage Business policies page (eBay General Settings page)
 eBaySellingCity  Displays on eBay city of item location. 
 eBaySellingState  Displays on eBay state of item location. 
 eBaySellingZipCode  Set item location zip code.
 eBaySiteCode  eBay site code - or country code as defined by eBay - associated with the product. 
 TopTitle  adds the title to the product's list of eBay titles, marks it as approved and also sets it as the TopTitle
 eBayUseShippingRateTable  Use Shipping Rate table as configured in your eBay Account Settings on eBay (Not in SC). When enabled, will ignore  eBay  Shipping Price Template. 
 EnableBestOffer  Enables a customer to counter-offer with a price. eBay notifies the seller via email with an Accept or Reject button.
 EnableSecondChancePosting  When enabled, a message will be sent to bidders with an offer to buy the item at their last bid amount. Its up to the buyer to  decide whether to accept the offer. This message will only be sent if there is available quantity of the product.
 FixedPriceQuantity  Quantity displayed on eBay when listing in a fixed priced format.
 FixedPriceQuantityUseDefault  Populate the product with the default Fixed Price Qty set on the eBay Attributes page under eBay Settings. Requires client  setting Enable eBay Default Fixed Price Qty.
 GalleryImageCreatedOn  Date of gallery image creation
 GalleryImageExpireDate  Date of gallery image expiration
 GalleryImageURL  Adds image from URL to product as the Gallery Image 
 GenerateFixedPriceItem  When enabled will allow a fixed price listing to be posted automatically, provided that there is available inventory and the  product is  ready. When the item comes back in stock, it will auto list.
 ImmediatePaymentRequired  
 ImmediatePaymentRequiredUseDefault  
 MAPPriceExposure  When to display MAP; Pre-Checkout - use value 0, or During Checkout - use value 1
 MAPPricingTreatment  MAP - Only show MAP. STP - Show List Price (MSRP, not your eBay price) with strike-through in addition to eBay Price. If the  eBay is lower than the MAP, the eBay price will not display.
 ReservePrice  The hidden price a bidder must meet to win the auction. If not met, bidder will receive a message "reserve not met"
 SecondChanceMinPrice  Minimum acceptable bid amount to which the second chance offer will be sent. 
 ShippingTemplateID   sets the eBay Shipping Price Template for the product with a group of different prices for different shipping services
 StartPrice  sets the value used for eBay listings of the auction format. This is needed even for fixed price listings to be considered  eBayReady
 StoreCategory1  accepts either a numeric or text value related to the eBay store category specific to your eBay store
 UPCSendToEbay  Use values TRUE or FALSE.  For use when controlling to send as the catalog identifier when posting to eBay.
 ISBNSendToEbay  Use values TRUE or FALSE.  For use when controlling to send as the catalog identifier when posting to eBay.
 EANSendToEbay  Use values TRUE or FALSE.  For use when controlling to send as the catalog identifier when posting to eBay.
 eBayProductReferenceIDSendToEbay  Use values TRUE or FALSE.  For use when controlling to send as the catalog identifier when posting to eBay.
 UseeBayPostingDurationMin  Enable to apply listing duration for auctions. Set duration with eBayPostingDurationMin
 UseMatrixParentProductImage  Applies Matrix parent image to all child components of matrix.

Deleting Products in Bulk:

 _Action_  and  _Action_Confirm_  both columns need to have the value DELETE


  • To prevent overwriting existing images that have the same product image URL on the file but are actually two different images (meaning, the image was replaced at the source, but you want to keep the old image on the product) enable the client setting Do not overwrite existing image in bulk upload.
  • Read about acceptable image urls here.
 GalleryImageURL   Adds image from URL to product as the GalleryImage
 DescriptionImageURL  Adds image from URL to product as the DescriptionImage
 DescriptionAndGalleryImageURL  Adds an image as the description image and gallery images.
 SupplimentalImageURL1   Adds image from URL to product as a SupplimentalImage. These can be uploaded as values 1 through 10. The order of the images will be assigned based on the number in the header
 OtherImage1  Adds image from URL to product as a OtherImage. These can be uploaded as values 1 through 10. There is no order to Other Images. The number is only to create a unique column header for each image. If you need to upload 15 other images, first upload 10 and then the remaining 5.

Magento Columns

 MagentoEnabled  Enables available inventory to upload. Otherwise, an inventory of zero will upload for that product
 ExportedForMagento  Marks product as exported for Magento site
 ExportedForMagentoOn  Date of product export for Magento site
 MagentoCategoryList  The numeric ID of the Magento Category. Can be found on the Magento Categories page. When adding multiple categories, separate with commas.
 MagentoFreeShippingEnabled  Enable free shipping for Magento.
 MagentoMaxQtyForCart  Maximum quantity allowed per shopping instance.
 MagentoMinQtyForCartUseGlobal  Use default Magento Minimum Quantity.
 MagentoQtyToMakeOutOfStock  When quantity falls below, the item will be considered Out of Stock.
 MagentoQtyToMakeOutOfStockUseGlobal  Use default setting for quantity out of stock
 MagentoSpecialPrice  Magento sale price.
 MagentoSpecialPriceFromDate  Beginning date for sale price.
 MagentoSpecialPriceToDate  Ending date for sale price. 
 MagentoTaxClass  Product Tax Class - Use Global, None, Taxable Goods, or Shipping (Select Shipping if you charge additional tax on shipping.)
 MagentoTitle  Title of product to display on Magento.
 MagentoViewURL  URL given when saving image from Magento.

Multi-warehouse mode set:

 WarehouseName   Text name of the warehouse

 ExportedForNewEggDotCom  Marks product as exported for NewEgg
 ExportedForNewEggOnDotCom  Date of product export for NewEgg
 NewEggDotComCategoryID  Numeric code associated with Category IDs. https://sellerportal.newegg.com/Guideline/Newegg_Subcat_List.xlsx
 NewEggDotComEnabled  When enabled quantity of this SKU will be included in the feeds to NewEgg. When disabled, a quantity of Zero will be included in the feed for this product.
 NewEggDotComFixedInventoryQty  Inventory value to be sent to NewEgg regardless of products actual inventory. Note that this value will only be used as long as the actual inventory meets or exceeds it.
 NewEggDotComFixedInventoryQtyEnabled  Enabling this will set the inventory level as defined in Fixed Inventory Quantity
 NewEggDotComFixedInventoryQtyUseDefault  When enabled will use default quantity for all products sent to NewEgg (set at company level)
 NewEggDotComItemNumber  The listing ID. Will allow you to join an existing listing as another seller.
 NewEggDotComMerchantSKU  ProductID sent to NewEgg.
 NewEggDotComPrice  Price for specified SKU on NewEgg
 NewEggDotComPriceUseDefault  When enabled, SellerCloud will send Site Price to NewEgg as product price.
 NewEggDotComSafetyQuantity  Value to be subtracted from available inventory quantity when sending available inventory to NewEgg. This is used to prevent overselling. 
 NewEggDotComSafetyQuantityUseDefault  When enabled, this will use the company level default safety quantity as the safety quantity.

Jet Column Headers

 JETCatalogType  The unique product identifier type for this product. Valid values are ASIN, UPC, GTIN
 JETCategoryID  The numerical ID for a Jet category. Read how to get the IDs here.
 JETDefaultQty  The quantity sent to Jet when product is marked as replenishable.
 JETDefaultQtyEnabled  TRUE to enable the default qty above.
 JETDefaultQtyUseDefault  TRUE to use the company level Default Qty value, set on the Jet Settings page.
 JETEnabled  TRUE or FALSE. When enabled quantity of this SKU will be included in the feeds to Jet. When disabled, a quantity of Zero will be included in the feed for this product.
 JETFulfillmentTime  Amount of time to ship the item from time the order is placed.
 JETFulfillmentTimeUseDefault  TRUE to use the company-level lead time to ship set on the Jet Setting page.
 JETInventoryAvailableNodeID  The fulfillment node in Jet set on the product. Use the Node name.
 JETMapPriceImplementation  The rules used for MAP on Jet. Expected values are:
  - None
  - No_restrictions_on_product_based_pricing
  - No_restrictions_on_product_based_pricing
  - Jet_member_savings_never_applied_to_product
 JETMerchantSKU  Defaults to ProductID but can be mapped to a different SKU on Jet.
 JETMultiPackQuantity  The number of items based on Standard Product Code (Unique ID) that makes up your merchant SKU. Read here for an in depth  explanation.
 JETPrice  Price on Jet. 
 JETPriceUseDefault  TRUE or FALSE to use Site Price
 JETProductTaxCode  Product tax code
 JetSafetyQty  Safety Quantity for Jet 
 JetSafetyQtyUseDefault  If set - uses the default Safety quantity from the company Jet properties
 JETTitle  The Product Name is used for this attribute. Limited to 500 characters.

Overstock Column Headers

 ExportedForOverStock  Marks product as exported for Overstock
 ExportedForOverStockOn  Date of product export for OverStock
 OverStockBrandID  OverStock's numeric value for a given brand
 OverStockCondition  New, Refurbished
 OverStockCost  
 OverStockEnabled  Enables updates for this product to the OverStock channel
 OverStockCostNew  
 OverStockCountryOfOrigin  Country of product origin. This column will populate on the product home page as well. 
 OverStockFixedInventoryQty  Inventory value to be sent to OverStock regardless of products actual inventory. Note that this value will only be used as long as the actual inventory meets  or exceeds it.
 OverStockFixedInventoryQtyEnabled  Enabling this will set the inventory level as defined in Fixed Inventory Quantity
 OverStockFixedInventoryQtyUseDefault  When enabled will use default quantity for all products sent to OverStock (set at company level)
 OverstockGeneratedProductID  OverStock's Parent ProductID for this product. All items have Product ID and Option SKU.
 OverstockHTMLDescription  HTML description of product 
 OverStockMerchantSKU  OverStock Merchant SKU
 OverStockMSRPSalesLocation  
 OverStockOptionDescription  
 OverStockOptionSKU  SKU through which the products inventory updates on Overstock.
 OverStockPrice  The price Overstock is paying you for the item. Overstock then resells item to customer at their own determined price. The price on the order will reflect the  OverStockPrice.
 OverStockSafetyQuantity  Value to be subtracted from available inventory quantity when sending available inventory to OverStock. This is used to prevent overselling.
 OverStockSafetyQuantityUseDefault  When enabled, this will use the company level default safety quantity as the safety quantity.
 OverStockShortName  
 OverStockSourceZipCode  
 OverStockSpecificationsMaterials  
 OverStockStreetPrice  
 OverStockSubCategoryId  
 OverStockSuggestedSellingPrice  A suggested price for OverStock to resell to customer.
 OverstockTitle  Product title on OverStock
 OverStockUseDefaultPrice  
 OverStockWarrantyContactPhoneNumber  Phone number of warranty provider.
 OverStockWarrantyDescription  Description of warranty.
 OverStockWarrantyProvider  N/A, Manufacturer, or Partner


 DropShipMode   A value of 1 means ShipFromSite and it is not going to be dropshipped, while 2 means ShipFromVendor
 InventoryLowStockNotice  Sets the low-level of a product. Inventory below set level will filter in Unfillable Products with option to add to a purchase order
 IsEndOfLife  Enable to Discontinue the Item (Checkbox on Product Purchasing page).
 LastCost  Sets or exports Last Cost (PO) of the item on the Purchasing page.
 Purchaser  Purchaser of this item. Enter purchasers user email address.
 OnOrder  Sets the On Order amount on Purchasing page. Enter quantity value of whats on order. A positive value will include this product when searching for  products on order on the Unfilliable Products page.
 ReOrderQty  Quantity to reorder. For internal info.
 QtyPerCase  Enter quantity per case value. 
 QtyPerPalet  Enter case quantity per pallet value. 
 VendorID The numeric code associated with the vendor. Note that there is an alternative option to update the Vendor of product using the VendorName and that you don't have to use the numeric id.
 VendorName   Sets vendor/supplier as the product's default vendor. The vendor must already be in the system before the import.
 VendorSKU   The SKU to be used on the vendor's purchase order, that can be unique to that vendor.
 VendorPrice  Each vendor can have a unique price per product. Use together with VendorID or Vendor Name. When the product is added to a purchase order for that vendor, the price will default to the VendorPrice. Similarly, when a new price is entered on a purchase order it will update the current VendorPrice.


Sears Column Headers

 ExportedForSearsOn  Date of product export for Sears.
 SearsCategory1  The full category name path. Read how to get the list of category names here.
 SearsFixedInventoryQty   Inventory value to be sent to Sears regardless of products actual inventory. Note that this value will only be used as long as the actual inventory meets or  exceeds it.
 SearsFixedInventoryQtyEnabled  When enabled, will allow Fixed inventory Quantity to be set for Sears. 
 SearsFixedInventoryQtyUseDefault  When enabled, will use default quantity for all products sent to Sears (set at company level)
 SearsMerchantSKU  ProductID sent to Sears. Defaults to regular ProductID.
 SearsPickupNowEligible  Enables for listing as Local Pick Up.
 SearsPrice   Price of product as sold on Sears. Does not include taxes, shipping costs, rebates, coupons, or bulk discounts. This value must be equal to or greater  than  the cost. You can enter up to 5 digits before the decimal point and two after. List prices in US dollars, without a $ sign, commas, text, or quotation  marks.  Minimum Standard Price is 0.02
 SearsSafetyQuantity  Value to be subtracted from available inventory quantity when sending available inventory to Sears. This is used to prevent overselling. 
 SearsSafetyQuantityUseDefault  When enabled, this will use the company level default safety quantity as the safety quantity.
 SearsSaleEndDate  End date of Sale price
 SearsSaleStartDate  Start date of the sale price.
 SearsShippingExpeditedEnabled  Enables two-day shipping.
 SearsShippingExpeditedPrice  Price for two-day shipping.
 SearsShippingFreeEnabled  Enter TRUE to enable free shipping.
 SearsShippingFreeEndDate  The date when an item will have free shipping. If provided, this value must be in the format "MM/DD/YYYY" and be at least 2 days after the current date.  The Start Date must occur before the End Date.
 SearsShippingFreePromotionalText  This is the text that customers will see describing the details of this free shipping promotion. will see describing the details of this free shipping promotion.  50 characters max, numbers, letters, $, !, % only.. Symbols cant be doubled up (ex. Sale!!)
 SearsShippingFreeStartDate  The date when an item's free shipping ends. If provided, this value must be in the format "MM/DD/YYYY" and be at least 2 days after the current date.  The End Date must occur after the Start Date.
 SearsShippingGroundPrice  Price for Ground Shipment. 
 SearsShippingPremiumEnabled  Enables next day shipping.
 SearsShippingPremiumPrice  Price for next day shipping.
 SearsStoreLocation  Pulls location from Sears Settings page.
 SearsTitle  Title of Product for Sears
 SearsUseDefaultPrice  Pulls price from Site Price.

TopHatter Column Headers

TopHatterBrandNameProduct's brand
TopHatterBuyItNowPriceAuction BuyItNow price
TopHatterBuyItNowPriceUseDefaultWhen checked will use the default BuyItNow value.
TopHatterConditionCondition of the product (new, used...etc)
TopHatterCategoryTopHatter product's category
TopHatterDaysToDeliverUseDefaultWhen checked will use the default value for promised date of delivery
TopHatterDaysToDeliverPromised date of delivery
TopHatterDescriptionProducts description
TopHatterDescriptionUseDefaultWhen checked will use the default description
TopHatterEnabledEnabled the product for TopHatter. When disabled SellerCloud will not send updates to the channel.
TopHatterLeadTimeLead time for TopHatter channel
TopHatterLeadTimeUseDefaultWhen checked will use the default lead time.
TopHatterMaterialSets the material of the product.
TopHatterMerchantSKUMerchant SKU
TophatterSafetyQuantitySafety Quantity for the product.
TophatterSafetyQuantityUseDefaultWhen checked will use the default Safety Quantity set on the channel properties.
TopHatterShippingOriginSets the Shipping Origin of the product
TopHatterShippingOriginUseDefaultWhen checked will use the default value for the Shipping Origin.
TopHatterShippingPricePrice for shipping the product.
TopHatterShippingPriceUseDefaultWhen checked will use the default value for the Shipping Price.
TopHatterStartingBidWhen the item is on auction, this will set the starting bid.
TopHatterStartingBidUseDefaultWhen checked will use the default value for the Starting Bid.
TopHatterTitleProduct title for the TopHatter channel.

Walmart Marketplace Column Headers

These columns are for Walmart Marketplace, not Walmart DSV.
 WalmartAPIEnabled  Products that are not Walmart enabled will be considered, for the Walmart Inventory Feed, to have a qty  zero.
 WalmartAPIMerchantSKU  Defaults to ProductID. However, in case of SKU mismatch in can be edited to match the SKU code on  Walmart Marketplace. The Merchant  SKU is sent to Walmart.
 WalmartAPIProductTitle  Defaults to Product Name
 WalmartAPIParentCategory  Main category  - Alphanumeric
 WalmartAPIChildCategory  Sub Category - Alphanumeric
 WalmartAPIDefaultQty  Qty to be used when product is marked as Replenishable.
 WalmartAPIDefaultQtyEnabled  Enables the Default qty feature
 WalmartAPIDefaultQtyUseDefault  Uses default qty from Walmart Marketplace Settings page.
 WalmartAPIDescription  Long Description
 WalmartAPIFulfillmentLatencyDays  Lead time to ship - The amount of time it takes to ship the order from when the order is placed.
 WalmartAPIFulfillmentLatencyDaysUseDefault  Use default set up from Walmart Marketplace Settings page.
 WalmartAPIUnitsPerConsumerUnit   Indicateed multipack qty, e.g pack of 6. Expected value is numerical - 6
 WalmartAPIPrice  Selling price on Walmart.
 WalmartAPIPriceUseDefault  Default to use the site price
 WalmartAPIPriceDiscountDisplayType  Defaults to "Base" (regular price) type. To list a discount with a comparison price, enter Clearance or Reduced. Read more here.
 WalmartAPIPriceDiscountType  SubMAP Cart or SubMAP Checkout. Read more here.
 WalmartAPISafetyQty  Helps reduce the risk of overselling by subtracting the set number of units from the available quantity.
 WalmartAPISafetyQtyUseDefault  Uses default safety qty from Walmart Marketplace Settings page.
 WalmartAPITaxCode  The Product Tax Code. Walmart Marketplace tax codes are numerical values. Learn more about how to apply tax codes and download  updated tax codes here.  
 WalmartAPITaxCodeUseDefault  Uses default tax code from Walmart Marketplace Settings page.
 WalmartAPIShippingTemplateID  The shipping template used to override the shipping settings set up globally in Walmart Seller Center. The template numeric ID is the expected value.


 IsSubComponentScanRequired  Requires scan of individual components of kits when using Ship and Scan.
 MaxQtyPerShippingPackage  Enter a maximum quantity of allowed for this sku to be shipped in one package. (e.g. entering 1 will cause 2 labels  to be printed for an order of 2) 
 MaxQtyPerShippingPackageEnabled  Enter TRUE to enable, FALSE to disable, the MaxQtyPerShippingPackage option.
 MaxQtyShipFromSite  Quantity above the set limit will Drop Ship from vendor.  
 RequireDeliveryConfirmation  Enter TRUE or FALSE to set delivery confirmation requirement.
 RequireDeliverySignature  Enter TRUE or FALSE to set delivery signature requirement.
 RequireSerialNumberScanWhileShipping  Enter TRUE or FALSE to set requirement status of imputing serial number when shipping with Scan and Ship.
 ShippingCarrier  Default carrier for this product.
 ShippingCost  Default shipping cost for this item.
 ShippingHeight  Shipping height of item. Updates the "Ship Height" field on the Product Summary page. 
 ShippingLength  Shipping length of item. Updates the "Ship Length" field on the Product Summary page.
 ShippingMethod  Default shipping method. Must match spelling of method as is spelled in ShipBridge in order to populate column in  ShipBridge
 ShippingWidth  Shipping width of item. Updates the "Ship Width" field on the Product Summary page. 

 WebEnabled  Allows available inventory to upload to Website. Otherwise, an inventory of zero will upload for that product.
 Categories  The numerical value of the website category. To add multiple categories per product, separate  category IDs with a comma. Ex. - 11,21,71
 WebsiteCategories  The category name. Update with full category path.
To add multiple categories per product, separate category names with tilde symbol. Ex. - Category name 1~category name 2~category name 3
 MetaKeywords  Meta keywords are submitted to many of the shopping carts integrated with Sellercloud. Note that there is a maximum character count of 1000 for this column.
 WebsitePrice  Sets a price for website integrated markets.
 WebsitePriceUseDefault  When enabled it will use the SitePrice of the product as default value for Website Price. Any prices lower than the Map price will be adjusted to the Map Price.


 WeightLbs  Definition: LB. weight of the product - EXCLUDES shipping materials. Updates the "Product Weight LB." field on the Product Properties page. 
 WeightOz
 Definition: Oz. weight of the product - EXCLUDES shipping materials. Updates the "Product Weight Oz." field on the Product Properties page.
 PackageWeightLbs
 Definition: LB. weight of the package - INCLUDES shipping materials. Updates the "Ship Weight Lb." field on the Product Properties page

 PackageWeightOz  Definition: Oz. weight of the package - INCLUDES shipping materials. Updates the "Ship Weight Oz." field on the Product Properties page

How did we do?