DeX Posted May 24, 2018 Share Posted May 24, 2018 I have a Bill Of Materials (BOM) and we buy a building product from a third party supplier that custom makes them for us. They charge us a certain price based on these factors of the product: - width of building (in static increments: 24, 30, 36, 42, 44, 50...) - building type it's being used in (each type requires certain design specifications to meet code requirements) - snow load (depending on where in the country the building will be, we need to make it more durable if there will be a higher snow load on the building) Based on all of these, they build the product for us and charge us accordingly. I'm wondering if I need to have 400 items in my BOM to account for each combination of length, building type and snow load for this one product. Is this normal practice? The price differences don't have a pattern and don't overlap in any way, it's random pricing set for each combination. It's not like the price goes up $30 for each length, the pricing gaps are all different for each setting. Quote Link to comment https://forums.phpfreaks.com/topic/307300-need-advice-on-building-bom-with-many-attributes-for-each-product/ Share on other sites More sharing options...
Barand Posted May 24, 2018 Share Posted May 24, 2018 Only 400. That is quite a small table. Quote Link to comment https://forums.phpfreaks.com/topic/307300-need-advice-on-building-bom-with-many-attributes-for-each-product/#findComment-1558578 Share on other sites More sharing options...
DeX Posted May 24, 2018 Author Share Posted May 24, 2018 There are only 400 items total in the products table, plus however many of these items there are. Quote Link to comment https://forums.phpfreaks.com/topic/307300-need-advice-on-building-bom-with-many-attributes-for-each-product/#findComment-1558579 Share on other sites More sharing options...
Barand Posted May 24, 2018 Share Posted May 24, 2018 (edited) Without knowing exactly how a final price is calculated it is impossible to say what you need. It all depends on the rules, what combinations of factors come into play in different circumstances. You need to thoroughly analyse the data, data relationships and processes to arrive a a data model that works, then implement it. Edited May 24, 2018 by Barand Quote Link to comment https://forums.phpfreaks.com/topic/307300-need-advice-on-building-bom-with-many-attributes-for-each-product/#findComment-1558580 Share on other sites More sharing options...
DeX Posted May 24, 2018 Author Share Posted May 24, 2018 Every item has a corresponding quantity calculation that's input manually by the developer, this calculation never changes. Then when a final price for the building is needed, it does the following: - get all product ID from the database - loop through all product ID quantity calculations and multiply this quantity by the price in the database (price updated once a month) - adding all these totals together and multiplying by a markup percentage gives us our final price Is that all you needed? Quote Link to comment https://forums.phpfreaks.com/topic/307300-need-advice-on-building-bom-with-many-attributes-for-each-product/#findComment-1558581 Share on other sites More sharing options...
Barand Posted May 24, 2018 Share Posted May 24, 2018 I don't need anything, you do. A thorough analysis exercise takes days, if not weeks. Certainly more work than you are going to get for free in a help forum and from those who don't have access to the detailed infomration required, such as all the quantity calculations Quote Link to comment https://forums.phpfreaks.com/topic/307300-need-advice-on-building-bom-with-many-attributes-for-each-product/#findComment-1558582 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.