Supplier Guide For Smartsheet Item Add - Shopmyexchange

Product Information Manager PIM Supplier Guide for Smartsheet Item Add

PIM Overview/Benefits Item information gathered at beginning of process Suppliers aware of required information prior to submission Business rules and validation throughout the process Ensures consistent data throughout the enterprise Information entered and stored in portal No large files through email 2

How To Create Item - Export Smartsheet Supplier Login Page: 3

Supplier Portal

How To Create Item - Export Smartsheet Home Page: 5

Item Smartsheet

Smartsheet/Item Add Create Smartsheet items Homepage, click on SS Export Items widget. Products (GPC Products) Will Open, Drop down to the product category for your item. Highlight item, then click okay 7

Smartsheet/Item Add Create An Smartsheet Product Item category visible in Search box Click on Export 8

Smartsheet/Item Add Status Log Once file is exported, Status will show Succeeded Open Downloaded file. Click on file name at the bottom of log page. 9

Smartsheet/Item Add Smartsheet Item Add Click enable Content Tab at bottom of page will take you to Smartsheet 10

Smartsheet Item Add Smartsheet Item Add Note: Validate Sheet, Next Error, Duplicate Row, Delete Row Should be At Top Enter Name of Item in the “Name” Column All Columns Marked In Blue Highlight Are Mandatory and must be complete to save the data. 11

Smartsheet/Item Add Validate Sheet Once Required Information and mandatory fields have been entered, Validate Sheet Validate Smartsheet Contents pop-up will appear. Enter username and password. If information is missing, You will receive Validate Smartsheet Content with error message. Return to Smartsheet And enter missing information or error data in red. 12

Smartsheet/Item Add Error on Smartsheet Errors will be highlighted in Red, correct the data in the error columns. Next Error tab will take you to the next error to be corrected. Once corrections are made click Validate Sheet 13

Smart sheet/Item Add Once data is complete click Validate sheet If no errors, pop up will appear stating Examined product Ok. Click done, and navigate back to PIM homepage. 14

Smartsheet/Item Add Import Smartsheet Click on Import Smartsheet under Quicklinks widget. 15

Smartsheet Item Add Import Smartsheet Select smartsheet file pop-up will appear Find the Smartsheet file within your device, highlight and open. The file name will appear on the pop-up, click okay, file will save in PIM. 16

Smartsheet/Item Add Import Smartsheet File will upload You will be directed back to the homepage 17

Smartsheet/ Item Add Vendor Workflow Click Item Review or number under normal column. Check box under Assigned to me column Click on the name of the file created. 18

Smartsheet/Item Add You will be directed to the Characteristic, Product Detail, Category Specific. If it’s an eComm item the shipping Delivery tab Fill in requested data and all mandatory fields in blue. Save. If any data is missing or required the file will not save and the column will be underlined in yellow. Once data is complete. 19

Smartsheet/Item Add Primary Product Ship Point Click on green plus indicator, Click supplier root, supplier name, then find ship point , highlight click okay. 20

Smartsheet/Item Add Once all information is correct and saved. Click Submit File will be sent to the buying office for approval. 21

PIM email address pimadmin@aafes.com 22

Thank You!

Products (GPC Products) Will Open, Drop down to the product category for your item. Highlight item, then click okay. 8 Create An Smartsheet Product Item category visible in Search box Click on Export Smartsheet/Item Add. . Smartsheet/Item Add You will be directed to the Characteristic, Product Detail, Category Specific. If it's an eComm