Post by kestas » Thu May 05, 2016 7:08 pm

Hi,

I use specific xml import product module to import the products from other products suppliers. All seems working fine exept this error:
Notice: Error: Duplicate entry '4299-1' for key 'PRIMARY'
Error No: 1062
INSERT INTO oc_product_to_store SET product_id = '4299', store_id = '1' in /home/pi24x7/domains/***.***/public_html/system/library/db/mysqli.php on line 41

How to prevent this error?
I using OC2.1.0

Thank you in advance

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by IP_CAM » Fri May 06, 2016 4:37 am

>> I use specific xml import product module <<
nice! :D
But wich one ?
http://www.opencart.com/index.php?route ... t%20module
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kestas » Fri May 06, 2016 7:13 pm

IP_CAM wrote:>> I use specific xml import product module <<
nice! :D
But wich one ?
http://www.opencart.com/index.php?route ... t%20module
Ernie
Oh sorry this one...
http://maaz.lt/opencart-xml-importavimo ... o-modulis/

This is in Lithuanian... seller told me that problem are in database, not in a module. Maybe i need to "clean" database. But nobody can't explain how, seller of this module also... Or maybe are some php code who can prevent duplicated entries.

Can anybody suggest something?

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by IP_CAM » Fri May 06, 2016 11:27 pm

yes, get rid of it, if not even the seller have any idea about...
and no-one else would know, about this Extension, so, it's of not much use...
Good Luck ;)
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kestas » Sat May 07, 2016 7:00 am

Oh yes i did it if you "IP_CAM" suggest some better way to import products from this supplier... ???

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by IP_CAM » Sat May 07, 2016 10:29 pm

if you possibly explain, wich Products you import from wich seller, possibly, someone around here would be able, to share such knowledge, and some extensions also exist already for such tasks, but without any facts and/or Links, I fear, that no-one else would be able to.

I never played around with such Extensions, I only know, that genious MaxD, the (formerly) well known OpenShop contributor around here, created such Extensions, especially for the russian/ukrainian Scene. You may contact him, by PM, to find out more:
http://www.opencart.com/index.php?route ... rname=MaxD

Good Luck !
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kestas » Mon May 09, 2016 4:03 am

IP_CAM wrote:if you possibly explain, wich Products you import from wich seller, possibly, someone around here would be able, to share such knowledge, and some extensions also exist already for such tasks, but without any facts and/or Links, I fear, that no-one else would be able to.

I never played around with such Extensions, I only know, that genious MaxD, the (formerly) well known OpenShop contributor around here, created such Extensions, especially for the russian/ukrainian Scene. You may contact him, by PM, to find out more:
http://www.opencart.com/index.php?route ... rname=MaxD

Good Luck !
Ernie
Sorry, but Lithuania it is not russia or ukraine... if you not know Lithuania are the part of Europe union like Germany France Poland Czech and so on..
So his experience in russia seems are not suitable for me :)
Anyway of course thank you for the suggestion.

Kestas

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by IP_CAM » Mon May 09, 2016 6:22 am

that's not the case, I just mentioned, that he is more OC- engaged, usually, in those regions, as it looks, from the traces he leave's...., but it would make absolutely no difference, when it comes to his Coder knowledge. This Place here does NOT CARE about political ressentiments, or similar things, related to/with history, we are just Humans, trying to commonly achieve something, nothing else.
Sorry, if you possibly understud me wrong...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kestas » Tue May 10, 2016 9:21 pm

Sory I mean our region is not russian region and our language and low are very different than russian... So I mean not political situation...
Anyway problem are solved. And like @IP_CAM suggest I got help from @MaxD...
Problem was in xml importing module (multistore problem). So seller of this module make some changes and now all working fine.

Thanks a lot.

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by IP_CAM » Wed May 11, 2016 8:09 am

Good for you! I only mentioned MaxD's Name, because he is the only one, I knew, who would be able to handle such !
Good Luck ;)
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 8 guests