Import / Export module - duplicate errors

Hi,

I have just installed Opencart 1.4.8 and Import/Export 1-4-8-11 ruining in a test system using WAMP server, php .53

I have approx 3500 products to import but I am having trouble using the import module.
My product_id is the product code, some of the codes are:
24HP2.1
24HP2.2
24HP2.3
etc

The import fails with the error:
Error: Duplicate entry '24HP2' for key 'PRIMARY'
Error No: 1062

It obviously does not see the . in the string and so produces the duplicate error.
The same thing happens on other codes where it has a hyphen in the code eg: 24HP2-6

Now I have tried entering these codes manually through the admin panel successfully so Opencart has no problem with them but the Import/Export module does.

Anyone have any idea have to resolve this - I don't want to enter all 3000+ manually

Thanks in anticipation for any help.

Best regards

Dave.

Can you try and replace the dots with slashes or some other kind of punctuation?

Whilst I appreciate that this is not a fix, it will get the store online, then you can look to alter the code (if neccessary) through sql

Hi Steve,
I see where your going with this, it was my first thought.
Unfortunately it is not an option. Our main ERP system handles all all the sales order processing, purchasing, inventory etc. My plan is to set up a daily update from our ERP system, the obvious thing that will change regularly is the stock quantity of each product. I will use Crystal Reports (or Access Query)to extract the required info from the ERP system and then import into Opencart thus keeping Opencart up to date. So going forward, the product_id must be the same on both systems.

Thanks for your input though!

Dave

I know what you mean, and whilst my offering isn't a solution, it would be a reasonably simple short term fix for you?
it would just mean adding another step to the process.

also, just thinking now, have you tried entering some products manually....
how does the export show the products in excel?
does it replace the punctuation with a piece of code or does it show correctly?

Ah, good point! I will do a quick export and let you know.

The product_id always has to be a unique integer value.

Use the SKU for your own way of identifying products.

Hi JNeuhoff

I take your point that the product_id field must be an integer (and indeed it is set as an INT in the product table), but I did a manual entry of 24HP2.1 and 24HP2-1, it accepted them and displayed them in the store front, I also exported the database and sure enough they appeared on the spreadsheet.

I can't explain that?

Dave.

I seem to have a similar error

Error: Duplicate entry '49--1' for key 1
Error No: 1062
INSERT INTO `product_tags` (`product_id`,`tag`,`language_id`) VALUES (49,'',1), (49,'',1);

I exported my test file - had only 3 products in it. Changed the sku numbers to something different then imported. I made sure all the product_id is unique.Have not changed anything else.

Threw up the error above (language???) Now only have 1 product.

Only have 1 language installed.

Not sure what to do.

cc6264 wrote:I seem to have a similar error

Error: Duplicate entry '49--1' for key 1
Error No: 1062
INSERT INTO `product_tags` (`product_id`,`tag`,`language_id`) VALUES (49,'',1), (49,'',1);

I exported my test file - had only 3 products in it. Changed the sku numbers to something different then imported. I made sure all the product_id is unique.Have not changed anything else.

Threw up the error above (language???) Now only have 1 product.

Only have 1 language installed.

Not sure what to do.

Send me your spreadsheet file and I take a look at it.

I need to upload about 6000 products into my store but when i tried to upload the xls file, it doesn't show up anything! not even an error, i can see that the loading bar in my browser was running, it means that i was uploading to the server but after it ended, nothing seems to happen. I tried to upload about 3000 products and it was fine. Products showed up.

p/s: if someone is good with spreadsheet, may i ask this question:
for example: i got two products like this:
200 1 Million by Paco Rabanne 3.4z
201 1 Million by Paco Rabanne 1.7z
the only diffrenet between this two products are the size. I don't want to have 2 products on the main store with the same name but different size. Is there any way I can put this in to "option" without doing it manually?

Thank you so much...

phoanglong wrote:I need to upload about 6000 products into my store but when i tried to upload the xls file, it doesn't show up anything! not even an error, i can see that the loading bar in my browser was running, it means that i was uploading to the server but after it ended, nothing seems to happen. I tried to upload about 3000 products and it was fine. Products showed up.

p/s: if someone is good with spreadsheet, may i ask this question:
for example: i got two products like this:
200 1 Million by Paco Rabanne 3.4z
201 1 Million by Paco Rabanne 1.7z
the only diffrenet between this two products are the size. I don't want to have 2 products on the main store with the same name but different size. Is there any way I can put this in to "option" without doing it manually?

Thank you so much...

If you can upload 3000, but not 6000 products, then chances are you have hit one of the limits from your PHP configuration. Check the usual PHP configuration variables as per the readme.txt.

As regards product options: Try this in your 'Options' worksheet (Replace x.xx with your add-on price for the larger size):

hi there, thank for your reply, i think that i will have to ask my host to increase the php memory for me.
And for the spreadsheet, i know how to do it manually but i want to ask some spreadsheet expert howt o do it with some kind of code. because I have like 6000 products with asleast 2-3k is like that. thanks

this is my php configuration, what should i change to make 6000 products upload possible?

phoanglong wrote:this is my php configuration, what should i change to make 6000 products upload possible?

You should at least double your memory_limit.

BTW.: Don't use Windows for your Opencart server!

cc6264 wrote:I seem to have a similar error

Error: Duplicate entry '49--1' for key 1
Error No: 1062
INSERT INTO `product_tags` (`product_id`,`tag`,`language_id`) VALUES (49,'',1), (49,'',1);

I exported my test file - had only 3 products in it. Changed the sku numbers to something different then imported. I made sure all the product_id is unique.Have not changed anything else.

Threw up the error above (language???) Now only have 1 product.

Only have 1 language installed.

Not sure what to do.

I had the same problem. The reason was the lack of data in a field tag in the product description. Script inserted "," symbol in "tags" field instead of an empty content, after exporting the data in the XLS file. Importing passed without errors, after removing this symbol in the column "tags" for each product in saved XLS file.

comua wrote: I had the same problem. The reason was the lack of data in a field tag in the product description. Script inserted "," symbol in "tags" field instead of an empty content, after exporting the data in the XLS file. Importing passed without errors, after removing this symbol in the column "tags" for each product in saved XLS file.

I am unable to reproduce this error. Try the latest Export/Import module.

JNeuhoff wrote:

phoanglong wrote:this is my php configuration, what should i change to make 6000 products upload possible?

You should at least double your memory_limit.

BTW.: Don't use Windows for your Opencart server!

is there any way i can still upload 6000 products without the need of double my memory_limit. As i'm using share host right now and the provider does not want to double it. they said it is the maximum for them at 64M.

can i devided the spreadsheet into 2 and upload it part by part?

phoanglong wrote: is there any way i can still upload 6000 products without the need of double my memory_limit. As i'm using share host right now and the provider does not want to double it. they said it is the maximum for them at 64M.

can i devided the spreadsheet into 2 and upload it part by part?

You could install an Opencart system on your local PC which gives you the freedom to configure it with a sufficient memory_limit. Then edit and import your spreadsheet to your local PC. Once done, do a backup of your database via PHPMyAdmin or the Opemcart admin backup function, and then do a restore of this database to your remote server.

JNeuhoff wrote:

phoanglong wrote: is there any way i can still upload 6000 products without the need of double my memory_limit. As i'm using share host right now and the provider does not want to double it. they said it is the maximum for them at 64M.

can i devided the spreadsheet into 2 and upload it part by part?

You could install an Opencart system on your local PC which gives you the freedom to configure it with a sufficient memory_limit. Then edit and import your spreadsheet to your local PC. Once done, do a backup of your database via PHPMyAdmin or the Opemcart admin backup function, and then do a restore of this database to your remote server.

wow.. i don't really know what to say now, all I can say is thank you so much.. I don't know why i didn't think of this ealier..

but will it work out, because my remote server is a share host, and they just allow me to have 64M of memory.

anyway thank you so much.