No stock issue - only on one product line

  • Posts: 82
  • Thank you received: 1
13 years 3 months ago #23606

Attached is the csv file. This is set up the same as other files that I'm importing. However, the first product imports perfectly, the product name changes and variants are selected. The 2nd two products show no stock and the product name does not change as variants are selected.

What am I doing wrong?

174.121.38.60/~hhware/index.php?option=c...category_pathway=121

File Attachment:

File Name: Tights3.csv
File Size:7 KB



I'm also finding NO STOCK happening in random other places as well.

174.121.38.60/~hhware/index.php?option=c...category_pathway=122

Attachments:
Last edit: 13 years 3 months ago by FreshIdeas.

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

  • Posts: 82821
  • Thank you received: 13368
  • MODERATOR
13 years 3 months ago #23631

You don't specify any stock ( column product_quantity ) in your CSV. So here is what happen:

If the product/variant already exists, the stock isn't changed.
If the product/variant does not already exists, the stock is set to unlimited.
If you have a variant which does not exists, but that can be selected via the dropdowns (it can happen if for example you have two characteristics: color and size with the values blue/red and S/M but that you only have three variants: blue/S, blue/M and red/S. The red/M variant can be selected via the dropdown on the product page even though it doesn't exists. So HikaShop displays the "no stock" message)

Also, I see the name changing on both product pages you gave a link to.

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

  • Posts: 82
  • Thank you received: 1
13 years 2 months ago #24177

NEVER MIND -- I FIGURED IT OUT!!!! The Variant PRODUCT NUMBERS were the same in the CSV! Argghhh.. I've tried so many combinations and it was so simple!!!

Last edit: 13 years 2 months ago by FreshIdeas.

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

  • Posts: 4
  • Thank you received: 0
12 years 4 months ago #55040

Sorry for opening it again, but I´ve read many of these 'no stock' issues and I still did not find a solution for my problem. Only the main product is out of stock if I import my products and the variants. If I import only the main products everything will be fine but after importing the first variants, the main product is displayed out of stock.

I added the product_published column even if I use the checkbox 'force products to be published...'

Maybe I´m blind today but I think my .csv is fine.

Thanks a lot,
Heiko

Attachments:

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

  • Posts: 82821
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #55096

Your CSV is not fine.

Take for example the variant One Door 350 L 770 on line 31.
Based on its product_parent_id, it's the variant of the product S1.00002.01.001.2001 which is on line 3.
As far as I can see there are no other variants for that product.
If I look in the column Select Ironmongery: which is apparently a characteristic, I can see that you have the value '110 Degree Clip-Top - Blum' for the main product (that's the default value of the characteristic for that product). And in the variant, you have the value '110 Degree Clip-Top with integrated Blumotion - Blum'.
So you have AT LEAST two variants for that characteristic of that product. But in the CSV, you have filled only the information of one of the variants.
Thus, when you import, some data is missing. And when you have a variant without data, its stock is set to 0.

You should create one product with a characteristic via the interface and export it. You will see that you have one line for the main product data, and then one line per variant (and by the way, if the information is the same, you don't need to fill it in the variants).
Do the same in your CSV and it should work better.

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

  • Posts: 4
  • Thank you received: 0
12 years 4 months ago #55149

Of course it´s not. I wrote that I THINK it´s fine :blush:

So the problem was that the main product must have a variant of its own. Thanks a lot for helping me, I was nearly at the right way by myself but I did not figure out how to work with the product_numbers. Everything is fine now.

Thank you very much....

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

Time to create page: 0.079 seconds
Powered by Kunena Forum