The table below shows columns that you can use in a default or custom template to add or modify SKUs. Columns that can be imported can also be exported in a default or custom template. You can use imports to add a new inventory item that matches an existing Amazon ASIN or to modify an existing SKU. For more information about using custom import templates, see To add an inventory import template. For more information about importing new inventory or modifying existing inventory, see Importing Inventory Overview.
When you import to add inventory, your file should include required columns and any columns that are unique to the inventory items such as Classifications and CostOfGoods. When you import to modify inventory, your file should include required columns and only those columns that you want to modify.
For detailed information about which columns are required or recommended for adding or modifying inventory, see the following sections in Importing Inventory Overview:
| Column header | Label in the Monsoon Marketplace desktop | Definition |
Import value |
Example entry | Which categories use this data field? | Can you add data to this field using the add operator? | Can you change data or use the data to identify an item during a modify import?? |
|---|---|---|---|---|---|---|---|
| MonsoonOP | — | An import operator tells Monsoon how to process the line item: add a new SKU, decrease a SKU's quantity, modify an existing SKU, or update a SKU. For more information, see Import Operators. | a, d, m, u | m |
All categories |
— | — |
| ASIN | ASIN | The Amazon Standard Identification Number (ASIN) is a unique, 10-character, alphanumeric identifier assigned by Amazon.com for product identification. An ASIN is guaranteed to be unique within an Amazon marketplace. | An alphanumeric string with a maximum length of 10 characters. | B000GQ0MTW | All categories |
Yes |
No |
| Category | Product Category | The product category an item belongs to. | Apparel, AutoPartsAndAccessories, BabyProducts, Beauty, Books, Cameras, Computers, ConsumerElectronics, Dvds, FoodAndBeverages, HealthPersonalCare, Home, HomeImprovement, Jewelry, Lighting, Miscellaneous, Music, MusicalInstruments, OfficeProducts, OutdoorLiving, PetSupplies, PhotoAccessories, Shoes, Software, SportsFitness, ToysAndGames, VhsVideos, VideoGameAccessories, VideoGames, Watches, Wireless | OfficeProducts | All categories |
Yes |
No |
| Classification | Classification | A label that you can add to an inventory item. When you import a classification, the value replaces (overwrites) a SKU's existing classification. To add multiple classifications to an existing SKU, separate each classification with a colon without spaces between the classification value and colon. e.g. Shaun:Ed:Liz. For more information, see Classifications and Classification Notes. | An alphanumeric string with a maximum length of 256 characters. | ExtraShipping | All categories |
Yes |
Yes |
| Collectible | Collectible | Collectible information is sent to Amazon only. Amazon supports collectible as part of an item's condition description in the following categories: Books, DVDs, Music, Toys & Games, VHS Videos. For more information, see the Amazon website. | True, False | True | Books, DVDs, Music, Toys & Games, VHS Videos |
Yes |
Yes |
| Condition | Condition | Describes the condition of an item. | New, Like New, Very Good, Good, Acceptable, Refurbished | New | All categories |
Yes |
Yes |
| CostOfGoods | Cost of Goods | For retailers, typically the direct cost of an inventory item. For more information, see Cost of goods. | A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. | 12.95 | All categories |
Yes |
Yes |
| DefaultPrice | Default Price | When you receive an item and no competitive listing, market listing, or MSRP is found, your default price is applied. For more information, see Default price. | A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. | 24.95 | All categories |
Yes |
Yes |
| DustJacket | Dust Jacket | Specifies whether the book has a dust jacket. | True, False |
True |
Books |
Yes |
Yes |
| EAN | EAN | A European Article Number (EAN) is a unique 13-digit product identifier. | A numeric string with a maximum length of 13 characters. | 5050582726053.00 | All categories |
Yes |
Yes |
| eBayCategory | eBay Listing Details | The product category ID on the eBay US site. | Integer value of the category ID on eBay US. | The category Cases, Covers & Skins on eBay US is 20349. | All categories | Yes | Yes |
| eBayStoreCategory - eBayStoreCategory2 | eBay Store Category | When you create a store on eBay, you can create store categories and subcategories which can then be imported into Monsoon using the category ID number assigned by eBay (not the category name). For more information, see eBay Store and eBay Shop categories. | A valid eBay US store category ID number. | 16 | All categories |
Yes |
Yes |
| eBayUKCategory | eBayUK Listing Details | The product category ID on the eBay UK site. | Integer value of the category ID on eBay UK. | The category Games on eBay UK is 139973. | All categories |
Yes |
Yes |
| eBayUKStoreCategory - eBayUKStoreCategory2 | eBay UK Shop Category | When you create a store on eBay, you can create store categories and subcategories which can then be imported into Monsoon using the category ID number assigned by eBay (not the category name). For more information, see eBay Store and eBay Shop categories. | A valid eBay UK shop category ID number. | 16 | All categories |
Yes |
Yes |
| FbaListingHold | FBA Listing Hold | When an FBA shipment is created directly on Amazon, a listing hold is automatically applied to new or 0 quantity Monsoon SKUs. After the listing hold is applied, an item will not list on Amazon until the column value is changed to False. For more information, see Managing Inventory for FBA. | True, False |
True |
All categories |
Yes |
Yes |
| FirstEdition | First Edition | Flags a book as a first edition. First edition information is sent to Alibris and AbeBooks only. | True, False | True | Books |
Yes |
Yes |
| FulfillmentLatency | Lead Time To Ship (In Days) | Indicates the time, in days, between when you receive an order for an item and when you can ship the item. For more information, see Amazon Shipping Rules. | An integer with a minimum value of 1 and a maximum value of 30. | 3 | Non-media categories |
Yes |
Yes |
| ImageUrl1 | Image 1 | The URL for the main product image. For more information see Product Image Requirements by Market. | A valid URL with a maximum length of 255 characters. | http://www.companyname.com/images/1250.main.jpg | All categories |
Yes |
Yes |
| ImageUrl2 - ImageUrl9 | Image 2 — Image 9 | The URL for additional product images. For more information see Product Image Requirements by Market. | A valid URL with a maximum length of 255 characters. | http://www.companyname.com/images/1250.image2.jpg | All categories |
Yes |
Yes |
| InternalNotes | Internal Notes | The Internal Notes field allows you to add notes to a sku that are only visible to Monsoon users and are not visible to buyers. For example, this could be a note about special packaging required when shipping this sku. | An alphanumeric string with a maximum length of 1000 characters. | These lithium batteries require blister pack, cushioning, and a divider in order to prevent a short-circuit and activation. | All categories |
Yes |
Yes |
| ISBN | ISBN | The International Standard Book Number (ISBN) is a unique 10- or 13-digit numerical identifier for commercial books published since 1970. | An alphanumeric string with a maximum length of 13 characters. | 1442489677 | Books |
Yes |
Yes |
| IsParentSKU | — | Specifies whether an item is a parent SKU, to be used for a variation listing. | True, False | True | All categories that eBay supports for variation listings. For more information, see the eBay website. | Yes | No |
| ItemSpecific[the name of the item specific]On[market name] | eBay item specifics are viewable under eBay Listing Details | Item specifics let you provide details about the item you're selling, such as brand, size type, size, color, and style. When you import an item specific column header, you must also import an eBay category column header. The name of the item specific that you insert into the column header is space and case independent in terms of matching the name of an imported ItemSpecific to a name pre-defined by eBay. For example, Sleeve Length, Sleeve length, and sleevelength are all acceptable values. For more information see eBay category and item specifics overview. |
Market name: eBay, eBayUK Item specific: an alphanumeric string with a maximum length of 255 characters. eBay has thousands of required and optional item specifics. Best practice is to confirm required and optional eBay item specifics for a category, either on the Inventory Receiving or My Inventory tab, by clicking the eBay Listing Details ellipsis button (...). |
Column header example: ItemSpecificShadeOneBay SKU value example: Mint Green |
Non-media categories |
Yes |
Yes |
| JacketCondition | Jacket Condition | Describes the condition of a book's dust jacket. Jacket condition information is sent to Alibris and AbeBooks only. | New, Like New, Very Good, Good, Acceptable, Refurbished | Very Good | Books |
Yes |
Yes |
| Keywords | Keywords | Uploads to Alibris. Uploads to Amazon Seller Central in the product feed when you create a new product in Monsoon. A word or phrase that best describes the product. The keywords, or search terms, help Amazon.com locate the product when a customer performs a search. | An alphanumeric string with a maximum length of 255 characters. | Zombie | All categories |
Yes |
Yes |
| LocatorCode | Location |
For tracking and ease of order picking, you can assign inventory to locations identified by unique numeric or alphanumeric locator codes. You can add a locator code at the same time you add a new SKU, add a locator code to an existing SKU, add quantity to a SKU at an existing location, modify the details of a SKU at an existing location, or decrease the quantity of a SKU at an existing location. For more information, see Importing Inventory Overview. |
For numeric locator codes, the value must be an integer. For alphanumeric locator codes, the value is a string with a maximum length of 63 characters. |
Numeric example: 123 Alphanumeric example: ABC123 |
All categories |
Yes |
No |
| MAP | Minimum Advertised Price (MAP) | Minimum Advertised Price is an agreement between suppliers and retailers stipulating the lowest price an item is allowed to be advertised at. For more information, see Minimum Advertised Price (MAP). | A number with a maximum of 4 digits to the left of the decimal point and 2 digits to the right. | 69.95 | Non-media categories |
Yes |
Yes |
| Notes | Item Notes | Item, classification, category and condition, and default market notes are consolidated into one note with a maximum size of 1000 characters when uploaded to all markets that accept notes. For more information, see Amazon Market Notes. | An alphanumeric string with a maximum length of 1,000 characters. | 12" talking action figure that can stop a zombie uprising. Comes with his cricket bat and base as well as an interchangeable left hand with flower bouquet. | All categories |
Yes |
Yes |
| NumericUserData1 — NumericUserData25 | Numeric User Data 1 — Numeric User Data 25 | There are 25 numeric data fields that you can use to store numeric information such as numeric data mapped from a data exchange's external source. You can customize the name of a data field then display the field in your Monsoon desktop. The number must be between -9,999,999.99 and 9,999,999.99. | A number with a maximum of 7 digits to the left of a decimal point and 2 digits to the right. | 8.95 | All categories |
Yes |
Yes |
| ParentSKU | — |
A stock keeping unit (SKU) used to identify the top-level entity in a variation listing for eBay. A custom SKU with a "mon" prefix will not import into Monsoon Marketplace. |
An alphanumeric string with a maximum length of 63 characters. | monPAR0000005 | All categories that eBay supports for variation listings. For more information, see the eBay website. | Depends: You can use the a operator to add a parent SKU for a new item; you cannot use an a operator to change the parent SKU when adding quantity | Yes |
| Price | Price | Each inventory item displays a price for each market in the My Price > Pricing Information dialog box. Upon import, applies a fixed price to SKUs on all markets for both local and FBA fulfillment types. The price you import applies only to those items that are using a Fixed Price pricing strategy. For more information, see My Price. | A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. | 24.95 | All categories |
Yes |
Yes |
| PriceCeiling | Price Ceiling | An imported price ceiling is applied at the item level and overrides any relative or inventory group price ceiling. For more information, see Price ceilings. | A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. | 99.95 | All categories |
Yes |
Yes |
| PriceOfFbaUsOn[market name] | Price (in the Pricing Information dialog box) | Upon import, applies a fixed price to FBA SKUs on the selected market. The price you import applies only to those FBA SKUs that are using a Fixed Price pricing strategy. When no market is selected, the price is applied to all FBA SKUs on all markets that use the Fixed Price pricing strategy. |
Market name: Abebooks, Alibris, AmazonCA, AmazonDE, AmazonES, AmazonFR, AmazonIT, AmazonUK, AmazonUS, eBay, eBayUK, Half.com, Rakuten.com, Walmart. For a data exchange, use the exact name on the Settings tab under Data Exchange. Price: a number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. |
Column header example: PriceOfFbaUsOnAmazonUS SKU value example: 24.95 |
All categories |
Yes |
Yes |
| PriceOfLocalOn[market name] | Price (in the Pricing Information dialog box) | Upon import, applies a fixed price to locally fulfilled SKUs on the selected market. The price you import applies only to those locally fulfilled SKUs that are using a Fixed Price pricing strategy. When no market is selected, the price is applied to locally fulfilled SKUs on all markets that are using a Fixed Price pricing strategy. |
Market name: Abebooks, Alibris, AmazonCA, AmazonDE, AmazonES, AmazonFR, AmazonIT, AmazonUK, AmazonUS, eBay, eBayUK, Half.com, Rakuten.com, Walmart. For a data exchange, use the exact name on the Settings tab under Data Exchange. Price: a number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. |
Column header example: PriceOfLocalOnAmazonUS SKU value example: 24.95 |
All categories |
Yes |
Yes |
| PriceOn[market name] | Price (in the Pricing Information dialog box) | Upon import, applies a fixed price to SKUs on the selected market for both local and FBA fulfillment types. The price you import applies only to those items that are using a Fixed Price pricing strategy. When no market is selected, the price applies to all SKUs that are using a Fixed Price pricing strategy. |
Market name: Abebooks, Alibris, AmazonCA, AmazonDE, AmazonES, AmazonFR, AmazonIT, AmazonUK, AmazonUS, eBay, eBayUK, Half.com, Rakuten.com, Walmart. For a data exchange, use the exact name on the Settings tab under Data Exchange. Price: a number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. |
Column header example: PriceOnAmazonUS SKU value example: 24.95 |
All categories |
Yes |
Yes |
| PriceStrategy | Pricing Strategy (in the Pricing Information dialog box) | Upon import, applies a price strategy to SKUs on all markets for both local and FBA fulfillment types. | The exact name of a pricing strategy on the Settings tab under Custom Strategies. | MatchBuyBox | All categories |
Yes |
Yes |
| PriceStrategyOfFbaUsOn[market name] | Pricing Strategy (in the Pricing Information dialog box) | Upon import, sets a price strategy for FBA SKUs on the selected market. When no market is selected, the price strategy is applied to FBA SKUs on all markets. |
Market name: Abebooks, Alibris, AmazonCA, AmazonDE, AmazonES, AmazonFR, AmazonIT, AmazonUK, AmazonUS, eBay, eBayUK, Half.com, Rakuten.com, Walmart. For a data exchange, use the exact name on the Settings tab under Data Exchange. Price strategy: the exact name of a pricing strategy on the Settings tab under Custom Strategies. |
Column header example: PriceStrategyOfFbaUsOneBay SKU value example: MatchBuyBox |
All categories |
Yes |
Yes |
| PriceStrategyOfLocalOn[market name] | Pricing Strategy (in the Pricing Information dialog box) | Upon import, applies a price strategy to locally fulfilled SKUs on the selected market. When no market is selected, the price strategy is applied to locally fulfilled SKUs on all markets. |
Market name: Abebooks, Alibris, AmazonCA, AmazonDE, AmazonES, AmazonFR, AmazonIT, AmazonUK, AmazonUS, eBay, eBayUK, Half.com, Rakuten.com, Walmart. For a data exchange, use the exact name on the Settings tab under Data Exchange. Price strategy: the exact name of a pricing strategy on the Settings tab under Custom Strategies. |
Column header example: PriceStrategyOfLocalOneBay SKU value example: MatchBuyBox |
All categories |
Yes |
Yes |
| PriceStrategyOn[market name] | Pricing Strategy (in the Pricing Information dialog box) | Upon import, applies a price strategy to SKUs on the selected market for both local and FBA fulfillment types. When no market is selected, the price strategy is applied to all SKUs on all markets. |
Market name: Abebooks, Alibris, AmazonCA, AmazonDE, AmazonES, AmazonFR, AmazonIT, AmazonUK, AmazonUS, eBay, eBayUK, Half.com, Rakuten.com, Walmart. For a data exchange, use the exact name on the Settings tab under Data Exchange. Price strategy: the exact name of a pricing strategy on the Settings tab under Custom Strategies. |
Column header example: PriceStrategyOnAmazonUS SKU value: MatchBuyBox |
All categories |
Yes |
Yes |
| Profit | Profit | An imported profit is applied at the item level and overrides profit set at the inventory group level. Depending on the profit mode you've selected, the value you enter in the Profit column is either a percentage of your cost of goods or a monetary amount. For more information, see Profit. | A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. | 25 (applies as $25.00 if your profit mode is monetary, 25% if your profit mode is a percentage of cost of goods). | All categories |
Yes |
Yes |
| Quantity | Qty on the My Inventory tab; dynamically displays the total quantity of inventory for an inventory item. Qty on the Inventory Receiving tab: indicates the quantity to be received. | An imported quantity is applied to local inventory only. If you use locator codes, the quantity is applied to the line item's SKU / locator code combination only. | A number between 0 and 32,767. | 68 | All categories |
Yes |
Yes |
| RebateMessage | Rebate Message | Amazon supports mail-in rebates for certain categories. If you have a Seller Central account, you can create a rebate for items in those supported categories by clicking the Rebate link and completing the required information. For more information, see Amazon mail-in rebate. | An alphanumeric string with a maximum length of 250 characters. | Non-media categories |
Yes |
Yes | |
| RebateStartDate | Rebate Start Date | The start date of your rebate offer. Amazon supports mail-in rebates for certain categories. If you have a Seller Central account, you can create a rebate for items in those supported categories by clicking the Rebate link and completing the required information. For more information, see Amazon mail-in rebate. | A date that is combined with a time of day. The time is based on a 24-hour day, with seconds always zero (:00) and without fractional seconds. | 2013-12-10 12:00:00 | Non-media categories |
Yes |
Yes |
| RebateEndDate | Rebate End Date | The end date of your rebate offer. Amazon supports mail-in rebates for certain categories. If you have a Seller Central account, you can create a rebate for items in those supported categories by clicking the Rebate link and completing the required information. For more information, see Amazon mail-in rebate. | A date that is combined with a time of day. The time is based on a 24-hour day, with seconds always zero (:00) and without fractional seconds. | 2013-12-25 24:00:00 | Non-media categories |
Yes |
Yes |
| No | No | ||||||
| ShippingSurcharge | Shipping Surcharge | For non-media products, when you offer free shipping or carry heavy or oversized inventory, you can offset shipping costs by adding a shipping surcharge to your listings. For more information, see Shipping Surcharges by Marketplace. | A number with a maximum of 4 digits to the left of the decimal point and 2 digits to the right. | 3.95 | Non-media categories |
Yes |
Yes |
| Signed | Signed | Flags a book as signed. Signed information is sent to Alibris and AbeBooks only. | True, False | True | Books |
Yes |
Yes |
| SKU | SKU | A stock keeping unit (SKU) is a unique identifier assigned to each of your inventory items. A Monsoon generated SKU starts with the letters "mon" and ends with one of the following suffixes: _usf, _ukf, _loc, or _sqz. A custom SKU with a "mon" prefix will not import into Monsoon. | An alphanumeric string with a maximum length of 63 characters. | mon0123456789 | All categories |
Yes |
No |
| Title | Title | A short title for the product. | An alphanumeric string with a maximum length of 450 characters. | NECA Cult Classics 6 Inch Shaun of the Dead Action Figure 2Pack Shaun Ed | All categories |
No |
No |
| UPC | UPC | The Universal Product Code (UPC) is a unique 12-digit numerical identifier for commercial products that's usually associated with a barcode printed on retail merchandise. | An alphanumeric string with a maximum length of 13 characters. | 634482420188 | All categories |
Yes |
Yes |
| UserData1 — UserData25 | User Data 1 — User Data 25 | There are 25 data fields that you can use to store information such as supplier details or alphanumeric data mapped from a data exchange's external source. You can customize the name of a data field then display the field in your Monsoon desktop. | An alphanumeric string with a maximum length of 255 characters. | Winchester Toys SE14 5EQ | All categories |
Yes |
Yes |
| VariationTheme | — | The name of a variation theme. It must be unique per market and be the same as a theme that you have created using the Variation Themes option on the Settings tab. | An alphanumeric string with a maximum length of 255 characters. | Color Size | All categories that eBay supports for variation listings. For more information, see the eBay website. | Yes | No |
|
WalmartSubcategory |
— |
The Walmart Subcategory that the item will be added to when it is listed on Walmart. For more information on which Walmart subcategories Monsoon supports listing items in, see the Walmart Marketplace topic. For more information on how to pick the best Walmart subcategory for your item, see the Walmart Knowledge Base. |
|
BooksAndMagazines |
All categories |
Yes |
Yes |
| WarehouseLocator | Location |
Locator codes use the following format: Location-Zone-Aisle-Bay-Shelf-Unit. You can add a locator code at the same time you add a new SKU, add quantity to a SKU at an existing location, modify the details of a SKU at an existing location, or decrease the quantity of a SKU at an existing location. The shelf locations for the SKUs in your import file must be available (not closed or in use). For more information, see Importing Inventory Overview. |
An alphanumeric string with a maximum length of 20 characters. Location: 3 alphanumeric characters maximum Zone: 1 alphanumeric character maximum Aisle: 2 alphanumeric characters maximum Bay: 3 numeric characters maximum Shelf: 3 numeric characters maximum Unit: 5 numeric characters maximum |
L2 -1-B -003-002-1 | All categories |
Yes |
Yes |
©2016 Monsoon, Inc. All rights reserved.