Best way to build a catalog for farming equipment

-- url of the page with the problem -- : vedafarming.com
-- HikaShop version -- : n/a
-- Joomla version -- : 3.x
-- PHP version -- : 3.5
-- Browser(s) name and version -- : any
-- Error-message(debug-mod must be tuned on) -- : No error.

I have been tasked with rebuilding both the online and print catalog for a company that manufactures Farming Equipment.
Right now the catalog is done in SobiPro, but SOBI has some serious drawbacks and right now the catalog itself is next to useless when it comes to search for a given machine.

What I am looking for is a way not only to list each machine, price and description/photos, etc, but also I need the following:

Each machine has a series of features specific to the machin. Right now, it is handled in a very poor way. There are 6 fields and the data entry person enter values in these fields according to the machine type.
The problem with that is that depending on the machine, the same field may contain things like

Weight
Blade width
Blade with with data looking like ["20" to 50"] (which obviously means nothing to the database)
Number of wheels
Hours per gallon

and other features all mixed up inside those 6 generically named fields. Clearly, that's an nightmare as the same field can contain values expressed in Inches, feet, Kg, Lb and so forth. Additionally, even fairly common features like "Weight" are scattered across several of these "generic" fields, so one machine may have its weight stored in Generic_field_01 and the next machine may have the same weight in Field_generic_3. There is no rhyme or reason.

Currently I am having the office people build a comprehensive spreadsheet where all the "features" each have their own field and a corresponding value. Just so we can get a handle on it and eventually device a good way to display those "features" in the catalog.

Essentially, you can think of these features as an ingredient list. Not all machines/products will have the same ingredients. So the goal is to have this list of items/data/fields, display inside the product page but without displaying the empty data. For instance, product where the Load weight is not part of the list, there shouldn't be an empty entry for it. Only the field with the proper data should display in this "ingredient" list.

I hope the above was clear enough, if not I'll be happy to upload a subset of the current database so everyone can see what a mess it is.

The other important thing about this catalog is that it should be able to display videos (from 1 to about 5 or 6) again without leaving empty boxes on the product page in case there aren't any videos or only 1 is available.
In addition, these videos will be hosted on youtube and I would like to have a very simple entry system for the operator to add the videos.

The product description is not a good place to add videos as they should be part of the product page template.

Essentially, I need to create a number of custom fields that only appear and take space if they have data in them. No data, no field should be visible in the product page.

Am I making any sense?

I am not asking how to do all this. Obviously. But since I am choosing a good catalog to handle these products and I am already familiar with Hikashop, unless I find a better catalog I would like to use Hika for this job.

Then eventually I'll have to do all this research again for the print part of the job. I am looking at InDesing plugins for that.

Do you guys think Hikashop would be a good tool for that or maybe what I am asking would stretch its capabilities too much? Are there examples of what I would like to do already live somewhere where I could see a similar implementation in action?

Thank you so much for reading this. I know I am asking a lot, but I want to make sure to choose the right tool for the job.

Thank you. I have now built a few shops with Hikashop, including one that was quite complex with numerous different Customer groups and different prices for each group (selling PPV fights on cable for sport bars, etc. A very complicated issue since they charge by occupancy), but I have never done anything like this catalog.
I sort of knew it was possible, but getting a confirmation makes me feel better about my choice. Thank you.