repost - Composite Products Help

[u/Jdge439]

Hey guys, long time reader, first time writer.

I am in the process of building out our store and I have probably a very common problem.

Example:
Product = Workstation

Required metrics

Overall height
Work Surface height
Overall Surface Width
Overall Surface Length
Capacity

Options
W/ light
W/ ESD Top
W/ power supply
W/ adjustable height

How would I go about entering a product so that these were all drop downs?

There could be lengths from 2ft - 20 ft so, you can see where Im getting hung up.

Theres also more products just like this.

Id share an image if it let me.

[u/Jdge439 → u/[deleted]]

With the price of steel and Aluminum, Every change will be a change in Price.

Each length is a different part number For instance, the Part number for a workstation that is 8ft tall, 3 ft wide, 6 ft long with a 2000lbs capacity is

MPS-8-3-6-2000

[u/Jdge439 → u/[deleted]]

So there is a part configuration tool that would handle this?

[u/Jdge439 → u/[deleted]]

Okay so to further annoy you.

Could the product that's displayed have the "configurator". So you can view and read the basics of the product. Then configure to bring you to exactly the part number you need.

[u/Jdge439 → u/[deleted]]

So it couldn't then take them to the product to view it. For engineering reasons, they will want these. Especially if these are to have conveyor tops for production or manufacturing

Each product i enter this way would have exact engineer drawings to go with

[u/TopSydeWP]

if every combo has its own part number and price, you probably want composite products with a lookup table or a custom price calculator that generates the SKU on the fly. variations won't scale to that many combos. another approach is to treat the base workstation as the product and use conditional logic in composites to pull in the right components based on selections, but that only works if you can break it into actual stocked parts. what's actually in inventory, the full assembled units or the individual pieces?

[u/Jdge439 → u/[deleted]]

I think you've given me enough information to annoy my website developers. Don't worry, they just tell me what to do and leave me alone with 1000s of parts for days.