"URL key for specified store already exists." Product import

[bablupali]

Hello,

I had tried to export my products to a CSV file, then I tried importing it into my site. After the import was done, I found that the quantity column was blank for some products and the products were listed out of stock. Although I could see the quantities in exported CSV file, but it was not shown in imported products.

I have tried many times but every time same result was there.

Any help.

Magento Version: 2.1.9

Thanks

[Rakesh Jesadiya]

Could you share your CSV file with data. so any user can figure out your issue and its easy for us to solve your query.

[bablupali]

Thanks for reply.

Sorry, but I forgot to mention that while importing products, I got the error

"URL key for specified store already exists."

I had checked the whole url_key column of CSV file but no duplicate entries were there.

At the same time I found that out of my 126 products only 100 products were imported.

Then I performed these steps

I divided the CSV file into two CSV files with 67 and 59 entries.

First file with 67 entries imported well and all the products were listed with quantity column correct.

While importing second file I got the error,

"URL key for specified store already exists."

and this time products are imported but quantity column was blank.

I have checked again and found unique URL keys.

Any help.

Thanks

[bablupali · Accepted solution]

Hello,

I have my problem solved .

I am going to explain what I have done to find the problem source so that it may help someone.

First I deleted all products from my local site. (Not a part of solution, but just to indicate from where the problem is coming)

Then, I went to url_rewrite table in database.

I found that there were two entries of products already listed although I had deleted all the products.

I checked my CSV file and found that these two products were listed there.

I deleted these two entries from url_rewrite table.

Then, I tried again to Import my products and this time products were imported without any errors.

Perhaps this is a bug, I dont know, I am just a beginner in Magento.

Anyway, my problem is solved.

Thanks.