Hello,
We are professional developers having similar magnitude of designing and developing software to manage products in shopify. As currently you are using excel file to upload. You can use PHP framework or symfony in place of Ruby on rails .
We understood your requirement that you want separate fields to search product and to quickly upload product names. with some unique product identifier, we will provide you product id so that when any product will upload it will generate a unique product code for that product . Also you have got three ways to edit the product , product can be edited by searching with unique id as well.
We are interested in discussing this project further, please let me know when are you comfortable to discuss this ahead .
Do check our work portfolio at -
http://www.freelancer.in/u/omsoftware.html
Looking for your reply
Thanks
Mukta