I think the term you're looking for is "Print on Demand," or POD. POD books are not generally carried in brick and mortar stores because the distributors for POD don't usually take returns - so if the bookstore orders ten copies of a new release and only sells a couple, they're stuck with the remaining stock.
.....
Many small presses use Ingram Spark as their distributor (a subdivision of behemoth distributor Ingram which specializes in self-publishers and small presses). However, Ingram Spark will not get your books on the shelves in brick-and-mortar stores, either, although your book will be available for special order from the Ingram catalog.
I think you may be conflating Ingram Spark and IPS (Ingram Publisher Services). Ingram Spark is not a distributor - it is for self-publishing, similar to CreateSpace (ie it will print books POD and get them listed on e-book and book retailers like Amazon, B & N, etc). Ingram Spark titles are generally listed in the regular Ingram on-line ordering system for bookstores, although afaik the self-publisher can decide on the discount to bookstores (eg standard or short) and whether or not it is returnable (at their own expense).
Ingram Publisher Services is Ingram's full-service distribution arm for independent publishers ranging from well-established houses like Grove Atlantic to tiny ones with 10-book catalogs. (lately they have been adding some 'hybrid' presses and borderline-vanity presses which concerns me a bit). IPS has sales reps that visit bookstores to go over publisher catalogs, give out ARCs, etc.
And a note about POD - Ingram does the POD printing for the Ingram Spark titles as well as other POD books, including those from some small trade publishers. In some cases these are listed as returnable if the publisher sets it up that way (at their expense). So in and of itself, POD is not as much of a barrier to getting into bookstores as it was even 5 years ago. There are a number of great little niche presses that use POD rather than offset but the quality of the finished product is high, the marketing to stores is good, and they make sure their books are returnable through Ingram.
In any case, I checked Ingram for Winter Goose books, and there are just over 100 listed going back to pub dates in 2011. The discount? NET, non-returnable. This means that if a book has a list price of $10.99, a bookstore has to pay $10.99 to get it. How's that for "not gonna happen!"? I'd maybe order it for a loyal regular customer special order situation, but otherwise no way. I wonder why they even bother putting them on Ingram. Just to say they can? (Oddly, of the 6 or 7 I checked, one had a 5% discount. That's almost worse than NET, an insult to bookstores - our margins already suck. 5%? Come on.).