How to upload product to correct category tree

Hi Team,

I read your document about how to upload products in a tree category, however I still could not get it right. Please advise where I'm doing wrong.

- I have category list as per below:

Root
|-- Product Category
|

---

Category A (ID=12)
|

---

Category A1 (ID=21)
|

---

Category A2
|

---

Category B (ID=13)
|

---

Category B1 (ID=29)
|

---

Category B2

- When I add the product using the below method, I could correctly see my product in a designated module.

a. Go to 'Products' --> 'Add a Product'
b. Enter any value in 'Name' (e.g. Product A), 'Description'. ID=35.
c. Select 'Category' --> Category A1 (ID=21), Category B1 (ID=29).
d. Select 'Image', then add image from my local PC.

When I clicked on the product in the site, it has a URL something like below (example when I chose from Category A1 (ID=21)):
myTestPage.cloudaccess.net/ hm-surveyed-products/product/35-product-a/category_pathway-21.html

- However, when I add a product using the bulk upload (e.g. ID=38), I could not see it under the same module.

product_name,product_description,parent_category,categories
"Test Product","Bla bla",12,21

Here, I expect that when I clicked on Category A1 (ID=21), I would see this product (ID=38) as well along with the above product (ID=35), however I could not see it. It is visible when I searched on the product from 'Search' function. When I clicked on the product itself, below is the URL to the product:

myTestPage.cloudaccess.net/ component/hikashop/product/38-test-product/category_pathway-21.html

The difference in the URL between the correct and the false one is:
correct path: hm-surveyed-products,
however incorrect path, seems like the product is placed under this component: component/hikashop.

Please kindly advise how to make the latter product available in the same module as first product (ID=35) using the bulk upload. Thank you in advance.

Thank you so much for the help, Nicolas, it works now!

You were right, it was because of the quantity. I can see them once the qty was changed.

Thank you!!