Product Options... and more

3/22/2009 9:50 amnduckworth267709

I'm doing a site for a medical equipment company and have a couple of database questions (no MySQL forum section so posting it here). I'm using the BSM database as a starting point and modifying that where necessary.

Some equipment comes with size options, but the types of sizes vary by equipment. For instance, it might be small, medium, large for some pieces; and then numerical sizes for others, 1, 1.5, 2, etc. Should I just use one table for these mixed sizes? Then I assume I'd use a lookup table to assign sizes to products using the manage relational tables SB. Similarly with colors?

Is all the order and order details data inserted automatically by eCart during the checkout process?

OK... straying from the database topic a bit, my client ships via UPS and wants to include a tracking number with their receipt. Is it possible, or do I need to complete the transaction and then connect independently to UPS to get that? Any tips appreciated.

Thanks!

-Nigel

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Product Options... and more

3/22/2009 9:50 amnduckworth267709