Ladies and gentlemen, thank you for standing by, and welcome to the Q3 Earnings Call. At this time, all participants are in a listen only mode. After the speakers' presentation, there will be a question and answer session. And please note that this conference is being recorded. And I would now like to hand the call over to Mr.
Richard Bellanti, CFO. Please go ahead, sir.
Thank you, Joseph, and good afternoon to everyone. I'll start by stating that these discussions will include forward looking statements within the meaning of the Private Securities Litigation Reform Act of 1995. These statements involve risks and uncertainties that may cause actual events, results and or performance to differ materially from those indicated by such statements. The risks and uncertainties include, but are not limited to, those outlined in today's call as well as other risks identified from time to time in the company's public statements and reports filed with the SEC. Forward looking statements speak only as of the date they are made, and the company does not undertake to update these statements except as required by law.
In today's press release, we reported operating results for the Q3 of fiscal 2020, the 12 weeks ended May 10. Reported net income for the quarter came in at $838,000,000 or $1.89 per diluted share. This compared to $906,000,000 or $2.05 per diluted share last year in Q3. Now this year's Q3 was negatively impacted by direct expenses of $283,000,000 pretax or $0.47 per diluted share from incremental wage safety and sanitation costs related to COVID-nineteen. And last year's 3rd quarter number of $2.05 included the benefit from a non recurring tax item of $73,000,000 or $0.16 per diluted share.
Net sales for the quarter increased 7.3 percent to $36,450,000,000 up from $33,960,000,000 last year in the 3rd quarter. On a same store or comparable sales basis for the Q3, for the 12 weeks on a reported basis, the U. S. Was a 5.9%. Excluding gas deflation and FX impact, the 5.9% would have been for the 12 weeks and 8.0%.
Canada on a reported basis was minus 2.5%, ex gas deflation and FX plus 3.0 percent. Other international came in on a reported basis at 6.2 percent and again ex gas deflation and FX plus 12.2%. All told, the total company came in with a reported 4.8% and again ex gas deflation and FX, the 4.8% would have been 7.8%. I might also note that e commerce on a reported basis was 64.5% comp and ex gas deflation or ex FX, 66.1%. Now foreign currencies relative to the U.
S. Dollar negatively impacted sales by approximately 110 basis points and gasoline price deflation negatively impacted sales by approximately 190 basis points for the total company, therefore, the 300 basis points. Additionally, gasoline volumes or gallons were down about 20 percent year over year in the quarter as a result of less driving due to the pandemic. These adjusted figures the impact of gasoline gallons is not in the adjusted figures that I just described above. In terms of traffic, our shopping frequency, our shopping frequency decreased in the quarter worldwide by 4.1% and in the U.
S. By 2.0%. Our average transaction ticket was up 9.3% during the Q3 and the 9.3% does include the negative impacts from gas deflation and FX. Now our Q3 comp sales figures did reflect also that a few of our businesses, notably optical, hearing aids and photo were closed for much of Q3 and a good portion of our food court item offerings were eliminated also for much of Q3 as well we eliminated the food court seating during this time. Reopenings of these began these the ones that were closed began on April 30, 10 days prior to the Q3 end, with about 20% of the locations back operating by Q3 end.
In the past 2 to 3 weeks, nearly all will be back in operation by mid June. In terms of the food courts, which have been open, but again, a much more limited menu, we've added some, but not all the items back as of now. In all, an estimated hit to the reported sales numbers that we gave you earlier in Q3 by 1 to 2 percentage points by those items being closed or restricted. Next on the income statement, membership fee income reported came in at $815,000,000 or 2.24 percent, up 5% or $39,000,000 from $776,000,000 or 2.9% last year in Q3. Ex FX weakness, the $39,000,000 increase and 5% increase would have been up $47,000,000 or 6%.
During the quarter, we had 2 new openings, a total of 4 year to date. In terms of renewal rates, at Q3 end, our U. S. And Canada renewal rate came in at 91.0%, a tick up from where we were at Q2 end end and worldwide and the worldwide rate came in at 88.4%, the same as it was a fiscal quarter ago. Keep in mind that any impact on renewal rates from COVID, positive or negative, are reflected over the next several months.
In terms of the number of members at Q3 end, member households and cardholders in terms of households, we ended the Q3 with 55,800,000 households, up from 55,300,000 12 weeks earlier and total cardholders came in at 101,800,000 up from $100,900,000 12 weeks earlier. At Q3 end, paid executive memberships came in at $21,800,000 an increase of 135,000 over the last 12 weeks. Going down to the gross margin line, our reported gross margin was higher year over year by 54 basis points on a reported basis, coming in at 11.53%, up from 10.99%. Now the 54x gas deflation would have been plus 33 basis points. As I usually do, I'll ask you to write down a few numbers in 2 columns and then we'll go through that explanation.
In terms of reported in Q3 2020 year over year, the core merchandise was up 51 basis points on a reported basis and without gas deflation up 33. Ancillary businesses was on a reported basis plus 26 basis points, ex gas deflation plus 21 percent the 2% reward minus 6% and minus 4 basis points other, minus 17 and minus 17. And you add up those two columns, total reported, again, up 54 basis points on a reported basis and up 33 basis points. The gross margin was up 33 basis points ex gas deflation. Now the core merchandise component gross margin again higher by 51 or 33x deflation.
Keep in mind that in the quarter we had a decent sales shift from ancillary and other businesses to core businesses, which resulted in a higher contribution of our total gross margin dollars coming from the core. Looking at the core merchandise categories in relation to only their own sales or what we call core on core, margins year over year were lower by 17 basis points, 5 basis points by the way of which was losses related to our new poultry complex. This is something I've pointed out in the last two quarters and we'll probably do so next quarter as well. In total, pretty similar in fact to our year over year impact in Q2. So while higher penetration of our total sales came from the core this year, it was at a slightly lower gross margin percentage year over year.
This is mostly attributed to sales mix both between and within merchandise categories. Our fresh foods gross margin percentage was up again despite any 1st year headwinds from the ramp up costs associated with the poultry complex. The strength in fresh was a result of high sales driving down our spoilage as well as labor costs as a percent of sales being able to leverage those at a greater than normal rate. Softlines, food and sundries and hardlines all had lower margin percentage year over year in the quarter. One example, non foods, which is both hard lines and soft lines, non foods was impacted by a shift in sales towards lower margin departments, particularly things like majors and big ticket electronics.
Ancillary and other business gross margin in the two columns, higher by 26 basis points, again 21 higher basis points ex strength in gas and e comm gross margin dollars year over year, partially offset by a lower penetration of ancillary sales due to lower gas prices and volumes and the closures of some of those ancillary businesses that I talked about earlier. Several of those businesses have higher gross margins. 2% reward was higher 2% reward was higher or was a hit to gross margin by 6 basis points on a reported basis and 4x deflation, implying that a slightly higher percentage of our sales were eligible for the executive member reward. The other line item, 17 basis points to the negative, 12 of the 17 basis points is attributable to the COVID costs and the 12 basis points, that's about $44,000,000 of the $283,000,000 number that was mentioned in the press release. These are the costs for incremental wages, safety and sanitation costs allocated to our cost departments and merchandise fulfillment operations.
So it's just a hit to margin. The other 5 basis points or $19,700,000 came from accruing reserve for certain third party gift cards and ticket programs. This latter $19,700,000 was not included in the $283,000,000 total amount that we called out as a direct incremental expenses from COVID. Moving to SG and A, our reported SG and A percentage year over year was higher by 59 basis points, coming in at a 10 point 5 1 percent of sales, up from 9.92 percent. Ex gas deflation, the minus 59 would have been minus 40 or higher by 40.
If you begin, please jot down the following SG and A components and then we'll go through that. Core operations reported was plus 9 or lower by 9, a benefit of 9, ex gas deflation, plus 24 or a benefit of 24 basis points. Central, 0 and plus 2. Stock compensation, plus 3 and plus 3. Other, minus 71 and minus 69 and you add up those two columns, you get to the reported SG and A increase of 59 basis points and gas deflation rather minus 40 higher by 40 basis points.
Now, again, the core operations component, lower by 9% and ex gas deflation lower by 24%. SG and A in the core operations excluding that's excluding the COVID related expenses that I'll talk about in a minute. They were needless to say leveraged with strong core merchandise sales. Central was essentially flat and a slight improvement relative to with including ex gas deflation. Stock comp, no surprises there, and a slight improvement to SG and A, but 3 basis points.
And again, the other component, the 71 or 69x gas deflation, of the 71, 66 basis points of the 71 is attributable to the incremental costs of COVID-nineteen or $239,000,000 of that $283,000,000 total amount that was in the press release. Again, these are the costs for incremental wages and safety and sanitation related direct expenses. The balance of the 71 basis point figure was 5 basis points or $18,500,000 This came from the costs associated with the acquisition and integration related expenses of our recent acquisition of Innoval, that last mile delivery and installation operation for Big and Bulky that we acquired a few months ago. Next on the income statement is pre opening expense. Pre opening expense was lower by $6,000,000 coming in at $8,000,000 in the quarter versus $14,000,000 a year ago.
Again, we had 2 openings this year. Last year in the quarter, we had 3, although chunks of each of these numbers relate to pending openings in Q4 as well. All told, reported operating income in the Q3 of 2020 increased by 5.1 percent coming in at $1,079,000,000 this year compared to $1,122,000,000 a year ago. Now this 5% increase is notwithstanding the incremental cost that we talked about that I just talked about the $283,000,000 as well as the $19,700,000 and the $18,500,000 that I just mentioned as well. Those are all taken in the Q3.
Below the operating income line, interest expense was higher year over year by $2,000,000 coming in at $37,000,000 this year in the quarter versus $35,000,000 a year ago. Recall that we completed a $4,000,000,000 debt offering on April 20 during the Q3. Following the completion of the debt offering, we call the outstanding debt due May of 2021, that was a $1,000,000,000 tranche and additional $5,000,000 tranche that was due in February of 2022. Both of these tranches we've paid off this morning after a 30 day call notice. There will be a pre tax expense of $36,000,000 related to the earlier time and or make whole of this debt, which will hit our Q4 results on the interest income and other line in our P and L.
Next on the income statement, interest income and other for the quarter, it was lower by $15,000,000 year over year, mostly attributable to lower interest income and mostly attributed to lower interest rates within that. Overall reported pretax income in Q3 fiscal 2020 was up 3.6 percent coming in at $1,163,000,000 versus $1,123,000,000 last year and again the $1,163,000,000 is after taking the impacts of those charges that I previously mentioned. In terms of income taxes, our tax rate in Q3 was this year was 26.7%. Last year was 18.5% tax rate. Again, last year, it included a benefit of a non recurring tax item of $73,000,000 A few other items of note terms of warehouse expansion.
As I mentioned, we opened 2 units in the Q3. That puts us at 5 actually 5 units total through the 1st three quarters. We expect in Q4 to open 10 including 2 relos, so net of 8. So it looks like our net total this year will be somewhere around 13. There's been a few that have been impacted by COVID-nineteen in terms of construction delays and have been pushed into the 1st part of fiscal 2021, which starts in early September.
As of Q3 end, total warehouse footage stood at 115,000,000 square feet. In terms of capital expenditures, the 3rd quarter fiscal 2020 total spend was approximately $626,000,000 and our estimated CapEx for all of fiscal 2020 is currently in the $2,700,000,000 to $2,900,000,000 range, a slight decline from what we had estimated a quarter ago. And again, I think that has to do with some of the delays in construction since this COVID issue. In terms of e commerce, as I mentioned earlier, overall, our e commerce sales on a reported basis increased 64.5% 66.1% ex FX. I might mention I should note that within that 61 percent, like many retailers out there, we saw an increasingly level of strength in e commerce sales over the last few months.
If I look to the 12 week the 3, 4 week periods that comprise our 12 week Q3, roughly that 66.1% or that 64.5% reported number in the 1st 4 weeks was in the 25% range and the next 4 weeks in the 50% increase range and the most recent in the last 4 weeks in the 90% range, but totaling that 64.5% on a reported basis. A few of the stronger departments, health and beauty aids, office, majors, housewares and small electrics. Total online grocery grew at an incredible rate within the during the Q3, as I'm sure it did in many places. The comp numbers just mentioned again follow that's the 64% number. They follow our historical convention that where we exclude our 3rd party or same day grocery program since that comes into the warehouse to be picked up by the 3rd party and delivered to our member.
If we were to include that 3rd party in our e commerce number, that mid-sixty percent comp number would be slightly over 100%. So we've seen big strength in driving the business that way. Overall, our e com sites have worked pretty smoothly during the quarter despite dramatic volume increases and as well we're able to improve on delivery times throughout the quarter as we adjusted to the ramped up order volumes. Now turning to coronavirus and all the issues and impacts surrounding it. From a sales perspective, as discussed last quarter and indicated by our monthly sales results that we do, We started Q3 strong.
I think it started actually in the 4th week of February and into the 1st two and a half weeks of March with very strong sales as people were stocking up prior to the the concern about availability of certain key products as well as the implementation of various stay at home orders. The middle of the quarter was weaker as many of the geographies in which we operate had issued mandates limiting movement as well. We have implemented our own restrictions during these times. Recently, our sales have started to recover somewhat as states have begun to relax restrictions. Within the merchandise categories, foods, fresh and other essentials have been very strong despite out of stocks on some items throughout the quarter such as toilet paper, paper towels, cleaning supplies, etcetera, meats and proteins toward the end of the quarter, hand sanitizers and the like.
Office and majors were also strong during the quarter driven by work from home initiatives, while most other discretionary categories were a little weaker during the quarter, such as jewelry, luggage, third party gift cards, they were generally weak. Other weak categories, which include things like sporting goods, lawn and garden, patio and apparel, while they were weak, they've rebounded somewhat towards the end of the quarter. From a supply chain perspective, I'll give you a 40,000 foot view of that. On the non food side, as it relates to imports from China, most of the factories are now up and running. Other major country suppliers, India for textiles and domestics, Mexico, primarily for things like TV assembly, a few weeks behind China in terms of getting back to normal, but each week is showing improvement.
On the food and sundry sides, paper goods still on allocation and item limits on certain items in certain regions, sporadic limited limits on canned food items like tuna and chicken. Toughest areas again are still hand sanitizers, disinfecting wipes and Lysol sprays and the like. Items like milk and butter are generally okay. And we've also we have eliminated like frozen certain or host frozen proteins like chicken and beef items. In terms of fresh, on the protein side, the merchandise is there, but challenging from a production and processing side.
Currently for us, pork is the least affected, but somewhat affected. But what we've done for the last couple of 3 weeks, I believe, on fresh beef, chicken and pork items, so those protein items, we'd limit 3 fresh items in total. We also have limits on of 1 per SKU on certain frozen items like £10 of hamburger patties or chicken breasts or the like. In terms of seafood and produce, that's all good. And again, talking to our buyers in these categories, they're generally, again probably with the exception of the hand sanitizer because of just it's not just people who are hoarding it, there's a great increase in use and demand of those items continued.
But we expect continued improvement generally each week. And lastly, Costco Travel, it was needless to say significantly impacted during the quarter due to reduced demand as well as cancellations of previous booked trips. Members are now starting to actually book travel again, although generally further out than we have certainly seen and of course we book those results when the trips or activities occur. Our warehouses have overall remained open, although we did operate at reduced hours at most of our U. S.
Locations for several weeks during the quarter. Regular hours resumed May 4 with an additional hour on weekday mornings for seniors and persons with disabilities. Warehouses are still Additionally, as discussed, some of our warehouse businesses like hearing aid, optical and photo and to a partial extent the food courts were closed or mitigated during the majority of the quarter. Also effective May 4, we now require all members and employees in the warehouses to wear masks. During the quarter, including that again that big $283,000,000 number, we spent about $32,000,000 on masks, gloves and incremental cleaning and cleaning supplies and things like flexi glass partitions and you name it, all related to COVID.
But that's in that $283,000,000 number. Some of the initiatives related to the $283,000,000 and costs will extend into Q4. We would expect the incremental expenses related to these types of expenses related to COVID to exceed 100,000,000 dollars in Q4, but be quite a bit lower than the $283,000,000 $283,000,000 that we had in Q3. We'll have to just wait and see though. Finally, in terms of upcoming releases, we will announce our May sales results for the 4 weeks ending this Sunday, May 31, next Wednesday, June 3, after market close.
With that, I will open it up for Q and A and turn it back to Joseph. Thank you.
Thank you, sir. We have our first question from Simeon Gutman from Morgan Stanley. Your line is open.
Hey, Richard. I know we have to wait till we get the May results, but I don't know how much you can preview us just given how dynamic the environment is in terms of the mix of product that's being sold, traffic to warehouse because the environment now you're starting to see other states and stores open. Curious if there's anything you can call out as a preview for May?
I really can't call anything as a preview. Some of the comments I made in this document as it relates to towards the end of the quarter, we saw certain things pick up. The fact that we went back recently to full hours, we're all better both us, our employees and our members are better at getting through the warehouse. So seasonally, I think some of the items that were online have picked up that we talked about and but we'll wait and see next week.
Okay. And then my follow-up on memberships, I think you said ex FX, they were up 6%, if I caught that. Can you parse out U. S. In the quarter relative to that 6%, if that is the right number?
And then anything that surprised you with regard to the pace of new members growth, the actual amount or anything geographic?
Generally, no. But what we talked about way back when the end of Q2 and the beginning of this quarter, we saw some pickup when there was a lot of when we had these crazy strong numbers and people were coming in to buy all those essential short supply high demand and short supply items, we saw some additional sign ups, but not meaningful relative to our whole company in those weeks towards the end of February and the first half of March. Other than that, I think the fact that the traffic is down a little bit, but the average ticket is up. You've got some members that are coming in and bulking up a little more. But and then you have some members that are not coming in as often.
So that hits you a little bit, but overall, we think that we're in pretty good stead.
Okay. Can I just sneak in one more? I just want to add
on Yes. One other comment is that we have also seen a switch from walk in sign ups to online sign ups. And that's good. When you sign up online, I know you're also required to have auto bill, which is a positive for renewal rates long term.
Yes. And then the last one is on e commerce, the assortment, the SKU assortment. Any like strategic thinking that we should have a bigger assortment you do? I think you were always adding, but is there a rethink as far as the total number of SKUs?
I don't think necessarily the total the only total increase is where we've gone some additional flyers and some very limited items. So we've expanded our supplier network in some limited cases. Beyond that, it's more of a shift. It started with, if you will, some of the big and bulky items and this started well before COVID like white goods and that's continuing. And certainly, the strength that we've had online whether it's reported online through our 2 day grocery or through e commerce or third party providers like Instacart and Shipt and others, all that stuff has driven some of the business from the warehouse online.
And again, I think we've if I go back 6, 8, 10 weeks ago, whatever the normal time to get something was, particularly like 2 day grocery was well more than 2 days, we're back to 2 days. Same day, our 3rd party suppliers had challenges of they ramped up in the 200 plus 1,000 new employees in a matter of weeks. That too has gotten a lot better in the last few weeks. So I hate to use the word strategic. We certainly know that big and bulky can be done very effectively online with a few displays in the warehouse as well, but have that delivered and installed through online and that will continue.
It probably has been expanded a little bit because of this, people at home, things like exercise equipment and big electronics and things.
Okay. Thanks, Richard.
We have our next question from Chris Harbors from JPMorgan. Your line is open.
Thanks. Good evening. So a couple of questions on the margin front. Can you talk about, break down the ancillary margin a little bit terms of what you saw in terms of the benefit of gas versus the headwinds that you would see from mixing down in those other categories? And as you look ahead, given where you see gas prices are at this point, would you expect that benefit of gas to if prices held to be higher in the current quarter?
Well, there was a perfect good storm in the last quarter as it relates to margins in gas. And I think there's not even our information, but there's public information on strengthening retailers that sell gasoline in terms of gross margins. We certainly benefited from that. A little offset to that was a reduced number of gallons, but nonetheless it was particularly strong. I think that's evidenced in the matrix.
You have higher margins on some of those other ancillary businesses like optical and hearing aid while small in size, there's a higher margin because we have to account for the additional cost of optometrists and hearing aid technicians and the like. And so those types of things, gas being the biggest piece of it dwarfs the other stuff, but it all adds up to it was net net good for us in the quarter.
And so was there any did you have any impact in terms of like the apparel category? Did you have to take any markdowns? And as you look ahead, how are you thinking about that the potential risk of that category impacting? Or are you seeing some rebound in that category and don't expect that to be a headwind in the next quarter?
Fortunately, we haven't seen a lot of markdowns. I mean, apparel for us is a pretty season there's a big component of it that's seasonal. And when this thing first started, we were able to talk to suppliers and work deals where in some cases, certain things hadn't been made yet or they had the raw materials, but they hadn't finished the product. So let's pay for part of the finish for the raw materials, but hold off until next season. We've held on.
We'll have one of the reasons we went and borrowed money was looking at the worst case, which in our view has not happened. But what if we had to hold some big volumes of seasonal stuff, we were going to whatever commitments we had, we were going to respect. But I think the combination of working with our vendors as well as sales have rebounded in those areas a little more than expected. It's not that people are coming in and going down every aisle, some are just going and getting their essentials and heading out of dodge. But at the end of the day, I think as the weather has turned, we've been a little bit more felt a little bit more good about things.
Who knows what tomorrow brings though.
Okay. And then just the last question also on gross margin. Did you mention that e commerce was actually a benefit? Most retailers we've seen have a substantial headwind as e commerce growth accelerated, but it didn't seem to occur here because so could you elaborate on that?
Well, first of all, it's like I think everybody for us certainly a lower margin business as we try to build it over time. Where the gross margin it's really the gross margin dollars are stronger because of the huge sales volume. We are spending more money on it and so probably I don't have it in front of me, but as a percent of profits as a percent of sales I'm sure is down a little bit and that's expected. But the total gross margin dollars are up simply because of the sheer strength of it. Understood.
Thanks very much.
We have our next question from Michael Lasser from UBS. Your line is open.
Good evening and thanks for taking my question. Richard, are you reaching an upper bound of your membership potential in the U. S. With the view that if a pandemic is not going to motivate a regular consumer to sign up for a membership, then it may be hard for them to sign up under any scenario?
Well, we certainly don't believe that. There's going to be 2 or 3 new normals over the next 2 or 3 years and probably not a real new normal. Then with its own set of difficulties besides that. We're asked the question constantly, when I talk about this giant 10 plus fold increase in same day grocery delivery, that's certainly because people there's a group of people that don't want to go out. There's others that want to come in, but they come in less frequently and buy more each time.
There's going to be some new normals. Our guess is that whatever it's gotten to is not going to necessarily maybe does it back down a little bit at some point, still be higher than it was the day before all this? Sure. But who knows? That's something that we talk about every day around here.
And I think over time, there's been a lot of questions and we're happy with our rule rates. And we're all going to have to get past this. One of the things we and some others of what I'll call the big essential retailers, we've all been fortunate that we've been open. And when you talk to people anecdotally, they feel frankly more comfortable coming into Costco which is bigger, more wide open with certainly the 6 feet apart that we're all doing with the mask requirements. There are a few people that don't like it, but there's most people do.
So I think all the things that we're doing including the visible things that you see in store. And then look at the end of the day it's a value proposition. Our average gross margin is in the very low very, very low double digits, 11% or 12%, implying whatever a 13% or so markup. Traditional retail grocers are in the mid to high 20s and other big boxes are above that and regular retail is way above that. So ultimately it's got to be a combination of all those things.
We got to figure out ways to get you in And I think we've felt so far at least successfully sometimes progressively, but successfully figuring out how to get you stuff online as well. And it will be a combination, but we'll have to see over time.
And my follow-up question is speaking of online, given the success that you've enjoyed as of late, coupled with the acquisition you made a couple of months ago and the overall increase in online penetration that we've witnessed across retail in the last few months, Is there an inclination within Costco to push harder to market your online channel more to expand your offerings to consumers or because of the desire to still push consumers into the store that you will maintain your posture?
Well, I think by necessity, we have responded. And maybe for those of you sometimes I'm not suggesting you Michael, but that feel that we've been a little stubborn or not wanting to do some of this stuff. We still want you to come in. You're going to buy more stuff when you come in period. And we think we can do both.
I mean, we recognize and I think white goods was the best example way before COVID. 4 years ago in the U. S, we did $50,000,000 in white goods sales. 3 years later, we did $600,000,000 on our way to 1,000,000,000 dollars which is getting there faster simply because of COVID right now. Certainly, the acquisition of Innivel helps a lot of higher ticket big and bulky items, many of which people don't want to put in their back of their suburban or truck and take home.
So I think we'll have to see over time. We feel we've also been pretty good, again COVID has changed things a little bit right now, of doing marketing and having email promotions that are in warehouse. And again, time will tell over time and we'll figure it out together.
We have our next question from Chuck Grom from Gordon Haskett. Your line is open. Hey, good afternoon, Richard. It's actually John Park on for Chuck.
Can you
talk a little bit more about what you're seeing from a gas gallons perspective towards the end of the quarter, a crossover to those visiting the club? And then how some of those metrics have changed as certain areas have opened back up and are starting to normalize?
Yes. Look, just driving to work, you know there's less gas gallons being bought. I think it has picked up a little as just hearing the news and seeing I know in the state of Washington, they have each state the percentage of cars traveling on different interstates is improving a little bit. Part of it is some of the stay at home stuff is part of it is the weather has gotten nicer and people want to get out of Dodge. It has to impact a little.
One of our frequency catalysts or the frequency catalysts that we've always talked about are fresh foods, executive member and gas. So the extent that gas has come down a little bit, that hurts a little bit. Offsetting that has been the fact that one, the average ticket in the store was way up, which helps offset the lower traffic. And again, who knows what tomorrow brings. We're encouraged of how we got through so far.
We've seen some things pick up a little bit in the last several weeks in terms of categories or as weather turns. Certainly, some of the openings, I think, should help us. But again, we'll let you know. Hello?
We have our next question from John Heinbockel from Guggenheim.
Richard, when you think about the Innoval, what's the biggest impact that's going to have from a customer perspective? And maybe it's just coincidence, it looks like you look at some of the mailers, you've been pushing big and bulky a little more here. I assume that's not tied to Innovell, that's just what you would have done anyway?
I think it's kind of what we would have done anyway. It certainly is because we now have the confidence that we can provide a better service at frankly a lower total price. Intervale was one of our suppliers that has always done a good job as have some others. But we and as we build more volume on it and get more density, that tool will allow us to lower the cost and lower the cost to our members. Certainly with that and what we've seen again, I think if you'd asked us 4 months ago, hey, we're going to have this big COVID thing and this is what's going to happen, we certainly weren't didn't know that we would sell more big and bulky items.
What we're finding is, is because people are at home, notwithstanding some of the economic things of layoffs and furloughs, people are buying things for the house. We saw that again more recently with not really a 2,000,000,000 bulky, but lawn and garden. If you had asked us 2 months ago how is lawn and garden going to look and we'd say it's going to not be very good because of all the economic issues. So I think at the end of the day, we are marketing additionally right now because we have the confidence that we can we've seen the delivery times on certain big and bulky items improve dramatically on small groups of items as we onboard some of those items. It's a year plus process.
And on the savings book, thought process there, it looks like the assortment sort of getting back to normal, right, from a food and sundry standpoint. When is that fully back to normal? And do you go back to mailings or stay digital only for now?
We will go back to mailings in June.
And the assortment normalizes in June as well?
Yes, for the most part, yes. Okay. Thank you. We
have our next question from Karen Short from Barclays. Your line is open.
Hey, thanks very much. A couple of questions on, I guess, e comm in general. Wondering first within the membership growth, is there any color you could provide on growth in online sign ups versus walk in? And then I wanted to just ask a little bit more about e comm generally. I mean, I know you've kind of obviously, you're blessed and cursed with very high velocity units and you've had to do the distancing, which has impacted traffic.
But would that kind of cause you to rethink potentially much more robust click and collect model? And then I just had one
other follow-up. Well, first of all, in terms of online sign ups, a member that again, there are some members that aren't coming in, they're coming in less frequently. To the extent they didn't come in the 1st part of this month and this is normally when they would come in and when they went through the checkout, it would notify them that they're up for renewal. They're now getting their email, which they would have gotten had they not renewed. And so that's pushing some of it that way.
Certainly, there anecdotally have been plenty of people that have signed up to become members simply because of the one day fresh or the 2 day dry on grocery. And we're seeing so we're seeing a big push. I think it's too early to tell what happens in the future. I think more of it will go online just like everything else in life and we'll do that. In terms of click and collect, we have very limited click and collect right now.
It's in some of those high value jewelry, small electronics. We did add pharmacy to it and that's not only click and collect, that's click and deliver through we're expanding, we're not everywhere yet with the benefit of Instacart. Tires we're doing that where you could go online, order it and schedule it schedule your tire installation. Photo. Photo.
So we are doing more things. But if you're asking the question to buy online and pick up in store in general, we're not looking at doing that on a regular product basis. We do delivery instead, again, through 3rd parties in a big way as well as our own today.
Okay. And then, I mean, I know it kind of seems like a lifetime from now, but when we look towards the fall, as it relates to merchandising, like back to school Halloween. I guess the question is, well, 2, how much flexibility do you have to pivot to the extent that there really isn't much of a Halloween or back to school? And then the second question is just bigger picture. Everybody loves to go to Costco for the sampling.
So I'm just curious how you think about that going forward. Is that something that we'll not likely ever see again? Is there anything that you're discussing in terms of how you could reintroduce that safely? Anything there?
Karen, I missed the second part of the question. In terms of how do we feel our ability to have pivoted and look if you go back 2 or 3 months, 3 months ago we were cutting orders reducing orders recognizing there's going to be plenty of merchandise out there in these categories. Certainly for things like Christmas, I think we reduced the selection of a few things. And so a little more regular items than out there items, but and now we're pivoting to try to get a few of those items, which are available. So I think frankly, I think in some ways it's been easier for us because we have so many fewer SKUs and we're willing to try a few new things.
And now I didn't get the second part of your question.
The other part of it was just people love going to Costco for sampling, food sampling, that's a big part of the experience. So how are you thinking about that just bigger picture when we get to a new kind of abnormal?
We're going to start doing some things in mid June on a slow rollout basis and sampling. I can't tell you anymore, but it's needless to say not going to be where you go and just pick up an open sample with your fingers. But the sampling both food and non food items are popular. And roadshows as well, I think you'll see little bit more excitement on the roadshow side. So things that we can do to get people excited about coming in.
Okay, great. Thanks.
We have our next question from Greg Badishkanian from Wolfe Research. Your line is open.
This is actually Spencer Hanus on for Greg. Just turning to e commerce again, can you give us any color on the repeat rates that you're seeing from the new customers that it looks like you're adding to the platform? And then have you been able to take advantage of some of the lower online advertising costs that are in the marketplace today?
On the second question, the latter question, I don't know. I'm out to speed on that in terms of lower prices. I would assume, as what I've read in the paper in general, So I'd assume we have some of that ability, recognizing we don't spend a lot to start with. On the first question was what? Repeat business.
What are the repeat rates? Yes, you know what, that's another one that I don't know off the top of my head, Sorry.
Great. And then just if we could turn to small business customers, can you talk about what you're seeing there? How did the sales go throughout the quarter for that segment of your customer base?
Well, look, I mean, foodservice related small business is down everywhere. It's been helped a little bit by some of we're less about serving the big restaurant change, but the mom and pop restaurants. And so the takeouts in your neighborhood, the Japanese, the Chinese, the Thai, those types of things, they're doing some business. Arguably, what business we're losing on some of those things, we're gaining because you're eating at home. So overall, I think just in looking at fresh foods and the food items of what we call food and sundries, it's been way up particularly in fresh foods and somewhat in the rest.
So I think overall we've been blessed. Now the question beyond that is what happens when everything opens up. I think it's going to be a lot the new normal is still going to take some time. You see on the news that even in states where it's been open, there's not everybody running to sit down and then there's restrictions on how many people can be in a certain place at a given time. So again, having fresh foods has been certainly something that's been very positive for us.
Great. Thank
you. We have our next question from Kelly Bania from BMO Capital. Your line is open.
Hi, good evening. Thanks for taking my question. Richard, I think you mentioned executive penetration, if I heard it correctly, was up 135,000, which seemed to be just a little bit of a slowdown. I'm wondering if it was just impacted by the environment and if you have to do anything to change your process in terms of convincing members to upgrade there?
Yes. It fluctuates all over the board. Certainly, it shows improvement when we add a country like we've done just in Korea in the last couple of years. It certainly is down from its peak a few years back. Probably the biggest things are that getting back to traffic.
Traffic is down a little bit. The other thing is one of the things we do in Store A Lock is something we internally call e blocks or electronic blocks. So based on when your membership is scanned based on your historical purchases, it makes all the sense in the world for you to upgrade to an executive member. We've chosen for the last couple of few months not to do e block because it's 1 on 1 direct contact with the member while they're waiting in line at the register. And so we've probably my guess would be a little higher.
And then we haven't opened a lot of warehouses year to date. So we'll get back to normal on these things, but we don't it does not raise a concern for us at all at this point.
Okay. And just as a follow-up, in terms of renewal weights, I think you mentioned any impact from COVID there will be in the next few months. Maybe just can you give us any color on what we should expect to see? I was thinking maybe there could be a positive impact to renewal rates from this environment, but any color you can share would be helpful.
Well, we do what's called it, we've always done it this way, a fully captured rate for renewal rates. So let's say you signed up originally in January and so in sometime in December, you get your renewal notice. And let's say, we ultimately get to that 91% renewal rate in the U. S. And Canada.
By the end of January, you and for all the people that signed up in January, maybe by the end of January, I'm making these numbers up, you're at 75. And by the end of February, you're at 82. And at the end of March, you're at 85. And it takes you might even get the last 0.5% or 1% of that renewal rate 6 months out because it's if somebody that was a snowbird or somebody that just doesn't come in that often, There's always going to be that. In addition, whenever you have a group of new members irrespective of whether it's online and in store or in a new country, you have a lower renewal rate in that first respective year and then it builds each year over as year 3 becomes the combination of of renewing for the 2nd time at a higher percentage than those that signed up originally in year 2 and signed and we're renewing for the first time in year 3.
So I and that I just want to we don't know which direction. We know that we wanted to say that because we don't know where it's going to go. But the renewal rate right now is mostly related to stuff that happened 4, 5 6 months ago 7 months ago.
Thank you.
We have our next question from Paul Lejuez from Citi. Your line is open.
Hey, thanks. Richard, can you remind us of the economics of an online order in terms of basket size and what's in that basket? Then separately, curious if there are any categories within the box that you would say are a bit high from an inventory perspective? Thanks.
Well, first of all, from online, there's regular online which includes a lot of the big ticket items. So I don't have the number in front of me, but if in store during regular times the average front end transaction was in the 1 60 range 140 range. I'm sorry, 140 range. Online, which include a lot of big ticket items, was probably 300 to 400 range. As we've added 2 day grocery, that number has come down.
Certainly, while we don't again include e comm, the same day grocery that the likes of Instacart and others come in and do, that's going to be lower as well. So all these things are in flux right now. Got you. And then
on the inventory side?
Again, I'm happy to report there's less than we braced for the worst case a few months ago or a couple of months ago and when we decided to raise some extra capital. Might we have to take things like seasonal apparel and seasonal lawn and garden and luggage. We do have some luggage to sell you, but it's a small category. But at the end of the day, all those things are less than we thought. So, yes, there will be a small amount of items of I mean, probably in the few $100,000,000 to several $100,000,000 that will hold for a season or up to a year.
But these are not things that are going out of style even in items like apparel, which again I think we did our buyers did a very good job of mitigating that impact initially with suppliers. And also it's come back a little better than we thought, not all the way back by any stretch, but better than we thought. And in addition, we're not exactly high fashion where things are going out of style. A lot of things that we have, whether it's some furniture items or apparel. Our senior merchant in the room is not pleased with that comment.
But yes, we're basic. We're fashion basic. We're not careful about that. Got you. Got you.
And then just Richard, what percent of members shopped the club in 3Q versus last year and did this quarter mark the peak in that metric?
I've never looked at it. I mean, it's a good question. We'll have that for next time. Certainly, it's a lower percentage this quarter simply because of new members or people that have decided. I mean, I have friends that have not chosen not to go physically anywhere and they're having things delivered and they love the same day fresh.
So my guess has come down a little. Why don't we have 2 more questions? Thanks. Good luck.
We have our next question from Greg Melich from Evercore. Your line is open. Hi, thanks.
Thank you. So Richard, it seems sounds like e commerce was probably 8% of the business in the quarter. And if I'm interpreting it correctly, should we think of it as that, that would have grown to over 10% if you include the Instacart?
Yes.
As part of the balance?
Yes.
Okay. And then second is on inflation. You talked about obviously deflation in gas and what that is to the top line. Has there been any inflation, especially given some of the shortages and proteins, etcetera, that's worth noting as an offset?
Overall, ex gas, overall, it's very small. And I actually guess because it's a lot more sales volume than there is inventory level. But on certain limited items, we've seen extreme examples were like eggs for a period of time, some of the protein items, you know, like meat. But I would guess that it's impacting us a little less than others in some of those categories because of some of our supplier relationships and strength. But that's on and it's coming back now.
It's coming down. So overall, it's I would say very little difference.
Got it. And then on Innovell, just a follow-up on that. How much of Innovell's business was distributing other people's things and where does that revenue show up and how you're thinking about either growing or reallocating that capacity?
Well, keep in mind, this Intervale is a business built over decades to serve Sears, its owner. And Sears of course has come down dramatically over the last few years. And while I can't disclose all the numbers I'm aware of, the component that was actually still servicing their needs had come down. And then also they had gone through their own reorganization as a retail company. And with that, I think they lost some business along the way.
So there's an infrastructure and a capacity in place, infrastructure place with great capacity. And so we view this as an ability to do great things with.
Could you describe that capacity a little bit, like number of employees or footage?
I think employees were 1550, 1500. There are about 100, there is about there is I think 11 large facilities, call it the roughly 800,000 to 1,200,000 square foot facilities. And then about 105 smaller facilities which could be as small as 8,000 or 10000 feet or as big as 50 or 60 and spread around generally serving I think 85% or 90% of the U. S. And again there's a lot of ability to it has a lot of capacity.
And we were doing we've worked with them for 5 plus years, I believe. And but like anyone else working with them, we're doing a small piece of our business because we didn't know what was happening to the business as parent was going to its own restructuring.
Got it. Thanks. Well, good luck.
Thank you. Last question.
We have our last question from Rupesh Parikh from Oppenheimer. Your line is open.
Good afternoon. This is actually Erica Eiler on for Rupesh. Thanks for putting us in and taking our questions. So I wanted to touch on the store capacity restrictions that you put in place. You talked a little bit about the impact from some of the ancillary businesses being closed had on your sales.
Are you able to quantify for us what you think the impact may have been to sales from the store capacity limitations and restrictions that you put in place? And as things start to open back up in certain markets, are there any changes in these restrictions you put in place? And can we expect to see these restrictions weigh upon sales for a bit longer?
Well, the only thing that we pointed out and I pointed out earlier was is that those businesses like optical, hearing aid, reduced food court, those things was somewhere in the middle between 1 percentage points impact in Q3. Aside from that, when we went from generally closing Monday through Friday at 8:30, we went to I think 6, but we also added an hour in the morning for elderly and expanded that from 2 days to 3 days and now to 5 weekdays. We have not tried to quantify that. I can tell you that when we've had some very busy locations historically and we said let's add an hour in the morning or an hour later at night, what we found is we tend to just spread the business. So I think the same thing here.
There's not a lot of big impact other than our view our qualitative view was that there's a lot more impact from shelter in place and stay at home and come and get what you need and leave than there is from anything else. And again, is that I was encouraged by some of the things I've seen with a couple of the other retail apparel stores that have just started to open and are showing good numbers because people are coming back. So I think that net net is encouraging, but I don't think it's a big it was a big impact to us either way. Okay. By the way, yes, there was you noticed in our numbers, Canada was weaker than the U.
S. In Canada, in Quebec there is actually limited there is current outstanding limitations of Sunday closes, which is new over the last few months. And there's also I think been a little bit more stricter generally up there, either stricter or people listening better to stay at home issues. And so we've seen in a country where we're the only game in town in terms of warehouse clubs, we've seen weaker traffic and therefore slightly weaker numbers in the U. S.
Okay. Well, I guess that's a good segue into my next question. So I was just curious on the international side, if there's any more color you can provide on what you're seeing internationally with regards to coronavirus impacts. Are there any notable differences in terms of behavior or any other callouts versus the U. S?
Well, I think, again, putting on my blinders for a minute, I mean, Taiwan and China are the most encouraging. China, we have one location, of course, that's been open for less than a year, so we don't have a year over year comparison. Taiwan is quite strong. Japan is quite strong, maybe a few weeks behind that. We see Australia coming back.
So overall, that gives us encouraging news for the U. S. And Canada. But part of that answer is so what until we see it.
Okay, great. Thank you so much.
Okay. Well, thank you everyone. And me and my guys here are around to answer questions. Have a good day.