Target PML Parts Order Email Processes

Part Order PML Email

An email is sent to the PML of each Target store after each Target Break Fix Continuity Program store visit. The email contains information about Displays fixes, Parts Ordered for the store and Parts that are out of stock in Target IW. The email also has an attached spreadsheet provides a display level breakdown of presence and functionality for the completely visited store.

Workflow

PML Email Daily Schedule

An automated process runs in every 30 minutes from 5 am to 11:30 pm, 7 days a week to send PML emails for all i:c call forms entered for the Target Break Fix Continuity Program store visit call form.

The process is run:

Morning (PST) 5:00 AM, 5:30 AM, 6:00 AM, 6:30 AM, 7:00 AM, 7:30 AM, 8:00 AM, 8:30 AM, 9:00 AM, 9:30 AM, 10:00 AM, 10:30 AM, 11:00 AM, 11:30 AM
Afternoon (PST) 12:00 PM, 12:30 PM, 1:00 PM, 1:30 PM, 2:00 PM, 2:30 PM, 3:00 PM, 3:30 PM, 4:00 PM, 4:30 PM, 5:00 PM, 5:30 PM, 6:00 PM, 6:30 PM, 7:00 PM, 7:30 PM, 8:00 PM, 8:30 PM, 9:00 PM, 9:30 PM, 10:00 PM, 10:30 PM, 11:00 PM, 11:30 PM

PML Email Example:

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Dear Store Team,

To keep you updated on the status of the interactive displays in the Electronics department, below is a high-level recap of the visit conducted by

BDSMktg Rep: Aaron
Store: #891 in Galesburg, IL
Date: 09/13/2022
Time: 4:16 PM

It is our goal to work towards ensuring the interactive displays in the Electronics department are fully functional and to keep you updated on our progress.

Display fixes:

None at this time

Class 94 Displays that are Out of Stock in the Target IW

None at this time

Parts On Order

Fitbit - 4ft Inline Display (2020) - Versa 2 Black - Product Stand
Fitbit - 4ft Inline Display (2020) - Luxe White Band
Fitbit - 4ft Inline Display (2020) - Luxe Black Band
AX5687 - Google Pixel 6a - Phone/Tablet Security Kit Full
Bose - 4ft Galaxy Display - Security Lanyard (HP700 & Frames ONLY)
LG - Waterfall Soundbars - Complete Display (008-94-7712)
Fitbit - 4ft Inline Display (2020) - Versa 2 Black Band
Connected Living - Amazon Gollum Echo (056-94-5159)
Connected Living - Amazon Echo Show 5 Gen2 (056-94-0373)

Parts Ordered, But Out of Stock

Heyday - 2' Speaker Listening Station - HeyDay Cylinder Speaker (Black) - ETA unknown. In stock date not yet provided to BDS.
Unlocked Phones - Nokia G20 (Live) Demo Unit - ETA unknown. In stock date not yet provided to BDS.

Number of Previously Missing Displays Set by BDS

None at this time

Additional Displays That Need The Assistance of Store Teams or PML

None at this time

TV Inspections

None at this time

Display Presence and Functionality

The attached spreadsheet provides a display level breakdown of presence and functionality for this location. The display assortment represented on this spreadsheet is based on information provided by Target Corporate.

Please note that if any projects were completed in your store, this email does not reflect any updates relevant to those projects. If you have any questions or would like further details, please reach out to your BDS rep, their field manager or the BDS Target Support Center at 888-581-9124 or Target.support@bdssolutions.com

*Please note that BDS is responsible for display parts ordering and placement once received. The parts shipping/delivery is handled by Target Corporate and each brand or their supply chain partner.

Thanks,

The BDSMktg Team

----------------------------------------------------------------------------------------------------------------

Below is a sample of an email attached spreadsheet Store Status Report.CSV to show the store's presence and functionality compliance by department and store.

Department Display Present Functional Contract Mobile (D255) LG CV1 - DPCI 080-94-0217 No No Contract Mobile (D255) Otterbox Display - DPCI 080-94-0150 Yes Yes Imaging & Office (D56) Panasonic TS25 - DPCI 056-10-1020 Yes Yes Imaging & Office (D56) Nest Display - Display DPCI 056-94-0131 Yes Yes Imaging & Office (D56) DJI Mavic Pro Drone - Display DPCI 056-94-0047 No No Portable Electronics (D57) Amazon 8" Tablet (E&E) - DPCI 056-94-0137 Yes Yes Portable Electronics (D57) Amazon Kindle Paperwhite (E&E) - DPCI 056-94-0010 Yes Yes Target Ad Hoc Tile Pro Sport V2 - DPCI 056-94-0170 Yes No Target Ad Hoc Ecobee3 Lite Thermostat - DPCI 056-94-0264 Yes No Telecomm (D262) Comcast (Xfinity) - DPCI 262-94-0007 Yes Yes TV & Home Electronics (D8) TCL 55” 4K HDR 120HZ Roku Smart - DPCI 008-09-0803 (USB Content) Yes No TV & Home Electronics (D8) TCL 49” 4K HDR 120 HZ Roku Smart - DPCI 008-09-0275 (Red Channel) Yes Yes Video Games (D207) Sensors Alive 2’ STEM Display - Display DPCI 207-94-0058 Yes Yes Video Games (D207) Kano 2’ STEM Display - Display DPCI 207-94-0009 No No Video Games (D207) Cozmo 2’ STEM Display - Display DPCI 207-94-0061 Yes No Video Games (D207) Starlink 2' STEM Display - Display DPCI 207-94-0072 Yes Yes

--------------------------------------------------------------------------------------------------------------------

PML Email Rules

Emails are sent out within 30 minutes after visits completed. A call form for a visit must be in completed status before an email is sent to the store.
Both the PML and PMBP for a store are emailed for each visit.
Display Fixes
1. Information in this section is from the Target Continuity Call form in i:c. This call form is filled out for each store visit.
2. The i:c item is listed with what was fixed.
3. Example: Bose Express Store Display - Display DPCI 008-94-0047 - sound
Class 94 Displays that are Out of Stock in the Target IW
1. This section lists the parts that are not functional or not displayed at the store and out of stock in the Target IW.
Parts On Order
1. This section lists the Partner - Part
2. The Parts listed were ordered during this store visit or previous store visits and have Account Team Approval.
3. Part Orders do not drop from this list until they are placed by the field rep.
Parts Order, But Out of Stock
1. This section lists the Partner - Part - Stock Status - ETA Date - ETA Comment
2. These orders have not been Account Team Approved because Out of Stock parts cannot be approved
3. The Stock Status, ETA and ETA Comment are populated from the Part details
4. If no ETA date is populated in the Part record "unknown" is displayed
Number of Previously Missing Displays Set by BDS
1. Data come from Target Continuity Call form Question ID 457390.
2. Previously answered number of Missing Displays at this store.
Additional Displays That Need the Assistance of Store Teams or PML
1. Data come from Target Continuity Call form Question ID 457392
2. Previously answered number of Additional Displays that need assistance at this store.
TV Inspections
1. Data come from Target Continuity Call form Question ID 474379, 474376
2. Answer choice text is:
  1. Choice 721703 then 'Number of Inspected TVs to be Returned to the Sales Floor
  2. Choice 721704 then 'Number of Inspected TVs to be CRC (Central Return Center)
  3. Choice 721702 then 'Number of TVs with no defective label present
Display Presence and Functionality
1. This section is a summary by department of the display presence and functionality shown in a grid.
2. There is also a detail report attachment in .csv format that shows the same information in detail by product.
3. The .csv file is in the following format - Stocks.csv.

PML Email Address List - Update Process

There are standard and adhoc email addresses sent the PML email for a particular Target store. The standard email addresses are added every time. The Ad Hoc email addresses are sent based on an uploaded file in the documents section of i:c on the Merchandising Team.

Standard Email Addresses
There are two standard email addresses send PML emails for a specific Target store

PML Email - a standard email address for each store consisting of T + store number + @target.com
Electronics Department Email - a standard email address for each store consisting of T + store number + electronics + @target.com

Ad Hoc Email Addresses
Email addresses which are not standard for a particular Target location can be included using the Ad Hoc process.

Schedule

The PML Email list is updated 7 days a week, twice a day at:

12:30 PM (PST) - for PML emails sent in the afternoon
7:00 PM (PST) - for PML emails sent in the morning

Process

Email addresses to include in the daily PML email process, need to be uploaded in a standard format to a document folder in i:c. Once uploaded the update process runs on the Schedule to include only the email addresses on the list. The list uploaded therefore need to be comprehensive because the old Ad Hoc list is deleted and the new list is now the standard. PMBP email addresses should be included in the Ad Hoc list because their email addresses are not standard.

Login to i:c and click on the Merchandising Team
Next navigate to the Documents section
In the documents section click on the folder - Target PML Email List
Download the PMT.txt and add the store, district and email information.

Each email address should be on its own row.
The 3 column names are delimited, the data needs to follow the same formatting as the headers.
The same store number can be entered more than one time in a file to include multiple emails addresses for a store.

Delete the old file in the Target PM: Email List folder.
The new file needs to be saved as a .txt file format.
Reopen the saved txt file to double-check. Make sure that all columns are populated separately.
Next upload the new email list to the Target PML Email List documents folder.

Note

The person who uploaded the file is emailed a notification if the uploaded file is invalid (file type, column errors or bad data)
The file name should remain - PMT.txt
The workbook name should remain PMT
The file will not process unless it has as a minimum store and Email columns
No spell checking will be done, the emails will be send as is in the file

PML Email Store Status Attachment Report

This CSV attachment report shows display presence and functionality of items in the store after a visit completed based on selected item question answers

The attachment report is just for the specific store in the PML email only.
The Library Question IDs used for the report are 493, 496, 506, 501, 505, 541, 512, 500, 510, 500, 513, 514, 499, 515, 516, 511 , 504, 530, 529, 507
The report does not include items in the categories: Target Ad Hoc and Target Continuity Non-Interactive Audit
There are specific items that the Target requested not to populate in the report. They are maintained in a table named dbo.tblPMTEmailItemExclusion

Target Internal Warehouse (IW) Out of Stock and ETA - List Update Process

Target fulfills many of the parts using their internal warehouse. In order for the PML email to include the ETA of when those parts would be available the data needs to available for the creation of the PML email process.

Schedule

The Target IW data is updated 7 days a week, twice a day at:

12:30 PM (PST) - for PML emails sent in the afternoon
7:00 PM (PST) - for PML emails sent in the morning

Process

Targets internal warehouse out of stock ETA information is recieved via email and uploaded to i:c to make it available for the PML email. Once uploaded the update process runs on the Schedule to include only the parts that are not functional or not displayed

Login to i:c and click on the Merchandising Team
Next navigate to the Documents section
In the documents section click on the folder - Target PMT Email List
Download the IWOH.CSV and add the store, district and email information.
1. ItemID
2. ETA (date 12/12/2018)

There are two columns on the file

Delete the old file in the Target PMT Email List folder.
The new file needs to be saved as a .csv file format not Excel.
Reopen the saved csv file to double-check. Make sure that all columns are populated separately.
Next upload the new list to the Target PMT Email List documents folder.

Use of Data

On the Display Presence and Functionality (Stocks.csv) attachment if there are any items that are not on display or not functional then lookups needs to occur
The lookup process checks the Target IW data to determine if the part is out of stock in the Target IW data.
The lookup then puts the ETA information both in the body of the email and the Stocks csv.

PML Email Parts Approval - Optional

There are parts which the PMLs want to approve before they are ordered. If a partner is marked as needs parts approval by IT then all parts by that partner will need client approval before they move through the Account Team Parts Management Queue.

On the PML email in the Parts Ordered Awaiting Approval section a link is available to take the PML to the Parts Approval screen in i:c.

Parts Ordered Awaiting Store Approval - Click here to Approve Parts

MTI - MTI - AX6864 - VHB, SENSOR, POWERED SCREAMER, CORE II
MTI - MTI - AX6114 - EE/LAPTOPS/MTI LAPTOP SECURITY TETHER
MTI - MTI - AX6114 - EE/LAPTOPS/MTI LAPTOP SECURITY TETHER
MTI - MTI - AX6114 - EE/LAPTOPS/MTI LAPTOP SECURITY TETHER
MTI - MTI - AX6114 - EE/LAPTOPS/MTI LAPTOP SECURITY TETHER

The Parts Approval screen has a list of all of the parts that need to be approved or rejected for a particular Target store.

The PML need to do the following:

Enter email address
Bulk Process - Click the check box next to the parts to approve. Click the Approve All Checked button.
Single Process - Click the Yes or No link for each of the part on the list

Yes - part is approved and removed from the list
No - part is not approved and user is required to enter text why it was rejected