Hi guys, got a big of a complicated one here. Been sat for hours working out what if anything I can do with this.
I have a product file that is has over 9,000 spare parts for boilers. All the parts have a manufacturer number. That relates to what boiler the part fits. Now, each part may fit up to 50 boilers. So on the product file, I have given each part a different sku. So all parts are searchable via the many model tags and serial numbers.
So here is my issue. I want to list all 9 thousand lines, by the sku, but only show 1 product of each manufacturer code on the website. And have a drop down box of all the different variations of boilers that part fits.
I have there for downloaded the pro version of WP-All Imports - woocommerce plugin. Which allows variations.
I gave the products Parents sku's to link up with the main sku. EG:
SKU Parent Sku
However I cannot get this to work. Nor anything else. I really don't want to make the whole price file up as tags. So I would appreciate if someone has any advice.