[HS] Re: Search Single Store

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
> > >
> > >
> > >
> >
>