Address Formats...Where do they apply?

[absoluteblock]

I think I must be missing something obvious.

Under Locations/Taxes--->Countries, you can select whichever Address Format you want (1-6) or create a new one for each country. I understand this part fine.
But why are the invoices and packing slips unaffected by the specific address format you set?

I tried formats 1-7 (including one of my own) but the invoices look the same with each address format.

[paulm]

It only affects invoices and packing slips created after you change the setting. Not the existing ones.

(I remember banging my head against the wall over the same issue once ;-) )

[absoluteblock]

Thanks Paul, I appreciate it.

Would you or anyone else know how to specify the state abbreviations in the United States when creating a new address format?

For example, California displays as California, but our Postal Service wants us to use two-letter codes like CA instead.

INSERT INTO address_format 
(address_format, address_summary) 
VALUES ('$firstname $lastname$cr$streets$cr$city, $state $postcode',
'$city, $state $postcode');

$state is displaying full state names, not abbreviations.

[DrByte]

Is this only a concern for the invoices and packing slips printed from the Admin area ?

[absoluteblock]

Is this only a concern for the invoices and packing slips printed from the Admin area ?

Yes. I've noticed that in other places, the state's abbreviation is used. This isn't the case for invoices and packing slips.

[DrByte]

Try this:

/admin/includes/functions/general.php
insert this before line 491:

        $zone_query = "select zone_code
                       from " . TABLE_ZONES . " z 
                       left join " . TABLE_COUNTRIES . " c on c.countries_id = z.zone_country_id
                       where zone_name = '" . $address['state'] . "'";
        $zone = $db->Execute($zone_query);
        if ($zone->RecordCount() > 0 ) $state = $zone->fields['zone_code'];

Thus it'll look like this (starting from 479:

    if (isset($address['country_id']) && zen_not_null($address['country_id'])) {
      $country = zen_get_country_name($address['country_id']);

      if (isset($address['zone_id']) && zen_not_null($address['zone_id'])) {
        $state = zen_get_zone_code($address['country_id'], $address['zone_id'], $state);
      }
    } elseif (isset($address['country']) && zen_not_null($address['country'])) {
      if (is_array($address['country'])) {
        $country = zen_output_string_protected($address['country']['countries_name']);
      } else {
        $country = zen_output_string_protected($address['country']);
      }
        $zone_query = "select zone_code
                       from " . TABLE_ZONES . " z 
                       left join " . TABLE_COUNTRIES . " c on c.countries_id = z.zone_country_id
                       where zone_name = '" . $address['state'] . "'";
        $zone = $db->Execute($zone_query);
        if ($zone->RecordCount() > 0 ) $state = $zone->fields['zone_code'];
    } else {
      $country = '';
    }
    $postcode = zen_output_string_protected($address['postcode']);
    $zip = $postcode;

Do similarly to
/includes/functions/functions_customers.php
insert on line 67, making it look like this (quoted from 55 onward):

    if (isset($address['country_id']) && zen_not_null($address['country_id'])) {
      $country = zen_get_country_name($address['country_id']);

      if (isset($address['zone_id']) && zen_not_null($address['zone_id'])) {
        $state = zen_get_zone_code($address['country_id'], $address['zone_id'], $state);
      }
    } elseif (isset($address['country']) && zen_not_null($address['country'])) {
      if (is_array($address['country'])) {
        $country = zen_output_string_protected($address['country']['countries_name']);
      } else {
        $country = zen_output_string_protected($address['country']);
      }
      $zone_query = "select zone_code
                     from " . TABLE_ZONES . " z 
                     left join " . TABLE_COUNTRIES . " c on c.countries_id = z.zone_country_id
                     where zone_name = '" . $address['state'] . "'";
      $zone = $db->Execute($zone_query);
      if ($zone->RecordCount() > 0) $state = $zone->fields['zone_code'];
    } else {
      $country = '';
    }