Price and Inventory Lookup

Google Chrome is the preferred browser. If you normally use a version of Internet Explorer below version 9, use Google Chrome.

The Price and Inventory Lookup screen provides quick access to inventory quantities and prices by SKU, UPC, ISBN, and EAN. A variety of search fields are available to locate merchandise

Use the Price and Inventory feature to assist customers, e.g. find a comparable item for an XL sweatshirt, when the blue one is out of stock.
Use the information to review negative on hands.

The quantities are near-real time. The near-real time updating is referred to as “trickle polling.” Trickle polling refers to the process of continuously updating inventory counts from all systems that affect inventory, for example, CourseTracks, SODA, eFollett, and MMS.

To access the Merchandise Management System (MMS) screen, you need either SODA access or view-only access in MMS. Anyone in the store who has SODA access is able to access this screen. If someone in the store needs to use the Price/Inventory Lookup screen and does not have access to SODA, complete a Store SAR to request MMS Level Price and Inventory Lookup access for that person.

Use this URL to access the MMS screen: http://mms

After you access the URL one time, you can save the link as a Favorite to use again.

The Login window is displayed.

Type your SODA or MMS user name and password in the fields.
Select the Login button.

The MMS menu is displayed.

Select the Price and Inventory Lookup button.

The Price/Inventory Lookup screen is displayed.

Note: The Store field only appears if the user sign on information is not linked to a specific store number.

Type or scan information in the Search fields for the item you want to look up.
Note: As data is entered in a search field, results begin to display. Click on a result to populate the field with that suggestion.

View Search Capabilities

Press the Go button.
The search results display in a grid listing all SKUs for the entered search criteria. The search result grid can be sorted by clicking on any of the column headers.
Click a row in the search results grid.
The item results display.

View Field Definitions

8. Click the Clear button to reset the entire page, removing all search criteria and results.

Note: Click on the First time here? link for an online guide.

Zendesk HTML5.4.log-258608912.zip
30 KB Download

Field	Definition
Image	Product image of the searched item, if available.
Price
Item	Description of the item as it appears in MMS
Store	Store number. This field only appears if the user sign on information is not linked to a specific store number.
SKU	SKU, UPC, ISBN, or EAN of the item
Department	Department number and name
Price	Price in MMS (Current selling price)
Seasonal Code
Status	Item status - status includes Active, Discontinued, Inactive, Not to be re-ordered, or To be purged.
Vendor	Vendor number and name of default vendor. Note: There may be alternate vendors in MMS; only the default vendor displays in lookup.
Inventory Position
Store On Hand	Quantity of the item on hand in the store.
Min. Order Quantity	Minimum order quantity for the default vendor.
Allocated On Order	Quantity allocated for SODA orders in the store.
PO On Order	Quantity of the item that is included on open purchase orders.
Transfer On Order	Quantity of the item included on transfers from other stores.
Last Day Store Sales Posted	Date the system was updated with store sales. If the date is in red (see sample screen below), it has been at least one day since sales were updated. Verify that you have successfully completed End of Day processing in the POS each day.
Last Trickle Poll Received	Trickle polling is the process that updates the inventory quantities in near-real time. This field tells you the date and time of the last update.
PO on Order tab	A list of open purchase orders for the searched item.

Price and Inventory Lookup

Articles in this section