auto populate shipping info from xls spreadsheet

I need some help. I sell firearms and cannot ship directly to my purchaser, rather they need to go to a dealer for transfer. I am trying to figure out a way to have a searchable xls spreadsheet with the dealers information that can then auto populate the shipping fields once they information is selected as the "preferred" ship to location. Any help would be greatly appreciated!

Thank you!

Dave

Hi,

There is not really a pickup selector for shipping in HikaShop. What you can do though is to create one shipping method per dealer so that the user would select the dealer by selecting the shipping method.
You would have to directly import the data in the hikashop_shipping table of the database via phpmyadmin.