blakekr Posted September 20, 2006 Share Posted September 20, 2006 After what seems like far too much agonizing, I think I've decided to build my own php "shopping cart" and hack my own interface to paypal IPN, because all the other solutions I've come across are massively oversized and overdeveloped for my needs.But I could use some help in setting up the structure. I'm not sure of the best way to handle "options" with my various products.First of course I set up a basic database with product fields like:[I]sku, price, name, etc. etc.[/I]The tricky part is that some products will have special options, some dropdowns and some text fields, and I know I won't be able to predict all these in advance, like: [I]item color, accessory color, font, initial, initials ...[/I]In addition, some products will call for extra product photos and others won't ...And then I will need some way of storing all these extra options for a given customer's order when it comes through.I know this is probably a pretty common design question. I'd appreciate any hints on how you'd approach it. Link to comment https://forums.phpfreaks.com/topic/21434-designing-databases-properly-for-a-simple-diy-shopping-cart/ Share on other sites More sharing options...
fenway Posted September 21, 2006 Share Posted September 21, 2006 Break out any "custom" options into separate tables, and relate them back to their parent product ID. Link to comment https://forums.phpfreaks.com/topic/21434-designing-databases-properly-for-a-simple-diy-shopping-cart/#findComment-95767 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.