You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
My business is purely UK only. I wan't to hide unnecessary fields in the checkout such as State, Residential and possibly the Country option, or at the very least not have them set as required options.
I've found various threads on this subject which proved to be a nightmare in CCP6, has this been sorted out in CCP7? How would I go about changing these fields.
Thanks
Lee
Offline
Failing that, how does a UK customer enter their county as the state field only shows American states even when UK is selected as the country?
Offline
This thing really isn't UK ready at all is it?
Offline
Yes, it is, very much so. The problem you are having will be addressed in the upcoming update to V7.
Offline
So are you saying that this product is for sale, ready for UK use but UK customers can't actually enter their address until there's an update or am I missing something here?
Offline
A straight Forward fix(temporary or otherwise). I have tested this extensively and I can't see any problems.
Step 1: locate and open up the /apps/ecom/ECOM_Checkout file so it can be edited. Around line 1191 you will have this line of code
if (empty($address['stateprov'])) {$reqok = 0;}
Comment it out
//if (empty($address['stateprov'])) {$reqok = 0;}
Step 2: Go to Raw Database admin and browse the core_formfields table.
Go through each of the 6 pages and open anything that has stateprov in the id such as core.createaccount.stateprov - there are 4 columns that need altering in total.
On each stateprov entry change the required column to 0 and the TYPE column to HIDDEN-REG.
Now the State/Prov option will not be seen by customers.
I have done the same for the RES/COM option as well, you just need to comment the line in ECOM_Checkout file line 1202 and change the columns in core_formfields relating to RESCOM.
//if (empty($address['rescom'])) {$this->CORE_Session->sessvalues('rescom','R'); $address['rescom'] = 'R'; }
The country field should be straightforward to do as well.
Remember the ECOM_Checkout field will be overwritten in an update so initial the changes so you can easily find them again after updating.
Offline
Zanart thanks very much for your help, if I can make this part work then at least I can use the cart.
As for Kryptronic, I'm quite disgusted with the response from them, no wonder there is no demo and no refunds given, I could have saved myself a lot of time and stuck with Viart had I known all this, no doubt I'll carry on finding more problems that are going to be solved in an update.
Offline
Lee, a complete and full demo of both the store and the admin area are available and one only needs to contact sales to request a trial version.
Offline
Dave, do you work for Kryptronic?
Offline
Dave points to his signature line, title here in the fora and avatar Yes comes to mind.
Offline
Beware.
If you are calculating price excluding VAT the mod I posted is messing up the VAT as the tax system is expecting a value for the stateprov field but with it disabled it isn't getting one and therefore charges no VAT.
Offline
Zanart, thanks again for the info, I'd have no hope without someone like you volunteering this information.
Dave, so I ask again, am I missing something here? According to Kryptronic, what are Uk users expected to do while waiting for this update?
Offline
To have the UK counties displayed in the selection lists throughout CCP issue the following raw DB commands :
UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usecon=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.createaccount.stateprov' LIMIT 1 ;
UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usecon=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.accountmaint.stateprov' LIMIT 1 ;
UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usedel=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.addbookins.stateprov' LIMIT 1 ;
UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usedel=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.addbookupd.stateprov' LIMIT 1 ;
UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usecon=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'ecom.guestco.stateprov' LIMIT 1 ;
Offline
Thank You
Offline
Hi Dave
I have just submitted the statements as suggested.
When I go to Orders(Completed & Processing) in the backed I now get this error:
Script Execution Error There was a processing problem encountered while processing your request. Please try again later. File: /ccp_private/core/CORE/CORE.php Line: 510 Error Number: 256
I didn't receive this error moments before submitting the statements - could it be related??
Thanks
Rob
Offline
Extremely doubtful Rob. That line in core is the error handling routine when there is a problem executing the CORE_App class.
Offline
Dave
Since submitting those statements I get the same error front end when clicking the Guest checkout button after proceeding past the shopping cart.....
But only if I change the ISEU column in the stateprov table to 0. I have to change all the UK counties ISEU column to 0 to replicate the error, it doesn't happen if I change just one county to YES via the locations>states/provinces in the control panel.
By changing the entire ISEU column to 1 it stops the error in the backend and the frontend.
Rob
Last edited by zanart (09-16-2009 13:22:45)
Offline
Ok Dave
Total ISEU column set to 1 - I get the error BACKEND when clicking UPDATE on any order, but the front end works fine.
Total ISEU column set to 0 - I get the error when proceeding from the shopping cart and pressing guest checkout, but the backend works fine and when I click the UPDATE button on any order I don't get the error!
Rob
Offline
and this is from the debug for the error page:
CORE_Form::check_field_def: An invalid request to validate a form field was received. The form field 'ecom_orders.stateprov', a 'SELECT-TABLE' type field requires an array of values. An array of values was not specified. CORE_Error::error: Fatal error encountered: There was a processing problem encountered while processing your request. Please try again later.
Offline
Hi Dave
Are you trying to find a resolution to this? or do have have SQL statements that will reverse the effects of those in post 13
Rob
Offline
bump
Offline
Run the same commands shown in post 13 but change iseu=''1''' to iseu=''0'''
That was the only thing that changed and making the change should not have caused the issues you are/were having.
Offline
If I change the ISEU field to 0 I get the same error frontend when clicking the guest checkout button.
Offline
Dave
To overcome the script execution error in both front and backend I have had to do the following:
1: Reverse the effects of your SQL statements by doing as you suggested and changing the ISEU to '0'
2: Change the ISEU value in all displayed states/provinces to 0.
Obviously this isn't how the software should be set up for UK websites.
Offline
I use Eurocart. I applied the SQL commands suggested by Dave above, and ended up with a Script Execution Error .
I reversed the commands and the script error went away.
But I still see only U.S. States in the dropdown list, not UK counties. All States are marked as ISEU=0, all Counties are marked as ISEU=1.
However, if I set an English county as usecon=1 and usedel=1, and ISEU=0, that County shows in the list.
Surely that's not right? Looks back-to-front to me.
Do I really have to trawl through dozens of UK Counties and make the changes manually, just to make this "UK" cart work in the UK?
Regards
Paul
Last edited by NicheDev (04-03-2010 15:04:57)
Offline