[Skip to main content](#vessel-content) # Import not functioning although no errors. ## - **[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")** - [![hydromarket's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35601-hydromarket "View hydromarket's Profile") Topic Author - [ Offline](/forum/user/35601-hydromarket) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#185144](#185144) by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile") *[Import not functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185144 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* was created by *[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")* -- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 9 months ago [\#185158](#185158) 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 functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185158 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* Hi, It's probably a problem with your CSV file. Please attach your CSV file so that we can see what you did and we'll be able to answer you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")** - [![hydromarket's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35601-hydromarket "View hydromarket's Profile") Topic Author - [ Offline](/forum/user/35601-hydromarket) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#185259](#185259) by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile") Replied by *[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")* on topic *[Import not functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185259 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* It was no problem with the CSV file when I selected UTF-8, the tutorials I watched did not select any and left it undisclosed, any reason why? I am however getting table errors in certain lines with it, can descriptions be too long? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")** - [![hydromarket's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35601-hydromarket "View hydromarket's Profile") Topic Author - [ Offline](/forum/user/35601-hydromarket) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#185260](#185260) by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile") Replied by *[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")* on topic *[Import not functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185260 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* Here is the file Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")** - [![hydromarket's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35601-hydromarket "View hydromarket's Profile") Topic Author - [ Offline](/forum/user/35601-hydromarket) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#185262](#185262) by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile") Replied by *[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")* on topic *[Import not functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185262 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* Sorry I didn't realize you had to click insert after you attached :ohmy: Last edit: 11 years 9 months ago by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile"). Reason: attachment Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")** - [![hydromarket's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35601-hydromarket "View hydromarket's Profile") Topic Author - [ Offline](/forum/user/35601-hydromarket) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#185263](#185263) by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile") Replied by *[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")* on topic *[Import not functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185263 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* Hope this works, i've clicked add file and see the attachment:1 in [] Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")** - [![hydromarket's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35601-hydromarket "View hydromarket's Profile") Topic Author - [ Offline](/forum/user/35601-hydromarket) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#185264](#185264) by [hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile") Replied by *[hydromarket](/forum/user/35601-hydromarket "View hydromarket's Profile")* on topic *[Import not functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185264 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* Sorry I had the file open! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 9 months ago [\#185628](#185628) 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 functioning although no errors.](/forum/37-import-export-csv-xls/873994-import-not-functioning-although-no-errors#185628 "-- url of the page with the problem -- : hydromarket.co.uk/joomla -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.0 -- Browser(s) name and version -- : 5.4.14 -- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? products stated uploaded but I dont see any products after using a HikaShop template CSV to upload. It states the products uploaded successfully yet I can not see any products? Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys? I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?")* Hi, Sorry for the delay. So I see quite a lot of problems in both the CSVs you provided. First, for the hikashop 2.12.csv: [ take.ms/rWiXr](http://take.ms/rWiXr) 1. There are some problems with the quotes in the product description of some products leading to a mismatch between the columns and the data that should be in them around the 50th row of your file 2. Besides the product_name, price_value and product_description columns everything else is empty (besides the categories column for the first product). If you don't have anything in a column, don't put the column. Second, for the Hydromarket 2015 CSV products.csv: [ take.ms/OHKdY](http://take.ms/OHKdY) and [ take.ms/f7LMT](http://take.ms/f7LMT) 1. There is the same problem with the quotes and the description at around line 50 of the CSV. 2. The product_parent_id has a D instead of a d at the end of the column name. 3. The product_parent_id column should contain the product_code of a main product or nothing. If it contains a product_code of a main product, it means that the current row is a variant of the main product and there should be a characteristic column with the value for each variant and for the main product (you can read more about importing variants/characteristics in our import documentation page: [ www.hikashop.com/support/support/documen...hikashop-import.html](http://www.hikashop.com/support/support/documentation/73-hikashop-import.html) ). But maybe each line is its own product and in that case, you just don't need that column and should not have it. 4. You can remove the product_id column. The id will be added automatically by HikaShop. 5. The product_vendor_id should contain the id of the vendor, not its name. 6. The categories column should contain the name of the category of the product, not a price. 7. The parent_category column should contain only the name of the parent category or just remove it. If you already have your categories on your HikaShop, you don't need it and the name of the category is enough for each product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzM5OTQtaW1wb3J0LW5vdC1mdW5jdGlvbmluZy1hbHRob3VnaC1uby1lcnJvcnM/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.305 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)