Stop Sale - Marlin 4, 5, 6, and 7 Head Tube MY26-27

Written By Kristina Florin (Collaborator)

Updated at October 13th, 2026

Table of Contents

Before You Begin System setup Create Ascend Work Order Ascend Queries Contacting potentially affected customers Display the number of impacted bikes you have in stock Reporting

Before You Begin

Ascend makes it easy for you to manage recalls and contact customers who may be impacted. For full details on this recall, visit the B2B article on TrekBikes.com. Not all bicycles within these models are included in the stop sale.

System setup

Create 1 Non-Inventory Labor SKU: MARLINHTR2026 for tracking within your Ascend database:
1. Labor – Marlin Head Tube Recall MY26-27
  - Description: Labor – Marlin Head Tube Recall MY26-27
  - BRAND: Trek
  - UPC: MARLINHTR2026
  - Keyword: Marlin Head Tube Recall MY26-27
  - SKU: MARLINHTR2026
  - Category: Labor
  - Manufacturer’s Part Number: MARLINHTR2026
  - Estimated Cost: $0.00
  - MSRP: $0.00
  - Non-Inventory: Checked
  - eCommerce: Unchecked

Create Ascend Work Order

Create a Work Order for the customer.
Add the non-inventory Labor SKU noted above (MARLINHTR2026) to the work order.
Follow the B2B article guidelines on how to receive your rebate for the bike build labor.

Ascend Queries

You will be receiving an email from Trek with bikes shipped to you. You can use the queries below to discover which customers bought them and if you still have any in stock.

If you are unfamiliar with how to run a query in Ascend, check out our article, Reporting - How to Run a Custom Query.

Contacting potentially affected customers

Copy this query:

SELECT DISTINCT Sales.ID
	,[Customer]= Customers.FirstName+ ' ' + Customers.LastName
	,[Phone] = SUBSTRING(Customers.Phone, 1, 3) + ' ' +
                 SUBSTRING(Customers.Phone, 4, 3) + ' ' + 
                 SUBSTRING(Customers.Phone, 7, 4)
	,[Email]= Customers.Email
	,[Address]= Customers.Address
	,[Address2]= Customers.Address2
	,[City,State,Zip]= Customers.City + ', ' + Customers.State + ' ' + Customers.Zip
	,[Description]= Products.Description
	,SerialNos.SerialNo
	,SalesItems.Quantity
	,[DateCreated]= SalesItems.DateCreated
	,[Finish Date]= Sales.FinishDate
FROM Sales
	JOIN Customers ON Sales.CustomerID = Customers.ID
	JOIN SalesItems ON Sales.ID = SalesItems.SalesID
	JOIN Products ON SalesItems.ProductID = Products.ID
	LEFT JOIN SerialNos ON SalesItems.SerialID = SerialNos.ID
	JOIN VendorProducts ON Products.ID = VendorProducts.ProductID
	JOIN Vendors ON VendorProducts.VendorID = Vendors.ID
WHERE Sales.Hide = 0
AND Sales.Quote = 0
AND SalesItems.Hide = 0
AND Sales.FinishDate IS NOT NULL
AND VendorProducts.PartNumber IN(
'5336955',
'5336956',
'5336957',
'5336958',
'5336959',
'5336960',
'5336961',
'5336962',
'5336963',
'5336964',
'5336965',
'5336966',
'5336967',
'5336969',
'5336970',
'5336971',
'5336972',
'5336973',
'5336974',
'5336975',
'5337015',
'5337016',
'5337017',
'5337018',
'5337019',
'5337020',
'5337021',
'5337022',
'5337023',
'5337024',
'5337025',
'5337026',
'5337027',
'5337029',
'5337030',
'5337031',
'5337032',
'5337033',
'5337034',
'5337078',
'5337079',
'5337080',
'5337081',
'5337082',
'5337083',
'5337085',
'5337086',
'5337087',
'5337088',
'5337089',
'5337090',
'5337092',
'5337093',
'5337094',
'5337095',
'5337096',
'5337097',
'5337141',
'5337142',
'5337143',
'5337144',
'5337145',
'5337146',
'5337150',
'5337151',
'5337152',
'5337733',
'5337735',
'5341140',
'5341141',
'5341142'
)
ORDER BY
[Customer],
Sales.FinishDate

Navigate to Ascend SQL Query. From the Ascend desktop > Reports > SQL Query in the top toolbar.
Paste the text in the top pane within Ascend Reports > SQL Query.
1. Click Execute.
2. Contact the customers on the list to let them know their bikes may be impacted

Display the number of impacted bikes you have in stock

Copy this query:

Select Products.ID,
[SKU] = Products.[Store UPC]
,[Description] = Products.Description
,[Qty] = Products.Quantity
FROM Products
WHERE Products.Hide = 0
AND Quantity > 0
AND Products.ID IN (Select ProductID From VendorProducts
Where (PartNumber IN(
'5336955',
'5336956',
'5336957',
'5336958',
'5336959',
'5336960',
'5336961',
'5336962',
'5336963',
'5336964',
'5336965',
'5336966',
'5336967',
'5336969',
'5336970',
'5336971',
'5336972',
'5336973',
'5336974',
'5336975',
'5337015',
'5337016',
'5337017',
'5337018',
'5337019',
'5337020',
'5337021',
'5337022',
'5337023',
'5337024',
'5337025',
'5337026',
'5337027',
'5337029',
'5337030',
'5337031',
'5337032',
'5337033',
'5337034',
'5337078',
'5337079',
'5337080',
'5337081',
'5337082',
'5337083',
'5337085',
'5337086',
'5337087',
'5337088',
'5337089',
'5337090',
'5337092',
'5337093',
'5337094',
'5337095',
'5337096',
'5337097',
'5337141',
'5337142',
'5337143',
'5337144',
'5337145',
'5337146',
'5337150',
'5337151',
'5337152',
'5337733',
'5337735',
'5341140',
'5341141',
'5341142'
)))

Navigate to Ascend SQL Query. From the Ascend desktop > Reports > SQL Query in the top toolbar.
Paste the text in the top pane within Ascend Reports > SQL Query.
1. Click Execute.
You can use this list to help guide you to the products you have in the shop.

Reporting

Reimbursements/rebates are issued based on B2B warranty claims. Do not submit Ascend reports to Trek Customer Care. You may reference the reports below for personal use, though they are not needed for the reimbursement process.

To report on coupon redemptions, use the Payments > Coupon Use History report.
To report on work performed, use the Customer or Product Query utility. Article: Reporting - Create Customer and Product Queries

Ascend RMS Knowledge