"No stock" showing for products with unlimited qty

  • Posts: 95
  • Thank you received: 1
11 years 11 months ago #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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81597
  • Thank you received: 13081
  • MODERATOR
11 years 11 months ago #50496

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 or Create an account to join the conversation.

  • Posts: 95
  • Thank you received: 1
11 years 11 months ago #50502

Thanks Nicolas! Thanks so much! I changed it as you said and it worked.

Please Log in or Create an account to join the conversation.

  • Posts: 32
  • Thank you received: 3
11 years 5 months ago #76562

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 or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 5 months ago #76666

Hi,

Are you sure that your products and variants are published, and have a quantity of "-1" ?

Please Log in or Create an account to join the conversation.

  • Posts: 32
  • Thank you received: 3
11 years 5 months ago #77334

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 or Create an account to join the conversation.

Time to create page: 0.085 seconds
Powered by Kunena Forum