I am taking over development of a shopping cart for a music store. The site originally only sold music but now I am tasked to add other items that are not music files (i.e books/posters)
So, the question is, since the entire cart depends on finding product id from the ‘music_tracks’ table, I now am trying to figure out the best way to add other products and have non conflicting product ID’s for books and posters (using these 2 non music products as examples for this post).
So, what should I do? Should I spill all music files into a universal product table and increment from that table and re-write all of the cart files to handle product ID’s from that table?
Obviously if I have a separate table for physical merchandise, the existing cart page would confuse the product ID from that new table with older products from the music table (such as adding new record ID #3, the cart will think it’s ID #3 from the music table)
What is the best way to avoid conflict in your opinion?