Hi all, I'm hoping someone here might be able to give me some advice. My current client has hired me to create a product importer for their shopping cart. The problem I am having is that there is a total of 7,154 products which need to be inserted into the database, but so far I can only get just over 1,000 of them to insert successfully.
Because I'm working on a test version of the site I can clear out the database and start again. But no matter how many times I do this I still hit the same problem which is after the first 1,000 or so products have been inserted Mysql generates a Duplicate Key Entry error and then the processing stops.
I have tried using INSERT IGNORE which at least lets the php script continue executing, but the final amount of products inserted still remains the same. Has anyone else had an issue like this and managed to resolve it? It's got me stumped.