Kryptronic Software Support Forum

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.

#1 08-24-2012 00:23:27

polarize
Member
Registered: 11-15-2004
Posts: 293

Default all accounts to Residential Shipping

Which tables would I change to default all accounts and shipping estimator to residential and hide the field from the storefront?  In version 7 there were several places to do this or does version 8 have an option to default and hide all?

Thanks!


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#2 08-24-2012 07:25:32

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Default all accounts to Residential Shipping

Execute this SQL statement in Raw DB Admin:

UPDATE core_formfields SET type='HIDDEN-REG', defaultvalue='R' WHERE id='ecom.shipestimator.rescom'


Nick Hendler

Offline

 

#3 08-25-2012 03:00:34

polarize
Member
Registered: 11-15-2004
Posts: 293

Re: Default all accounts to Residential Shipping

This doesn't appear to be hiding the field when setting up a new delivery address, etc.


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#4 08-25-2012 05:53:32

polarize
Member
Registered: 11-15-2004
Posts: 293

Re: Default all accounts to Residential Shipping

I found my earlier post about this for CCP7 but wonder if there are any changes with exception to the xmodQuickBuy which doesn't exist.  The rest of the tables are still the same however. Please advise.

Thanks! smile


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#5 08-26-2012 13:06:30

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Default all accounts to Residential Shipping

You only asked about the shipping estimator.  The other fields are exactly the same as in v7, so make all the same changes less the quickbuy change.


Nick Hendler

Offline

 

#6 08-27-2012 12:43:42

polarize
Member
Registered: 11-15-2004
Posts: 293

Re: Default all accounts to Residential Shipping

Thanks for your reply Nick.  I did say in the first post..."Which tables would I change to default all accounts and shipping estimator to residential and hide the field from the storefront?  In version 7 there were several places to do this or does version 8 have an option to default and hide all?"

No worries Nick. I know you've had your plate full lately so I understand.  Thanks for helping me out. smile


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#7 08-27-2012 14:05:56

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Default all accounts to Residential Shipping

smile No prob.


Nick Hendler

Offline

 

#8 08-29-2012 04:30:46

bbac
Member
From: Bristol, UK
Registered: 08-25-2008
Posts: 141

Re: Default all accounts to Residential Shipping

Code:

UPDATE core_formfields SET type='HIDDEN-REG', defaultvalue='R' WHERE id LIKE '%rescom'

did it for me

Offline

 

Board footer