I am not sure, but I may have discovered a bug in the current version when it comes to Australian setups.
In my other shop setting on CE 4.6.4_49061, when a customer selects the country to be Australia, a new box or drop down menu appears asking the user to select a State. This is NOT present in CE4.9.7 for some reason.
Its either this or I have inadvertently turned it off or deleted it.
So, what can I do to restore this functionality as it is pretty important.
Don,
just looked it up in the Database: for Australia, there are no states defined yet. Unfortunately, it cannot be done via admin panel but adding new entries into oxstates (name of the table) via phpMyAdmin should be as easy as a charm. Please note: the country ID you need is 8f241f11095410f38.37165361.
Would be glad if you could provide your table of Australian states here so we can add it to the standard delivery of the database.
Cheers!
Hey Marco,
Looking at phpMyAdmin has opened up a new dimension for me just now and another “How to Navigate” chapter.
I found:
Full texts OXID OXCOUNTRYID Ascending OXTITLE OXISOALPHA2
Edit Edit Copy Copy Delete Delete ACT 8f241f11095410f38.37165361 Australian Capital Territory ACT
Edit Edit Copy Copy Delete Delete VIC 8f241f11095410f38.37165361 Victoria VIC
Edit Edit Copy Copy Delete Delete WA 8f241f11095410f38.37165361 Western Australia WA
Edit Edit Copy Copy Delete Delete NT 8f241f11095410f38.37165361 Northern Territory NT
Edit Edit Copy Copy Delete Delete SA 8f241f11095410f38.37165361 South Australia SA
Edit Edit Copy Copy Delete Delete TAS 8f241f11095410f38.37165361 Tasmania TAS
Edit Edit Copy Copy Delete Delete NSW 8f241f11095410f38.37165361 New South Wales NSW
Edit Edit Copy Copy Delete Delete QLD 8f241f11095410f38.37165361 Queensland QLD
Now that I found them, I don’t know what to do next. I coloured the correct name (OxTitle) and correct abbreviation (Oxisoalpha2) however perhaps using the OXID reference is more correct?
As you “found” it, it should appear, shouldn’t it?
Can you please take a look into oxstates and oxstates_de table if you find these entries there, too?
Cheers
I found the information in an earlier version of CE - CE 4.6.4_49061.
I couldn’t do the same trick in the newer version of CE.
Is a transplant possible?
I was hoping to hear back from someone regarding the implementation of a dropdown menu for the states of Australia - how to implement it, sort of step by step if possible.
Hey Don,
sorry - was busy with other stuff meanwhile.
INSERT INTO `oxstates` (`OXID`, `OXCOUNTRYID`, `OXTITLE`, `OXISOALPHA2`, `OXTITLE_1`, `OXTITLE_2`, `OXTITLE_3`) VALUES
('ACT', '8f241f11095410f38.37165361', 'Australian Capital Territory', 'ACT', 'Australian Capital Territory', '', ''),
('VIC', '8f241f11095410f38.37165361', 'Victoria', 'VIC', 'Victoria', '', ''),
('WA', '8f241f11095410f38.37165361', 'Western Australia', 'WA', 'Western Australia', '', ''),
('NT', '8f241f11095410f38.37165361', 'Northern Territory', 'NT', 'Northern Territory', '', ''),
('SA', '8f241f11095410f38.37165361', 'South Australia', 'SA', 'South Australia', '', ''),
('TAS', '8f241f11095410f38.37165361', 'Tasmania', 'TAS', 'Tasmania', '', ''),
('NSW', '8f241f11095410f38.37165361', 'New South Wales', 'NSW', 'New South Wales', '', ''),
('QLD', '8f241f11095410f38.37165361', 'Queensland', 'QLD', 'Queensland', '', '');
Good luck!
Oh - and thanks BTW. Will request to put that into the standard delivery 
Hey Marco,
I inserted the code line by line, entry by entry as I could not see a way to copy and paste the entire code that you laid out all at once.
I did encounter an issue when it came to WA or Western Australia - it appears that there is another WA in the database belonging to the Yanks. I deleted Washington and I was then able to add WA, Western Australia but until then I kept getting duplication errors.
This was the only work around I found.
Many thanks for your help to establish the database.
Cheers
Don
[QUOTE=NHWS;179381]
I did encounter an issue when it came to WA or Western Australia - it appears that there is another WA in the database belonging to the Yanks. I deleted Washington and I was then able to add WA, Western Australia but until then I kept getting duplication errors. [/QUOTE]
Exactly. This is because of a bug:
https://bugs.oxid-esales.com/view.php?id=5029
That’s why my commit had to be reverted 
Wow Marco,
I actually performed a workaround and it WAS an actually bug!! I think I am getting more familiar with this stuff all the time.