Welcome Guest, Not a member yet? Register   Sign In
DB structure for bundled products
#3

I'm in agreement with Paul.

I'd setup the database to have a products table with a column to indicate if the product was a bundle.
Then another table with all of the products associated (and qty per product if you sell anything physical or limited uses/licenses/etc):

Table:product_bundles
product_bundle_id
parent_product_id
child_product_id
quantity
date_added

I'd actually put the product_bundle_id in the product table column for the bundled column (i.e. it is either a zero for no bundle or the bundle ID, which makes it much easier for your SQL to find the bundle's contents when you need it)

This lets you have all of the reporting and normal flows for your products and bundles using one table instead of having to group multiple tables together.
Reply


Messages In This Thread
DB structure for bundled products - by neuron - 01-15-2018, 09:03 AM
RE: DB structure for bundled products - by PaulD - 01-15-2018, 11:42 AM
RE: DB structure for bundled products - by Kaosweaver - 01-15-2018, 12:52 PM
RE: DB structure for bundled products - by neuron - 01-15-2018, 11:53 PM



Theme © iAndrew 2016 - Forum software by © MyBB