[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: mv:3.12 - Options
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Thu, 6 May 1999, Russ wrote:
> I am selling items with ISBN numbers (books, music, videos, software) on my
> site. I send the orders to different fulfilling houses where they reference
> everything by the ISBN number. (ISBN is my 'code' field)
>
> When a product has different options, it has different ISBN numbers for each
> option. A book with red, black, and blue binding has 3 different ISBN
> numbers and the same price. An album comes in Tape or CD format with
> different ISBN's and different prices.
>
> Ordering the different items is not a problem. The problem is in searches.
> A search for a book which has 3 separate entries for the different options
> comes back with 3 results that are exactly the same, except the cover. The
> same problem happens to tapes/CD's.
>
> The item-modifier isn't appropriate, because its not just a modifier, but a
> completely different product to order.
You should re-design your database and use a table like product_master
to hold all of the common fields and product_detail for the fields
that differ; color, media, price ...
Search would look at product_master and the flypage would reference
both.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
-
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
