[Skip to main content](#vessel-content) # Import orders via CSV and auto-fill customer address from user\_id? ## - **[UPL](/forum/user/83461-upl "View UPL's Profile")** - [![UPL's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/83461-upl "View UPL's Profile") Topic Author - [ Offline](/forum/user/83461-upl) Less More - Posts: 6 - Thank you received: 1 - - 1 year 3 months ago [\#367839](#367839) by [UPL](/forum/user/83461-upl "View UPL's Profile") *[Import orders via CSV and auto-fill customer address from user\_id?](/forum/25-install-update/909570-import-orders-via-csv-and-auto-fill-customer-address-from-user-id#367839 "Hello, When importing orders via CSV, I assign the user_id correctly and the user is properly linked to the order in the backend. However, the customer’s address data is not automatically filled in on the order. In the backend, when assigning a user manually to an order, a popup appears with a switch called "Enter user address" which allows loading the user's address data into the order. Is there a way to trigger this same behavior automatically during CSV import? That is, to have the address fields filled in when the user_id is assigned, just like when that switch is enabled manually. Thank you.")* was created by *[UPL](/forum/user/83461-upl "View UPL's Profile")* Hello, When importing orders via CSV, I assign the user_id correctly and the user is properly linked to the order in the backend. However, the customer’s address data is not automatically filled in on the order. In the backend, when assigning a user manually to an order, a popup appears with a switch called "Enter user address" which allows loading the user's address data into the order. Is there a way to trigger this same behavior automatically during CSV import? That is, to have the address fields filled in when the user_id is assigned, just like when that switch is enabled manually. Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTU3MC1pbXBvcnQtb3JkZXJzLXZpYS1jc3YtYW5kLWF1dG8tZmlsbC1jdXN0b21lci1hZGRyZXNzLWZyb20tdXNlci1pZD90bXBsPW1hcmtkb3du) 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: 86324 - Thank you received: 14286 - - 1 year 3 months ago [\#367847](#367847) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import orders via CSV and auto-fill customer address from user\_id?](/forum/25-install-update/909570-import-orders-via-csv-and-auto-fill-customer-address-from-user-id#367847 "Hello, When importing orders via CSV, I assign the user_id correctly and the user is properly linked to the order in the backend. However, the customer’s address data is not automatically filled in on the order. In the backend, when assigning a user manually to an order, a popup appears with a switch called "Enter user address" which allows loading the user's address data into the order. Is there a way to trigger this same behavior automatically during CSV import? That is, to have the address fields filled in when the user_id is assigned, just like when that switch is enabled manually. Thank you.")* Hi, There is no CSV order import in HikaShop. So I don't know how you're importing your orders via CSV. The hikashop_order table in the database has columns order_billing_address_id and order_shipping_address_id. If the tool you're using to import the orders supports all the columns of HikaShop, then you can fill these columns with the id of the address you want to be used. If you want this id to be filled automatically during the import, then that's something you need to ask to the developer of that tool. Supposing you're using the RO CSVI import tool, then you need to talk to Roland, the developer of RO CSVI: [ extensions.joomla.org/extension/ro-csvi/](https://extensions.joomla.org/extension/ro-csvi/) The following user(s) said Thank You: [UPL](/forum/user/83461-upl "View UPL's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTU3MC1pbXBvcnQtb3JkZXJzLXZpYS1jc3YtYW5kLWF1dG8tZmlsbC1jdXN0b21lci1hZGRyZXNzLWZyb20tdXNlci1pZD90bXBsPW1hcmtkb3du) 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.113 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)