Merchandiser Duties Handbook

AD Database

Along the top of the worksheet, you will see ten colored “buttons”, each of which has its own functionality

Clicking Ad Item Input is one method of entering Ad Event data. The Input Form helps standardize user’s contribution so it can be accurately stored in the database and viewed by Marketing.

Before discussing individually each tab that resides within the Ad Item Input Form, the bulleted list below is helpful to keep in mind as it pertains to all tabs within the Ad Item Input form:

1. Bold text indicates input is required.
2. Try to input information in Tab order. Some selections on later tabs (like Coop) may depend on what is input on prior tabs.
3. Double-clicking underlined text may be helpful sometimes to auto-populate the input fields.
4. Click the Next button to move to the subsequent tab, or just click the tab you wish to go to.
5. Try to use choices from dropdown boxes. If they do not contain what you need, then you may be able to type it in.
6. The Refresh Dropdown Lists link will repopulate the dropdown boxes if they don’t list something you thought should be included.
7. The Clear All Item Input button clears item-related input, but leaves Event and Department related data.
8. The Close Form button will close the form, but preserve the data you have input; the red “X” button will close the form, AND cause the data to be cleared.

Note that this Ad Item Input Form can also be used to edit existing records (see the section on Editing and Deleting).

9. Once you reach the Coop tab, you have the ability to click a green “Add New Item” button that updates the database with all the entered information. Upon doing so, you should receive a message stating your information was successfully saved to the database. You can then refresh the worksheet contents using the Quick View or Filtered View button to confirm your item was entered.
10. The very last tab (the one with a question mark) is contact information and related links to Ad Database material.

"Basic" Tab

All information on the Basic tab (except for the ‘Submit by’ input) is displayed on the ‘Ad Summary Worksheet’

1. Fill in from top-left to bottom-right. Much of the data will populate itself.
2. TIP: Double-clicking the underlined “Group” header should automatically populate this section with your group information.
3. If the item has been input in a previous event, you can enter the item number and click the “Find” button to populate the form.

OR

4. You can double-click the blank “RIN/Item List” box to populate the form with whatever item is currently selected in the worksheet.
5. When importing data from prior events, be sure to correct any fields that changed, such as Event, Week, etc.
6. Question-Mark buttons can be clicked if to signify “Various”.
7. The TBD (To Be Determined) item option can be clicked if you currently do not know the Item List or RIN number.
8. Advertising Items at “Subclass”, “Class” and “Dept” level is now available in addition to RIN and Item List.
9. If a yellow highlighted message displays saying “This Event Is Locked”, you will not be able to successfully input your information. Contact Danielle Edmonson and she may temporarily be able to unlock the event for you.

"Item" Tab

All information on the Item tab except ‘Past Ad/Like Item’ is displayed on the ‘Ad Summary Worksheet’

1. Page: Enter page number of Ad on which this item will appear. If you don’t know, use the View IMP Doc link, but insure that you’ve entered a week on the Basic tab. This will open the IMP documents for you to see pagination information.
2. Priority: Used by Marketing. Some items may have the same priorities, if they are related.
3. New Item / Web Exclusive: Check the box if true.
4. Pricing Strategy: Select the Strategy that fits your input. Some pricing strategies (YFB in particular) reflect a savings from MSRP as opposed to NEX retail. If selecting Banner input, you must also select Banner on the Price tab.
5. Item Description: Name or short description of advertised item. You can try double-clicking the label to use the RMS Description. Do not use abbreviations. Character counts will let you know if you type in too many characters for that field. This is the gray-shaded number at the top right of each input box. It will turn red if you are approaching max characters.
6. Ad Information: Detailed description of item, which usually appears underneath the Item Description line on the Ad Flyer. Do not include price points or RINs.
7. Past Ad/Like Item: For reference purposes only. You can double-click and have it automatically populate based on the last Ad Like-Item, or add your own input.

"Price" Tab

All information from Pricing and Multi-Buys sections shows on the ‘Ad Summary Worksheet’.

1. Select type of Promo: Based on NEX Price, Based on MSPR, or Banner
2. Fill in all Bolded-text input. Non-bolded input is optional.
3. Select the Change Types:
   $ OFF
   % OFF
   FIXED
   NoChg
4. If Promo is based on MSRP, then enter the MSRP % off first. If based on NEX price, enter the NEX % off first (box below Change Type). Note, if the Change Type is “NoChg” or “FIXED”, then the Amount off will reflect the Advertised Price.
5. Note: selecting No Pricing (Banner) will still allow a % Off to be input.
6. If you are entering an MSRP, then mathematically the NEX and MSRP discounts should reflect the same Advertised price. If it doesn’t, a yellow “Force RPC %” button may appear and allow you to adjust the NEX amount.
7. You can input price ranges or single prices in the price fields. Price Ranges must have a dash separating the range, ie. 25.99 – 79.99.
8. Multi-Buys: Use the available options in the dropdown, if a multi-buy scenario is applicable. Then type the details in the Description box.
9. Scandown: You can type in manually or double-click label to automatically populate.

"Qualifications" Tab

All information on the Qualifications Tab is displayed on both the ‘Ad Summary Worksheet’

1. Call Outs: Try to use Marketing’s options for populating this box. If there is no underlined option for your scenario, you can still type it.
2. Disclaimers: Same process as mentioned for Call Outs.
3. Grouping: For items which are to be grouped together in the Flyer, check the “This item is part of a group…” checkbox, and give the group a descriptive name in the textbox below.

"Image" Tab

Everything within the Image Requirements section is displayed on the ‘Ad Summary Worksheet’

1. Image Requirements: If there are imaging requirements, check the option box and describe the method for image delivery using the dropdown box and input box.
2. Tip: For G-Drive, you can double-click the underlined “G-Drive Path”, and it will allow you to select a folder, instead of manually typing it in.
3. Featured RIN: The section should be completed when you are advertising an item that has a specific price point and includes a submitted image (above).
4. Use the Validate Parent RIN button to make sure the Parent RIN is at the Parent level.

"Order" Tab

Nothing on the ‘Order Tab” is displayed on the ‘Ad Sum worksheet. This tab is for user reference only.

1. Order Frequency: Select from
   BAS (AR) – Basic Stock
   BAS (QOE) – Basic Stock
   OTB – One Time Buy
   SEAS – Seasonal
   SQOH – Stock quantities on hand
   OTH – Other
2. Order Multiple: Case, Pack information.
3. General Comments: You can type whatever notes you want here.
4. Shipper RIN:
5. Shipper Description:
6. Shipper Cost:

"Coop" Tab

1. If Coop information has previously been entered for a particular DUNS/Department combination, then this tab should update automatically. You just need to double-check the information and update the Coop amount.

REPLICATE ITEMS

The other method of adding items is by clicking the Replicate Items button. This method allows you to duplicate one or more items that were previously input. This is helpful if you are advertising the exact same items from a previous event. To use, just highlight any cells from any number of previously entered items and then click the Replicate Items button. A form will display allowing you to enter the new week and Event information.

QUICK VIEW

Use the Quick View button to refresh the worksheet with the latest data available. Quick View will by default, refresh the worksheet based on settings from the last time Filtered View (discussed next) was used.

Once data is displayed on the worksheet, blue underlined column headings can be double-clicked to sort the data.

FILTERED VIEW

The “Filtered View” button provides options for filtering the ad information that gets displayed on the worksheet – for example, you can view subtotals, filter records by Department, DMM, GMM, etc. You can also search specific columns for items with text matching your input.

1. To display all available weeks, leave the selection on “Week”.
2. You can click My Items to view all items that you have input. This is useful if you can’t find something that you know was input.
3. You can click Refresh to reset the dropdown boxes. This is useful, when you feel like records you think should be showing, are not.
4. Tip: Do not over filter. For example, you don’t need to filter on Buyer, if you are filtering on Dept. Department is preferential to Buyer, as the buyer is likely to change.

SELECT COLUMNS

Clicking the Select Columns button allows you to customize which columns are displayed on the worksheet -- for example, Advertising may not want to hide Coop information. Arrow buttons allow you to manually add or remove columns from the view. You can also create and use Predefined Views.

EDIT & DELETE

The Edit & Delete buttons allow you to make changes to the data either via the Input Form (yellow button) or, by directly editing the cells on the worksheet (orange button).

1. Use the yellow Edit (Form) button to edit data via the Ad Input Form. Before clicking the button, make sure you have selected a worksheet cell from the item that you want to edit.
2. Tip: after updating via the Form Method, it is recommended, in order to actually see the changes, to update the worksheet by clicking the Quick View button.
3. Use the orange Edit (Worksheet) button when you want to make updates directly from the worksheet itself. Simply edit the data on the worksheet, highlight the edited cell(s), and then click this button.
4. Tip: Use the Worksheet method of updating when you want to update multiple items at once. The Form method only updates one inputted item at a time.
5. To delete an ad item, simply select any cell(s) or row(s) from the worksheet, and then click the Delete button.
6. If you are not the originator of the item listing, it will prompt you for confirmation before deleting or editing, so as to help prevent accidentally messing up other people’s input.
7. A record of updates and deletions are kept, so if you have any questions it can be researched. If you accidentally delete records, they may potentially be retrieved from a backup. Just contact Jack Fyfe.
8. Tip: A cutoff date may prevent the item from being updated (or deleted) when using the “Form Method”. However, edits can still be made to most fields using the “Worksheet Method”. If it still won’t let you make changes, then Advertising will need to be notified so they can temporarily suspend the cutoff date while your changes are made. All final changes to the ad database must be made between 3 – 4 weeks from the start of the event. The database will be unlocked during this timeframe. Any changes after the lock date, will require filling out and submitting a Change Form request, regardless of whether you were able to input it into the Ad Database or not.
9. Backups are created on the Ad Database every few hours. If you’re the lucky person who gets picked for the backup, it can take a little extra time to process your input. If you want to opt out of this possibility, then uncheck the option to create a backup, and you won’t be subject to the backup process.

COOP FORM

With a specific row or rows selected, you can click the Coop Form button to create a Coop Agreement form for that item. (Note, you must have inputted the Coop information earlier using the Ad Input Form.)

1. The Coop image to the right was created by selecting records from the worksheet and clicking the Coop Form button.
2. The Coop form is saved as a separate file to make it easier for emailing.
3. If there is a change to the Coop data, please make the change in the Event Summary Worksheet and not the saved Coop file. If you make the change to the Event Summary Worksheet, a new Coop Form can easily be created and the correct data will be retained in the database.

AD SUMMARY

Clicking the Ad Summary button will create a report that contains the essential item-related information you are advertising for the event. Before clicking the button, be sure to do the following:

1. Filter the data on the worksheet so it contains just the event and items you want to export.
2. Sort the displayed items by the Priority column.
3. Select a range of cells from the worksheet that correspond to the items you want exported.
4. Now you can click the button.

If you have multiple page numbers within the items you selected, the resultant Ad Summary worksheet will have separate tabs for each distinct page number.

See Saved Settings for other factors that may affect the output of the data on the Ad Summary Worksheet.

RPC FORM

Clicking the RPC Form button will populate the Simple Promo Induction Form that can be submitted to the START group. Select a cell or cells in the View worksheet that you wish to export and then click the “RPC Form” button. If one cell is selected, all items with the same Week and Group in the current view will be included in the report. If a range of items are selected, all items in that selected range will be included.

SAVED SETTINGS

Clicking the Saved Settings button will display options you can tailor to your preference. These settings are saved in a separate file on your PC in the same folder you saved the Ad Database worksheet.

View Sheet

1. “Prompt if viewing more…” Sets max number of records to view. The more records, the longer it takes.
2. “Include Buyer as index…” This is a sorting preference. Check if you want the Buyer included as primary key.
3. Sort records by Priority…” This option uses the Priority field as the primary sort key. Check if you want items returned in Priority order.
4. “Automatically hide columns…” Hides redundant columns (such as Week and Event) to save space when printing.
5. Reset Column Formatting… Occasionally formatting may get messed up (ie. dates not displaying as dates). This will correct the issue. It takes about a minute to run. Be sure to save the Ad Database file after running.

Ad Sum Worksheet



6. Prompt if Number of Exported Items: Helps to prevent mistakenly retrieving too many records (which would take a long time).
7. Append RNI # to Vendor Style… – An Item’s RIN will be appended to the Style number, so it shows on the Ad Flyer.
8. Append Item List # to Vendor Style… – Item List #s will be appended to the Style number, so they show on the Ad Flyer.

Coop Sheet



9. Various options allowing you to select what to display on the Coop sheet.

RPC Form



10. Restrict Exported Items: will cause only the currently selected department to be exported to the RPC form (as opposed to the whole Group). If a range of cells are selected, then, this option is ignored.
11. Sort by Priority: self-explanatory
12. Enter Buyer Number: Number will display on Simple Promo Form.

Asset Worksheet (Put Items on the Web)

Open

Send worksheet to vendor so they can fill out information for columns J-U

Get link to images. Images must be named according to parent rin followed by color code.

Case Pack Change

1. Navigate to 'Items'

2. Navigate to 'Download Items From RMS'

3. Type in 'Item' or 'Item List' and download it
4. Open the file and edit the following as needed:

"Item_Master" Tab

AH
Store Order Multiple
Inner Pack

"Item_Supplier_Countries" Tab

H	I
Suppler Pack Size	Inner Pack Size
1	1
1	1

Send to DST when changes are made.

Change Forms

Workfront Change forms

Process:

1. Enter RIN 149***** at $** OFF in the Ad Database as normal
2. Generate an Ad Sum for EACH WEEK that you're submitting
3. Go to "filtered view," filter to the week you're working on, select the row with the RIN, and click the "Ad Summary" button (blue)
4. The filename MUST match the one attached. Advertising will it back if it doesn't
5. In WORKFRONT, go to the Requests tab and click New Requests, then fill out as below:
6. Request Type: Change Forms
7. Subject: Change Form – WK13X Home and Wearable Technology (MUST match naming convention)
8. DMM:
9. Category:'Electronics - Home and Wearable Tech'
10. Week: whichever week you're working on
11. Event: whichever event you're working on
12. Type of Change: Add Item(s)
13. Description of Items to Add: Example:
    AirPods Pro 2
    Parent RIN: 14988183
    Model #: MTJV3LL/A
    Reg Price: $244
    Sale Price: $164
    Save $80
14. Reason for Change: Promotion/Sales Opportunity
15. Under Documents, attach the Ad Sum and images for item

Communication Request

Communication request Template

1. Fill out information in form.

Hitting submit will pull up the email to the communications team with the form.

Cost Changes

Cost Change Template

1. Fill out template.
2. Upload template into V16.

1st tab

2nd tab

Upload cost change into V16 under:

Fact Tags

Creating New Fact Tags

Navigate to: G:\Code_M\Code_MG1\CT Jason Wilmoth\Consumer Tech Fact Tags

1. Navigate to your respective teams fact tag tab
2. Fill out information for new fact tags
3. When finished, click the "Email Fact Tags" button in the top left. This will generate an email with the template to the sign team.
4. After, go to 'Master' Tab and click 'Update Master' button

See fact tag examples below:

Copies	Template	UPC	ItemID	Model	Name	Description	StartDate	StopDate	UserDefined	SalePriceType	RegPrice	SalePrice
1	5X3FACT	19513316086 Sale $439.99 Acer Aspire 3 15.6" Laptop 15.6" FHD Display Intel Core i5-1235U 8GB DDR4 SDRAM 512GB NVMe SSD Intel Iris Xe Graphics Reg. $539.99 A315-59-54P3 14779561 03/03 - 03/09 1 9513316086 5	14779561	A315-59-54P3	Acer Aspire 3 15.6" Laptop	15.6" FHD Display//Intel Core i5-1235U//8GB DDR4 SDRAM//512GB NVMe SSD//Intel Iris Xe Graphics	3/3/2024	3/9/2024	Sale	Sale	$539.99	$439.99

Copies	Template	UPC	ItemID	Model	Name	Description	StartDate	StopDate	UserDefined	SalePriceType	RegPrice	SalePrice
1	7X5FACT	24052806541 Even Lower Than Advertised $999.99 simpl by Ashley Arroyo Sofa Chaise Caramel faux leather upholstery Exposed modern tapered legs Loose cushions, reversible chaise cushion Minor assembly (simply attach legs) 82" W x 57" D x 33.5" H 89401-18 14423151 03/03 - 03/09 2 4052806541 3	1.4E+07	89401-18	simpl by Ashley//Arroyo Sofa Chaise	Caramel faux leather upholstery//Exposed modern tapered legs//Lo...	3/3/2024	3/9/2024	Sale	Lower Than Advertised	$999.99	$799.99

Copies	Template	UPC	ItemID	Model	Name	Description	StartDate	StopDate	UserDefined	SalePriceType	RegPrice	SalePrice
1	5X3FACT	81009797015 Clearance $29.95 Nutribullet 52 oz. Magic Mini Juicer 400-watt motor extracts all the nutrition from your favorite fruits and veggies. 52 oz pulp bin allows you to juice more produce with fewer interruptions. Comes with a 16-oz cup with a twist on lid. Reg. $44.99 NBJ10100 14646708 03/03 - 03/09 8 1009797015 3	1.5E+07	NBJ10100	Nutribullet 52 oz. Magic Mini Juicer	400-watt motor extracts all the nutrition from your favorite fruits and...	3/3/2024	3/9/2024	Sale	Clearance	44.99	29.95

Promotional Fact Tags

1. Navigate to "Sale Master" Tab
2. Fill in RINs on ItemID Column
3. Information should automatically fill into other columns
⚠
If information does not automatically populate:
The Fact Tag hasn't been created
The Fact Tag has not been populated to the 'Master' tab

4. Fill in information for Start/End date columns & Reg/Sale Price columns
5. Click blue 'Export To Sign Team' button
6. Fill in requested information and email template will be generated

Frustrated Freights

LINK  |  StoreManagementUtility Download

Open the SMU

From 'Report' Select 'Group - Open Issues'

Select 'Group #'

Select Output Typle and Select 'Excel Workbook'

Item Inductions

Download the "Item Induction Template" and "Item Induction Template Assistant" from the Templates Page

1. Fill out Template.
2. Run through Item Induction Template Assistant
3. Send to DST datastewardteam@NEXWEB.ORG
4. Ask DST to serialize high ticket items.

See Example below:

Item Page:

Location Page:

Item List

OPEN

Save as ODS and upload to Oracle

Item List RMS V10

Instructions for submitting RMS10 item list or location list requests to LoadRunner:

• LoadRunner Template for item and location lists can be found at link

There are 3 functions that can be completed via LoadRunner:

• Item List Build — creating a brand-new item list
• Edit Item List — adding and/or removing items from an existing item list
• Loc List Build — creating a brand new location list

Once template is complete, email to ROADS@NEXWEB.ORG.

Item Reclass

Template

Example Below:

Send to DST.

Mail Package

OPEN

See example below:

Promotion Template

Promotion DOF Macro

See below example:

PO's

Purchase Order Template

1. Fill out template
2. Click populate template
3. Save as ODS file
4. Upload file to Oracle: Orders > Upload Orders from File

Send orders over $5000 to financial planners for approval

Price Change

Price Change Template

Fill out price change template and send to pricing team: pricing@NEXWEB.ORG

See example below:

Person of Contact

Quick Reference Guides

Quick Reference Guides Link

Ranging Items

Serialization

Store Order Multiple (SOM) Change

1. Find and click on item in RMS. (Example: Item 14738778 – j5create USB-C to 4K HDMI cable Gray)
2. Find More Actions and click on Locations.
3. Find More Actions again, click on Mass Change, then Location Attributes.
4. Click "+" then select "All Locations" or whichever is applicable. You may just want warehouses. Click "OK".
5. Find "Store Order Multiple" on the right panel and change to the desired outcome.
6. Select Save and Close.

SQL (Structured Query Language)

Basic syntax: SELECT column1, column2 FROM table_name WHERE condition GROUP BY column1 HAVING condition ORDER BY column1

Simple Select Statement:

WHERE clause — used to filter rows based on conditions:

ORDER BY — sort results:

Vendor Allowances

Vendor Allowance Database

1. OPEN RDW QUANTISENSE: https://microstrategy.nexad.nexweb.us/MicroStrategy/asp/Main.aspx"

2. Search 'Vendor Allowance - Item (w/o EOH) Gross Sales'
3. Select dates of promotion
4. in '2. Product' click "Item" then under "Search For" paste all item numbers and move over to right side "Selected" box
5. Bottom left "Run Report"
6. Export Report



1. Open "Vendor Allowance Database"
2. On 'Item Credit' tab select 'Get Items & Chargeback Header'
3. Load report from RDW





4. Select Correct Vendor DUNS
5. Select Vendor POC and EMAIL
6. Click "Get Items Now"





7. Fill in item credit for each item
8. When finished click "Input Chargeback Info"





9. Fill out Start & End Dates
10. Select "Margin Assistance"
11. Select Authorization Document
12. Fill out Notes as shown
13. Verify "Distro Total" looks correct
14. Submit to Database




Export Chargeback PDF

1. Go to View Tab
2. Click "View CBs/Invoices" button and filter information






3. Copy CB Number





4. Go to "CB" Tab
5. Select "Select & Print"
6. Paste in CB Number
7. Select "Update View"





8. Window will populate select "Print This Record to PDF"





9. From here "Save As" document to Team Folder




Email Chargeback

Report to DMM

1. Navigate to:
   \\nexad.nexweb.us\HQ\Code_All\Code_M\Code_MG1\Group 257\Chargebacks\2026 CHARGEBACK FOLDER
2. Open Chargeback Tracker
3. Click "Pull Data" Button
4. Screenshot and Email to DMM

Reach out to Ryan Gray if you want it built for your specific team

VADB POC List

Here

Search:

✕ No matching vendor directory items found.

DUNS	VENDOR NAME	BRAND	POC	NOTES
2725	INGRAM MICRO	Apple (Cofunding, Sales Incentives)	*	ONLY for cofunding and sales incentives, NOT monthly Apple claims. For cofunding, submit as Invoice, then convert to CB when funding is finalized.
7948	SAMSUNG ELECTRONICS AMERICA	Samsung (Wearables, Tablets, Buds)	samsungclaims@mssco.com
501165	VOYETRA TURTLE BEACH, INC.	Turtle Beach (Peripherals, SIM Accy's)	carriel@smpsales.com
502378	D&H DISTRIBUTING CO. (WEB)	Lenovo, LG, Microsoft (drop ship)	ppnotice@dandh.com	claim web AND in-store DUNS if both are present on the RDW report!
503870	GARMIN INTERNATIONAL (WEB)	Garmin (drop ship)	jcohen@ussalescorp.com	double-check offers from Garmin - some TCs may be drop ship ONLY, or may have different claim amounts to the in-store offers.
504865	CENTON ELECTRONICS INC.	Centon	jennifer@ivcsr.com
504969	LIGHTHOUSE FOR THE BLIND (F)	Falcon Air	kpolinski@robertjuryassociates.com	* DO NOT claim through DUNS 150582500. This DUNS number is for our dept and has different TPA agreements.
491946	INGRAM MICRO	Epson, Sandisk	*	DO NOT CLAIM LOGITECH THROUGH INGRAM.
791120	D&H DISTRIBUTING COMPANY	Asus (monitors ONLY), Cooler Master, CLX, Fitbit/Google, Lenovo, LG, Microsoft, Mobile Pixels, MSI	ppnotice@dandh.com	claim in-store AND web DUNS if both are present on the RDW report!
9122532	HP, INC	DO NOT USE	DO NOT USE	for claims directly to HP, use dummy DUNS 999999953.
2076501	BRAINSTORM CORPORATION	Skytech	danielcalderon@skytechgaming.com
4687184	AMERICAN FUTURE TECHNOLOGY	iBuyPower	joshua.bejarano@ibuypower.com
51492901	ICE SERVICES LLC	Laut, Spigen	theresa.gapero@icemobility.com
51983567	WESTERN DIGITAL CORPORATION	Western Digital/WD, Sandisk Hard Drives	Abigael.McShane@wdc.com	these are INVOICES, not CBs
60704780	APPLE INC.	Apple (Monthly Claims, Price Protection)	*	ONLY for monthly claims and price protections, NOT cofunding or sales incentives. Submit as INVOICES.
66655143	C R MCMULLEN CO, INC.	Zagg	kpolinski@robertjuryassociates.com
68073601	DEAL RISE LLC	Ultrahuman	kevin.oneill@powerplayretail.com
78887436	PHONESUIT INC.	Phonesuit	accounting@phonesuit.com
80341941	ZEPP NORTH AMERICA, INC.	Amazfit	jennifer@ivcsr.com
89144831	SPA, LLC	Razer, SteelSeries	amy.allen@softpack.com	Razer product may populate with Synnex DUNS - manually change it to SPA in the RDW report before importing into VADB.
111264784	SPECULATIVE PRODUCT DESIGNS	Speck	Kate.Freeman@speckproducts.com
112375758	TD SYNNEX CORPORATION	Acer, Asus (Hardware), Amazon, HP, Dell/Alienware, Toshiba, HyperX	navyclams@tdsynnex.com	~ Alienware product has a SELL-IN incentive - for every unit we BUY, we get a credit. Shannon will provide these credits on a ~30 day delay. ~ Synnex will sometimes offer credit through Qualcomm, AMD, etc. Claim these through Synnex only if directed by disti. ~ DO NOT use DUNS 186542296. This is outdated. If something populates with the old DUNS number, manually update it in the RDW report before importing into the VADB.
150582500	LIGHTHOUSE FOR THE BLIND	DO NOT USE	DO NOT USE	this DUNS is for other departments, our DUNS (504969) has different TPA agreements
186542296	TD SYNNEX CORPORATION	DO NOT USE	DO NOT USE	this DUNS is no longer valid for TD Synnex
205547750	SOLUTIONS 2 GO	Playseat, Thrustmaster	showard@solutions2go.com
791288004	GARMIN INTERNATIONAL INC.	Garmin (in-store)	jcohen@ussalescorp.com	double-check offers from Garmin - some TCs may be drop ship ONLY, or may have different claim amounts to the in-store offers.
828766738	LIFEWORKS TECHNOLOGY GROUP LLC	iHome	kpolinski@robertjuryassociates.com
962930934	KAIJET TECHNOLOGY INTL INC.	j5create	peter@fildermanforward.com
965642440	GIGASTONE	Gigastone	gwen.yu0530@gmail.com
999999934	Microsoft	Microsoft (direct claims Only)	v-colwalters@microsoft.com	for direct claims ONLY - use as directed. Usually for sales incentives.
999999953	HP, INC (NOT IN LAWSON)	HP (direct claims ONLY)	richard.golden@hp.com	only use this if directed - regular claims go through Synnex. Usually for check clears.
999999955	LOGITECH (Not in Lawson)	Logitech (ALL)	amr_claim_backup@logitech.com; cschlegel@mssco.com; jon.barber@mssco.com	also copy Chase Schliegel and Jon Barber. DO NOT claim Logitech through Ingram. Their invoices must be submitted as invoices directly to Logitech.
999999997	INTEL (Not in Lawson)	Intel (direct claims ONLY)	leonard.pienta@intel.com	for direct claims ONLY - use as directed.
999999999	ADVANCED MICRO DEVICES, INC	AMD (direct claims ONLY)	*	for direct claims ONLY - use as directed.

Website URLs

Who Can Help?

Link

Consumer Tech Specific