Hi all -
I've had a quick scan around this forum and on Google for some help but I'm struggling a little. I've setup a new website, got my theme up and running and added via the admin a single product. All good, very happy.
I've then exported my catalog of products resulting a single-line CSV, DELETED that line and added another line and re-imported. Was hoping to now have two products, but import fails every time with 'URL Key already exists'. Doesn't seem to matter if I have one product in my CSV or 100, if it's a fresh creation and I choose the replace option or I'm adding additional products. I can't get anything to go in the database, ever. I appear to have my categories spelt correctly, I certainly have unique URL keys (I've even tried leaving the field blank). Fails every time. Hoping desperately not to have to key in 2500 products one at a time!
Oh yeah, I'm running Magento 2.02.
Any help would be much appreciated. I'm a 20+ year Microsoft developer, I know Windows, ASP.Net and SQL Server inside out but I'm a complete newbie with Unix / MySQL / PHP, this is my first attempt with Magento and I'm feeling very lost and confused!
Thanks in advance
Is the URL key "outdoor-ss-wall-light" really exist in the Magento 2 database before the problem import?
It doesn't exist, no. It's a brand new key. When doing the import I've selected Add/Update as I'm trying to add new products.
I have tried all sorts of things in that field, it doesn't matter what I put in there. It can be in use already or not. All I ever get is the following:
General system exception happened