If this is your first visit, check our documentation. To post, register or login.
Forums / Built-in Shipping and Payment Modules / Shipping and Billing DO match but Admin says they don't

Shipping and Billing DO match but Admin says they don't

Locked

Started by countryneedle on 6 Feb 2009, 7:53 PM · Views: 2,434

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
6 Feb 2009, 7:53 PM
#1
countryneedle avatar

countryneedle

Inactive

Join Date:
Oct 2006
Posts:
24
Plugin Contributions:
0

Shipping and Billing DO match but Admin says they don't

Since 1/28/09, When customers place orders, I have been getting the "red dot" stating that their billing and shipping addresses do not match. When I go to review their orders, everything seems to be as it should and the billing and shipping addresses DO match. Payments from the customers were made through the PayPal IPN - Website Payments Standard and I am using the latest ZenCart release.

I have made no changes and all of my products (all digital media) are set up the same way. Why all of a sudden am I getting this error?

I have searched the forums and have found nothing that addresses this particular situation. Any assistance would be greatly appreciated.

Nathenia
The Country Needle
http://www.countryneedle.net

7 Feb 2009, 3:49 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Billing DO match but Admin says they don't

The comparison is made on the customer address, shipping address and payment address for any differences ...

NOTE: little things like
Road vs RD
Street vs ST

will be flagged ...

This flag does not mean something is definitely wrong, it is just a heads up to review the information ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Feb 2009, 6:14 PM
#3
countryneedle avatar

countryneedle

Inactive

Join Date:
Oct 2006
Posts:
24
Plugin Contributions:
0

Re: Shipping and Billing DO match but Admin says they don't

Ajeh:

The comparison is made on the customer address, shipping address and payment address for any differences ...

NOTE: little things like
Road vs RD
Street vs ST

will be flagged ...

When comparing all of these, they are all the same, even when checking their address on PayPal. There are no differences.

Nathenia
The Country Needle
http://www.countryneedle.net

10 Feb 2009, 3:08 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Billing DO match but Admin says they don't

And the red dot is appearing next to the Order and not just in the legend correct?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

10 Feb 2009, 10:36 PM
#5
countryneedle avatar

countryneedle

Inactive

Join Date:
Oct 2006
Posts:
24
Plugin Contributions:
0

Re: Shipping and Billing DO match but Admin says they don't

Yes, that is correct.

Nathenia
The Country Needle
http://www.countryneedle.net

10 Feb 2009, 11:39 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Billing DO match but Admin says they don't

And if you look in the actual orders table are all 3 sets of data identical?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

10 Feb 2009, 11:42 PM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Billing DO match but Admin says they don't

This is the specific code testing the fields if it helps:

      $show_difference = '';
      if (($orders->fields['delivery_name'] != $orders->fields['billing_name'] and $orders->fields['delivery_name'] != '')) {
        $show_difference = zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', TEXT_BILLING_SHIPPING_MISMATCH, 10, 10) . ' ';
      }
      if (($orders->fields['delivery_street_address'] != $orders->fields['billing_street_address'] and $orders->fields['delivery_street_address'] != '')) {
        $show_difference = zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', TEXT_BILLING_SHIPPING_MISMATCH, 10, 10) . ' ';
      }

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

11 Feb 2009, 12:37 AM
#8
countryneedle avatar

countryneedle

Inactive

Join Date:
Oct 2006
Posts:
24
Plugin Contributions:
0

Re: Shipping and Billing DO match but Admin says they don't

Hi Ajeh,
I just checked the code and what I have is exactly the same code as above. Is there any other place I can check? Do you think this could be a PayPal issue or would it help if I re-installed the PayPal payment module?

Nathenia
The Country Needle
http://www.countryneedle.net

11 Feb 2009, 3:53 AM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Billing DO match but Admin says they don't

I was referring more to checking the specific fields in the orders table for identical matches ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

11 Feb 2009, 4:54 AM
#10
countryneedle avatar

countryneedle

Inactive

Join Date:
Oct 2006
Posts:
24
Plugin Contributions:
0

Re: Shipping and Billing DO match but Admin says they don't

Where do I find the orders table?

Nathenia
The Country Needle
http://www.countryneedle.net

11 Feb 2009, 4:58 AM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Billing DO match but Admin says they don't

In your database ... you can view it in phpMyAdmin from your Control Panel ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Feb 2009, 5:45 PM
#12
countryneedle avatar

countryneedle

Inactive

Join Date:
Oct 2006
Posts:
24
Plugin Contributions:
0

Re: Shipping and Billing DO match but Admin says they don't

Ajeh:

This is the specific code testing the fields if it helps:

  $show_difference = '';
  if (($orders->fields['delivery_name'] != $orders->fields['billing_name'] and $orders->fields['delivery_name'] != '')) {
    $show_difference = zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', TEXT_BILLING_SHIPPING_MISMATCH, 10, 10) . ' ';
  }
  if (($orders->fields['delivery_street_address'] != $orders->fields['billing_street_address'] and $orders->fields['delivery_street_address'] != '')) {
    $show_difference = zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', TEXT_BILLING_SHIPPING_MISMATCH, 10, 10) . ' ';
  }

Sorry it's taken a couple of days to reply. It's been quite hectic around here.
 I was finally able to check the orders table and all addresses match up. The code above is also correct in my files. I have also re-installed the PayPal mod and I am still having the same issues.  

I did not mention this before because I thought one thing had nothing to do with the other, but on 1/28  my site went down due to a sessions error and my host did something to "fix" it because it could not be repaired through cpanel.

Here's the error code I received:
126 Incorrect key file for table './needles_zenrebuild/zen_sessions.MYI'; try to repair it in: [delete from zen_sessions where expiry < 1233211769] 

Do you think the two issues are related?

Nathenia
The Country Needle
http://www.countryneedle.net