I have already imported 20,000+ products successfully.
I moved on to a new category. Everything is importing perfectly except the quantity (I have verified it is in the CSV as qty 1).
I am not using Magento to manage stock. Due to the quantity not importing, no items are showing up since it has 0 quantity, I verified this is the issue by changing a quantity to 1 and the SKU shows up.
Is there something I am doing wrong or a mis-configured setting?
Thanks!!
UPDATE:
So I tried to use my original import file to delete all the items not showing and redo it (which was 2500 SKUs). It gave errors when trying to delete after row 2200.
I deleted everything through import up to that 2200.
The other 300 products were still showing in the catalog pages. I tried to select all and delete them and got a http 500 error. I tried to manually delete them one by one which all resulted in a 500 error. I noticed only the name was filled in the catalog pages, everything else was blank like it didn’t import the information. Trying to open the details resulted in a 500 error.
Checking the logs I didn’t see anything helpful.
I ended up going into sql and manually deleting them by entity_id in the catalog_product_entity table. All the fields in the database were NULL but the id.
I am guessing it was some sort of failed import which corrupted any further imports. By manually clearing it all I was able to go on.
I tried re-importing and was still getting no quantities. I lowered my SKU import to 2000 SKUs (9MB) from 2500(11MB) and it is now working. My guess is the import was just too big and it would fail most of the way through. Can anyone verify this?