[Skip to main content](#vessel-content)

#   No Products after a sucessful import

##

- **[Jims](/forum/user/2963-jims "View Jims's Profile")**
- [![Jims's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2963-jims "View Jims's Profile") Topic Author
- [ Offline](/forum/user/2963-jims)

Less More

- Posts: 152
- Thank you received: 0
-
-
-
- [](http://potluckceramics.ca)
-

15 years 4 months ago -  15 years 4 months ago [\#20018](#20018) by [Jims](/forum/user/2963-jims "View Jims's Profile")  *[No Products after a sucessful import](/forum/4-how-to/20018-no-products-after-a-sucessful-import#20018 "After a successful import: &quot;131 products found : 131 new products imported, 0 invalid product code, 0 already existing products&quot;  I cannot find the products anywhere in the Product Table at htp://js-ca.net/potluckcms  Here are the first 4 lines of the csv file:  product&#95;description;price&#95;value;product&#95;name;product&#95;type;product&#95;code;product&#95;parent&#95;id;Colour;Size;categories;images  Bear Tracks Beige;0;Bear Tracks Beige;main;RBT-B;;Beige; ;West Coast Series;image367.jpg  Breakfast Cup;13.95;Breakfast Cup;variant;RBT-B-60;RBT-B;Beige; ;West Coast Series;image1195.jpg  cereal bowl;13.95;Cereal Bowl;variant;RBT-B-65;RBT-B;Beige; ;West Coast Series;image1074.jpg  Where did the products go? :-)  Further: monday evening: I noticed the ; separators from Excel2010 and changed to , but got exactly the same result, and also the same result from a quite different csv file. I also changed the file to put the product&#95;code in column 1, but that had no effect on the problem.  Jim")* was created by *[Jims](/forum/user/2963-jims "View Jims's Profile")*

After a successful import:
"131 products found : 131 new products imported, 0 invalid product code, 0 already existing products"

I cannot find the products anywhere in the Product Table at htp://js-ca.net/potluckcms

Here are the first 4 lines of the csv file:

product_description;price_value;product_name;product_type;product_code;product_parent_id;Colour;Size;categories;images

Bear Tracks Beige;0;Bear Tracks Beige;main;RBT-B;;Beige; ;West Coast Series;image367.jpg

Breakfast Cup;13.95;Breakfast Cup;variant;RBT-B-60;RBT-B;Beige; ;West Coast Series;image1195.jpg

cereal bowl;13.95;Cereal Bowl;variant;RBT-B-65;RBT-B;Beige; ;West Coast Series;image1074.jpg

Where did the products go? ![:-)](/media/kunena/emoticons/3.png ":-)")

Further: monday evening: I noticed the ; separators from Excel2010 and changed to , but got exactly the same result, and also the same result from a quite different csv file. I also changed the file to put the product_code in column 1, but that had no effect on the problem.

Jim

Last edit: 15 years 4 months ago by [Jims](/forum/user/2963-jims "View Jims's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIwMDE4LW5vLXByb2R1Y3RzLWFmdGVyLWEtc3VjZXNzZnVsLWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#20030](#20030) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: No Products after a sucessful import](/forum/4-how-to/20018-no-products-after-a-sucessful-import#20030 "After a successful import: &quot;131 products found : 131 new products imported, 0 invalid product code, 0 already existing products&quot;  I cannot find the products anywhere in the Product Table at htp://js-ca.net/potluckcms  Here are the first 4 lines of the csv file:  product&#95;description;price&#95;value;product&#95;name;product&#95;type;product&#95;code;product&#95;parent&#95;id;Colour;Size;categories;images  Bear Tracks Beige;0;Bear Tracks Beige;main;RBT-B;;Beige; ;West Coast Series;image367.jpg  Breakfast Cup;13.95;Breakfast Cup;variant;RBT-B-60;RBT-B;Beige; ;West Coast Series;image1195.jpg  cereal bowl;13.95;Cereal Bowl;variant;RBT-B-65;RBT-B;Beige; ;West Coast Series;image1074.jpg  Where did the products go? :-)  Further: monday evening: I noticed the ; separators from Excel2010 and changed to , but got exactly the same result, and also the same result from a quite different csv file. I also changed the file to put the product&#95;code in column 1, but that had no effect on the problem.  Jim")*

Could you try without the dashes in the product codes ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIwMDE4LW5vLXByb2R1Y3RzLWFmdGVyLWEtc3VjZXNzZnVsLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jims](/forum/user/2963-jims "View Jims's Profile")**
- [![Jims's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2963-jims "View Jims's Profile") Topic Author
- [ Offline](/forum/user/2963-jims)

Less More

- Posts: 152
- Thank you received: 0
-
-
-
- [](http://potluckceramics.ca)
-

15 years 4 months ago [\#20037](#20037) by [Jims](/forum/user/2963-jims "View Jims's Profile")  Replied by *[Jims](/forum/user/2963-jims "View Jims's Profile")* on topic *[Re: No Products after a sucessful import](/forum/4-how-to/20018-no-products-after-a-sucessful-import#20037 "After a successful import: &quot;131 products found : 131 new products imported, 0 invalid product code, 0 already existing products&quot;  I cannot find the products anywhere in the Product Table at htp://js-ca.net/potluckcms  Here are the first 4 lines of the csv file:  product&#95;description;price&#95;value;product&#95;name;product&#95;type;product&#95;code;product&#95;parent&#95;id;Colour;Size;categories;images  Bear Tracks Beige;0;Bear Tracks Beige;main;RBT-B;;Beige; ;West Coast Series;image367.jpg  Breakfast Cup;13.95;Breakfast Cup;variant;RBT-B-60;RBT-B;Beige; ;West Coast Series;image1195.jpg  cereal bowl;13.95;Cereal Bowl;variant;RBT-B-65;RBT-B;Beige; ;West Coast Series;image1074.jpg  Where did the products go? :-)  Further: monday evening: I noticed the ; separators from Excel2010 and changed to , but got exactly the same result, and also the same result from a quite different csv file. I also changed the file to put the product&#95;code in column 1, but that had no effect on the problem.  Jim")*

I changed all the hyphens to underscores, Nicolas, but got exactly the same result.

"131 products found : 131 new products imported, 0 invalid product code, 0 already existing products"

and no new products in the Product Table.

Jim

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIwMDE4LW5vLXByb2R1Y3RzLWFmdGVyLWEtc3VjZXNzZnVsLWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#20039](#20039) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: No Products after a sucessful import](/forum/4-how-to/20018-no-products-after-a-sucessful-import#20039 "After a successful import: &quot;131 products found : 131 new products imported, 0 invalid product code, 0 already existing products&quot;  I cannot find the products anywhere in the Product Table at htp://js-ca.net/potluckcms  Here are the first 4 lines of the csv file:  product&#95;description;price&#95;value;product&#95;name;product&#95;type;product&#95;code;product&#95;parent&#95;id;Colour;Size;categories;images  Bear Tracks Beige;0;Bear Tracks Beige;main;RBT-B;;Beige; ;West Coast Series;image367.jpg  Breakfast Cup;13.95;Breakfast Cup;variant;RBT-B-60;RBT-B;Beige; ;West Coast Series;image1195.jpg  cereal bowl;13.95;Cereal Bowl;variant;RBT-B-65;RBT-B;Beige; ;West Coast Series;image1074.jpg  Where did the products go? :-)  Further: monday evening: I noticed the ; separators from Excel2010 and changed to , but got exactly the same result, and also the same result from a quite different csv file. I also changed the file to put the product&#95;code in column 1, but that had no effect on the problem.  Jim")*

Then please activate debug mode in the configuration of joomla and try again.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIwMDE4LW5vLXByb2R1Y3RzLWFmdGVyLWEtc3VjZXNzZnVsLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jims](/forum/user/2963-jims "View Jims's Profile")**
- [![Jims's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2963-jims "View Jims's Profile") Topic Author
- [ Offline](/forum/user/2963-jims)

Less More

- Posts: 152
- Thank you received: 0
-
-
-
- [](http://potluckceramics.ca)
-

15 years 4 months ago [\#20041](#20041) by [Jims](/forum/user/2963-jims "View Jims's Profile")  Replied by *[Jims](/forum/user/2963-jims "View Jims's Profile")* on topic *[Re: No Products after a sucessful import](/forum/4-how-to/20018-no-products-after-a-sucessful-import#20041 "After a successful import: &quot;131 products found : 131 new products imported, 0 invalid product code, 0 already existing products&quot;  I cannot find the products anywhere in the Product Table at htp://js-ca.net/potluckcms  Here are the first 4 lines of the csv file:  product&#95;description;price&#95;value;product&#95;name;product&#95;type;product&#95;code;product&#95;parent&#95;id;Colour;Size;categories;images  Bear Tracks Beige;0;Bear Tracks Beige;main;RBT-B;;Beige; ;West Coast Series;image367.jpg  Breakfast Cup;13.95;Breakfast Cup;variant;RBT-B-60;RBT-B;Beige; ;West Coast Series;image1195.jpg  cereal bowl;13.95;Cereal Bowl;variant;RBT-B-65;RBT-B;Beige; ;West Coast Series;image1074.jpg  Where did the products go? :-)  Further: monday evening: I noticed the ; separators from Excel2010 and changed to , but got exactly the same result, and also the same result from a quite different csv file. I also changed the file to put the product&#95;code in column 1, but that had no effect on the problem.  Jim")*

Thanks SO VERY much, Nicolas. I was not aware of debug.

The problem was caused by a faulty custom field that I had been experimenting with while trying to solve the span error this morning. When I deleted that custom field the import was successful.

I wonder why Hikashop did not report that error. ![:-)](/media/kunena/emoticons/3.png ":-)")

I copied the the initial part of that report and have attached it.

Many thanks

Jim

####  *This attachment is hidden for guests.
Please log in or register to see it.*

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIwMDE4LW5vLXByb2R1Y3RzLWFmdGVyLWEtc3VjZXNzZnVsLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.047 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
