Sorry if this is long but I really need to get this off my chest and figure out where I went wrong.

So a few weeks ago I (m36) managed to build up the courage to ask out a woman who works at my local grocery store where I do most of my shopping. She said yes which was a shock to me as so far every woman I've asked has said no and/or that I'm too good of a friend etc. We exchanged numbers and she seemed surprised and interested when I asked.

We were talking a bit over text, and I had asked her if she would like to go out for coffee or lunch sometime, something casual and with no real implications other than getting to know each other with the possibility of dating. We somewhat shared our work schedule to try and set a time for a possible lunch or coffee date. Her schedule was not as concrete as mine, so I had told her to let me know when she was available.

Things kept coming up for her, and over a few weeks we didn't text much, maybe once every other day, and I was the one always initiating the conversations. After talking for a bit one night she sent a fairly long and very vulnerable text about how she had just ended a long term relationship that had become toxic, and had also recently went out with a guy who was also possibly abusive in some way (she did not go into detail and I did not ask). She did mention that she wasn't sure if she was interested in dating right now as she didn't want to be hurt again which is absolutely fair.

I then shared quite a bit of personal/vulnerable information as well to try to diffuse the situation and to hopefully make her feel at ease. We ended up talking way more that night than we had the entire week before, and I felt like there may have been some connection as we did have some things in common.

I asked her again if she would be interested in going to coffee just to talk, with zero intention of dating, just so we could both get more comfortable. She agreed and we had set a date and time. The morning of the day in question, she sends me a text saying she was being called into work and had to cancel, and asked me again which days I usually have off, which I told her. That day also happened to be the day that I also do most of my chores and errands as well as my weekly grocery shopping.

When I went for my normal shopping around the time she said she would be working as I have been for years, I did not see her at all in the store, and she is usually one of the front end cashiers. My immediate thought was that she had lied to me, and for some reason just couldn't or wouldn't tell me the truth.

I haven't contacted her at all since that day, and she has not messaged me either. At this point I'm not going to send any more texts, as I feel like I got the hint that she is actually not interested in anything at all. I'm still not sure if she had actually lied, or for some reason just wasn't doing her normal job that day, but this is a huge blow to my ego as I've never actually had a woman say yes to me asking them out. I'm just not sure why she would do this as I tend to see her a couple of times a week when I go shopping and I feel seeing her will be very awkward.

TLDR: I'm not sure if I was lied to and ghosted after asking a woman out as she cancelled last minute and was not at her job when I went in for weekly grocery shopping where she works.