Re: [mv] different items, different colours

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting cclient@penguin.ecoast.ca (cclient@penguin.ecoast.ca):
> 
> 
> If I have one item and it has about 15 colours and another item 
> that has a different list of colours how can I represent this
> in terms of both mysql and CommonAdjust?  If I keep making 
> new columns in the pricing table for each new colour, that
> database becomes pretty unmanageable.
> 
> I wondered about using something like ==color:pricing:color so that
> I could reference a specific column in the database but for that
> to work, it seems like I would need to be able to enter a 
> data like:  red=+5%, blue=1.50, green=2.00.  Same thing
> goes for size.  
> 
> Can I do this?

Not as it stands. But you could easily set up a set of option fields,
like color1 - color16, then set your modifiers with strings like:

    color1=Red, color2=White, color3=Blue 

Then do ==color:pricing again. To unmap the options for display on the order,
you can use [item-accessories display].

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Friends don't let friends use Outlook. -- Bob Blaylock
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list