[Skip to main content](#vessel-content) # Import not working for us at all........ ## - **[webjive](/forum/user/211-webjive "View webjive's Profile")** - [![webjive's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/211-webjive "View webjive's Profile") Topic Author - [ Offline](/forum/user/211-webjive) Less More - Posts: 30 - Thank you received: 2 - - 10 years 8 months ago - 10 years 8 months ago [\#228467](#228467) by [webjive](/forum/user/211-webjive "View webjive's Profile") *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228467 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* was created by *[webjive](/forum/user/211-webjive "View webjive's Profile")* -- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks Last edit: 10 years 8 months ago by [webjive](/forum/user/211-webjive "View webjive's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) 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: 86291 - Thank you received: 14269 - - 10 years 8 months ago [\#228505](#228505) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228505 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Hi, HikaShop handle both commas and semi colons. Changing that won't change anything. The best is to configure a few categories yourself and export the products. You'll get a CSV so you can compare how it should be done. Regarding the categories, I suppose that in "Product Category,ADL,Hook and Loop", Product Category is the main category, ADL is a subcategory of Product Category, and Hook and Loop a subcategory of ADL. In that case, what you wrote is not correct. You should only write the name of the directly connected categories in the "categories" column of the product. So in your case, you should only have "Hook and Loop" in it. If you need to specify the parent category, then you can add an additional column called "parent_category" with the value "ADL". If the "ADL" category doesn't exist, it will be created automatically under the "Product category" main category. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[webjive](/forum/user/211-webjive "View webjive's Profile")** - [![webjive's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/211-webjive "View webjive's Profile") Topic Author - [ Offline](/forum/user/211-webjive) Less More - Posts: 30 - Thank you received: 2 - - 10 years 8 months ago - 10 years 8 months ago [\#228614](#228614) by [webjive](/forum/user/211-webjive "View webjive's Profile") Replied by *[webjive](/forum/user/211-webjive "View webjive's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228614 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Thanks for the advice! It looks like we're getting closer but, still having issues getting subcats created automatically. ADL is the new top category with 2 subcategories and listed below. ADL (new parent) -> Hook and Loop (subcat of ADL) -> Webbing Back Hook and Loop Fastener (subcat of Hook and Loop) Just to keep things sane, I started with 1 product this time to get the hang of this instead of 1700 ![:P](/media/kunena/emoticons/15.png ":P") - [ ![Screenshot_2016-02-02_10_10_41.png](/forum/attachment/29266) ](/forum/attachment/29266 "...2_10_10_41.png") [ ](/forum/attachment/29266?download=1 "...2_10_10_41.png") Last edit: 10 years 8 months ago by [webjive](/forum/user/211-webjive "View webjive's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[webjive](/forum/user/211-webjive "View webjive's Profile")** - [![webjive's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/211-webjive "View webjive's Profile") Topic Author - [ Offline](/forum/user/211-webjive) Less More - Posts: 30 - Thank you received: 2 - - 10 years 8 months ago - 10 years 8 months ago [\#228615](#228615) by [webjive](/forum/user/211-webjive "View webjive's Profile") Replied by *[webjive](/forum/user/211-webjive "View webjive's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228615 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Fixed the product import error by changing that column to product_code (duh)... ** The only thing not working correctly is the subcat;subcat creation when I have more than 1 level listed above. Also, my prices are importing correctly but, the Retail Price value is still 0. Is there a field label to set that field value? I tried many variations from the doc page and it didn't work either. Importing product categories Then, you can also have a categories column where you can put a list of categories id or a list of categories namekey. For example: product_code,product_name,categories my_product_1,My first product,"2,13" This will add one product with 2 categories attached: the category with the id 2 and the one with the id 13. You can find ids of categories on the category listing in the column called ID on the right of the listing. You can import a tree of categories which will be created if they don't exist already in HikaShop with the option "Create automatically missing categories" set to "yes". For example, you could have something like: parent_category,categories product category,main category 1;main category 2;main category 3 main category 1,sub category 1;sub category 2 You could also mix both products and categories in the CSV: product_code,parent_category,categories ,main category 1,sub category 2 my_product_1,main category 1,sub category 2 Last edit: 10 years 8 months ago by [webjive](/forum/user/211-webjive "View webjive's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) 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: 86291 - Thank you received: 14269 - - 10 years 8 months ago [\#228653](#228653) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228653 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Hi, I understand that you already found about the sub categories creation with the documentation page. Regarding the retail price, there is a specific column for it. It's called product_msrp so just add that column in your CSV and enter the corresponding value for it for each row. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[webjive](/forum/user/211-webjive "View webjive's Profile")** - [![webjive's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/211-webjive "View webjive's Profile") Topic Author - [ Offline](/forum/user/211-webjive) Less More - Posts: 30 - Thank you received: 2 - - 10 years 8 months ago [\#228746](#228746) by [webjive](/forum/user/211-webjive "View webjive's Profile") Replied by *[webjive](/forum/user/211-webjive "View webjive's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228746 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Thanks for the field ID! As for the auto creation of subcat->subcat vs cat,cat, we have not gotten that problem worked out per this thread. [ www.hikashop.com/forum/import-export-csv...s-at-all.html#228614](https://www.hikashop.com/forum/import-export-csv-xls/882006-import-not-working-for-us-at-all.html#228614) We've tried commas and semi-colons in the categories field like this. Parent_category -> ADL Categories -> Hook and Loop,Webbing Back Hook and Loop Fastener Instead of creating a category tree like: ADL - Hook and Loop -- Webbing Back Hook and Loop Fastener The import creates categories like: ADL - Hook and Loop - Webbing Back Hook and Loop Fastener Per the doc, HIKA shows it should create nested sub-categories? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) 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: 86291 - Thank you received: 14269 - - 10 years 8 months ago [\#228748](#228748) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228748 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Hi, Your CSV is just wrong I suppose. It should be like that: product_code;parent_category;categories code of a product in the category hook and loop;ADL;Hook and Loop code of a product in the category webbing back...;Hook and Loop;Webbing Back Hook and Loop Fastener Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[webjive](/forum/user/211-webjive "View webjive's Profile")** - [![webjive's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/211-webjive "View webjive's Profile") Topic Author - [ Offline](/forum/user/211-webjive) Less More - Posts: 30 - Thank you received: 2 - - 10 years 8 months ago [\#228859](#228859) by [webjive](/forum/user/211-webjive "View webjive's Profile") Replied by *[webjive](/forum/user/211-webjive "View webjive's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228859 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Thats how I have it in the attached CSV but, Hika isn't importing the categories as subcat->subcat. ![:(](/media/kunena/emoticons/5.png ":(") All I can think is that there's a bug? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) 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: 86291 - Thank you received: 14269 - - 10 years 8 months ago - 10 years 8 months ago [\#228868](#228868) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import not working for us at all........](/forum/37-import-export-csv-xls/882006-import-not-working-for-us-at-all#228868 "-- HikaShop version -- : 6.2.1 -- Joomla version -- : 3.5.8 -- Error-message(debug-mod must be tuned on) -- : Notice I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats. Thank goodness for NaviCat and being able to export Hika tables the reimporting. Im attaching the two CSV files we have tried to use without any luck. Thanks")* Hi, No, your CSV is still wrong. You didn't do what I said. That CSV should be like that: *This attachment is hidden for guests. Please log in or register to see it.* Last edit: 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIwMDYtaW1wb3J0LW5vdC13b3JraW5nLWZvci11cy1hdC1hbGw/dG1wbD1tYXJrZG93bg==) 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.401 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)