Summary
The call framed improving execution and pro momentum against sharper DIY pressure, with second-half actions supporting reaffirmed annual targets.
- 200 bpsMain Street pro growth exceeded total pro by more than 200 basis points, while national-account pressure should halve in the second half.
- DIY weakness intensified late in Q2 as constrained budgets, deferred projects, weather, and commodity-driven pricing pressured transactions.
- Operational KPIs improved materially, and supply-chain initiatives provided greater confidence in future productivity gains.
Guidance
- 2%FY26 comparable sales growth 1–2%.
- 4%Second-half operating margin 3–4%.
- 45%Second-half gross margin 44–45%, with Q3 above Q4.
- 3%Second-half same-SKU inflation approximately 3%.
- 2026 market hub openings 15–20 locations.
- Year-end market hubs 50 locations.
- Mid-2027 market hubs 60 locations.
- 7%Medium-term adjusted operating margin target 7%.
What analysts pressed on
- 01Main Street pro momentum: transactions and growth are outperforming total pro as assortment, service, and market hubs improve.
- 02DIY recovery: management cited value offerings, rewards, paid search, and better conversion, but retained back-half pressure.
- 03Gross-margin bridge: mix, freight, and fuel create headwinds, while merchandising initiatives remain strong.
- 042027 margin expansion: management reaffirmed the 7% target but declined to provide specific next-year guidance.
- 05Capital allocation: excess cash will fund operations first, then opportunistic debt retirement before maturity.
- 06Customer acquisition: management said new and existing Main Street accounts are both contributing, without quantifying their split.
Notable disclosures
- National-account pressure should be approximately half as large in the second half versus the first half.
- Q3 market hub openings will total nine, taking the network toward 50 locations by year-end.
- 25%25% of identified distribution-center process improvements were completed during Q2.
- 70%Transportation rebidding targets 70% fewer carriers and tens of millions in 2027 savings.
- Greenfield market hubs are outperforming conversions because better retail locations generate additional sales.
Risks raised
- DIY pressure is expected to persist in the back half despite improving post-quarter trends.
- Approximately 100–150 basis points of Q2 comparable-sales pressure came from consumer, project, and weather factors.
- Higher freight, fuel, commodity costs, and channel mix remain second-half margin headwinds.
- Q4 operating margin faces approximately 20 basis points of pressure from the 53rd week.
- National-account optimization continues to reduce pro sales while Main Street relationships develop gradually.
Tone: Mildly positive 0.35
Strategic execution, pro momentum, positive cash flow, and margin initiatives offset weaker DIY demand and persistent consumer and cost pressures.
Who spoke
Company
- Lavesh HemnaniInvestor Relations
- Shane O'KellyChief Executive Officer
- Ryan GrimslandChief Financial Officer
Analysts
- Steve ForbesAnalyst, Guggenheim Securities
- Simeon GutmanAnalyst, Morgan Stanley
- Michael LasserAnalyst, UBS
- Unidentified AnalystAnalyst, Citi
- Brett JordanAnalyst, Jefferies
Full transcript
Analyst questions are marked with a bar. Timestamps are into the recording.
Prepared remarks
Welcome to the Advanced Auto Parts 2nd Quarter 2026 Earnings Conference Call.
Lavesh HemnaniInvestor Relations
I would now like to turn it over to Levesh Hemnani, Vice President, Investor Relations. Good morning and thank you for participating in today's call. I'm joined by Shano Kelly, President and Chief Executive Officer and Ryan Grimsland, Executive Vice President and Chief Financial Officer. During today's call, we will be referencing flights which have been posted to our Investor Relations website.
Before we begin, please be advised that management's remarks today will contain forward-looking statements, all statements other than statements of historical fact are forward-looking statements, including but not limited to statements regarding initiatives, plans, projections, goals, guidance and expectations for the future. Actual results could differ materially from those projected or implied by the forward-looking statements. Additional information can be found under forward-looking statements in our earnings release and risk factors in our most recent form 10K and subsequent filings made with the SEC.
Shane will begin today's call with an update on the business and progress on our strategic priorities for 2026. Later, Ryan will discuss results for the second quarter and provide an update on the guidance for full year 2026. Following management's prepared remarks, we will open the line for questions.
Now, let me don't know the call to our CEO, Shano Kelly. Shane.
Shane O'KellyChief Executive Officer
Thank you, Levesh, and good morning, everyone. I would like to start by expressing my appreciation for our frontline team, for their hard work and dedication to serving our customers. During the second quarter, the team navigated a volatile demand environment which contributed to a slight decline in comparable sales. This included low single-digit sales growth in the pro-channel, which performed in line with our expectations.
Within pro, the main street business continued to outpace overall growth, supporting share gains in that segment. In the DIY channel, sales declined more than we anticipated, particularly during the last four weeks as tighter household budgets weighed on consumer spending during the quarter. Against this backdrop, the advanced team continued to prioritize actions across our strategic initiatives, which contributed to solid profitability in Q2 with an adjusted operating margin of 5.6%.
Excluding the benefit of IEPA refunds received in the quarter, adjusted operating income margin expanded by nearly 130 basis points to 4.3%. We maintain focus on executing actions within our control, which is translated to sequential improvement in core operational KPIs, including NPS, time to serve, and attachment rates. The second quarter marked an inflection point for advance with a return to positive free cash flow as we generated $120 million year to date compared to an outflow of cash during the last two years.
During the quarter, we also repurchased approximately 30 million of outstanding debt, which along with improved profitability supported further deleveraging of the balance sheet while we continue to allocate more capital to investments to grow the business.
Based on our first half performance and updated projections for the remainder of the year, we are reaffirming our full year sales, operating margin, and free cash flow guidance. This includes comparable sales growth in the one to 2% range, which considers continued spending pressure in the DIY channel, offset by ongoing strength in the pro channel, along with higher same skew inflation due to increased commodity costs.
We are also implementing a focus action plan aimed at strengthening execution across our operational KPIs and driving higher customer engagement to deliver better transaction performance in the second half compared to trends during Q2. Our margin outlook balances the tailwind from recent tariff refunds with incremental headwinds stemming from shifts in channel mix and increased commodity costs. We will continue to prioritize efforts to make progress in our strategic objectives as we work to create long-term value for our shareholders.
Let's turn to an update on our strategic priorities for 2026. Our strategy remains unchanged and is built on three pillars, merchandising supply chain and store operations supported by targeted initiatives to drive sustainable, profitable growth over the long term. We remain committed to executing actions under our 2026 strategic priorities as we make progress in our journey towards a medium term, 7% adjusted operating margin target.
Let's begin with merchandising. We are focused on ensuring reliable product availability, which supports the efforts of our store team to enhance customer service and drive growth in unit sales for transaction. Our newest SORMAND framework launched last year is helping us increase the breadth of parts we carry in each store and broadening availability across our network of DCs, hubs and stores.
Halfway through this year, we have added approximately 80,000 new SKUs to our SORMAND catalog, building upon the 100,000 new SKUs we introduced last year. Through comprehensive category reviews, we are strengthening relationships with existing vendors and identifying opportunities to improve margins, while also partnering with new vendors to further expand our selection of parts. In the near term, our merchandising team is refining communication within the DIY channel to enhance brand awareness and deliver value-driven offerings aimed at increasing customer engagement.
We are collaborating with vendors on targeted media campaigns, leveraging advanced rewards, providing store incentives and optimizing online paid search to stimulate transaction growth and improve conversion in stores.
Moving to an update regarding our pricing and promotions management initiatives, we are on schedule to complete the full deployment of a new pricing framework for both DIY and pro segments by year end. Our pricing philosophy remains unchanged. We aim to offer everyday competitive prices and operate rationally in the market. The new framework is expected to enhance visibility of competitive pricing actions and enables the execution of precise market-based pricing strategies.
The early results from the pro channel have shown an increase in team member and customer confidence, which we expect to support efforts to grow share among main street pros. Alongside the implementation of more sophisticated pricing models, we are also improving discipline around the management of store-based promotional activities. We expect to offer everyday competitive prices along with seasonally relevant promotions and plan to deploy marketing dollars on offers that yield and improvement in sales or profitability.
On a year-to-day basis, our merchandising initiatives have contributed approximately 100 basis points to product margin expansion. We anticipate building upon this growth in the second half of the year to support our margin improvement goals for the year.
Turning to supply chain. In the second quarter, we completed our distribution center consolidation. This initiative commenced more than two years ago when we operated nearly 40 DCs across the United States, utilizing multiple warehouse management systems. As of today, we operate 15 DCs supported by a unified warehouse system marking a key milestone in our efforts to enhance asset productivity throughout our supply chain.
Along with consolidating our DC network, we also launched market hubs that improve same day parts availability for our customers. Areas equipped with market hub locations consistently outperform those without market hubs, which reaffirms the strategic value of these locations.
Year to date, we have opened five market hubs bringing the total to 38 locations. Our real estate team has done a great job in expanding our capabilities and I am pleased to share that we are accelerating the pace of market hub openings for this year. We now plan to open 15 to 20 market hub locations this year and remain on track to achieve our goal of operating 60 locations by mid-2027.
Regarding DC productivity, our team is concentrating on key process improvements aimed at streamlining and standardizing operations within our distribution centers. We anticipate that these actions will yield greater operational efficiency and facilitate improved product flow into and out of the DCs. During the second quarter, we completed 25% of the identified process improvement and remain on track to systematically implement the remaining process changes by mid-2027. These actions are aimed at increasing labor productivity within our DCs and provide visibility into cost reductions per unit shift which is expected to contribute to margin expansion starting next year.
Our strategy is focused on minimizing redundant product handling, improving shipment accuracy, reducing inventory lead times and transitioning to a more variable cost structure. For example, we have now standardized the DC receiving process across our facilities, eliminating a significant number of variations which is expected to deliver better productivity to higher processing volumes per labor hour.
Another critical component of supply chain productivity is transportation optimization. We are currently rebidding all of our carrier contracts and we expect to consolidate our volume with 70% fewer carriers. This initiative is expected to generate tens of millions of dollars in cost savings which will support margin expansion in 2027. Collectively, the DC process changes and transportation initiatives are expected to enhance our ability to operate a more efficient and scalable supply chain.
Next, I will conclude with an update on our third strategic pillar, store operations. In our stores, we are holding teams accountable for service execution and measuring the effectiveness of our initiatives to clearly identify KPIs as we strive to increase labor utilization. The second quarter provided further evidence of progress on our store based initiatives. NPS or net promoter scores have improved to nearly 80 points from the high 60 point range in the same period last year, which suggests that our service enhancements are resonating with customers.
In-store attachment rates have improved to nearly 30% from the mid high 20% range in the same period last year which contributes to unit share gains. And average time to deliver pro orders consistently tracked below 40 minutes during each week in Q2 which is improving reliability for our pro customers.
In addition to measuring progress through these KPIs, we are also identifying opportunities to better prioritize store tasks, investing in technology to drive operational efficiencies and enhancing training content to further elevate customer service. These actions will help us strengthen execution across our primary KPIs in the near term while our store and merchandising teams partner to drive higher customer engagement and improve conversion in the second half of the year.
During the second quarter, we also completed an independent evaluation of store task execution with the objective of updating our store labor standards that were previously unchanged for over a decade. This activity follows the rollout of our store operating model last year which determined the allocation of resources such as trucks and drivers based on market demand factors. The study examined time allocated to routine store responsibilities including picking or stocking products, receiving shipments from distribution centers and assisting customers with product installations such as batteries and wipers. We expect to use the findings to identify tasks that deliver the highest value to our customers and simultaneously highlight non-value added activities that can be reduced to enhance productivity.
The next phase of this initiative involves updating our labor allocation systems to align with the newly developed labor standards. We anticipate beginning this implementation later this year which will enable us to further improve NPS and drive productivity in the years to come. To conclude, I want to reiterate that our strategic plan is unchanged, our KPIs are improving and we have returned to positive free cash flow.
We are cognizant of the external macro pressures impacting consumer spending in the near term. We are implementing a focused action plan to support the business in the second half while we actively manage the execution of our strategic initiatives throughout the year. I will now hand the call over to Ryan to discuss our Q2 financial performance. Ryan.
Ryan GrimslandChief Financial Officer
Thank you Shane and good morning everyone. I want to begin by thanking our frontline associates for their commitment to serving our customers. For the second quarter we reported net sales of $2 billion with a slight decline in comparable sales. The pro channel delivered low single digit growth which was in line with our expectations. The strength in pro was more than offset by declining DIY sales in the low single digit range as constrained household budgets impacted spending during the quarter.
We also experienced milder summer weather in several of our markets which drove an underperformance in weather sensitive categories such as cooling and climate control and fluids and chemicals. In our view, the combination of a larger than anticipated deceleration in DIY spending with deferral in large ticket projects, a reduction in discretionary spending compared to last year and weather related drivers during Q2 accounted for approximately 100 to 150 basis points of cops headwind in the quarter.
Turning to the cadence of sales. During the first eight weeks of Q2, comparable sales grew by approximately 1% including a low single digit growth in pro and flattish DIY sales. In the final four weeks, cop growth moderated in both channels as we cycled through difficult comparisons from last year. Also this timeframe coincided with price changes to reflect movements in commodity costs which further stretch consumer budgets.
In this period, the pro channel delivered positive comparable sales growth but DIY volumes slowed further driving most of the shortfall in sales for the quarter. For the quarter, average ticket was positive and included the same skew inflation of approximately 4%. The sequential step up in inflation from approximately 3% last quarter was driven by market related price adjustments and increases in commodity costs which impacted motor oil and other petroleum products.
Our team remains committed to enhancing customer service and these efforts continue to support growth in units per transaction which grew on both a one and two year basis helping partially offset lower transaction values.
Diving deeper into category performance within DIY sales were stronger in maintenance and failure categories such as filters, motor oil and batteries while hard parts categories lagged likely indicating selective spending behavior and deferral of larger projects. On the other hand, in the pro channel, our hard parts business including brakes and undercar continue to outperform supported by an improvement in parts availability and consistency in delivery types.
We maintained our strategic focus on growing share across Main Street pros which represents the largest portion of our adjustable market. The pro team carried the momentum from Q1 with transaction performance for this segment outpacing the overall enterprise. The Main Street pro comp exceeded our total pro comp by more than 200 basis points helping offset the headwind created by the optimization of national accounts.
Moving to margins, adjusted gross profit was $924 million or 46.2% of net sales resulted in approximately 240 basis points of gross margin expansion in Q2 compared to the same period last year. Terra Free Funds contributed $26 million to gross margin accounting for 130 basis points of year over year change.
The balanced 110 basis points of margin expansion was primarily given by an improvement in product margin and included two incremental cost drivers in the quarter. First, a channel mix shift due to the slowdown in DIY sales resulted in a headwind of approximately 20 basis points.
Second, supply chain expenses including higher freight and fuel costs drove approximately 20 basis points of deleverage due to the lower than expected sales volume. These headwinds were offset by approximately 40 basis points of tailwind from immaterial, lifeboat and warehousing expenses in the quarter compared to a headwind in the same period last year. Excluding the benefit of IEPA refunds, we generated a gross margin of approximately 45% for the first half of 2026, highlighting the progress across our merchandising strategies.
Shifting to expenses adjusted SGA was $812 million or 40.6% in net sales, driving 15 basis points of leverage compared to last year. Expenses were down approximately 1% year over year, reflecting our focus on labor productivity through simplification of store tasks and management of resource allocation along with reinvestment of savings from indirect spend optimization.
Adjusted operating income came in at $112 million or 5.6% in net sales, resulting in approximately 260 basis points of year over year margin expansion. Adjusted diluted earnings per share was $1.03 compared to 69 cents during the second quarter last year. We've generated $120 million of free cash last year. The improvement in free cash flow was driven by improved profitability and working capital management, a reduction in cash expenses related to our store optimization activity last year, and the receipt of tariff refunds. Our balance sheet continues to be in a solid position as we ended the quarter with a cash balance of approximately $3.1 billion.
During the quarter, we utilized approximately $30 million of cash to repurchase a portion of 2028 senior notes. And we ended the quarter with a net debt leverage of 2.1 times compared to 2.4 times last quarter, which is in line with our targeted range of 2.0 to 2.5 times. We remain committed to repaying debt at or before maturity.
Turning to full year guidance, let's start with net sales. For the full year, net sales are projected at approximately $8.5 billion, including comparable sales growth in the 1 to 2 percent range. Based on product cost inflation experience during Q2, we now expect full year's same few inflation of approximately 3 percent, implying second half inflation of approximately 3 percent, consistent with the first half of 2026. The step down in inflation compared to the second quarter reflects the comparison against last year's tariff-driven price adjustments. Based on revised inflation expectations, along with our focused action plan to increase customer engagement, our range of comparable sales growth guidance assumes a recovery in transaction volumes compared to the second quarter.
Regarding Q3, trends during the first four weeks of the quarter are tracking slightly ahead of trends in the final weeks of Q2 and have accelerated on a two-year basis. As a reminder, these first four weeks of Q3 represent our most difficult comparisons the last year, and our comparisons begin to ease significantly over the next eight weeks.
Moving to margins, we have reaffirmed full year adjusted operating income margin guidance between 3.8 to 4.5 percent, resulting in 130 to 200 basis points of year-over-year margin expansion. We expect full year gross margin to expand in the range of 110 to 150 basis points to approximately 45 percent. Most of this margin expansion is expected to be driven by the merchandise initiatives related to strategic vendor sourcing and optimization of pricing and promotions. We expect that the benefits from these merchandise initiatives to be partially offset by investments in supply chain productivity. As I discussed earlier, we had some moving items within gross margin in Q2. These items have also been factored into our full year guidance. During the second quarter, we received substantially all the IEPA refund claimed by us.
These refunds equate to approximately 30 basis points of gross margin contribution for the full year. However, this benefit is being fully offset by the headwind from changes in sales mix compared to our prior forecast and the incremental impact of higher shipping, freight and fuel costs in the supply chain. We will continue to work closely with our vendor partners to navigate the evolving geopolitical landscape and mitigate potential supply or cost pressure.
Regarding SGNA, we expect reported full year expenses to be down year over year, contributing between 20 to 50 basis points of leverage. This is largely due to cycling of approximately 90 million in non-recurring expenses from 2025. Adjusting for these expenses, we expect SGNA to grow at a low single digit rate compared to last year. We expect to deploy savings generated from better in-store task management, effective resource allocation, and a reduction in indirect spending to fund general wage inflation, new store, and market hub opening expenses and strategic labor investments in priority markets.
As we move forward, we will continue a look for opportunities to streamline tasking operations in stores to dedicate more time to serving customers. Moving to other items and guidance, we have raised adjusted diluted EPS guidance to a range of $2.60 to $3.30. The revised EPS outlook includes approximately 100 million of interest income, which is an increase of 20 million compared to our previous expectations based on trends through Q2. We continue to plan for pre-tax interest expense of approximately 210 million for the full year. The recent debt repurchase does not have a material impact on guidance. The benefit of higher interest income is being partially offset by a slight increase in tax expectations for the year.
Shifting to cash flow, we continue to expect 2026 capital expenditures of approximately 300 million, with spending allocated to new stores and greenfield market hub growth, store infrastructure upgrades, and strategic investments. We have revised our store opening schedule for this year. Our revised guidance includes 30 to 35 new store openings this year, with six stores opened in the first half of 2026. For market hubs, our guidance now assumes 15 to 20 new market hubs this year, which exceeds our prior expectations.
We opened five market hubs in the first half of 2026 and currently planned to open nine market hubs during Q3. We are reaffirming our full year free cash flow guidance of approximately 100 million. Our guidance includes the flow through of tariff refunds received during the second quarter and timing for certain general operating expenses planned for the balance of the year.
The change in free cash flow trend compared to our year-to-day trend of 120 million does not reflect any change in underlying operational progress of the business. To conclude, I want to thank our frontline associates for the continued improvement in the quality of service provided to our customers. Their efforts are supporting improved conversion, NPS, and attachment rates, while our pro team continues to drive share gains across the Main Street Pro. I will now hand the call back to Shane.
Shane O'KellyChief Executive Officer
Thank you, Ryan. I'd like to close by thanking the advanced team for staying focused on elevating our customer experience and driving operational productivity, which we believe will position us well to create long-term value for our shareholders. Thank you.
Questions and answers
Operator, we can now open the line for questions. Thank you. If you would like to ask a question, please press star one in your telephone keypad. If you'd like to withdraw your question, simply press star one again. We ask that you please lend yourself to one question and one follow-up.
Steve ForbesAnalyst, Guggenheim Securities
Your first question comes from a line of Steve Forbes from Guggenheim Securities. Your line is open. Good morning, Shane, Ryan. Shane, I wanted to maybe dig into customer segmentation and whether you're seeing transaction growth among your largest up and down the street customers, and maybe any comments you can provide that help build conviction around sort of sustainable transaction comp growth into the out-ear here as you reap the benefits of the use for TD priorities.
Shane O'KellyChief Executive Officer
Yeah. Hey, good morning, Steve. Thank you for the question. And let me just begin by thanking our team. Important to recognize what they're doing each and every day. So great question. Let's unpack pro. Think about it in terms of Main Street and think about it in terms of national accounts. We are excited about what we're seeing with Main Street. So the growth there, 200 basis points above what we're seeing in Total Pro, and that's inclusive of transactions. What we're doing with Main Street, we're getting real traction. And think about this is in the trenches, seeing a local shop at somebody with two or three bays, and that's where both our connectivity, our reputation, and really the quality of what are both our outside and inside sales team members can do is making a difference.
Remember, this is us saying, hey, where do we want to be in the pro segment?
Ryan GrimslandChief Financial Officer
Where do we have a right to win? Where is our profitability more attractive? All of that points to Main Street. So national accounts waning, and we're starting to see that diminish over time. So given the success we've had with Main Street, given how we're situated to compete with Main Street, we feel good about that both in what you've seen here and what we think we can do for the future.
He has to develop a couple of things. Well, just think about the main, I'll hit on the Main Street and the national accounts. The national account pressure will be about half of what it was in the first half in the second half. So we are starting to lap it. There'll still be some pressure there, but it'll be about half of what we've seen in the first half of the year. So that that'll help a little bit on the trends there. On the Main Street Pro, we're not just seeing accounts that we've had for a while continue to shop with us by more transactions. We're seeing accounts on Main Street that hadn't shopped much with us before start to give us some of their business.
And that's a good sign that our assortment is getting there.
Shane O'KellyChief Executive Officer
The service level is improving. A couple of things to know why we believe that we're making the right moves here. But at the end of the year, 70% of our stores will have a market hub. We're bringing more parts closer to the customer, and that allows us to reach other Main Street pros and provide a better level of service to them. So we're excited about the Market Hub acceleration we're able to do here. We still think by the middle of the next year, all stores will be on a market hub. But being able to accelerate a few more in this year, by the way, we're going to open up 9 in Q3. So that acceleration is going to be impactful, bringing more parts closer to the customer.
The other thing is our assortment work that we're doing. And we still have opportunity to improve that assortment for the pro customer and make sure we got the right coverage. But the work we have done is starting to resonate. We're going to continue to do that. We see opportunity to continue to improve that coverage and be more relevant for our pro customers. A couple of just last additions and then look forward to your follow up. If you look at how we've played in the pro space over the years, we have a TechNet program, which has been very successful and included in that is a warranty program. So you say, Steve, you own a small shop somewhere and you fix their car and the customer drives three states away and needs to get that original work repaired.
They could do that through an unrelated shop, through our warranty program and get that paid for. We have programs like Moto Visuals, Moto Logic that help break down what's going on in vehicles, our credit programs, our tools and equipment programs, our ability to work with your account as you grow. So there's a number of things that we do with Main Street that I'm going to use the word that's specialized or even bespoke relative to what else is out there that helps our level of attractiveness and builds that partnership. Most recently, and this is just sort of coming out now with Anthony Solanus and our pro team, is owning the mile where he's using both our CRM software, the partnership between the outside sales team member, which is called a CAM and our customers who are geographically proximate to our stores.
Now on the plus side, our aggregate total time to serve is under 40 minutes and we think that's a key threshold. But now when you think about focusing on customers that are very close to the store and I'm thinking, you know, one, two, three miles will be well under 40 minutes there and that's a further point of differentiation. So look for us to continue to do that, but net net, we feel good about what we can do with Main Street Pro. Appreciate that and maybe just a quick follow up given the commentary around hub growth.
Steve ForbesAnalyst, Guggenheim Securities
I know the transition here was the greenfield growth, I believe this year over repurposed footage right of the distribution footprint. So can you talk about how those greenfield hubs are performing relative to the original cohort of hubs that were more repurposed footage and if that sort of performance is what sort of supports the acceleration that you're referencing here into the back half?
Ryan GrimslandChief Financial Officer
Yeah, I'll jump in here and shake in that color. But the greenfield market hubs, the actual store, because it's a store within the market hub, they actually are performing a little bit better than the other ones. And I'll give you just the background on the other ones. We did non-greenfield were actually conversions of old, we call them blue, but CarQuest DC, smaller DCs that we converted, they weren't necessarily in prime retail locations. But they did service the market. They do service the market for parts. So the hub runs help the market. The greenfield ones tend to be in a better retail location area where we can get more retail sales out of that hub as well.
So from a volume standpoint, they tend to do a little bit better on the greenfield side than the conversions just because the nature of the retail business we generate from them. And also the conversions, those still supply some parts of the market through what we call PDQ. So there was still some service level. It wasn't as strong or as efficient as the market hubs are. So when we put a greenfield in place, that is a lot of parts going to that market that weren't there before. So they tend to perform a little bit better than the conversions.
Shane O'KellyChief Executive Officer
Let's just add that the market hub paradigm for us is a key part of how we're going to grow, not just with Pro, but with DIY. And so we're accelerating what we're doing there. And as Ryan touched on, we'll open 9 in Q3. We're sitting at 38 currently. We want to be at 50 by the end of the year. As a reminder, think about these as having 70, 80,000 SKUs, sometimes a little bit more, being able to get parts same day to a radius of stores, 50 plus stores. So that really changes our ability to compete for parts that people want that day. And so we're going to continue it. We're going to refine it.
And we'll talk more about what we'll do as we get to the 50 going forward.
Thank you. Thanks, Steve.
Simeon GutmanAnalyst, Morgan Stanley
Your next question comes from a line of Simeon Gootman from Morgan Stanley. Your line is open. Hey, there. Good morning, guys. So this morning, the morning, this may be a slight repeat from the prior question. I missed some of the prepared remarks, but thinking about the core driver of do it for me, if there's temporal pressure in the economy like gas prices, I would expect DIY to be more sensitive, not DIFM. So can you talk about the trajectory you're on with core DIFM improvements and how much of this quarter was more macro or could be like strategy just taking some time to take hold?
Ryan GrimslandChief Financial Officer
Yeah, I'll talk about Q2 and then the Q3 trend. So Q2, the deceleration we saw in our P7 the last period of the month, we were running about flatish on DIY and most single digit positive and pro for the first eight weeks. We saw really DIY decelerate towards the end of the quarter. That was really the bulk of the lower performance of what we expected. DIFM, while slight deceleration was still positive during that time period. I think it was more just a reflection of a little bit of macro pressure there, but the pro was still positive in the quarter and in the final four weeks still positive. Both the momentum and pro has continued into Q3.
We like what we're seeing there. On the DIY side, we've seen a little bit of an acceleration from the trend we saw in Q2. And on a two-year basis, we've seen some good acceleration. More importantly, on the trends in Q3, we're seeing transaction growth improve. So the transactions have improved versus our Q2 trend where we exited Q2. So some positive things there that give us confidence in our guide for the rest of the year.
Simeon GutmanAnalyst, Morgan Stanley
Okay. And then a quick follow-up. And again, I apologize if you said this already. But merchandising success or excellence, I forget the terminology for some of the gross margin initiatives. I guess X tariff, if I got this right, the margin may have come in a little bit, I guess, worse than we expected. I don't know if that's right or wrong. Some of that, I assume, was the leverage of distribution expense or was there any slowdown in just the merchandising success strategy during the quarter?
Ryan GrimslandChief Financial Officer
Actually, good question. I mean, the rate was impacted a little bit by mix here. So you got about 20 basis points of mix impact from DIY, the lower volumes that we anticipated. And they so those are really the two that impacted us that drove it down. It's still with like a 44 nine so close to the 45, still able to manage close to the 45. The merchandising initiatives still cost out really strong and provide a great value for us. I mean 110 basis points year over year if you back out the tariff impact on margins. So the real slight decrease versus our expectation the quarter was driven by fuel supply chain expenses in the channel mix.
Simeon GutmanAnalyst, Morgan Stanley
Got it. Okay. Thanks, guys. Good luck.
Thanks, Jimmy. Thanks, Jimmy.
Unidentified AnalystAnalyst, Citi
Your next question comes from a line of Stevens Acone from City. Your line is open. Good morning. Thanks very much for taking my question. I want to follow up on the second half here.
Shane O'KellyChief Executive Officer
So clearly the decision to reiterate the same sort of sales guidance. It does look like the second quarter. So missed expectations. So maybe just help us understand, you know, some of the phenomenon that can help in the back half, you know, the loss failed due to whether you expect them to come back and then any help on the third quarter versus the fourth quarter because it seems like you got some work to do when the compare is going to be tough for them the second half of a year. Hey, Stephen, it's Shane. I'll start and then Ryan can unpack it further.
So big picture. We cater to the lower and mid tier consumers. And you see this not just in our numbers, but I think you see it broadly in our market and others. That's been a very stressed consumer. And so from a macro perspective, they've struggled. They've struggled as fuel prices have risen. And those budgets have continued to get tighter as they've gone through. And you saw that, by the way, in our Q2. And if you look at the last four weeks of our Q2, we were probably a little slower pivoting to value given that the consumers said, hey, this is what's what's really important to me. So as we look at Q3 and Q4, we're taking a series of actions to be more attractive and to maintain and improve conversion for those consumers as they come and visit us.
So here's what's going on with that. So we've got our advanced rewards program. That's been recently launched. We'll continue to reach out to that cohort of customers. We're doing work with paid search optimization to make sure both in terms of what keywords we're using, what geography of customers we're talking to and how we get them in there. We're going to continue to promote our good parts campaign. We're simplifying tasks inside of stores and communications so that when a customer does come in, that experience is as positive as it can be. And by the way, I've seen an uptick in feedback that I personally get from customers about what they're seeing in our stores. We know that value plays are important.
We've got Argos, which is our private brand of oil. And we're now expanding across a broader line of products that we think will be attractive. We also know that, and this is a good part of what we do from an assortment perspective, is good, better, and best. And so in the past, when the consumers help here, they'll say, hey, tell me more about the better and the best. Now they want to learn a little bit more about, tell me about the better or tell me about the good. We've got those products in. So that speaks to what we're doing on conversion, that speaks to what we're doing with units per transaction. So we kindling what's going on with the DIY customer to do as well as we can.
On the pro side, you heard some of that with how we respond to Steve's earlier comments, but we really like what we're doing with Main Street Pro.
Ryan GrimslandChief Financial Officer
We're going to continue to push in there. Yeah, and Steven, I'll just be a little specific around the what's driving the back cap performance expectations. So all that Shane talked about, we think will help with the DIY. And we're actually seeing on a two-year basis, that accelerated a little bit, but and you mentioned difficult compares in the back half. The real difficult compare is P8. It tends to ease as we go throughout the rest of the back half of the year.
One thing also to note is we had about 50 basis points of impact last year in Q4 due to product transitions. We won't be cycling that in Q4 this year. Those related to first-brand groups and other product transitions in our front room that had an impact last year, we won't have that this year. So that's kind of a tailwind cycle over, but we're focused on pro. Pro will continue to outperform. We're seeing those trends continue and that will be a driver. We still think there'll be DIY channel pressure, more than we originally thought. Even though trends have improved after the last four weeks of the quarter into Q3, we still are expecting that DIY will be pressured in the back half.
But to Shane's point, we think we have a really compelling value offering within our product set and our categories. We have good, better, best, and our goals expansion couldn't, other categories couldn't come at a better time, I think, for the consumer. It's a good value offering across many different categories now. I think our efforts to increase customer engagement will be good. One other thing to note in the back half, we've got a 3% inflation expectation that's really due to kind of commodity price, oil prices that are going in. That's about 100 basis points higher than we originally planned.
Unidentified AnalystAnalyst, Citi
Okay. Understood. I appreciate all that detail. My follow up is the prior commentary, you know, 70% operating target on a medium-term basis, you know, the next year, 27 with expectancy of least 100 basis points of expansion, do you still think that's a reasonable target in light of some of these weaker DIY trends and any cost inflation across the business?
Ryan GrimslandChief Financial Officer
Yeah. I mean, we're still focused on 7% of the medium-term target. The 100 basis points next year, that's where we're at today. It's a little too premature to give specific guidance for next year. But I'll tell you what Ron's doing in supply chain because the bulk of this year is supply chain planning, driving improvements, understanding the timing of benefits we'll get from supply chain and also our store optimization work and what we're doing there. And both Ron and Tony have been digging in. What Ron is doing, he's about 25% of the way through, really looking at the productivity in different areas, think of our receiving capabilities, our inbound, our outbound. And that team has been hard of work.
It's giving us more confidence in the value unlock in supply chain. We're not ready to necessarily give what that guidance will be for next year. We're still working through the planning, but the work he's uncovered year to date, it's just continuing to confirm for us that there's opportunity there. So we're still on our basis points for next year. Still makes sense for us, but we're not ready to give more specific guidance.
Shane O'KellyChief Executive Officer
Yeah. And let me build, I think, 7% is that right target. We're in a very complicated geopolitical situation that's impacting the consumer and so that consumers stressed. But think a little bit longer term, so I don't think we're going to be permanently in this state of affairs. If you think longer term, the backdrop of the industry that we're in remains very attractive. So think about that in terms of number of vehicles on the road. Think about that in terms of how old they are. Think about that in terms of what the penetration of electric vehicles has been or now of prevalence of a hybrid vehicle that has an engine. Think about that in terms of miles driven.
Think about that in terms of cost of a new car. People, the new cars are pushing $50,000. People are keeping their cars longer and want to fix them. Think about the total TAM. It's a $160 billion market. It's fragmented. So the idea that all of those backdrop fundamentals for the longer term, just think beyond the immediate pressing concerns of the consumer, those are all good things for us as we compete in the market. And so that's why keeping that target the same is appropriate.
Unidentified AnalystAnalyst, Citi
I understand. That's the box. Thank you.
Brett JordanAnalyst, Jefferies
Your next question comes from Alina, Brett Jordan from Jeffries. Your line is open. Hey, good morning, guys. Brett, how should we think about working capital? I guess, accounts payable to inventory and what your factory costs are looking like now that your leverage ratios come down a little bit. Yeah. Well, our coverage actually improves a little bit. I think we would expect that to continue to prove over the medium long term here.
Ryan GrimslandChief Financial Officer
We are making some investments, obviously, in working capital related to our assortment work, but we're also finding productivity. So overall, we'll see improvement in our working capital. We'll see improvement our coverage. We have great conversations with vendors to work through that, but that's going to be over the medium term. But we did see we have seen improvement in our coverage ratio.
Obviously, the banks versus with our vendors, they obviously provide rates to them. We don't get involved in that, but we know they've kind of stabilized for sure. There's obviously the external rate so far has been under pressure as well, but it has stabilized since we put in the transaction last year. And so what I've heard anecdotally is just that the difference is starting to converge, but it's I think about where it's been for a while to stabilize in a really volatile rate environment, which is good for our vendors. They want stability. I think one of the key points that happened in Q2 was reading agencies, both Moody's and S&P stabilize our outlook, which is just a demonstration of the improved balance sheet that we have.
It's in a solid position, the free cash flow returning to positive free cash flow. That's the first time in two years this company has gone to positive free cash flow. So I think from a balance sheet standpoint, improving supply chain finance, very stable. The thanks are supportive of the program. I think the bridge is the investment grade. Okay, and then on the commercial business, exponential account cutbacks, are you gaining share? Do you think a retaining share with the up and down the street business? I mean, sort of adjusting for same skew inflation and looking at that 200 basis point comp ahead of pro, do you think that's a share gain indicator or just holding share?
I think it's a hold and then potentially in some markets again is how I think about it.
Brett JordanAnalyst, Jefferies
A lot of noise going on as we transition the mix with the national accounts to the main street.
Shane O'KellyChief Executive Officer
But as I personally, when I visit accounts, the consensus on improving time to serve, improving the assortment, thinking about what we're doing with TechNet and other promotions, I think gives us confidence about what we're doing going forward.
Ryan GrimslandChief Financial Officer
Yeah, the main street, a larger addressable pan. I mean, you know this, but we're really excited about larger transactions there for us. So the transactions are stronger for us in the main street. So I think maybe it's a hold and gain in certain areas. We're excited about what we're doing on the main street, bro.
Brett JordanAnalyst, Jefferies
Right. Thank you. Thanks.
Unidentified AnalystAnalyst, TD Cowen
Your next question comes from a line up, Max, for Clanko from TD Cowan. Your line is open. Great. Thanks a lot, guys. So first, can you just help bridge gross margin for both 3Q and 4Q? The key puts in takes that we should be considering. And then just any help by triangulating two final outcomes compared to 2Q?
Ryan GrimslandChief Financial Officer
Yeah, absolutely. A couple of things. I think about the back half of the year, we are expecting it does include headwinds from higher freight, fuel costs, some channel mix headwinds. So DIY coming down, you'll have a little bit of a mixed pressure on DIY. We still expect elevated freight and fuel costs that'll be in our margins. Looking at kind of Q2 is our guide post, sorry, operating income. These cost items drove Plasmid 30 to 40 basis points of headwinds. One thing to keep in mind, we are cycling in a 53rd week. So in Q4 operating margins, that's approximately 20 basis points of headwind in the Q4 operating margins. So even margin guide for the second half is 3 to 4% with the high end consistent with last year excluding the 53rd week.
The gross margin specifically, we're assuming a margin range of 44 to 45% with Q3 higher than Q4 just due to seasonality in the mix that we sell. We don't expect any material, tariff refunds and flows coming in the back half of the year. So just a thought on that. On SGNA, if you're thinking about operating income and the flow through there, we expect those dollars to be relatively flat to last year in Q3, including more store openings.
The decline in Q4 year over year is really due to that extra week. So that extra week of SGNA. So in general, it'll be exclude that low single digit increase.
Unidentified AnalystAnalyst, TD Cowen
Got it. That's helpful. And then so you guys will purchase a little bit of the get this quarter for the first time in the while. If you remain on track to hit your guide for this year, should we see further repurchases ahead? And then it would be a similar magnitude or potentially to those step up? And then just figure picture, can you update us on conversations with the other rating agencies? And any sort of goal post that we should consider as able to get back to investment grade?
Ryan GrimslandChief Financial Officer
Yeah, so a couple of things on that. We're always going to be opportunistic with excess cash that we can't deploy or don't feel like we can deploy into the business. So the way our capital priorities go, we're going to deploy cash into the business to continue to drive this comeback, improve the business operations. When we have excess cash beyond that, if we find economic benefits to retiring debt before maturity, we'll deploy it towards that. We have no plans at this time, but we're always looking at the market. So we'll look to do that at our before maturity is our plan. And if we have excess cash, we're confident in we'll do that. But again, I'm excited about the fact that this is the first time in a long time we've been able to use excess cash, and our cash balance continuing to be a positive force on the balance sheet.
We've got 3.1 billion of cash. We are in excess cash position relative to our obligation. So if we can deploy that to the business, we will. If not, we'll continue to deploy to deliver the balance sheet. As far as the rating agencies are concerned, we've had very constructive dialogue. We're excited about the stable outlook. Just a reminder, to get to investment grade with Moody's about three jumps and S and P is two jumps. So this is a journey that we're on. It's been positive conversations. I think the free cash flow, returning to positive, free cash flow, the beginning to deliver the balance sheet are all good indicators that I hope they will see as positives.
But we have thought, could I log with them regularly? We're working towards getting back to investment grade, but it is a little bit of a journey.
Unidentified AnalystAnalyst, TD Cowen
Got it. Thanks a lot, guys. Into the market in the second half.
Unidentified AnalystAnalyst
Your next question comes from a line of Kate McShane from Goldman Sachs. Your line is open. Hey, good morning. This is Mark Jordan on for Kate McShane. Thank you for taking our questions.
Shane O'KellyChief Executive Officer
As we think about, as you think about your focus on Main Street customers, is there a way to quantify how much of that DAFM comp is coming right now from existing customers, how much is coming from new customers? And I guess if we think about the time it takes to win a new account, is there a lag or what is the lag between opening a new market hub and maybe signing up a new pro account? Yeah, good question. On the plus side, most customers know who we are, and we will commonly get some sort of business from them. Within the pro world, there's a hierarchy where you want to be first call. You want to be the guy that the customer says, hey, I'm ordering a lot of parts today and advance going to be the first call.
And by the way, the questions that go around how you earn that is, do you have the part yes or no? When can I get it? Time to serve. And then sometimes, hey, what's my cost going to be? And so as we improve in each of those areas, our ability to get first call customers or earn our way in the first call improves. And we haven't sort of unpacked that number specifically other than to say that we're very focused on it. And opening market hub certainly helps.
In my experience, when you go into somebody where you're not first call, it's not a question of, hey, I make one visit. And then the customer says, great, you're here. And so now I'm going to switch. So it usually takes a series of visits over a period of weeks where you have to both demonstrate the value proposition and earn that right. And usually it comes in the form of, okay, I'm going to give you guys this category. I'm going to give you this set of orders. And then how do you perform and you earn your way in? It's a trust-based business. It's a relationship-based business. And if I go back to some of the things that we talked about before, whether it's our TechNet program or the quality of our cams, our outside sales team member, we've got the right constituent parts to go make that happen.
And now the market hubs become a further neighbor of that. But it's not an immediate process, but we feel good in terms of where Main Street Pro sits today. We feel good in terms of how we're migrating through some of our national account business. And we feel good about where we're going forward with our own-the-mile program, our use of CRM, our value plays for our pro customers, the quality of our inside sales team and our stores, our CPPs, our reputation advance has long been known for being in a pro-universe.
Ryan GrimslandChief Financial Officer
And just to add the mix between new and existing, it's a mix of both. We're seeing growth in both.
Unidentified AnalystAnalyst
Perfect. And one follow-up, if I could, you mentioned the same skew inflation you're seeing on motor oil and other lubricants. Can you talk about how your Argos line is positioned relative to the competitors there?
Shane O'KellyChief Executive Officer
Yeah. So we like the name. We like the people that we source the product from. We like the performance within the category. Argos is actually our highest unit selling motor oil. And by the way, we represent very high quality prominent brands. And by the way, proud to sell those as well. But the consumer says value is really important to me.
They know the quality we put into the product. But the idea that it comes with affordability, reliability, sustainability, it really resonates with them and resonates with our team. And so it's an easy product for our store team members to sell.
Unidentified AnalystAnalyst
Great. Thank you very much.
Michael LasserAnalyst, UBS
Your final question comes from a line of Michael Laster from UBS. Your line is open. Good morning. Thank you so much for taking my question. It seems like your guidance is basically saying, hey, at the low end, we could do a flat comp. And part of that is you're going to see more, like for like inflation in the back half of the year, the comparison gets a little easier.
But on the other hand, it does seem like the business is becoming more volatile. You had spoken about some volatility coming into the second quarter and some volatility coming out of the second quarter. So how does that influence your perspective on the back half set another way? Was there any thought to lowering the comp outlook for the back half just to be a little bit more conservative? Thank you.
Ryan GrimslandChief Financial Officer
Yeah, appreciate it, Michael. Just talk a little bit about the trends. You know, when we entered into Q2, we did talk a little bit about the DIY, slow down a little bit of pressure there, softness and DIY. But even then, the first eight weeks was kind of in line with our expectations. We were tracking around on one comp for the first eight weeks and DIY was roughly flat, pro positive, low single digits. It was really the last four weeks. And I think in that last four weeks, we had one unique weather impact in our areas. If you look at print, the average temperature was actually down here over here. That's one.
I think the DIY really pivoted to value. And I just say, I don't want to belabor this, but I think we were slower to pivot our messaging to that. I think we've got a great value offering and we've pivoted going forward to make sure that the customer sees that. But the last four weeks really wasn't indicated to the health of the business. I think that was when we see the trends coming in Q3, those Q3 trends have accelerated and more particularly in transactions.
And from a two year basis, we are in line with what the guide would imply, which is roughly a 3% two year stack. And that's what we're expecting going forward. So we're not expecting a deviation from that kind of two year trend and where we're tracking today to be within our guidance range.
Michael LasserAnalyst, UBS
Thank you very much for that, Shane. Sorry, Ryan. My follow-up question is on the path moving forward.
Ryan GrimslandChief Financial Officer
You have articulated a lot of confidence that over time, there are idiosyncratic drivers to improve advanced auto parts profitability, especially from all the actions that have already been made. So are you still of the view that next year, there could be more margin expansion as the fruits of those initiatives take place? And if the overall environment for the aftermarket remains more challenging next year, to what degree does that potentially offset the idiosyncratic gains and profitability that you are expecting in 2027? Thank you so much. Yeah, appreciate my God. I'll just talk about, you know, we talked about at least 100 basis points next year. We still have confidence in that.
And a lot of the work that Ron's been doing, because this year has been about supply chain stores planning, getting out of the hood, and he's making his way through supply chain. It's giving us more confidence in the unlock that supply chain will have going forward. We're not ready yet to give specifics on that. We'll update later in the year on that. But honestly, we're getting more confidence as Ron is working through that. And then Tony on the store side, we're seeing a shift in making sure that our labor hours are as productive as possible serving our customers. Less tasking focus on the customer driving productivity there. We're seeing that and we're getting more confidence in the actions that we're going to be able to take there.
So we're more confident. I think 100, at least 100 basis points is still a target that we have for next year. You talked about if the current pressure is, and it's really around DIY, maybe some freight pressures. One, on the DIY, if that persists, there might be a little bit of pressure. And we saw that in Q2. We had 20 basis points of mixed pressure. But yeah, we still delivered underlying margin growth of over 110 basis points if you exclude tariffs.
So the business is still driving operating income growth, gross margin growth, even despite some of those headwinds in those trends. And we would expect that to continue. If that were to continue, we'd expect to be able to mitigate that next year.
Shane O'KellyChief Executive Officer
Hey, Michael, it's Shane. Thanks for the questions. If I come back to the big picture and you're on the big picture, good industry. By the way, if you look at how we're running the business, we're willing to make the tough calls. We're using KPIs to track how we're doing. We're being transparent about it. We're being disciplined in the execution. We're not happy with how Q2 came out. We're putting in a series of initiatives to help us as we think about what we can do with DIY and what we can sustain with Pro. But even in the tough moments, you can point to and find evidence of improvements in areas that are critical for our continued advancement, improvement for our turnaround, for our comeback.
And you can think about that in terms of MPS. We rolled that out and our initial numbers were rough. And we talked about the journey from the 60s to the 80s. That's meaningful. That's a customer saying, hey, I had a better experience than what I had last time. You think about things about attachment rate. And you look at our market hub openings. Look at what we're doing with the assortment. Look at the DC consolidation. We literally just finished the DC consolidation. So I don't want to say we're nascent in the journey because we've been at it for a minute. But we are making improvements and getting better every day in the things that we can control.
And we're staying at it in terms of being rational actors and putting in plans to make that improvement continue in the future.
Michael LasserAnalyst, UBS
Thank you very much. And good luck. Thanks, Michael. I appreciate it.
And that concludes our question and answer session.
Shane O'KellyChief Executive Officer
I will now turn the call back over to Shane O'Kellie for some closing remarks. Thanks, everybody, for joining the call. I want to thank the team members at advance. It's their hard work that's making the progress and some of the KPIs that I mentioned and it's their hard work that's helping us as we go through Q3. We look forward to talking to everybody at the end of the quarter. And we appreciate you following the company. Take care.
Thank you. This concludes today's conference call. Thank you for your participation. You may now do.
Done reading? Open Advance Auto Parts with the chart, filings, and estimates next to this call.
About this transcript
The summary, guidance, analyst focus, and tone are automated and should be checked against the call before being relied on. Names and figures can be misheard. Listen to the replay.