Importing customer data into opencart

Hi am looking to import customer account data from my old e-commerce website into Opencart.
Does the 'Zone id' need to be populated or will this update once the customer logs in or checks out.

Regards Ian

Check the images to see, what 'Zone ID' actually means, within the Setup of OC v.1.5.6.x,at least
Since we have no longer NAMED Zones (Cantons), postal-technically, in Switzerland, but only use PLZ-Numbers, it does not matter, in wich Canton someone lives. At least not in Belongings like Registration, or transporting Merchandise.
Therefore, CANTONS are not longer of any Value, and are not required anywhere, but, possibly, in registration/User-Section related Forms, if one does not use FIXED Values and hides the corresponding Zone/State-Registration-Fields.

But be aware, it could have some Consequences, as well, trying to make life easier, IF something DEPENDS on Zones, whatever it may be, Specials, Discounts, Shipping, Anything, it would, eventually, not longer function, the way, as planned, if one just starts to screw around in internal OC-Matters...

I would set ALL 'Swiss Customers only SHOPS' therefore to ONE SINGLE Zone Value. All corresponding Registration Field Sections would not longer be visible to Users, and 'prefilled', hidden, with a FIXED Form Post Value.
So much to my tests on that.
--
You could possibly do the same, just use an OC-VALID Zone ID VALUE, complying to ONE, or THE (OC-pre-given!) Customer Country Number, to get the stuff, basically functional, onto the DB. In my case, I use the one only Swiss Canton AARGAU Zone VALUE 3095, and hide the whole ZONE-Stuff from Customer View.

But possibly, you would have to redoo them, individually, after upload, depending on where your Customers reside.
IT WOULD NOT function properly, afterwards, if you JUST add an random Value, in certain Routines and Tasks, just be aware of that! And it will NOT upgrade automatically, it has to be done manually, by or for each Customer, outside of the PRESET Zone.

I hope, you get the idea!
Ernie
bigmax.ch/os/

---

in:
os\install\opencart.sql
or:
os\install\openshop.sql
you'll find all Zones, and their OC-Values: actually, a plain Waste of of DB-Efficiency, if one only serves a Country...

Hi There

Thanks for your reply. Ill have a look

Thanks again
Ian