Product Options... and more
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.