[Skip to main content](#vessel-content) # Import (Excel File) ## - **[richardhamilton](/forum/user/1651-richardhamilton "View richardhamilton's Profile")** - [![richardhamilton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1651-richardhamilton "View richardhamilton's Profile") Topic Author - [ Offline](/forum/user/1651-richardhamilton) Less More - Posts: 12 - Thank you received: 0 - - 15 years 7 months ago [\#11279](#11279) by [richardhamilton](/forum/user/1651-richardhamilton "View richardhamilton's Profile") *[Import (Excel File)](/forum/4-how-to/11279-import-excel-file#11279 "I wonder if it's possible for someone to please mail me a copy of an Excel file which I could use as a template for importing products, categories, prices, description and Images ... I don't...")* was created by *[richardhamilton](/forum/user/1651-richardhamilton "View richardhamilton's Profile")* I wonder if it's possible for someone to please mail me a copy of an Excel file which I could use as a template for importing products, categories, prices, description and Images ... I don't understand how to set up the import file .. Please guys Regards Richard Hamilton richard@bigbirdcrafts.com I attatch hereto the file exported from Turbocash .. those fields in the green bar are those ones I need to import into Hika .. PLEASE !! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMjc5LWltcG9ydC1leGNlbC1maWxlP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 7 months ago [\#11282](#11282) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import (Excel File)](/forum/4-how-to/11279-import-excel-file#11282 "I wonder if it's possible for someone to please mail me a copy of an Excel file which I could use as a template for importing products, categories, prices, description and Images ... I don't...")* You need to change the header of the columns: SSTOCKCODE => product_code SBARCODENUMBER => product_name SDESCRIPTION => product_description SMANUFACTURER => manufacturer ( there is no manufacturer attribute by default in hikashop. If you need one, you need to go in Display->Custom fields and create a custom field for the table "product" with the column name "manufacturer" ) FDTYONHAND => product_quantity FSELLINGPRICE1 => price_value SGroup1 => categories Then, export the file as a CSV file and import it via the import interface in the menu Products->Import of HikaShop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMjc5LWltcG9ydC1leGNlbC1maWxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[richardhamilton](/forum/user/1651-richardhamilton "View richardhamilton's Profile")** - [![richardhamilton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1651-richardhamilton "View richardhamilton's Profile") Topic Author - [ Offline](/forum/user/1651-richardhamilton) Less More - Posts: 12 - Thank you received: 0 - - 15 years 7 months ago [\#11292](#11292) by [richardhamilton](/forum/user/1651-richardhamilton "View richardhamilton's Profile") Replied by *[richardhamilton](/forum/user/1651-richardhamilton "View richardhamilton's Profile")* on topic *[Re: Import (Excel File)](/forum/4-how-to/11279-import-excel-file#11292 "I wonder if it's possible for someone to please mail me a copy of an Excel file which I could use as a template for importing products, categories, prices, description and Images ... I don't...")* thank you very much for your help ! I appreciate it BIG time ! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMjc5LWltcG9ydC1leGNlbC1maWxlP3RtcGw9bWFya2Rvd24=) 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.074 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)