[Skip to main content](#vessel-content) # "No stock" showing for products with unlimited qty ## - **[vaclav](/forum/user/6663-vaclav "View vaclav's Profile")** - [![vaclav's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6663-vaclav "View vaclav's Profile") Topic Author - [ Offline](/forum/user/6663-vaclav) Less More - Posts: 95 - Thank you received: 1 - - - 14 years 5 months ago [\#50448](#50448) by [vaclav](/forum/user/6663-vaclav "View vaclav's Profile") *["No stock" showing for products with unlimited qty](/forum/3-bug-report/50448-no-stock-showing-for-products-with-unlimited-qty#50448 "Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav")* was created by *[vaclav](/forum/user/6663-vaclav "View vaclav's Profile")* Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81MDQ0OC1uby1zdG9jay1zaG93aW5nLWZvci1wcm9kdWN0cy13aXRoLXVubGltaXRlZC1xdHk/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 5 months ago [\#50496](#50496) 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 stock" showing for products with unlimited qty](/forum/3-bug-report/50448-no-stock-showing-for-products-with-unlimited-qty#50496 "Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav")* The stock is correct. The problem is that you have the product_published column in your CSV with an empty value for each variant. Thus, the variants are unpublished. Because of that, the system doesn't allow you to buy them. Just set "1" in the product_published column of your CSV and it will work. That will solve both problems. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81MDQ0OC1uby1zdG9jay1zaG93aW5nLWZvci1wcm9kdWN0cy13aXRoLXVubGltaXRlZC1xdHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaclav](/forum/user/6663-vaclav "View vaclav's Profile")** - [![vaclav's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6663-vaclav "View vaclav's Profile") Topic Author - [ Offline](/forum/user/6663-vaclav) Less More - Posts: 95 - Thank you received: 1 - - - 14 years 5 months ago [\#50502](#50502) by [vaclav](/forum/user/6663-vaclav "View vaclav's Profile") Replied by *[vaclav](/forum/user/6663-vaclav "View vaclav's Profile")* on topic *[Re: "No stock" showing for products with unlimited qty](/forum/3-bug-report/50448-no-stock-showing-for-products-with-unlimited-qty#50502 "Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav")* Thanks Nicolas! Thanks so much! I changed it as you said and it worked. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81MDQ0OC1uby1zdG9jay1zaG93aW5nLWZvci1wcm9kdWN0cy13aXRoLXVubGltaXRlZC1xdHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jwmartinez](/forum/user/9515-jwmartinez "View jwmartinez's Profile")** - [![jwmartinez's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9515-jwmartinez "View jwmartinez's Profile") - [ Offline](/forum/user/9515-jwmartinez) Less More - Posts: 32 - Thank you received: 3 - - - - 13 years 11 months ago [\#76562](#76562) by [jwmartinez](/forum/user/9515-jwmartinez "View jwmartinez's Profile") Replied by *[jwmartinez](/forum/user/9515-jwmartinez "View jwmartinez's Profile")* on topic *[Re: "No stock" showing for products with unlimited qty](/forum/3-bug-report/50448-no-stock-showing-for-products-with-unlimited-qty#76562 "Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav")* Hi I'm having the same problems, since I updated to the essentials version. I did'nt added the products using CSV I created the product and the variants on the back-end and it was working alright. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81MDQ0OC1uby1zdG9jay1zaG93aW5nLWZvci1wcm9kdWN0cy13aXRoLXVubGltaXRlZC1xdHk/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) - 13 years 11 months ago [\#76666](#76666) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: "No stock" showing for products with unlimited qty](/forum/3-bug-report/50448-no-stock-showing-for-products-with-unlimited-qty#76666 "Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav")* Hi, Are you sure that your products and variants are published, and have a quantity of "-1" ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81MDQ0OC1uby1zdG9jay1zaG93aW5nLWZvci1wcm9kdWN0cy13aXRoLXVubGltaXRlZC1xdHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jwmartinez](/forum/user/9515-jwmartinez "View jwmartinez's Profile")** - [![jwmartinez's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9515-jwmartinez "View jwmartinez's Profile") - [ Offline](/forum/user/9515-jwmartinez) Less More - Posts: 32 - Thank you received: 3 - - - - 13 years 11 months ago [\#77334](#77334) by [jwmartinez](/forum/user/9515-jwmartinez "View jwmartinez's Profile") Replied by *[jwmartinez](/forum/user/9515-jwmartinez "View jwmartinez's Profile")* on topic *["No stock" showing for products with unlimited qty](/forum/3-bug-report/50448-no-stock-showing-for-products-with-unlimited-qty#77334 "Hi Nicolas, My problem is that when I import my products with characteristics, there is "No stock" in frontend for all my variants of that products even there is "-1" for the quantity for the product and for all its variants - see attached csv. I imported only one product to show you the problem and to make the csv as small as possible for the purpose of your help... This is what I did: I made a csv file with all products (all done the same way as the one attached to this message). I created one Characteristic named "Varianta" with about 1500 values and imported it as a table in phpmyadmin. Then I imported my product to Hikashop. Product shoved, but to see the characteristic with correct prices in frontend I had to open that product in backend and add characteristics (that one called "Varianta" which I imported in phpmyadmin) to it. After saving - the correct prices and correct characteristics showed in frontend, but everything is out of stock - even there are "unlimited" quantities in product details in backend. 1. What to do to make the product in stock? 2. How to make all the characteristics(variants of product set in characteristics) show with correct prices immediately after importing without having to open each product, add characteristics and save it? It is quiet annoying when you have about 1000 products and all with characteristics... I guess you will need to see my shop to solve this bug...so I am sending you access details in PM. Thanks Vaclav")* Sorry didn't reply early, Yes there were variants and there were published, and had a quantity of "-1". I fixed the problem, but it require for me to delete this products and re-created all the info, luckily this happened on only 3 products, they are showing fine now, but still don't know what was the problem. Like I mention before, this happen when I updated to Essentials version. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81MDQ0OC1uby1zdG9jay1zaG93aW5nLWZvci1wcm9kdWN0cy13aXRoLXVubGltaXRlZC1xdHk/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.059 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)