Kryptronic Software Support Forum

Lee N · 09-10-2009 06:22:54

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

Lee N · 09-10-2009 11:47:41

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?

Lee N · 09-11-2009 05:33:21

This thing really isn't UK ready at all is it?

Dave · 09-11-2009 06:13:54

Yes, it is, very much so. The problem you are having will be addressed in the upcoming update to V7.

Lee N · 09-11-2009 22:04:00

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?

zanart · 09-12-2009 03:11:50

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

Code:

if (empty($address['stateprov']))  {$reqok = 0;}

Comment it out

Code:

//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.

Code:

//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.

Lee N · 09-12-2009 20:15:23

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.

Dave · 09-13-2009 05:52:16

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.

redwood · 09-13-2009 09:33:40

Dave, do you work for Kryptronic?

Dave · 09-13-2009 11:22:24

Dave points to his signature line, title here in the fora and avatar Yes comes to mind.

zanart · 09-13-2009 14:14:27

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.

Lee N · 09-13-2009 20:40:46

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?

Dave · 09-14-2009 08:31:15

To have the UK counties displayed in the selection lists throughout CCP issue the following raw DB commands :

Code:

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 ;

Code:

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 ;

Code:

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 ;

Code:

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 ;

Code:

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 ;

Lee N · 09-14-2009 12:33:29

Thank You

zanart · 09-16-2009 13:01:53

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:

Code:

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

Dave · 09-16-2009 13:06:52

Extremely doubtful Rob. That line in core is the error handling routine when there is a problem executing the CORE_App class.

zanart · 09-16-2009 13:21:52

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)

zanart · 09-16-2009 13:50:21

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

zanart · 09-16-2009 14:01:53

and this is from the debug for the error page:

Code:

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.

zanart · 09-17-2009 07:27:45

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

zanart · 09-18-2009 10:08:20

bump

Dave · 09-18-2009 10:16:57

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.

zanart · 09-18-2009 10:30:35

If I change the ISEU field to 0 I get the same error frontend when clicking the guest checkout button.

zanart · 09-19-2009 02:30:02

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.

NicheDev · 04-02-2010 17:27:00

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)

Kryptronic Software Support Forum

#1 09-10-2009 06:22:54

Remove or hide checkout fields for CCP7

#2 09-10-2009 11:47:41

Re: Remove or hide checkout fields for CCP7

#3 09-11-2009 05:33:21

Re: Remove or hide checkout fields for CCP7

#4 09-11-2009 06:13:54

Re: Remove or hide checkout fields for CCP7

#5 09-11-2009 22:04:00

Re: Remove or hide checkout fields for CCP7

#6 09-12-2009 03:11:50

Re: Remove or hide checkout fields for CCP7

Code:

Code:

Code:

#7 09-12-2009 20:15:23

Re: Remove or hide checkout fields for CCP7

#8 09-13-2009 05:52:16

Re: Remove or hide checkout fields for CCP7

#9 09-13-2009 09:33:40

Re: Remove or hide checkout fields for CCP7

#10 09-13-2009 11:22:24

Re: Remove or hide checkout fields for CCP7

#11 09-13-2009 14:14:27

Re: Remove or hide checkout fields for CCP7

#12 09-13-2009 20:40:46

Re: Remove or hide checkout fields for CCP7

#13 09-14-2009 08:31:15

Re: Remove or hide checkout fields for CCP7

Code:

Code:

Code:

Code:

Code:

#14 09-14-2009 12:33:29

Re: Remove or hide checkout fields for CCP7

#15 09-16-2009 13:01:53

Re: Remove or hide checkout fields for CCP7

Code:

#16 09-16-2009 13:06:52

Re: Remove or hide checkout fields for CCP7

#17 09-16-2009 13:21:52

Re: Remove or hide checkout fields for CCP7

#18 09-16-2009 13:50:21

Re: Remove or hide checkout fields for CCP7

#19 09-16-2009 14:01:53

Re: Remove or hide checkout fields for CCP7

Code:

#20 09-17-2009 07:27:45

Re: Remove or hide checkout fields for CCP7

#21 09-18-2009 10:08:20

Re: Remove or hide checkout fields for CCP7

#22 09-18-2009 10:16:57

Re: Remove or hide checkout fields for CCP7

#23 09-18-2009 10:30:35

Re: Remove or hide checkout fields for CCP7

#24 09-19-2009 02:30:02

Re: Remove or hide checkout fields for CCP7

#25 04-02-2010 17:27:00

Re: Remove or hide checkout fields for CCP7

Board footer