Inventory Column Descriptions

The Inventory Grid displays a wide range of information on each item. This data is obtained by Seller Engine Plus from Amazon's API.

 

To sort by the value in a particular column:

  • Click on the column header you want to sort by.
  • To reverse the order click on the column header again.
  • The column being sorted by will show a small arrow displayed close to its right margin.
  • If you add an inventory item into a sorted list the item will show at the end of the list, it will not fall into the correct place in the sorted inventory list. The items need to be reordered again by clicking the header.

 

To sort by multiple columns:

  • Click on the primary sorting column header.
  • While pressing the Shift key on your keyboard click on the secondary sorting column. You will now notice the items being primarily sorted by the first column. Items with an identical primary sorting attribute will also be sorted by the second sorting attribute.

 

To customize the order of the columns choose one of these methods:

  • Click on the column header and drag it to the desired position. You can scroll over by dragging it to the header portion at the far right or left of the screen. The columns will scroll over. When it is in the desired position, release the mouse button.
  • Use the 'Customize Grid Columns' dialog, which can be accessed by the following methods:
    • Right mouse click anywhere in the Inventory list and select 'Customize Grid Columns' from the drop-down menu.
    • Select 'Customize Columns' from the 'View' menu.

 

Column Name Column Description
No. The database index number for your item. This is useful only for keeping track of where an item is located in the list. Note: when you resort the list, the indices of y our items will change. If the list is sorted by this column, adding an item will simply add it to the end of the list.
Item Type Book, DVD, software, etc.
Price Check Status The progress and status of your price check on this item. A number of different icons are used in the column, and the meaning of their values can be configured through the Price Status Flags dialog.
Listed on Amazon Yes - this item is an active listing on your Amazon ProMerchant seller account. No - this item is in your inventory list, but is not an active listing. Unknown - SellerEngine Plus has not yet retrieved information from Amazon for this item, so it is unknown whether the listing is active on your Amazon ProMerchant seller account or not. Obtain status by open listing downloads and price checks.
(Merchant) SKU Displays your Merchant SKU for the listing.
ASIN / ISBN / UPC / EAN (Product ID) Product ID used to identify items on the Amazon platform.
Product ID Type Specifies what type of Product ID is displayed in the ASIN/ISBN/UPC/EAN field.
Title The title of the product. It is automatically retrieved from Amazon.
Price The price you have set for that item.
Condition The item's condition. See the Amazon condition definitions for more information.
Inventory Quantity The quantity you currently have in your local inventory.
Authors The item author, editor, or manufacturer.
Export to Amazon Defines whether an item is included in export operations. If the option is set, it will be included when uploading items to amazon or exporting the inventory to a file.
Delete from Amazon Defines whether the item will be removed from your listings on the next upload. This is one of the ways to remove listings from Amazon.
No Reprice When this flag is set, if you have a reprice schema assigned to your item, the application will not change the price field during a reprice operation, but rather set the new calculated price to the Recommended Price field. If no schema is assigned to the item, this field is ignored.
Recommended Price The price recommended by the reprice schema assigned to the item. Value is set after a reprice is completed.
Last Price The price you had assigned to your item before running a price check on that item.
International Shipping Values: Default - No value is assigned. The Amazon default will be assigned (US only). US Only - US delivery only. Worldwide - The item can be shipped internationally.
Shipping Estimation Estimated shipping credit received from Amazon for Merchant fulfilled items; the estimation is based on Shipping Credit settings in Preferences, and on Weight & Dimensions values retrieved from Amazon (not values set manually in the software). Shipping Estimation is calculated/updated using Get New Price Data and Reprice.
Image URL The URL for the Amazon catalog image for this item.
Open Date Date when the item was first listed on Amazon. Can only be retrieved by an open listings report.
Manufacturer Company that provides item (The publisher in the case of books).
Release Date Item release date (by publisher).
Megaseller Price Price belonging to the bucket of offers that most likely contains the Amazon price.
Listing ID Unique id for your listing provided by Amazon.
Browse Path Old Zshop field still available but no longer in use on Marketplace
List Price The item's MSRP, what the publisher recommends that the retailer sell the book for. Amazon almost always sells below this, as do independent sellers.
Sales Rank Displays the Amazon sales rank for the item. This can vary dramatically from hour to hour, so use this column with care.
Last Checked Date The date of the last price check affecting the item.
Availability Whether Amazon and other sellers have the book in stock.
Lowest Price The lowest price on Amazon (including other sellers).
Highest Price The highest price on Amazon (including other sellers).
Average Price The average price on Amazon.
Item Note Your description of the item.
Expedited Shipping A check-box field that if checked, makes the item available for expedited shipping.
Paid Price The price you originally paid for the item (value can be set when adding or editing an item).
Location Local-only field used for keeping track of any location data you might need about your item.
Edition Details about the edition of the book, shows if it's a first edition book, a reprint or other relevant details.
Media Hardback, paperback, etc.
Size Product dimensions. This field is for internal use only.
Platform Shows the gaming platform for Video Game items (PlayStation, Nintendo, etc)
Media Number Number of items contained in an item (for example a book can consist of 2 volumes or an audio disc of 2 cds).
Director DVD and VHS specific column; shows the director of the film/movie on the media item.
UPC The UPC code for an item.
Weight Weight of the item.
Starring DVD and VHS specific column; shows actors starring in the film.
Provider The source from which you obtained the item.
User Data Information input by the user for their own reference.
Encoding This is a legacy column that no longer shows any information - it will be removed from the grid in future SE Plus versions. 
Asin1 ASIN for alternate publication of the same product. 
Rating Audience rating for DVD and VHS items.
Format Shows format type for DVD and Video Game items (PAL, Subtitled PAL, Import, etc.)
Asin2 ASIN for alternate publication of the same product.  
Asin3 ASIN for alternate publication of the same product.  
MPN This is a legacy column that no longer shows any information - it will be removed from the grid in future SE Plus versions. 
Local SKU Your Local SKU, if it differs from the Merchant SKU.
Number of Listings The number of other offers on Amazon for the same item.
Artists Artist(s) that sign the release. 
AgeGroup The age group by which the media item can be viewed / listened to.
Buyer Waiting Price If the item is not currently available on Amazon, the price at which waiting buyers have specified they would like to pay for the item.
Number of Listings with condition New The number of other offers on Amazon for the same item with condition New.
Number of Listings with condition Used The number of other offers on Amazon for the same item with condition Used.
Number of Listings with condition Collectible The number of other offers on Amazon for the same item with the Collectible condition.
Average New Price The average price of the item in condition New.
Average Used Price The average price of the item in condition Used.
Average Collectible Price The average price of the item in condition Collectible.
Highest New Price The average price of the item in condition New.
Highest Used Price The average price of the item in condition Used.
Highest Collectible Price The average price of the item in condition Collectible.
Reprice Schema The Reprice Schema assigned to this item.
My Price on Amazon The current price at which you have the item listed on Amazon.
Lowest New Price The lowest price of the item in condition New.
Lowest Used Price The lowest price of the item in condition Used.
Lowest Collectible Price The lowest price of the item in condition Collectible.
FNSKU The FNSKU code for the item. 
Subject Category This is a legacy column that no longer shows any information - it will be removed from the grid in future SE Plus versions.
Studio The studio where the DVD/CD was recorded.
ListedState Indicates whether the item is part of the FBA program and being sent to an Amazon fulfillment center or Merchant Fulfilled An item is merchant fulfilled if it is ordered on Amazon and shipped to the customer by the third party seller, not by Amazon.
Sorter The sorter associated with the entry. Sorters can only be assigned to items as they are added to shipments. In the current release, a sorter cannot be added to an entry in the Edit window.
SorterResult Value triggered after running the sorter for the item.
Shipment Quantity Shows the quantity placed in a shipment. This value changes to zero once a shipment is received and processed by Amazon.
Amazon Quantity (FBA) The quantity you have in the FBA warehouse for an item. 
Automatic Reprice Enables/disables automatic reprice for the item.
Custom Condition Value set by user to use when editing SKU and item description to differentiate between identical items in slightly different conditions. This is for internal use only.
FBA Warehouse Condition The condition of your item as received by Amazon. 
Expedited Shipping Details Details about expedited shipping.  
Price+Shipping Your total price including shipping. 
My Shipping on Amazon Your shipping rates as specified on Amazon.
My ListedState on Amazon Your Listed State on Amazon - shows whether or not the item has an Active Listing. 
Upload Status The status of the uploaded price change during Automatic Reprice
Uploaded Last Time Shows you when item/changes to the listing were uploaded last.
Upload Error Errors occurring during Automatic Reprice
I have the Buy Box Tells you whether or not you have the Buy Box for an item. 
Buy Box New Price+Shipping The New Buy Box price including shipping. 
Buy Box Used Price+Shipping The Used Buy Box price including shipping. 
My Price+Shipping on Amazon Your total price including shipping currently available on Amazon.
EAN The EAN code for an item. 
Minimum Price The minimum price set for an item.
Maximum Price The maximum price set for an item.
Features Shows features specific to the item.
Tax Code The tax code assigned to an item; this value can be changed through the software using the Tax Code dropdown in the Edit window.

 

Have more questions? Submit a request

Comments