[ic] Persistence of item-modifier

[Paul Jordan]

> I was unable to locate the "Interchange E-Commerce Functions" reference
> manual. Does anyone have a URL?

Not really sure, but I have found it here:
http://www.interchange.rtfm.info/docs/rtfm_ic_ecommerce.html


> My problem is not the same as the one Ubi described.  Item-modifier is
> working just fine for me all the way through the receipt and reporting
> processes of my catalog.  It's just that after the order is finished,
> there is no record of the modifier values in any of the database tables.
> I expected it to be in the orderline table.
>
> My questions really are:
>
> If I have "UseModifier color" in a properly configured catalog, will
> that result in Interchange creating a "color" database field in the
> orderline table?


No, but it appears that there already is a color field in it anyways :)


> I need my item modifiers added to the orderline table for order tracking
> and I'm sure there are others out there that would like item-modifier
> information tracked in the status of their orders.  I'm going to try and
> reconfigure my development catalog from scratch this morning to see if
> anything changes.


Try looking at etc/log_transaction. It controls what gets added to the
transaction table and orderline table.


> I thinking about doing the following if that doesn't work:
>
> 1. Create two new fields in the orderline table, by editing the
> appropriate dbconf file for my item-modifiers.
> 2. Remove products/orderline.sql and restart Interchange to create the
> new table.
> 3. Add the two new orderline fields  to the orderline entry in
> products/mv_metadata.asc (what does this really do?)
>
> Then I just have to figure out how to put the hooks in during the
> checkout process to get Interchange to place these modifier values in
> the orderline table.
>
> I'm not worried about the admin GUI at this point.
>
> - Jerry

Jerry, also see Kevins post down vvvv there. That post should be on top of
yours.

Be sure to read:
http://interchange.redhat.com/archive/interchange-users/2001/msg10876.html

Were trying to facilitate good facilitation here :)

HTH

Paul


>
>
> >-----Original Message-----
> >From: interchange-users-admin@icdevgroup.org
> >[mailto:interchange-users-admin@icdevgroup.org] On Behalf Of
> >Kevin Walsh
> >Sent: Tuesday, June 18, 2002 3:54 PM
> >To: interchange-users@icdevgroup.org
> >Subject: RE: [ic] Persistence of item-modifier
> >
> >
> >>
> >> It appears that item-modifier does not persist as an attribute of an
> >> order once it is placed.  I'm using the catalog.cfg
> >directives to add
> >> a few modifiers to items during checkout, but I was surprised when
> >> these didn't show up in the orderline table.
> >>
> >> I wanted to see if either:
> >>
> >> A. I did something incorrectly that caused the system not to include
> >> my modifiers in the updates the orderline table; or
> >>
> >> B. Item-modifier was never intended to be used for data that
> >needs to
> >> be tracked in any of the orders tables.
> >>
> >> I would appreciate any guidance you can give me in either
> >finding the
> >> cause of my problem or directing me in modification more appropriate
> >> to my purposes.  The two item modifiers I am currently using will be
> >> an important part of the order status and tracking system I am
> >> building for my client.
> >>
> >Look up the UseModifier directive in the "Interchange
> >Configuration" reference manual for modifiers that you use
> >often, such as size or colour.  That directive is also
> >described in the "Item Attributes" section of the "Interchange
> >E-Commerce Functions" reference manual.
> >
> >There are other methods, involving "mv_item_option" values, in
> >association with "mv_order_*" values, but the UseModifier
> >directive is usually good enough.  If you are interested in
> >mv_item_option, you can see an HTML example in the "options"
> >section of the "Interchange Tags" reference manual.
> >
> >--
> >   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
> >  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
> > _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
> >_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/
> >
> >_______________________________________________
> >interchange-users mailing list
> >interchange-users@icdevgroup.org
> >http://www.icdevgroup.org/mailman/listinfo/inte>rchange-users
> >
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users