PI Builder Quick Reference Guide - LowesLink

1 PI Builder File Quick Reference Guide Lowe s Product Information Lowe s PI Builder File Quick Reference Guide Updated July 2015 Vendors are responsible for products, product data and media they provide. Vendors may not rely on this document for legal advice and should consult with their own counsel about legal requirements for their products. 2 PI Builder File Quick Reference Guide Lowe's Companies, Inc. | Confidential Maintained by T&C | Updated PI Builder File Quick Reference Guide Lowe s Product Information What is the PI Builder File?

2 3 Where to Find the PI Builder File PI Builder File Expiration Dates Checklist ..4 Additional Resources ..4 How to Enable Macros ..4 Excel 2007 Excel 2010 How to Submit New Items ..7 How to Submit New Items At a Glance Building the file Completing the file Submitting the file How to Update Existing Items .. 10 How to Update Existing Items At a Glance Building the file Completing the file Submitting the file Import Vendors .. 15 How to Submit New Items At a Glance Building the file Completing the file Submitting the file Major Appliance Vendors.

3 18 How to Submit New Items At a Glance Building the file Completing the file Submitting the file Mandatory Tasks Menu .. 21 Vendor Contact Information Data Validation Checker Utilities & Help Menu .. 23 Marketing Data Spreadsheet Stock Quantities & Dimensions SOS eCat Logistics How to Upload Images & Digital Assets .. 27 Digital Asset Upload Version (In development) Updating Images & Digital Assets in PCM How to Download Marketing Data from PCM .. 29 Taxonomy Marketing Data .. 30 Attributes & Category Requests Restrictions Collection Tool.

4 31 Item Restriction Types, Definitions and Examples Using the Restrictions Collection Tool Glossary & Key Terms.. 36 Table of Contents 3 PI Builder File Quick Reference Guide Lowe's Companies, Inc. | Confidential Maintained by T&C | Updated PI Builder File Quick Reference Guide Lowe s Product Information Purpose - What is the PI Builder File? The PI Builder is a set of smart Excel spreadsheets which helps the Product Information Specialist correctly input vendor data into Product Content Management (PCM).

5 The Builder File is generated based on the following selections; these options will provide the necessary sheets needed for item setup: Item type o Stock: Refers to products that are physically stocked in a Lowe s store and are available for purchase. o SOS (Special Order Sales): Sale of product that is not stocked in Lowe s stores. Country where the product is sold Marketing Category You may see any or all of the following sheets within the Builder File determined by the selections mentioned above: Marketing Data Spreadsheet (MDS): this sheet is used to collect marketing data for your product(s) at the category level.

6 The data you enter on the MDS should reflect the lowest selling unit for your item. Marketing data is utilized throughout the Lowe s selling channels to promote the sale of your product(s). MDS Snapshot: this sheet provides an overview and response parameters available within the Marketing Data Spreadsheet. Stock Sheet: this sheet is only generated if you are setting up a stock item. The Stock sheet is used to submit your item setup data for Stock items. SOS Sheet (Special Order Sales): this sheet is only generated if you are setting up a Special Order item.

7 The SOS sheet is used to submit your item setup data for SOS items. Logistics Sheet: this sheet is only generated if you are setting up a stock item. The logistics sheet collects all information pertaining to your company s transportation and warehouse information as well as your lead time and truck capacities. Quantities & Dimensions Sheet: this sheet collects all of your shipping quantities and dimensions. This sheet is only generated if you are setting up a stock item. You must supply every applicable shipping level s quantity & dimensions within this sheet.

8 ECat Sheet: this sheet is generated if you are setting up an SOS item. The eCat sheet collects all the cost information by model number and state/region for SOS items. Pub Report Sheet: this sheet is for Data Pool vendors only. This sheet is reserved for a copy of your Publication Report from your Solution Provider. Once your data has been published please paste a copy of the report on this sheet. Where to find the PI Builder File The PI Builder File is accessed from LowesLink under the Product Information Tool Kit Application.

9 Please remember you must download the file to your computer before accessing; do not attempt to open and run the file from LowesLink . You will need to download a new version of the PI Builder each time you wish to submit items to guarantee you are receiving the most up to date information. PI Builder Expiration Dates The PI Builder is under constant updates and to ensure you are accessing the most current and up to date category information; the PI Builder is equipped with 3 expiration dates: PI Builder (downloaded from LowesLink ): 14 days PCM Download File ( ): 14 days Built PI Builder File (used to enter data): 60 days You will not be able to edit or submit the data within an expired file; you must create a new Builder and reenter your data.

10 Note: Before you open the Builder File please confirm your macros are enabled, for further instructions please click here. Back to top 4 PI Builder File Quick Reference Guide Lowe's Companies, Inc. | Confidential Maintained by T&C | Updated PI Builder File Quick Reference Guide Lowe s Product Information Checklist To ensure your setup is completed efficiently, please make sure you have completed the following steps before you submit your PI Builder File to your Product Information Specialist: Ensured Merchandising has approved your items for setup Verified that your Brand Name is on the Lowe s Master Brand List If your brand is not listed on the Lowe s Master Brand List click here for instructions on how to add your Brand Name Published your data with your Solution Provider If you do not currently have a Solution Provider click here for a list of commonly used Solution Providers Reviewed the Lowe s Marketing Data & Image Standards To access the Lowe s Marketing Data & Image Standards