Importing a customer list in ZenCart

[TheOracle]

This looks pretty much like the objective you were talking about from this topic:

http://www.zen-cart.com/forum/showpo...67&postcount=9

However, I'd like to inform you that I have just finished to design my concept plan for something much more similar. Your request will also be included in this modulation.

[pierrick]

This looks pretty much like the objective you were talking about from this topic:

http://www.zen-cart.com/forum/showpo...67&postcount=9

However, I'd like to inform you that I have just finished to design my concept plan for something much more similar. Your request will also be included in this modulation.

Hi,

Yes, you're absolutely right. I was presented with the challenge by my client. Since I couldn't find a contrib that could do it, I got my brains into gear and this is what I came up with.
I was reluctant to put this thread in the 'Contributions' as it isn't one per say. I mean it's not like it presents as a nice formatted page, integrating itself into the admin module, or whatever.
I thought that if someone out there was faced with a similar challenge, at least there'd be some sort of a quick guide.

There's a lot of very helpful people in this forum. I obtained valuable information, which has saved me hours of work and got me a great insight into ZenCart and its inner workings. If this thread helps someone, all the better!

Great to know you'll be designing something along that line, and I am glad you'll be taking my request into consideration.

Cheers.
Pierrick

[TheOracle]

For now, your instructions could be applied, by wizard basis, when using mySQL-Front software. You can systematically compare each physical SQL fields between two different tables and import your readings into each appropriate fields you might select between the source table and the destination table.

In addition, if I remember correctly, I believe this can also be done from two different databases without the need to export and re-import your table (which I believe the EasyPopulate MOD does unfortunitely but I could be wrong).

[pierrick]

For now, your instructions could be applied, by wizard basis, when using mySQL-Front software.

Any wizard-based system would be welcome I guess since my method demands a fair bit of basic database knowledge (structures, relationships, etc) as well as a good working knowledge of phpMyAdmin.

You can systematically compare each physical SQL fields between two different tables and import your readings into each appropriate fields you might select between the source table and the destination table.

One must be careful when doing this in ensuring the integrity of the relationships between the three tables. The method you mention would assume that at the very least all unique ID’s have already been created and checked for integrity.

In addition, if I remember correctly, I believe this can also be done from two different databases without the need to export and re-import your table (which I believe the EasyPopulate MOD does unfortunitely but I could be wrong).

Not sure what you mean here.
Also I believe EasyPopulate is a chargeable add-on. I'm thinking of a free contrib here.

Cheers
Pierrick

[Brent]

Also I believe EasyPopulate is a chargeable add-on. I'm thinking of a free contrib here.

There are two versions. EP and EP Advanced. The standard version is free.

[pierrick]

There are two versions. EP and EP Advanced. The standard version is free.

True, but according to Lange's own description of EP Standard, it "updates/adds products from a tab delimited file", there no mention of customers.
For that matter, it looks like the Advanced version doesn't deal with the customers' side of things either.
EP doesn't seem to be the way to go if one wants to import a customer list. However EP could present an elegant methodology for importing external data into ZenCart.

Cheers
Pierrick