You might be scammed. Even if is not...
Is it an Orange SIM at the corner?
Have you ask the Orange shop why?
Did you check for the cell provider and signal on you cell phone when you got the SIM card at the corner?
What didn't work? Phone calls? Data?
Is it a French number? +33? Or a UK number? Until they leave Brexit, it is not uncommon to peddle a UK SIM card outside the country. They will market it as able to use everywhere in Europe. However, it will cost you more (voice and especially data). Using data on even a few hours of moderate use will clean out your balance.
To defend the corner store, I always get my SIM cards in Spain from either the corner store at the train station or bus station before I travel to my Camino starting point. Less effort than to find a department store, Carrefour, or Orange store. So far, they have been fine. You just need to spell out what you need to them.
Just a bit of attention is all you need.
1. Make sure the SIM card says Orange, or Movistar, etc....
2. Make sure they put the SIM onto you phone and check for signal.
3. Know how much voice credit you are getting.
4. If you need data tell them. 1 GB? 2 GB? How much?
5. Make them help you enter the code to say topup the data, etc. You don't want to do it yourself especially if you not familiar with the language and procedure.
6. Finally sent a message via text or data (Whataspp) and make sure it is okay before you leave the store.
A note: Make sure you cater around 20 minutes for this unless the SIM card already has all the things you want already bundled. Almost missed my train the last time.