How to fill out a CIS file
11/30/11 - Updated Marketing Categories list.
11/18/11 - Resorted Marketing Categories list to show alphabetical order by category instead of division.
Read all instructions carefully before submitting Item Setup requests!
- Shaded areas to be completed by Lowe's. All other fields should be completed by vendor.
- Columns with BLUE headings are PCM-required fields. Subscriptions will not be created if required data is missing.
- Use 'Paste Special > Values/Text' if you are copying data from another source so as not to overwrite the formatting of this file!
Product Information processes this file using macros that will not work if the formatting is changed.
ROLE: VENDOR WORKFLOW STEP
Obtain a publication report from your solution provider and copy it to Page 1 GDSN Published tab. Item setup WILL NOT
Step 1 proceed until a valid publication report is included on the setup file. This only applies to Data Pool Vendors. Web Vendors
proceed to step 2.
Complete Page3DescriptionPricing tab for stock items (60 item limit per ISS). Go to step 3 for Special Order item setup
Step 2
(1500 limit per ISS).
- Do not add, delete or modify and cells, rows, columns or formulas in this worksheet unless you have copied data from
another source and need to change the formatting back to 'text'. Please make every attempt to preserve the formatting. If
you are copying your data from another source, using Paste Special>Values will allow this.
- Add your first item on the first empty row. Do not leave empty rows between items.
- Shaded areas should not be edited or deleted. These cells are either pre-populated with a formula or are reserved for
data that will be supplied by Lowes.
• Vendor Information (top section of worksheet, D4 - D12 is required for both stock AND SOS items.
• Data Sync Information (top section of worksheet, J4 - J12) is required for both stock AND SOS items.
• Lowes Item Number will be supplied by Lowe's when CIS has been completed. Your MS will return the completed ISS file
to you with new item numbers added, You will also receive a notification in PCM with the new item number. EXCEPTION:
If you are submitting a file to add or modify an existing Lowe's item, you SHOULD populate the Lowes Item number here if
you know what it is.
• Shared w/Canada - Do not edit (Lowe's supplied).
• Highest Level GTIN - Data Pool vendors add the highest level 14 digit GTIN that you are publishing for this item. Web
vendors add the highest level barcode. GTINs/barcodes in this column will be used to request GDSN data.
• Lowest Level GTIN - Data Pool vendors add the lowest level 14 digit GTIN that you are publishing for this item. Web
vendors add the lowest level barcode. GTINs/barcodes in this column will be used to request the Marketing Data. This
column should ALWAYS contain a Consumer level GTIN/barcode or be blank if Marketing data will not be provided (needs
Merchandising approval).
• Brand - required.
• Marketing Category Name - required. Select a valid Marketing Category from the drop-down list.
• Vendor Model # - Model #s greater than 20 characters are truncated when synchronized. Items with multiple model #s for
different GTIN levels should show this publication's LOWEST LEVEL model # in this field.
• Lowe's Item Description - Descriptions longer than 33 characters are truncated when synchronized.
• Item Description Character Count - Do not edit (formula). This checks the length of the Item Description
• Initial Average PCM Cost - Only costs for NEW items can be added to PCM. Use N/A if setup is for an existing item.
(Lowe's Supplied)
• Margin - Only margins for NEW items can be added to PCM. Use N/A if setup is for an existing item (Lowe's Supplied)
• Costs (columns U - AA) - Cells should remain formatted as four (4) decimal places. If you are adding costs that are only
2 or 3 decimal places, please allow the extra ending '0's to remain. It is Lowe's Standard Practice to receive ALL four-way
costs (DC Collect, DC Prepaid, Store Collect, Store Prepaid) for an item due to different shipping options but at least one
cost is required by Merchandising to complete item setup. Cost options should be negotiated and approved by
Merchandising BEFORE item setup begins.
• Suggested Lowe's Retail - optional per Merchandising
• Lowe's Retail - Do not edit (Lowe's supplied).
• Minimum Advertised Price - optional per Merchandising
• Use MAP in Tabs? - optional per Merchandising
• Lowest Minimum Retail Price - optional per Merchandising
• Price Conversion Factor - optional per Merchandising
• Est Annual Sales - optional per Merchandising
• Initial Order Qty - Do not edit (Lowe's supplied).
• HazMat - Choose response from drop-down list.
• Energy Star Certified - Choose response from drop-down list.
• Assembly Required? - Required if you answered Yes for E11.
• Pallets per Truckload - optional per Merchandising
• Stackable Pallets? - optional per Merchandising
• Source Tag? - Choose response from drop-down list.
• Cost Begin Effective Date - Do not edit (Lowe's supplied)
• Cost End Effective Date - Do not edit (Lowe's supplied)
DATA POOL VENDORS ONLY: For Special Order items (SOS), complete Page3DescriptionPricing tab as follows:
Step 3 • Vendor Information (top section of worksheet, D4 - D12 is required.
• Data Sync Information (top section of worksheet, J4 - J12) is required.
*** No further data is needed on Page3DescriptionPricing for SOS items.***
Complete the Page2MultiSubscriptionsTemplate.
- Data MUST be 'text' format. Use 'Paste Special > Values/Text' if copying data from another source.
- Do not add, delete or modify any cells, rows, or columns in this worksheet unless you have copied data from another
source and need to change the formatting back to 'text'.
- Begin entering your data on row 7. Do not leave empty rows between items.
• GLN (column A) is a required field and MUST be 13 digits.
• Highest Level GTIN (column B) is a required field and must be 14 digits. If your highest level GTINs have leading zeroes,
make sure the cells are formatted to show all 14 digits. Replace the formulas with your GTINs.
• Lowest Level GTIN (column C) is a required field. GTINs must be 14 digits.
• Assortment Number (column D) is a required field but this is a Lowe's assigned number so if you do not know your
assortment number, leave this blank and your Merchandising Specialist (MS) will populate.
• SOS Item Number (column E) is a required field if item setup is for Special Order only but this is a Lowe's assigned field
so if you do not know your SOS Item Number, leave this blank and your MS will populate.
• Model Number is a required field and is limited to 20 alpha-numeric characters. Do not use special characters (refer to
Loweslink for specific characters that cannot be used). Model # that is published should match the model # supplied here.
Reference
Page 1 of 75 fc64a4e8-af63-4b9d-82ee-716d2b96b95d.xls
How to fill out a CIS file
• Model Description is a required field and is limited to 20 characters for SOS, 33 characters for stock. You can enter as
many characters as you like but Lowe's systems will truncate to 20 or 33. Use only alphanumeric characters where
possible. Do not use brackets, angle brackets, braces, asterisks, or tildes.
• TMCC is not used at this time. Do not populate or delete.
• Marketing Category Name - required. Select a valid Marketing Category from the drop-down list.
Step 4 Complete Page 4 Quantities & Dimensions tab for stock items only.
Reference
Page 2 of 75 fc64a4e8-af63-4b9d-82ee-716d2b96b95d.xls
How to fill out a CIS file
If you have completed Steps 1 and 2 correctly, this tab should already be partially filled out.
- Do not add, delete or modify and cells, rows, columns or formulas in this worksheet unless you have copied data from
another source and need to change the formatting back to 'text'. Exception: You may insert additional rows anywhere
between rows 4 and 40 (up to 1,500 total items) if you are setting up more items than there is room for on the blank
template.
- Do not leave empty rows between items.
- Shaded areas should not be edited or deleted. These cells are either pre-populated with a formula or are reserved for
data that will be supplied by Lowes. If you have completed Steps 1 and 2 correctly, your GTINs/barcodes should now be
showing on this tab.
• Add dimensions for any GTIN levels you will be publishing to Lowe's on this tab EXCEPT pallet dimensions. Follow
number format noted at bottom of page. NOTE: You will not need to add GTINs to this worksheet that are in the same
hierarchy and between but not highest or lowest (example: you're publishing a three level hierarchy, EA, CARTON and
PALLET, you will add the each and carton dimensions to this page even though you have not supplied the carton GTIN.
Lowe's will receive the entire hierarchy when the highest level is approved.
Step 5 Complete Page 5 Pallet & POG Information tab for stock items only.
If you have completed Steps 1 and 2 correctly, this tab should already be partially filled out.
• Required if you are supplying pallet data. If your highest level GTIN is not a PALLET, do not complete this tab.
• Do not add, delete or modify and cells, rows, columns or formulas in this worksheet unless you have copied data from
another source and need to change the formatting back to 'text'. Exception: You may insert additional rows anywhere
between rows 4 and 40 (up to 1,500 total items) if you are setting up more items than there is room for on the blank
template.
• Do not leave empty rows between items.
• Shaded areas should not be edited or deleted. These cells are either pre-populated with a formula or are reserved for
data that will be supplied by Lowes. If you have completed Steps 1 and 2 correctly, your GTINs/barcodes should now be
showing on this tab.
• Follow number format noted at bottom of page.
Step 6 Complete Page 6 Logistics Information tab for stock items only
If you have completed Steps 1 and 2 correctly, this tab should already be partially filled out.
- Do not use this page to add new shipping locations. Complete Item Set-up
Sheet and send to MS
Send completed CIS file and MDS (Marketing Data Spreadsheet) file (including publication report for Data Pool vendors) to
Step 7
MS.
Reference
Page 3 of 75 fc64a4e8-af63-4b9d-82ee-716d2b96b95d.xls
How to fill out a CIS file
ROLE: MERCHANDISING SPECIALIST WORKFLOW STEP
Obtain CIS file from vendor and review for the following. If any vendor supplied data is missing, return to vendor for
Step 1
completion.
Step 2 • Page 1 tab - If Data Pool vendor, publication report is Required.
• Page 2 tab for SOS items only. MS compares and
completes Item
- Add Assort #. Set-up Sheet
- Add SOS item #.
• Page 3 tab
- Review top section for completenes of Vendor Information and Data Sync Information. Return to vendor if missing. The
contact info is the ONLY item data on this tab that needs to be completed if setup is for SOS only.
- Add Item Ticket # (AB3) and Item Setup Due Date (AB4):
- If vendor has supplied Lowes Item Number for existing items, verify correctness. If item numbers have been reserved,
add them to column A.
- Select Item Type (B) for populated rows. Non-Inventoried requires SOS item # on Page 2 tab.
- If Stock Item, select type (C)
- Complete required columns I, J, K, L, M, Q, R, and AH for populated rows.
- Review vendor supplied data for correctness per Merchandising negotiations. Resolve any discrepancies with vendor
before proceeding!
• Page 4 tab (stock/SOE only)
- Review vendor supplied data for correctness per Merchandising negotiations. Resolve any discrepancies with vendor
before proceeding!
• Page 5 tab (stock/SOE only)
- Review vendor supplied data for correctness per Merchandising negotiations. Resolve any discrepancies with vendor
before proceeding!
Places Completed
• Page 6 tab (stock/SOE only) Item Set-up sheet
- Review vendor supplied data for correctness per Merchandising negotiations. Resolve any discrepancies with vendor in PLR folder and
before proceeding! submits Footprint
ticket with link to
item set-up sheet
Step 3 Place completed CIS file in PLR folder and submit Footprint ticket with link to item set-up sheet.
ROLE: PRODUCT INFORMATION WORKFLOW STEP
Step 1 Review CIS item setup file for completeness. Respond to Ticket if any PCM requred info * is missing.
Verifies
Publication is
Data Pool: Verify GDSN publication is complete and subscribe to GTINs.
Step 2 complete with
Web: Subscribe to barcodes. Verify vendor receives PCM task to enter product data. 1SYNC
Step 3 Receive and complete PCM worklist approval task
Creates
• Update CIS file with new item number(s) subscriptions
Step 4
• Update Ticket.
Receive
worklist task
in PCM for
aproval
Updates Item set-
up sheet and
update footprint
and send to MS
Reference
Page 4 of 75 fc64a4e8-af63-4b9d-82ee-716d2b96b95d.xls
DATA POOL VENDORS: COPY PUBLICATION REPORT TO THIS TAB.
Please enter the required fields: GLN, Highest Level and/or Lowest Level GTIN, and Assortment Number.
If this is for a brand new product to Lowe's and Marketing Data is required then please provide the Lowest Level GTIN.
If this is for Special Order product please provide the SOS Item Number, Model Number, and Model Description.
Please enter Category for Marketing Subscriptions
Be sure to save your change to a local hard drive!
GLN Highest Level GTIN Lowest Level GTIN Assortment Number SOS Item Number
the Lowest Level GTIN.
Model Description.
Model Number Model Description TMCC Category
LOWE'S NEW ITEM INFORMATION SHEET
* Shaded areas to be completed by Lowe's. All other fields should be completed by vendor.
* Columns with BLUE headings are PCM-required fields. Subscriptions will not be created if required data is missing. Item Ticket #:
Item Setup Due Date:
Vendor Company Name: Data Sync/Web Form Contact Name: Subscribed:
Lowe's Home Office Vendor Number: Data Sync/Web Form Contact Phone #: Approved:
Vendor Global Location Number (GLN): Data Sync/Web Form Contact E-Mail: MP Name:
Vendor Contact Name: Data Pool or Web Forms: MP #:
Vendor Contact Phone Number: Solution Provider/Data Pool Name: COMMENTS:
Vendor Contact E-Mail Address: Have GTINs been
EDI Compatible with Lowe's (Y or N): registered in the GDSN?
If no, fax # for orders: Have GTINs been
Do any items require Assembly (Y or N): successfully published
If yes, please indicate the items on the chart below (column AL) and forward to the Assembly Mailbox.
Lowest Minimum Retail
Pallets Per Truck Load
Energy Star Certified?
Shared with Canada?
Minimum Advertised
On Demand Signage
Assembly required?
Stackable Pallets?
(N, Phase 1, 2, or 3)
Use MAP in Tabs?
Price Conversion
Item Description
Character Count
Selling Center?
Selling Center
Effective Date
Effective Date
Lowes.com?
Source Tag
Lowes.com
Required?
**Highest Level GTIN **Lowest Level GTIN DC Prepaid Net FOB
(Limit 33)
(Global Trade Item #) - (Global Trade Item #) - Marketing Initial PCM DC Consignm Store Store Foreign Suggested Est. Annual Initial
Factor
(Y / N)
(Y / N)
(Y / N)
(Y / N)
Price
Price
(Y/N)
(Y/N)
(Y/N)
(Y/N)
Lowe's Item List Barcode if a Web List Barcode if a Web Category Vendor Model # Lowe's Item Description Average New Store Collect DC Prepaid ent Collect Prepaid Port Lowe's Lowe's Sales Units per Order HazMat
Number Item Type Select a response: Assort # Vendor Vendor Brand Name (Limit 20) (bin label) Cost Margin Cost Cost Cost Cost Cost Cost Cost Retail/ECP Retail Store Qty Code
Cost Begin Effective Date: Cost End Effective Date:
**IMPORTANT - PLEASE READ**
Please review the Lowe's Hazmat codes below. A Hazmat code must be entered in PCM for each item that Lowe's purchases. It is the vendor's responsibility to ensure each of their products are classified correctly in PCM. If you have already entered your
This must be completed in PCM for all items.
CODE** SELECT THE CODE THAT IS ACCURATE FOR YOUR PRODUCT (SELECT ONLY ONE CODE)
N ITEM DOES NOT HAVE AN MSDS AND IS NOT REGULATED BY DEPARTMENT OF TRANSPORTATION (CFR49)
1 ITEM HAS MSDS AND IS NOT REGULATED BY DEPARTMENT OF TRANSPORTATION (CFR49)
2 ITEM HAS MSDS AND IS SHIPPED AS ORM-D WITHOUT LTD. OR REPORTABLE QTY. RESTRICTIONS
3 ITEM HAS MSDS AND IS SHIPPED AS ORM-D WITH LTD. OR REPORTABLE QTY. RESTRICTIONS REQUIRES SPECIAL SHIPPING PAPERS TO TRANSPORT, ETC.
4 ITEM HAS MSDS AND IS SHIPPED ACCORDING TO THE SHIPPING REQUIREMENTS OF DEPARTMENT OF TRANSPORTATION CFR49 . REQUIRES SPECIAL SHIPPING PAPERS TO TRANSPORT, ETC.
LOWE'S NEW ITEM INFORMATION SHEET
Qty (Lowest
Actual Product Dimensions*
Selling Unit
Inner Pack
Stock (out-of-box & assembled if applicable) Individual Item Dimension* Master Carton Dimension*
**Highest Level GTIN Dimension*
Lowe's (Global Trade Item #) - in (only if Stock in Calif) Selling Master Master Vendor
Level)
Item List Barcode if a Web Calif? Bulk? Unit** Carton Carton Master Carton Inner Inner Inner Pack Package Min. Order
Number Vendor Vendor Model # (Y/N) H W D (Y/N) H W D Weight Selling Unit Package Type H W D Wt** Qty Package Type *** H W D Pack Wt Pack Qty Type *** Multiple
0 0 0 BAG (BAG)
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
* List all dimensions in inches
LOWE'S NEW ITEM INFORMATION SHEET
On POG
Pallets (Y/N)
Pallet Individual Item Dimension* As Master Carton Dimension* As
Pallets Per
as Item
Truckload
Truckload
Stackable
Units Per
**Highest Level GTIN Dimension* Presented on POG Presented on POG or Cut
(Global Trade Item #) -
Case?
List Barcode if a Web Tiers Per
Lowe's Item Number Vendor Vendor Model # H W D Pallet Wt** Pallet Qty MC Cases Per Tier Pallet H W D H W D I or C
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
* List all dimensions in inches
** List all weights in pounds and in decimal format; no fractions
LOWE'S NEW ITEM INFORMATION SHEET
Vendor Company Name: 0
Vendor Number: 0
Vendor Global Location #(GLN): 0
Vendor Contact Name: 0
Vendor Contact Phone Number: 0
Vendor Contact Email Address: 0
EDI Compatible with Lowe's (Yes or No): 0
* Please list all existing Vendor shipping points that you have negotiated with Merchandising to ship this product from/to
below.
* Do not use this file to request new shipping location VBU numbers.
Ship Point #1 Ship Point #2 Ship Point #3 Ship Point #4
Address
City
State
Zip Code
Lowe's Vendor Shipping Number
Capacity (TLs per week)
Number of Outbound Doors
Collect Prepaid Collect Prepaid Collect Prepaid Collect Prepaid
Vendor Processing Lead-time in Days
Avg. Outbound Cube per TL
Warehouse Contact Name
Warehouse Contact Phone #
Transportation Contact Name
Transportation Contact Phone #
Are all Lowe's Items Available at this
Location?
Which Lowe's Distribution Centers Do You
Ship from this Facility?
Prepaid Store Direct Order Minimum
(express minimum in dollars, units, or pounds)
Prepaid DC Order Minimum
(express minimum in dollars, units, or pounds)
Collect Store Direct Order Minimum
(express minimum in dollars, units, or pounds)
Collect DC Order Minimum
(express minimum in dollars, units, or pounds)
Transportation Mode
(TL-vans, Flat Bed, Rail Cars)
Page 75 of 75 Page 6 Logistics Information fc64a4e8-af63-4b9d-82ee-716d2b96b95d.xls