[Skip to main content](#vessel-content) # Importing product data from Excel to Hicka Shop ## - **[Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile")** - [![Wine Promoter's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar563.gif)](/forum/user/563-wine-promoter "View Wine Promoter's Profile") Topic Author - [ Offline](/forum/user/563-wine-promoter) Less More - Posts: 3 - Thank you received: 0 - - 14 years 11 months ago [\#30972](#30972) by [Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile") *[Importing product data from Excel to Hicka Shop](/forum/4-how-to/30972-importing-product-data-from-excel-to-hicka-shop#30972 "I am trying to find a way to import my data from a 31 day spreadsheet in Excel into Hicka Shop. Trying the import function on the products category isn't doing it. I have read through the help text...")* was created by *[Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile")* I am trying to find a way to import my data from a 31 day spreadsheet in Excel into Hicka Shop. Trying the import function on the products category isn't doing it. I have read through the help text but still just can't get it to work correctly. This is one line of text. product, code, qty, qty, price "April 1, 2012",JA0112,1,1,188 Is there a reason why this is not working. Any help is greatly appreciated. Wine Promoter Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMwOTcyLWltcG9ydGluZy1wcm9kdWN0LWRhdGEtZnJvbS1leGNlbC10by1oaWNrYS1zaG9wP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 11 months ago [\#30987](#30987) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing product data from Excel to Hicka Shop](/forum/4-how-to/30972-importing-product-data-from-excel-to-hicka-shop#30987 "I am trying to find a way to import my data from a 31 day spreadsheet in Excel into Hicka Shop. Trying the import function on the products category isn't doing it. I have read through the help text...")* You need to adapt the first line to match the names used by HikaShop. So product should be product_name,code should be product_code,qty should be product_quantity,price should be price_value And you should not have twice the same column name in a CSV (although I don't think that it will be a problem for HikaShop). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMwOTcyLWltcG9ydGluZy1wcm9kdWN0LWRhdGEtZnJvbS1leGNlbC10by1oaWNrYS1zaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile")** - [![Wine Promoter's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar563.gif)](/forum/user/563-wine-promoter "View Wine Promoter's Profile") Topic Author - [ Offline](/forum/user/563-wine-promoter) Less More - Posts: 3 - Thank you received: 0 - - 14 years 11 months ago - 14 years 11 months ago [\#30994](#30994) by [Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile") Replied by *[Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile")* on topic *[Re: Importing product data from Excel to Hicka Shop](/forum/4-how-to/30972-importing-product-data-from-excel-to-hicka-shop#30994 "I am trying to find a way to import my data from a 31 day spreadsheet in Excel into Hicka Shop. Trying the import function on the products category isn't doing it. I have read through the help text...")* Hi Nicolas: Thanks for the reply. I did read that in the help text I just needed to understand it more clearly. Here is my product: (Product_Name) April 1 2012 (Product_Code) JA0112 (Product_Quantity) 1 (Price_Value) 188 Here's how it looks on the spreadsheet with four columns: Product_Name Product_Code Price_Value Product_Quantity April 1, 2012 AP0112 188 1 April 2, 2012 AP0212 190 1 April 3, 2012 AP0312 192 1 April 4, 2012 AP0412 194 1 It worked using the text import function. You can see here how it looks: [ wepromoteyourwine.com/buy-your-spot/46-april-2011.html](http://wepromoteyourwine.com/buy-your-spot/46-april-2011.html) Thanks a lot for your help. I love Hicka Shop and how we integrated it into our calendar, just need to tweak it some now for 2012. Jeff Last edit: 14 years 11 months ago by [Wine Promoter](/forum/user/563-wine-promoter "View Wine Promoter's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMwOTcyLWltcG9ydGluZy1wcm9kdWN0LWRhdGEtZnJvbS1leGNlbC10by1oaWNrYS1zaG9wP3RtcGw9bWFya2Rvd24=) 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.055 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)