[ic] Modular options using options tab of the template.xls

Dave Turk interchange-users@interchange.redhat.com
Sun Apr 28 11:32:01 2002


----- Original Message -----
From: "Dave Turk" <interchange@montanaservers.com>
> I am trying to import my spreadsheet into the catalog and would like to
> setup a modular options
> on the options tab of the template.xls spread sheet. I would like to
replace
> the sku # with its own when
> the option is selected but if this is not possible without coding thats
OK.
> Example
>
> Product   Nutrition shake plain     sku = 0024
> option flavor = vanilla                   sku = 0025
> option flavor = chocolate              sku = 0026
> widget = select
>
> Can someone help me with what to put in the following columns in the
options
> tab of the template.xls to make this work.
> I just don't understand how to make this work.
> code    sku    o_enable     o_matrix     o_modular    o_group    o_value
> o_label   o_widget     o_master     price     wholesale      differential
> description
>
> weight     volume      mv_shipmode      o_exclude      o_include
o_header
> o_footer    o_height     o_width
>
> Thanks very much
> Dave Turk

I have since figured most of this part out by playing with it in the admin >
items > options section then displaying the results in spread sheet form. I
found this would give me an example of what to enter into options tab of the
template.xls sheet. Also not I chose matrix, separate widgets, but doing it
this way you can
figure out most any combination by playing with it. I hope this helps
someone else just starting out with interchange like myself . Also note to
display the columns below correctly set your screen resolution to 1024 X 768
Minimum and display the message full screen.

code    sku       o_enable     o_matrix     o_modular    o_group    o_label
o_value                                  o_widget     o_master     price
description
0025    0024    1                    1
select                            41.00    vanilla-0025
0026    0024    1                    1
select                            41.00    chocolate-0026
0024    0024
flavor        flavor      VAN=Vanilla, CHK=Chocolate   select

Dave Turk