Wordpress - Import custom CSV file in Database and validate upon registration

Question

I am trying to import custom CSV file in WP Database containing information about product_type and its product_serial number like below format. Plugins tried so far are 1, 2 and 3

product_type    product_serial
Apparel         app-192-168-1-1 
Cosmetic        cos-192-168-1-2
Footwear        foot-192-168-1-3

The plugins mostly imports POSTS data while I need to import custom data from CSV in my custom table wp_product_details

Later, on registration page, how can I fetch all Product Serial # from imported CSV and check if it matches user input ?

At the time of registration user needs to enter Product Serial # and if that number exists in that CSV list, only then registration is successful else it would validate user.

Any plugin that helps importing custom data apart from POSTS would work.