How to order multiple options and quantity in one product?

[oavs]

Hi

I have a problem and hope some one can come up with a solution.

Client has many products. see below. How can the user select item size or grade what corresponds with the product code?

Not sure it is possible or if there is a plugin.

For example If I want to order 'Sanding Discs Gold 150 mm Velcro 15 Hole' as a product with variations as below.
Order item: 'Sanding Discs Gold 150 mm Velcro 15 Hole'
Option: P40
Size; 150 mm
and the matching item code is '3050.004' to be automatically selected.


Sanding Discs Gold 150 mm Velcro 15 Hole OPTION SIZE
3050.004 P 40 150 mm
3050.006 P 60 150 mm
3050.008 P 80 150 mm
3050.012 P 120 150 mm
3050.015 P 150 150 mm
3050.018 P 180 150 mm



OR in another example,
Order item: 'Universal Hardener'
Option: Fast
Size; 500 ml
and the matching item code is '407.0501' to be automatically selected.

Universal Hardener OPTION SIZE
407.0251 Fast 250 ml
407.0253 Standard 250 ml
407.0501 Fast 500 ml
407.0503 Standard 500 ml
407.1001 Fast 1 Litre
407.1002 Extra Fast 1 Litre
407.1003 Standard 1 Litre
407.2501 Fast 2.5 Litre
407.2502 Extra Fast 2.5 Litre
407.2503 Standard 2.5 Litre
407.2507 Extra slow 2.5 Litre
407.0201 Fast 200 ml

I mean in worst case I could list them as options as a whole as per single line but that is too busy. Another way is I could I thought like this.

Order item: 'Sanding Discs Gold 150 mm Velcro 15 Hole'
Drop Down Option:[ P 40 - 150 mm (3050.004) ]

and

Order item: 'Universal Hardener'
Drop Down Option:[ Fast - 250 mm (407.0251) ]

On top of that user must be able to select more than one option to order as per item. Such as

Order item: 'Sanding Discs Gold 150 mm Velcro 15 Hole'
Drop Down Option:[ P 40 - 150 mm (3050.004) ] X 2 order
Drop Down Option:[ P 180 - 180 mm (3050.018) ] X 6 order
etc etc.

OR

Order item: 'Universal Hardener'
Drop Down Option:[ Fast - 250 ml (407.0251) ] X 6 order
Drop Down Option:[ Extra Fast - 1 Lt (407.1002) ] X 2 order
Drop Down Option:[ Extra Fast - 2.5 Litre (407.2502) ] X 10 order

Any alternative ideas?