[Skip to main content](#vessel-content) # Products import into db, but don't display ## - **[jeaki](/forum/user/32878-jeaki "View jeaki's Profile")** - [![jeaki's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32878-jeaki "View jeaki's Profile") Topic Author - [ Offline](/forum/user/32878-jeaki) Less More - Posts: 2 - Thank you received: 0 - - 11 years 11 months ago - 11 years 11 months ago [\#180668](#180668) by [jeaki](/forum/user/32878-jeaki "View jeaki's Profile") *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#180668 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* was created by *[jeaki](/forum/user/32878-jeaki "View jeaki's Profile")* -- url of the page with the problem -- : [ www.evangelinespec.com/](http://www.evangelinespec.com/) -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up. - [ ![db_cap.png](/forum/attachment/20809) ](/forum/attachment/20809 "db_cap.png") [ ](/forum/attachment/20809?download=1 "db_cap.png") - [ ![import_cap.png](/forum/attachment/20810) ](/forum/attachment/20810 "import_cap.png") [ ](/forum/attachment/20810?download=1 "import_cap.png") - [ ![product_list.png](/forum/attachment/20811) ](/forum/attachment/20811 "product_list.png") [ ](/forum/attachment/20811?download=1 "product_list.png") Last edit: 11 years 11 months ago by [jeaki](/forum/user/32878-jeaki "View jeaki's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/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: 14267 - - 11 years 11 months ago [\#180685](#180685) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#180685 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi, In your CSV, there is no "categories" column with the name of one or several categoreis separated by a ; or a , Because of that, the product is indeed added in the database, but is not linked to any category. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")** - [![james@esgmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") - [ Offline](/forum/user/35942-james-esgmail-com) Less More - Posts: 14 - Thank you received: 0 - - 11 years 1 week ago - 11 years 1 week ago [\#217307](#217307) by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") Replied by *[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#217307 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi - I have a similar issue. I'm new to hikashop. I am not being able to make the csv upload, show up in the product listing. Only the test item I put in from the add product section - not by CSV. Attached is the CSV. I have the associated categories created. The listing is all displaying in the DB table. However in the DB the categories column does not exist. Can you advise where to look for a solution? Thx. *This attachment is hidden for guests. Please log in or register to see it.* joomla 3.4.4 hikashop business 2.6.0 Last edit: 11 years 1 week ago by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/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: 14267 - - 11 years 1 week ago [\#217329](#217329) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#217329 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi, I don't see a problem with your CSV. There is no categories column and that's normal. The link between the products and the categories is done in the table hikashop_product_category with one row for each link between a category and a product. Are you sure that the problem is not coming from something else, like the way your products listing is configured ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")** - [![james@esgmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") - [ Offline](/forum/user/35942-james-esgmail-com) Less More - Posts: 14 - Thank you received: 0 - - 11 years 1 week ago - 11 years 1 week ago [\#217410](#217410) by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") Replied by *[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#217410 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi Nicolas - Trying to figure that out. On the CSV - should I have a 'categories' column - should that be revised to match the name in the category DB - screen shot of that attached. category_name ??? On the product setup - I've added a screen shot - doesn't seem like anything there that is off. On the import page - screen shot attached - on product template there is none listed. Could this be it - if so - how do I change it? Also attaching from your comment on the DB for the product category - the screenshot from that page - with only the one product that was hand loaded - not uploaded. Thanks! [ ![Import_pg_Screen_Shot_.png](/forum/attachment/27075) ](/forum/attachment/27075 "...reen_Shot_.png") [ ![Product_config_Screen_Shot_.png](/forum/attachment/27076) ](/forum/attachment/27076 "...reen_Shot_.png") [ ![DB_category_scrn_shot.png](/forum/attachment/27077) ](/forum/attachment/27077 "..._scrn_shot.png") - [ ![Import_pg_Screen_Shot_.png](/forum/attachment/27075) ](/forum/attachment/27075 "...reen_Shot_.png") [ ](/forum/attachment/27075?download=1 "...reen_Shot_.png") - [ ![Product_config_Screen_Shot_.png](/forum/attachment/27076) ](/forum/attachment/27076 "...reen_Shot_.png") [ ](/forum/attachment/27076?download=1 "...reen_Shot_.png") - [ ![DB_category_scrn_shot.png](/forum/attachment/27077) ](/forum/attachment/27077 "..._scrn_shot.png") [ ](/forum/attachment/27077?download=1 "..._scrn_shot.png") Last edit: 11 years 1 week ago by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/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: 14267 - - 11 years 1 week ago [\#217413](#217413) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#217413 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi, 1. You could keep the column name "categories". If you put something else, it won't work. 2. Your screenshots don't show much. The import screen is just for you to import CSVs. It doesn't display products. And your database screenshot is from the hikashop_category, which just lists the categories in your shop. It's different from the hikashop_product_category table which lists the links between the products and the categories. What you want to look at is the Products menu where you should see your products once you select a category on the left explorer. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")** - [![james@esgmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") - [ Offline](/forum/user/35942-james-esgmail-com) Less More - Posts: 14 - Thank you received: 0 - - 11 years 1 week ago [\#217541](#217541) by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") Replied by *[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#217541 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi Nicolas, I'm attaching screenshots of the product_category page along with the products pages. The one sample1 product I have in is assigned to the froz category and will display under froz or none settings. It is not showing up on the product_category DB table. The other products from the CSV are in the DB but not showing on the product listing page. Any idea how they could be uploading to the DB from the CSV but not appearing in the product listing? Thank you! James [ ![Screen_Shot_2015-10-16_at_11_26_17_AM.png](/forum/attachment/27091) ](/forum/attachment/27091 "...1_26_17_AM.png") [ ![Screen_Shot_2015-10-16_at_11_26_17_AM.png](/forum/attachment/27091) ](/forum/attachment/27091 "...1_26_17_AM.png") [ ![Screen_Shot_2015-10-16_at_11_25_59_AM.png](/forum/attachment/27092) ](/forum/attachment/27092 "...1_25_59_AM.png") [ ![Screen_Shot_2015-10-16_at_11_25_34_AM.png](/forum/attachment/27093) ](/forum/attachment/27093 "...1_25_34_AM.png") [ ![Screen_Shot_2015-10-16_at_11_25_14_AM.png](/forum/attachment/27094) ](/forum/attachment/27094 "...1_25_14_AM.png") - [ ![Screen_Shot_2015-10-16_at_11_26_17_AM.png](/forum/attachment/27091) ](/forum/attachment/27091 "...1_26_17_AM.png") [ ](/forum/attachment/27091?download=1 "...1_26_17_AM.png") - [ ![Screen_Shot_2015-10-16_at_11_25_59_AM.png](/forum/attachment/27092) ](/forum/attachment/27092 "...1_25_59_AM.png") [ ](/forum/attachment/27092?download=1 "...1_25_59_AM.png") - [ ![Screen_Shot_2015-10-16_at_11_25_34_AM.png](/forum/attachment/27093) ](/forum/attachment/27093 "...1_25_34_AM.png") [ ](/forum/attachment/27093?download=1 "...1_25_34_AM.png") - [ ![Screen_Shot_2015-10-16_at_11_25_14_AM.png](/forum/attachment/27094) ](/forum/attachment/27094 "...1_25_14_AM.png") [ ](/forum/attachment/27094?download=1 "...1_25_14_AM.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")** - [![james@esgmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") - [ Offline](/forum/user/35942-james-esgmail-com) Less More - Posts: 14 - Thank you received: 0 - - 11 years 5 days ago [\#217978](#217978) by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") Replied by *[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#217978 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hello Nicolas - any ideas on why the products or categories are not populating? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")** - [![james@esgmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") - [ Offline](/forum/user/35942-james-esgmail-com) Less More - Posts: 14 - Thank you received: 0 - - 11 years 4 days ago [\#218001](#218001) by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") Replied by *[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#218001 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* I seem to have figured out the upload problem for the data, the column for 'product_type" needed to be populated with 'main'. My previous CSV was listed with 'variant' Now working on the image upload. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 4 days ago [\#218052](#218052) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#218052 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi, So is the issue with the categories solved ? If not, the issue is maybe coming from the csv format, some columns, for example "product_description" the text is not between double quotes, and that is potentially breaking the import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")** - [![james@esgmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") - [ Offline](/forum/user/35942-james-esgmail-com) Less More - Posts: 14 - Thank you received: 0 - - 11 years 4 days ago [\#218058](#218058) by [james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile") Replied by *[james@esgmail.com](/forum/user/35942-james-esgmail-com "View james@esgmail.com's Profile")* on topic *[Products import into db, but don't display](/forum/37-import-export-csv-xls/873169-products-import-into-db-but-dont-display#218058 "-- url of the page with the problem -- : www.evangelinespec.com/ -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.34 -- Browser(s) name and version -- : FIrefox 32 -- Error-message(debug-mod must be tuned on) -- : no error message displying I have used hikashop for months now, configuring and testing mostly. It has been a pleasure to work with. I have manually inserted hundreds of products and have had no issues. I recently started to import products via a csv import and had limited success with that process. I have deleted all products at different times for various reasons. My point being, it has worked great for months. Recently, My imported products are not showing in my products list in hikashop. I get a success message, but the products won't display. I have checked each level of products, from root all the way down to sub catagories. They are not there. The products are, however, in the db on my hosting server. I can see the products in my db interface. I have attached a copy of the import file (csv), along with screenshots of the successful import picture, and one capture of the product list at the root of products level, and lastly a capture of the products table. I am showing one product, for simplicity, but my database is actually over 2 thousand products. I will point out that I use the same import csv each time. I have added and delete different columns, but only for display purposes. I didn't have issues, I just changed it around while I was testing. I confirmed each column name was proper, etc. Where am I going awry? I am wanting to launch this site soon, but this is really holding me up.")* Hi Xavier - yes - the issue was that in the product_type column I had it listed as 'variant'. When I changed this to 'main" the items would populate. Now trying to get the photos to import. Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMxNjktcHJvZHVjdHMtaW1wb3J0LWludG8tZGItYnV0LWRvbi10LWRpc3BsYXk/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.474 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)