[ic] Item options, orderline, or transactions comments

Kevin Walsh interchange-users@interchange.redhat.com
Sun May 26 19:06:02 2002


> 
> I would like all items to have a field say 40-60 chars where simple comments 
> can be made when buying the item, in addition to any standard options.
> I would prefer not to have to go through all inventory items to make this 
> change.
> 
> I would also like a comment field for the entire cart for general comments 
> about the order.
> 
> I can create a new field in orderline, and transactions, but thought their 
> might an easier method.
> 
> Any comments appreciated.
> 
As you have identified, you will need to create a new column in the
orderline table to store the per-item comments.  The transaction
table, defined with the Foundation demo, includes a "comments" column
which you may use to store your per-order comments.

I don't see that you'd have to make any changes to the inventory to
implement your idea.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/