[Skip to main content](#vessel-content) # auto populate shipping info from xls spreadsheet ## - **[Sarita](/forum/user/11302-sarita "View Sarita's Profile")** - [![Sarita's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11302-sarita "View Sarita's Profile") Topic Author - [ Offline](/forum/user/11302-sarita) Less More - Posts: 1 - Thank you received: 0 - - 13 years 8 months ago [\#89351](#89351) by [Sarita](/forum/user/11302-sarita "View Sarita's Profile") *[auto populate shipping info from xls spreadsheet](/forum/2-general-talk-about-hikashop/78218-auto-populate-shipping-info-from-xls-spreadsheet#89351 "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...")* was created by *[Sarita](/forum/user/11302-sarita "View Sarita's Profile")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc4MjE4LWF1dG8tcG9wdWxhdGUtc2hpcHBpbmctaW5mby1mcm9tLXhscy1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 13 years 8 months ago [\#89570](#89570) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[auto populate shipping info from xls spreadsheet](/forum/2-general-talk-about-hikashop/78218-auto-populate-shipping-info-from-xls-spreadsheet#89570 "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...")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc4MjE4LWF1dG8tcG9wdWxhdGUtc2hpcHBpbmctaW5mby1mcm9tLXhscy1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.239 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)