fatkatie Posted May 24, 2017 Share Posted May 24, 2017 I've been asked to create an online inventory system for multiple vendors.The data should be stored in a way that allows searching on product parameters; the simple ones like color, size and other parameters like schedule times, expiration and must be of age.The vendor list is varied, including food, clothing, automotive parts, services and ... you name it.The parameters are so varied and rich that I can't come up with a simple scheme of how to record the information. I thought of a table with 'meta' columns that rely on a product characteristics to define them, or just a huge text field with a delimited list of paramters; like size:14, color:red, or product type tables; table_clothing, table_coatings, table_travel... My class analogy would be automotive_services extends product many times over.What ever I decide to do, I'll wind up chucking it as I've never thought about this kind of an inventory database. I'd like to hear from a e-commerce guy on how they did it.Thanks for any suggestions. Quote Link to comment https://forums.phpfreaks.com/topic/304006-how-to-design-for-varied-product/ Share on other sites More sharing options...
requinix Posted May 24, 2017 Share Posted May 24, 2017 This would be a good job for a NoSQL-type database, or some similar mechanism. Otherwise the purely relational approach is an indexed key/value store (product ID, meta key, meta value) or two (first has product type + meta key, second has first's ID + meta value). A huge text field is definitely not the way to go. Quote Link to comment https://forums.phpfreaks.com/topic/304006-how-to-design-for-varied-product/#findComment-1546788 Share on other sites More sharing options...
benanamen Posted May 24, 2017 Share Posted May 24, 2017 I agree with requinix. Take a look at MongoDB https://www.mongodb.com/ Quote Link to comment https://forums.phpfreaks.com/topic/304006-how-to-design-for-varied-product/#findComment-1546789 Share on other sites More sharing options...
fatkatie Posted May 25, 2017 Author Share Posted May 25, 2017 Mongo? I think I'll start here: https://university.mongodb.com/courses/M101P/about Thanks both for the suggestions. Quote Link to comment https://forums.phpfreaks.com/topic/304006-how-to-design-for-varied-product/#findComment-1546813 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.