[Skip to main content](#vessel-content) # Importsheet question ## - **[rbeelen1](/forum/user/26865-rbeelen1 "View rbeelen1's Profile")** - [![rbeelen1's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26865-rbeelen1 "View rbeelen1's Profile") Topic Author - [ Offline](/forum/user/26865-rbeelen1) Less More - Posts: 45 - Thank you received: 1 - - 11 years 10 months ago [\#184344](#184344) by [rbeelen1](/forum/user/26865-rbeelen1 "View rbeelen1's Profile") *[Importsheet question](/forum/32-content-creation/873837-importsheet-question#184344 "-- HikaShop version -- : 2.3.4 Business -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome 39.0.2171.95 m Maybe simple solution, but it seems that i can't find the answer: Were do I find information of the importsheet, what colom does what. I need to create several different product groups, (Wines) and the next level is white wines and the final level is the product it self. help? :dry:")* was created by *[rbeelen1](/forum/user/26865-rbeelen1 "View rbeelen1's Profile")* -- HikaShop version -- : 2.3.4 Business -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome 39.0.2171.95 m Maybe simple solution, but it seems that i can't find the answer: Were do I find information of the importsheet, what colom does what. I need to create several different product groups, (Wines) and the next level is white wines and the final level is the product it self. help? :dry: Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODczODM3LWltcG9ydHNoZWV0LXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 11 years 10 months ago [\#184352](#184352) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Importsheet question](/forum/32-content-creation/873837-importsheet-question#184352 "-- HikaShop version -- : 2.3.4 Business -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome 39.0.2171.95 m Maybe simple solution, but it seems that i can't find the answer: Were do I find information of the importsheet, what colom does what. I need to create several different product groups, (Wines) and the next level is white wines and the final level is the product it self. help? :dry:")* Hello, If you want more information about the import/export option, a solution can maybe be to create a test product, export it through a CSV file and check that CSV file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODczODM3LWltcG9ydHNoZWV0LXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rbeelen1](/forum/user/26865-rbeelen1 "View rbeelen1's Profile")** - [![rbeelen1's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26865-rbeelen1 "View rbeelen1's Profile") Topic Author - [ Offline](/forum/user/26865-rbeelen1) Less More - Posts: 45 - Thank you received: 1 - - 11 years 10 months ago [\#184395](#184395) by [rbeelen1](/forum/user/26865-rbeelen1 "View rbeelen1's Profile") Replied by *[rbeelen1](/forum/user/26865-rbeelen1 "View rbeelen1's Profile")* on topic *[Importsheet question](/forum/32-content-creation/873837-importsheet-question#184395 "-- HikaShop version -- : 2.3.4 Business -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome 39.0.2171.95 m Maybe simple solution, but it seems that i can't find the answer: Were do I find information of the importsheet, what colom does what. I need to create several different product groups, (Wines) and the next level is white wines and the final level is the product it self. help? :dry:")* I created a csv file and tested the import. Creating main categories worked just fine. Only the products and prices are not imported, so somewere there someting is wrong. I attached the testfile. Can you have a look wat's wrong? Thankx. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODczODM3LWltcG9ydHNoZWV0LXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 10 months ago [\#184398](#184398) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importsheet question](/forum/32-content-creation/873837-importsheet-question#184398 "-- HikaShop version -- : 2.3.4 Business -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome 39.0.2171.95 m Maybe simple solution, but it seems that i can't find the answer: Were do I find information of the importsheet, what colom does what. I need to create several different product groups, (Wines) and the next level is white wines and the final level is the product it self. help? :dry:")* Delete the product_id column as these products do not exist yet. Also, for the product_code of the variants, you should put a product code, not the description of the product. The description should actually go in the product_description column. Finally, you're import two products with three variants each. In such case, you should have a characteristic with three values and link the products/variants to the corresponding value in the CSV. If you create a product with variants in the backend and that you export it, you'll see that you get an extra column for the characteristic of the product and the values for each row link the variant/product to the values of the characteristic. Also note that the characteristic and the values should already exist in your backend before importing a CSV referencing the characteristic/values. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODczODM3LWltcG9ydHNoZWV0LXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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.220 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)