Lowes Item Management Application App User Guide

Contents hide

1 Lowes Item Management Application App

2 Specifications

3 FAQs

4 PRODUCT USING INSTRUCTIONS

5 Documents / Resources

5.1 References

6 Related Posts

Lowes Item Management Application App

Specifications

Product Name: Item Management Application
Version: Jav18

Repository Location: Vendor Library
Pages: 12

FAQs

Q: Can partial saves be made when updating item spec attributes?
- A: No, partial save is not enabled. All required and conditionally required attributes must be completed before saving the data.

PRODUCT USING INSTRUCTIONS

About Job Aid

This job aid will provide instructions on navigating the Search & Maintenance tab in the Item Management Application.

Searching Items

Select the Item tab to navigate to the Item Management Application

Select the Search & Maintenance page
Enter Search Criteria

Select Search
- Notes:
  - Must search by category to see category-specific attributes. When exported there will be two tabs, Core & Enrich listing your attributes.
  - When the Data Quality filter is selected a Category must also be selected.
  - Can search by as many Brands as desired.
  - Can only search one Category at a time.
  - Can search Sub-Division by number or name.
Scroll down to review Search Results
- Note: Results can be reviewed by Item Spec, Digital Assets, or Restrictions.
- Note: The Equivalent Item Number (Eq#) (SOS item number of a Stock/SOS flip) is shown to the right of the Stock Item Number while on the Item Spec tab.

Exporting Items

Note: To search for specific downloaded files, users can implement additional filtering options by clicking on the space next to the File Types field and selecting additional filter criteria.

Updating Item Spec Attributes in the User Interface (UI)

Enter Search Criteria

Select Search
Scroll down to view the search results

Update editable attributes by clicking in cells or clicking on the hyperlinked item number to open the single-item edit page functionality
Select Save
- Notes:
  - White cells are Non-Editable, orange cells are Conditionally Required, and green cells are Mandatory.
  - Must select buttons (1,2,3, etc.) to update those attributes. (Example: Core, Pricing, Fulfillment, etc.).
    - To update attributes in button 5 (Enrichment), a category must be selected in the search criteria above.
    - Pricing information in the #2 Pricing button becomes static after Business Awarding. To get current pricing information or to make price and cost updates please reach out to your Merchandising team.
  - Changing the Product Category will erase all previously collected enriched data for the item, best practice is to download all enriched data prior to updating the Category in case of needing to revert back to the previous Product Category.
  - If correcting DQ errors, you must correct all errors for an item before you can save.
- Single Item Edit Page:
  - Update all attributes on one single page.
  - Does not require a category to be entered.
  - Use tabs to access different types of attributes (Core, Pricing, etc.).
  - Use the Add Hierarchy buttons at the top of the Packaging Hierarchy & Barcode page to add additional hierarchy levels to the existing hierarchy.
  - Use the New Hierarchy buttons at the bottom of the page to add a brand-new hierarchy to the item.
  - Note: Partial save is not enabled on this page. All required and conditionally required attributes must be completed before the app will save the data and push it to downstream applications.
- Updating Digital Assets:
  - Select the Product Assets tab.
  - There are two sections, Mandatory Assets and Optional Assets.
  - To know how many assets are required in the Mandatory Assets section refer to the asset counter. For example; 1/2 or 2/2.
  - To learn more about adding and assigning digital assets please see that help document and training video under the Digital Assets tab on the Search & Maintenance page.
Validate updates made are displayed on screen

Updating Item Spec Attributes in Bulk

This feature gives the user the ability to make edits in bulk right within the UI.

Select Search
Scroll down to view the search results

Under the Item Spec tab locate the button containing the attributes you would like to update; select the items you would like to bulk edit by checking the box next to the item(s)
- Note: Only the attributes under the selected button (1,2,3, etc.) can be updated.
- (Example: Core, Pricing, Fulfillment, etc.). Not all attributes are editable. To update an un-editable attribute please submit a ticket on the Vendor Gateway or reach out to your Onboarding & Maintenance Analyst.
- To update attributes in button 5 (Enrichment), a category must be selected in the search criteria above.
Select the Bulk Edit button
Fill in attributes to bulk edit

Select Apply
- Note: Bulk means the SAME updated values will be applied to all selected items.
- A max of 100 items can be updated at one time using the Bulk Edit function.

Confirm updates on the screen in the UI

Mass Maintenance

Search for items using any of the search criteria in the box at the top of the page.
- Note: Mass Maintenance can be performed on Core and Enrichment attributes. Core attributes will export when the product category search field is left blank. When you choose a product category, you will be able to export core and enrichment attributes.
Click Download to export all the selected items.
- Note: You can use the checkboxes beside the items to select specific items, or you can download all the search results.

The screen will redirect you to the File Upload Status tab. From here, you can open the exported file.
Make changes to any editable fields. Make sure to use the Reference Data tab when applicable for acceptable values.
Save the file to your computer.

Go to the Item Spec tab and click on Upload.
- Note: Grayed-out columns are not editable. White columns are open to edits. Open cells below an item number appear due to this being the same item, just a different packaging hierarchy. Product Category and California Prop 65 are not editable through mass maintenance. Please use the Bulk Edit option to change the values on these attributes for your items.
Once the template is uploaded, your screen will display the process summary. This summary will let you know how many items were fully updated, and how many items still have errors. You can export the items with errors, correct them, and reupload them.
- Note: There is a systematic partial save for the mass maintenance. This will allow the user to edit and save attributes without completing others. The user will still receive an error for mandatory or conditional attributes which will need to be completed, but the submitted information will be saved.

Correcting Data Quality Errors

Locate the Data Quality (DQ) errors by selecting Items with Open Errors from the Data Quality filter drop-down. Enter a Category. Select Search. Scroll down to see the resultes table.

Once on the results table, under the Item Spec tab, you can review the errors by:
- Clicking on the error count below the Lowe’s Item Number.
- Clicking on the #5 button (Enrichment) and using the arrows to locate the cells in red.
- Exporting by selecting the items, by clicking the checkboxes next to the items, and then selecting Export.
- To update the errors simply click on the cell showing in red and make the correction. Once all errors are corrected select Save.
- Note: All DQ errors for that item MUST be corrected before you can save.

Adding a Hierarchy

During item setup, you can only set up one packaging hierarchy. If you need to set up additional hierarchies once your item is set up, go to the Search & Maintenance tab. Locate your item(s), click on Button #4 (Packaging Hierarchy), and click on the +. This will take you to the Single Item Edit page on the Packaging Hierachy tab. To learn more about this tab click here.

Updating Stock/SOS Flip – Lead Times

A Stock/SOS flip means an item has the same barcode and model. Currently, only the stock item will show in IMA and the stock item will be used to maintain fulfillment attributes for the stock and SOS versions of the item.
To update the SOS lead time on a Stock/SOS item please update the Customer Order Lead Time and Customer Order Lead Time UOM attributes and select Sav

Adding Multiple Factories

To add multiple factories, navigate to the Factory ID and select the new Factory to be added.
Then, continue to fill out any additional mandatory or conditionally required attributes for the new factory. Once all attributes are completed select Save.

Notes:

IMA only displays the most recently added Factory but Lowe’s does have the complete list of Factories that have been added.
If the Factory or Shipping Port needed are not showing in the dropdown in IMA they will first need to be added in the vendor’s Vendor Gateway Company Information tab. Please see the training video listed in the Quick Training Clips & FAQs document on the Insights tab for guidance.
To update the Stock lead time on a Stock/SOS item please update the Vendor Processing Time and Vendor Processing Time UOM attributes and select Save.

Note: The Equivalent Item Number (Eq#) (SOS item number of a Stock/SOS flip) is shown to the right of the Stock Item Number while on the Item Spec tab.