[ic] Complex Searches - interchange 5.2 vs 5.3.1

Louie Martinez louie at kopykake.com
Fri May 13 19:56:19 EDT 2005


I tried copying over some complex searches from a 5.2 installation (which uses the old layout editor
menus) to a 5.3.1 test store using the flyout menus. For some reason this complex search works in
5.2 but not in 5.3.

Just a little background. Our store is split into two main categories. Arts & Crafts and Cake
Decorating. Both of these main categories have common categories "Airbrush Compressors" since we
sell airbrush compressors for Art & Craft people as well as Airbrush Compressors used in decorating
cakes. Now to make things more complex, some of our Airbrush compressor models can be used for both
Arts & Crafts and Cake Decorating, so we've placed those items into a 3 main category named Common.
In 5.2 this search would be done when people clicked on Airbrush Compressors for Cake decorating. It
basically says "Give me all the items in the Airbrush Compressors category that are in either the
Cake Decorating group or the common group and only show me the ones that aren't toggled inactive.
and while we're at it, sort them by the SKU number". This works in 5.2 fine. When I plug this search
into the search box under the general tab of the menu editor, save it, publish it, I get absolutely
no results at all.

fi=products
st=db
co=1
sf=category
se=Airbrush Compressors
op=rm
os=0
sg=0
sf=prod_group
se=Cake Decorating
op=rm
os=1
sg=1
sf=prod_group
se=Common
op=rm
os=1
sg=1
sf=inactive
se=1
op=ne
os=2
sg=2
sr=0 and 1 and 2
tf=sku
to=x

Maybe I'm not doing it correctly. The menu editor produces this line in /include/menus/Products.txt
for my menu item.

019             1                                       search
fi=products&st=db&co=1&sf=category&se=Airbrush%20Compressors&
op=rm&os=0&sg=0&sf=prod_group&se=Cake%20Decorating&op=rm&os=1&sg=1&sf=prod_group&se=Common&op=rm&os=1&sg=1&sf=inactive&se=1&o
p=ne&os=2&sg=2&sr=0%20and%201%20and%202&tf=sku&to=x     Airbrush Compressors            0


Am I doing something grossly wrong? I don't get any errors in my catalogs's error file or
interchange's error file.

-- 
Louie Martinez

Kopykake Enterprises
3699 W. 240th St
Torrance, CA 90505
(310) 373-8906
(800) 999-5253
FAX: (310) 375-5275



More information about the interchange-users mailing list