[HS] Re: Search Single Store

Chris, thanks for your continuing interest and assistance.  I don't know how you do it.

I've uploaded my Shopping db to Files as you requested.  I'm using HSv3.2 build 6516.  I've eliminated duplicate items from my Shopping db and now use Multiple Stores.  The two stores I use for grocery shopping are Ingles and Fresh Market.

1.  Menu-Tools-Options selections are:
   -Database:  per store prices and aisles is check-marked
   -Sort:  Sort View is set on Need, Sort By is set on Aisle
2.  Today I want to shop at Ingles, so I've chosen Ingles from the list of stores.
3.  Menu-View is set on Need.
4.  Of the 8 items I need, only two are showing aisle numbers, Cole Slaw and Milk.
5.  If I select any of the needed items and go to Menu-Details-Stores, the aisle numbers for both Fresh Market and Ingles are there (Ingles in Unfiled as you have indicated in the past it should be when Ingles is the store I'm shopping in)
6.  If I uncheck per store prices and aisles, all the aisle numbers show up for Ingles, but are not sorted by aisle.  The sort is neither by Item nor by Aisle and appears to be random.

Hope this explains my dilemma.  

Bill


--- In [email protected], "chrisant_wa" <chrisant@...> wrote:
>
> Still not understanding the steps, or the description of what is happening.
> 
> Could you upload the database into the Files section of this forum (or email to chrisant at premier1 dot net), and give a specific example from that database, with specific steps for what to do to observe the issue that you're asking about?  Point out specific items that you have questions about.
> 
> Also, what version of HS are you using?
> 
> Also, a while back you had a comment:
> > > > When I'm compiling my shopping list for Store B I'll 
> > > > do a search for milk and two entries will show up, 
> > > > one in aisle 2 and one in aisle 14.
> 
> That sounds like you have two separate items of Milk in the database.  Why have two?  HS is designed to have one, and if you care about tracking aisles on a per-store basis then enable the Per Store Prices and Aisles feature, and enter price/aisle on a per-store basis.
> 
> Then when you're compiling your shopping list for Store B you'd choose Store B from the Stores dropdown to filter the list, and then you'd only see one Milk, and you'd see the aisle for Store B.
> 
> 1 item can be associated with 100 different stores...
> 
> 
> --- In [email protected], "billszerlip" <billszerlip@> wrote:
> >
> > Still having problems.  In Store A, some items show aisle numbers, others don't although they're all entered the same way (i.e., multiple stores with aisle numbers for each store entered separately).  Also Sort is set by aisle but is not sorting by aisle.  Tried turning per-store prices and aisles on and off.  When it's off, the aisle numbers show up for Store A but the Sort still isn't working.  Running on a Sprint Mogul with Windows Mobile 6.1 Professional.
> > 
> > 
> > 
> > --- In [email protected], Barbara Needham <barbarajfn@> wrote:
> > >
> > > You just choose MILK and mark it needed. It will indeed show up in both 
> > > stores. But it would do that anyway even if the search showed only one 
> > > store.
> > > Then you go make sure your per store aisles and prices is checked, make 
> > > sure you are in store A, and your milk will be marked needed.
> > > 
> > > Of course, it will also be marked needed in store B... you did need 
> > > milk, right???
> > > 
> > > There was an add-on utility where you could say I only want to buy milk 
> > > in store A and never store B but I'm not sure it would work in current 
> > > iterations of HandyShopper.
> > > 
> > > 
> > > 
> > > On 07/18/2010 6:38 AM, billszerlip wrote:
> > > >
> > > > I shop in two different supermarkets.  Milk is in aisle 2 in Store A
> > > > and aisle 14 in Store B.  When I'm compiling my shopping list for
> > > > Store B I'll do a search for milk and two entries will show up, one
> > > > in aisle 2 and one in aisle 14.  I obviously don't have aisle
> > > > locations memorized for every item in each store, so if the same item
> > > > (milk) shows up twice with different aisle numbers, I don't know
> > > > which one to choose for Store B.
> > > >
> > > > Do I need to put each store in a separate database?  Thanks, as
> > > > always, for your response and your great tool.
> > > >
> > > >
> > > > --- In [email protected], "chrisant_wa"<chrisant@>
> > > > wrote:
> > > >>
> > > >> I don't understand what is meant by "the result will show the same
> > > >> item for all of the stores".  Can you describe what you expect it
> > > >> to do, in a little more detail?
> > > >>
> > > >> The database has items.  Items are associated with stores.  But if
> > > >> an item is associated with 57 stores, it is still just 1 item.  Do
> > > >> you mean that if you are filtering by a store, then you want to
> > > >> hide all other store associations in the Stores screen of the
> > > >> Details screen?  That would defeat the whole point of the Stores
> > > >> screen, so if that's what you meant can you explain why that's what
> > > >> you wanted?  Probably there is another way to achieve what you
> > > >> wanted.
> > > >>
> > > >>
> > > >> --- In [email protected], "billszerlip"<billszerlip@>
> > > >> wrote:
> > > >>>
> > > >>> I'm using HS on a Sprint Mogul.  I have several stores set up in
> > > >>> a single database.  When I select a single store in which I'm
> > > >>> going to shop, then use the search function (magnifying glass
> > > >>> icon) to find an item in that store, the result will show the
> > > >>> same item for all of the stores in the database.  Is there any
> > > >>> way to search within a single store only?  (This happens both
> > > >>> with and without having Per store prices and aisles checked in
> > > >>> the Database Options)
> > > >>>
> > > >>
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > .-^-._.-^-._.-^-._.-^-._.-^-._.-^-._.-^-._.-^-. HandyShopper Help:
> > > > http://www.ggaub.com/hswiki/
> > > > -._.-^-._.-^-._.-^-._.-^-._.-^-._.-^-._.-^-._.- Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> >
>