I need the following to be done, where everything with an "x" is already existing:
(x) WordPress instance with WooCommerce up and running (will be provided via Duplicator-image)
(x) around 80 products where just 18 are in stock (LED bulbs for cars)
( ) Filter these products with a custom filter in the web shop, containing of 4 hierarchical comboboxes: Make + Model + Variant - Light-Type
( ) These comboboxes must be filled from a 500.000-line product mapping (META information) which are connected to the actual products via SKU-ID/product-ID. These are NO real products, it's just information that helps to find the actual product
( ) A search operation must not take longer than 2 seconds, so product variations/attributes might not be the correct approach. My friends say a separate WordPress-plugin will be required, with a foreign-key relationship and a separate MySQL table pointing to the actual products.
Please carefully review the file I uploaded (example META file + products; full file will be delivered upon acceptance). It's CRUCIAL to understand that the product mapping does NOT contain actual products, but filter information needed to find the correct product in the end (that's why I called it "META"). Make sure BEFORE submitting an offer that you fully understand what I need, especially the ones that think it can be done with product variations/attributes. This has already been tried, and wasted 2 weeks of project time. Apart from that, it took 40 days to just import the META-file (!).
Let me know if there are any questinos.