State Codes |
Post Reply | Page 12> |
Author | |
Justplaying
Newbie Joined: 16-August-2007 Location: United Kingdom Status: Offline Points: 0 |
Post Options
Thanks(0)
Posted: 20-May-2008 at 9:06am |
On the default ProductCart, when a customer enters his/her details on the login form only the first 4 characters of the State are saved
We are based in the UK although we dont have states we do have counties e.g. North Yorkshire Northhampton Northumberland Therefore when we come to print out the Invoice we only get 'Nort' ~ the first 4 characters I have setup the state codes/statename/country to show the full information Northumberland Northumberland UK I have altered the dbo.states table in our sql database to allow 40 characters for the StateCode nvarchar(40) I have also modified dbo.orders and dbo.customers to allow the StateCode 40 characters and the shipping state code 40 characters But when a customers processes an order the first 4 characters of the state code are only saved I am obviously missing something but what? Please can anyone help Thanks Neil |
|
Hamish
Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
|
Hi Neil,
We are UK based as well, but chose to NOT use the state codes as the UK doesn't really use that concept, just county names, which is different. We are operating without any problems. I suspect your heading into potentially risky waters here. UK users - Do any of you have direct experience of implementing this ? Anyway, what I found : From the PC V3.11 manual :- "When there are no states or provinces associated with a country, the State/Province field becomes an input field, and is not required. Since an input field can lead to user errors, whenever possible we recommend that you enter the states/provinces associated with your default country (and the countries your customers most commonly purchase from)." Despite the last "whenever" sentence.... Looking for "statecode" in the asp source files reveals huge numbers of references (151 files with the string statecode). I'm sure many/most of the files would not need amending, but it would be best to check them all. Many of the payment gateway files appears in the list, which I would be very cautious about amending without reference to the interface documentation for the specific payment gateway that you use, and stringent testing after any changes. - For example, even what I assume is a UK specific piece of code (pcPay_ExpressPayUK_Start.asp) contains:- if len(pcv_StateCode)>4 then pcv_StateCode="" '// Show Province Field, This is not a valid ISO Code end if Similar restrictions seem to apply to Google checkout. This was a VERY QUICK look - It may well be that other UK users have implemented "state codes" for counties already. HTH Hamish |
|
Justplaying
Newbie Joined: 16-August-2007 Location: United Kingdom Status: Offline Points: 0 |
Post Options
Thanks(0)
|
Hi Hamish Thanks for getting back to me but you lost me in your first paragraph
We are UK based as well, but chose to NOT use the state codes as the UK doesn't really use that concept, just county names, which is different.
I realise we have counties in this country but they are a similar concept
County - A territorial division exercising administrative, judicial, and political functions in Great Britain and Ireland.
State - the territory, or one of the territories, of a government.
I guess the only reason ProductCart uses States/Provenices is because it isnt produced in the UK But more to the point how have you applied your county names like yorkshire or greater manchester if you havent used the MANAGE STATES PAGE in ProductCart Admin
And if you have used the manage states page, each entry requires a code which in turn is then printed on the invoice and delivery note
I realise I could delete all the counties we have applied to the UK, this would allow the customer to input it themselves
But I also realise this could cause typo mistakes
|
|
Hamish
Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
|
Hi,
Yes, Typo's are always a risk - but no more than the rest of the address & the key to delivery in the UK is the post code & house number/name. Lack of "state codes" has never caused us the slightest problem. We have not added any UK counties on the "manage states" page. The client's just type it in when they register, just like the rest of their address. The address comes out OK on invoice & delivery notes, although we do make minor changes to get the UK style layout, but strictly speaking that's not necessary. I took a look at another UK based PC website - www.wovenwheatwhispers.co.uk and they also do not use the "state codes" either. It would be great if someone who HAS either implemented or attempted to implement this in the UK joined the discussion, so there was a definitive answer on this. |
|
Hamish
Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
|
The main reason for the state code to be in a defined list is that, as far as I know, the state code is the first part of the ZIP code - Like we use GU for Guildford in our post codes, so it's crucial that it is correct, which is not the case for our county/area names, which are independent of the post codes.
|
|
Matt
Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73 |
Post Options
Thanks(0)
|
When you create a state via “Manage States” you must enter a Full Name (which is displayed to the customer in a drop menu) and a 2-4 character ISO Code (which is saved to the database). The ISO state code should be 4 digits or less. Some services, such as PayPal, require a valid ISO code in reference to an address. In such cases, the full name of a region is not acceptable (as it could be misspelled). If using ISO Codes does not fit your needs then you should not add custom states for your country. If there are no custom states ProductCart will display a text field for the customer to type the name of their region. They can type more than 4 characters in a text field. If you believe your install is not working as I have explained please let us know. |
|
Hamish
Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
|
Hi Matt,
That pretty much confirms my thoughts then. I think the "State Codes" is a bust for UK format addresses. Thanks for the input. Have there been any thoughts on having country specific sections on the forum? There are several UK users present that I'm aware of & this type of question would fit better in a country specific section as well as encoraging, say, UK members to subscribe & keep in touch over issues specific to their country - such as: - Postal & Shipping issues. - VAT - Payment Gateways (some). Hamish |
|
Justplaying
Newbie Joined: 16-August-2007 Location: United Kingdom Status: Offline Points: 0 |
Post Options
Thanks(0)
|
No our install is working fine, In fact we used Cartweaver for 2 years prior to switching to ProductCart last Summer and our sales have more than trebled I was just trying to find a way of using the full county names which have been setup in Admin other than customer input Also for UK use is it possible to edit the State/Province title on the login form Billing address First Name: Last Name: Company: Country: Address: City: State/Province: > County Postal Code: Phone: Fax: I have tried but cant figure out how to change the title to Counties but cant figure out where the page pulls the headings from Actually is it possible? Thanks Neil |
|
Matt
Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73 |
Post Options
Thanks(0)
|
Can you enter the ISO Code " |
|
Matt
Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73 |
Post Options
Thanks(0)
|
look for "CustAddModShip_19" and "CustAddModShip_6" and "CustAddModShip_5" inside "includes/languages.asp" to change the text.
|
|
Post Reply | Page 12> |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |