Forums / Managing Customers and Orders / 2 shipping address limit, but add more via SQL?

2 shipping address limit, but add more via SQL?

Views: 756

Results 1 to 4 of 4
29 Oct 2013, 7:35 PM
#1
d0ugparker avatar

d0ugparker

Zen Follower

Join Date:
May 2008
Location:
Near the water, somewhere...
Posts:
129
Plugin Contributions:
0

2 shipping address limit, but add more via SQL?

I've limited my shipping address count to 2 in the store
configuration and I want to leave it that way -- it works --
except for one client for whom I want to manually add
about a dozen more shipping addresses for their convenience.
I could bump the 2 limit up to 14, but I'd rather not require
the extra storage space necessary for everyone else (which
may or may not get used, I know, I know) to go beyond
the limit of 2 for everyone else which has worked fine for
five years now.

  1. Can add those additional shipping addresses, via SQL
    and phpmyadmin, and
  2. If I do do that, will all 14 or so display to that one client,
    or will only two be displayed?

Regards,

Doug

29 Oct 2013, 8:12 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: 2 shipping address limit, but add more via SQL?

No. The address book entry limit is site-wide (in the Configuration table) and is not assigned to individual customers.

29 Oct 2013, 9:09 PM
#4
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: 2 shipping address limit, but add more via SQL?

A quick test suggests that will work. I set the maximum to 4, logged in and added 3 addresses, logged out, set the maximum to 2, logged back in and I still had the 4 addresses to choose from. Logging in as another customer, I only was able to have 2.