[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] different items, different colours
****** message to minivend-users from cfm@maine.com ******
On Mon, Jul 03, 2000 at 03:28:18PM -0300, cclient@penguin.ecoast.ca wrote:
> ****** message to minivend-users from 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? Does anyone have any other ideas?
No matter how you cut it, that will be awkward. My experience with
clients that want to do that leads me to suggest that instead you
manage it outside of minivend, perhaps in a simple spreadsheet or with
a script, and generate unique codes for each item.
The issue turns out to be keeping it regular. Will blue always be 1.50
(or is that 150%) or will it be different on some items? Then if each
item has different markups for different colors you soon forget what
is what, what colors are available for what items, etc... and it will
be hard to sync the minivend price with their offline rate card.
Unique item codes are really cheap. ;^)
>
> Thanks,
> Derek Billingsley
> -
> 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
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
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
