We are using opencart and we are generating a product xml which have brand, name, description, product unique code, oem numbers, stock amount, price and photo urls to update the products in opencart.
We need to be able filter these products from tecdoc db with using these filters in the order of brand, model, type, year, motor size and horsepower and match them with our product oem numbers. (auto complete will be needed for next filter.)
Also we have some product brands which cannot be found in tectdoc, we would like to match those brand products via oem numbers as well.
And the filtered products will be shown in custom search page in opencart so our visitor can reach them.