Integration OC with and existing User table

Hey,
I having been searching but havent been able to find anything helpful on the above caption.

I am wondering if it is possible to have OC use my existing website's database of user accounts. I know its possible to create a process that will synchronise the 2 separate tables but i am wondering if there is an extension or something similar that will allow both my website and OC to use the same userbase and also allow a single signon process.
Thx for the help.

Welcome to the Opencart forum. Followed are many examples for synchronizing tables. In those examples, it export the fields and values of each required database tables in CSV files: http://www.opencart.com/index.php?route ... rch=export

If none of these modules can match your requirements, you can always post your inquiry as a custom paid job in the Commercial Support section of the forum.

are you truly trying to synchronize, as in keep both databases existing and ensure they match or are you trying to import to OC? Syncing could be extremely difficult, is there a reason you need both?

For importing, the above post helps alot, if it's not from one of those sources it all depends on the original database format. You could import it if you format it properly, but users might not be able to login depending on how the password is hashed and/or salted.

reed17 wrote:are you truly trying to synchronize, as in keep both databases existing and ensure they match or are you trying to import to OC? Syncing could be extremely difficult, is there a reason you need both?

For importing, the above post helps alot, if it's not from one of those sources it all depends on the original database format. You could import it if you format it properly, but users might not be able to login depending on how the password is hashed and/or salted.

Synchronization is not an issue with Opencart. the mPDO extension is already implemented as part of the core as it can be very easily dependant between databases of the same domain. Although, it is not recommended to set databases across different domains.

On my signature, you can see several examples based on the easiness of implementing an export tool via Opencart.

straightlight wrote:

reed17 wrote:are you truly trying to synchronize, as in keep both databases existing and ensure they match or are you trying to import to OC? Syncing could be extremely difficult, is there a reason you need both?

For importing, the above post helps alot, if it's not from one of those sources it all depends on the original database format. You could import it if you format it properly, but users might not be able to login depending on how the password is hashed and/or salted.

Synchronization is not an issue with Opencart. the mPDO extension is already implemented as part of the core as it can be very easily dependant between databases of the same domain. Although, it is not recommended to set databases across different domains.

On my signature, you can see several examples based on the easiness of implementing an export tool via Opencart.

from the way he describes it it sounds like he has a website that doesn't use a common system. Like a custom coded website with just a user and password for access. No other core system or framework. From this stand point, i still support my post.

I understand you have a bunch of import tools, but again, from his description it doesn't sound like he's using an actual system/framework/core. So if he were to synchronize, again assuming it's a simple user and password table, then there would be a lot of missing information within the oc_customer table.

Could be me mis-interpreting it, but we won't know until he posts again.