Go to primary content
Oracle® Retail Xstore Point of Service User Guide
Release 18.0
F12254-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

6 Search for an Item

During a transaction you may need to search for a particular item. Xstore Point of Service provides the following methods for performing an item search:

Item Lookup

Item Lookup searches for an item based on any of a number of criteria (for example, SKU, style, or department) and retrieves detailed information about the item. For kits, Item Lookup finds the component items that make up the kit.

Item lookups can be performed while Xstore POS is at a Register or Back Office login prompt without the need to login.

If item lookup is initiated from a sale, you can add the item to the sale directly from the lookup screen if all eligibility parameters have been met.

If your system has the Scan Items Prior to Adding to Transaction setting configured, the item is scanned to confirm it is the correct item being added to the transaction.

  1. Click Find Item in the Register Sale screen.

    Figure 6-1 Register Sale Screen

    Register Sale Screen
  2. Click Item Lookup.

    Figure 6-2 Item Lookup Form

    Item Lookup Form

    The Item Lookup window opens.

  3. Enter the search criteria for the item:

    • Item ID - ID of the item.

    • Department - Department to which the item belongs.

    • Subdepartment - Subdepartment to which the item belongs.

    • Class - Class to which the item belongs.

    • Subclass - Subclass to which the item belongs.

    • Style ID - ID of the style assigned to the item.

    • Description - Content in the description of the item.

    If advanced search options are configured on your systems, use the advanced options to further refine the search:

    • Select the value for any search criteria you are using.

    • Click Exclude for any unused search criteria.

  4. Click Process.

    • If more than one item matches the search criteria, continue with Step 5.

    • If only one item matches the search criteria, the item opens in the Item Viewer.

  5. If necessary, select an item in the Item List window:

    Figure 6-3 Item Selection

    Item Selection
    • Click the item.

    • Use the up and down arrows to highlight the correct item, then press the Spacebar.

  6. Click OK.

    The item opens in the Item Viewer.

    Figure 6-4 Item Viewer

    Item Viewer
  7. If your system has the Scan Items Prior to Adding to Transaction setting configured, you need to scan the item to confirm it is the correct item.

    Figure 6-5 Item Viewer with Exit to Scan Button Highlighted

    Item Viewer with Exit to Scan Button Highlighted

    Select Exit to Scan. You are returned to the Sales screen and must scan the item in order to add it to the transaction.

    Figure 6-6 Sales Screen Awaiting Item Scan

    Sales Screen Awaiting Item Scan

    Once an item is scanned it is added to the transaction:

    Figure 6-7 Sales Screen After Item Scan

    Sales Screen After Item Scan

Item Viewer

The Item Viewer provides information about an item. The Item Viewer displays the following information along the top of the screen:

  • Name of the item.

  • Item ID - ID of the item.

  • Current Price - Current price of the item.

  • Quantity of the item currently in stock.

The Item Viewer has the following tabs:

You can also print a rain check from the Item Viewer. See Print a Rain Check.

Product Information

The Product Information tab, (see Figure 6-4), displays the sections that display information about an item:

Merchandise Hierarchy

The Merchandise Hierarchy section displays the following information:

  • Department - Item department.

  • Subdepartment - Item subdepartment.

  • Class - Item class.

  • Subclass - Item subclass.

  • Style ID - ID of the style for the item (if available).

  • Dimension information for the item.

Vendor Information

The Vendor Information section displays the following information about the item's vendor:

  • Vendor - Name of the vendor.

  • Orderable - Indicates whether the item can be ordered.

  • Part # - Part number used by the vendor.

  • Order Lead Days - Number of lead days required when ordering the item.

Product Attributes

The Product Attributes section displays the following information:

  • Item Type - Type of item.

  • Season - Season for the item.

  • Stock Status - Current stock status.

  • Returnable - Indicates whether the item can be returned.

  • Unit of Measure - Unit used to measure the item (if applicable).

  • Restocking Fee - Restocking fee applied to the item when it is returned (if applicable).

  • Tax Group - Tax group for the item.

  • Tax Amount - Amount of tax applied to the item.

Today's Sales

The Today's Sales section displays the following information:

  • Net Sales - Net amount of sales minus returns for the item on the current day.

  • Qty - Number of items sales of the item on the current day.

Inventory Stock

Figure 6-8 Inventory Stock Tab

Inventory Stock Tab

The Inventory Stock tab contains the following areas:

Stock Ledger

The Stock Ledger table displays the following information for each inventory bucket in which the item is located:

  • Inventory Bucket - Inventory bucket in which the item is located.

  • Location - Location of the item.

  • Quantity - Quantity of the item in the inventory bucket.

Kit Component Items

If the item is a kit, this table displays information about each item in the kit:

  • Item ID - ID of the kit item.

  • Description - Description of the kit item.

  • Quantity - Quantity of the item included in one kit.

Serial Inventory

If the item is a serialized item, the Serial Inventory table displays the following information about each serial number:

  • Inventory Bucket - Inventory bucket in which the serialized item is located.

  • Location - Location of the item.

  • Serial # - Serial number.


Note:

No item quantity is displayed. For all items with one item ID, only one of those items will be assigned an individual serial number.

Related Items

Figure 6-9 Related Items Tab

Related Items Tab

The Related Items tab includes information about items similar to the selected item. The following tables display information about related items:

  • In This Style - Displays information about items assigned to the same style as the selected item.

  • Cross Reference Numbers - Displays information about items cross-referenced with the selected item.

  • Substitute Items - Displays information about items indicated to be substitutes for the selected item.

In This Style

The In This Style table displays the following information about each item that has the same style ID as the selected item:

  • Item ID - ID of the item.

  • Dimensions - Values of the dimension attributes configured for the item.

  • On Hand - Count of the item on-hand.

Cross Reference Numbers

The Cross Reference Numbers table displays the following information about items cross-referenced with the selected item.:

  • UPC - UPC for the item.

  • Manufacturer - Manufacturer that produces the item.

Substitute Items

The Substitute Items table displays the following information about items that are indicated to be substitutes for the selected item:

  • Item ID - ID of the substitute item.

  • Description - Description of the item.

Style Grid

Figure 6-10 Style Grid Tab

Style Grid Tab

The Style Grid displays a grid showing the grid that shows the on-hand quantity of items with one dimension cross-referenced with another dimension.

Price History

Figure 6-11 Price History Tab

Price History Tab

The Price History tab shows the past history of all prices that have been assigned to an item. The Price History shows the following information for each of the past prices:

  • Effective Date - Date on which the price first became effective.

  • Expiration Date - Date on which the price was not longer valid. This field will be blank for the current price.

  • Price - Price for the item from the Effective Date up to the Expiration Date.

Sales History

Figure 6-12 Sales History Tab

Sales History Tab

The Sales History tab displays sales data for the item. The Sales History tab displays the following information:

Weekly Sales

Displays sales data for the item by week. This table displays the following sales information for each week:

  • Week - Date range for the week.

  • Units - Net quantity of the item sold.

  • Net Sales - Net amount of all sales and returns of the item.

Annual Sales

Displays sales data for the item by year. This table displays the following sales information for each year:

  • Year - Year of the data.

  • Units - Net quantity of the item sold.

  • Net Sales - Net amount of all sales and returns of the item.

12 Week Unit Sales Trend

Graph displaying week-by-week net sales data for the item over the past twelve weeks. This graph has the following axes:

  • Start date for the week.

  • Number of items sold.

Print a Rain Check

A Rain check is an optional feature that allows customers to purchase out of stock items for the same price at a later date. To print a rain check:

  1. Click Print Rain Check in the Item Viewer.


    Note:

    The Print Rain Check button will be grayed out if a rain check cannot be issued for the item

    A confirmation prompt opens.

  2. Click Yes to print the rain check.

    Xstore Point of Service prints a rain check for the item.

Inventory Lookup

Occasionally an item may not be available in your store inventory, but the customer would like to see which stores in your chain have the item in stock. You can use the inventory lookup process to search a centralized database to locate these items within a set parameter range. For example, you could locate a specified item at a store within 25 miles of your location that has at least three of the specified item on hand.

To perform an inventory lookup:

  1. Click Find Item in the Register Sale screen (Figure 6-1).

  2. Click Inventory Lookup.

    The Inventory Locator Lookup window opens.

    Figure 6-13 Inventory Locator Lookup

    Inventory Locator Lookup
  3. Enter the lookup information for the item:

    • Item ID - ID of the item.

    • Style ID - ID of a style assigned to the item.


      Note:

      Either the Item ID or Style ID field must be populated. Information in the Style ID field is ignored if the Item ID field is also populated.

    • Distance - Distance from the local store.

    • Quantity - Minimum quantity of the item that the store must have on hand. For example, if the customer needs three of the item, enter ”3”.

  4. Click Process.

    Figure 6-14 Inventory Locator Results

    Inventory Locator Results

    Xstore Point of Service returns a list of stores with the item. The following information will be displayed for each location:

    • Count - On-hand quantity of the item at the store.

    • Location - Address for the store.

    • Phone - Phone number for the store.

    • Distance - Distance of the store from the local store.

  5. Click OK to close the window.

Item Matrix Search

The Item Matrix can be used to find items by navigating through the merchandise hierarchy. Starting at the Department level, you can move to the lowest level of merchandise hierarchy and find a specific item. The merchandise hierarchy levels are color-coded to help you navigate through the different levels. When the item is located, it can be added to the sale transaction.


Note:

Item Matrix is configured off by default.

To find an item in the Item Matrix:

  1. Click Find Item in the Register Sale screen (Figure 6-1).

  2. Click Item Matrix.

    The Item Matrix window opens at the highest merchandise level.

  3. Click the next merchandise level in which the item is located.

  4. Repeat Step 3 until the Item Matrix displays the correct item.

  5. Click the item to add it to the transaction.