Post by kdmp » Wed Sep 09, 2009 10:51 am

I did a live test of the shopping cart that I am working on. I put through a payment, which was successful. I come back to the site and it says that my order was successful...blah blah blah.

In the admin section, there are no orders listed. I check the orders with phpmyadmin - it is there.

First question. IPN should be on I would assume in PayPal. What URL notification do I need to put in there?

I have also noticed a weird error in the log:
2009-09-08 22:10:51 - PHP Notice: Undefined index: name in /home/user/public_html/catalog/model/checkout/order.php on line 68
2009-09-08 22:10:51 - PHP Notice: Undefined index: name in /home/user/public_html/catalog/model/checkout/order.php on line 112
These are related to OpenCart sending out confirmation emails - which were not received.

Why is the order status not updating after a successful order and why is the site not sending out an email?

OpenCart 1.3.2 - Linux/Apache - PHP 5.2.6

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by kdmp » Wed Sep 09, 2009 12:02 pm

I am not sure if this is normal or not...but I noticed that when I look into the payment modules there is a field titled Order Status. Is it normal to not have anything in that drop down?

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by kdmp » Wed Sep 09, 2009 12:30 pm

Hmm. I switched to COD as a payment option and completed an order. The order does send an email to the customer with a link to the invoice/order. However, when you click on it - it does not open. OpenCart says it can't find it. I check the admin section and there is no order present.
Thank your for interest in Store products. Your order has been received and will be processed once payment has been confirmed.

Order ID: 89
Date Ordered: 09/09/2009
Order Status:

Products:
1x Product $9.73

Totals:
Sub-Total: $9.73
Shipping (0.00kg): $13.90
GST 5%: $1.18
PST 8%: $1.89
Total: $26.69

To view your order click on the link below:
http://www.opencartstore.ca/index.php?r ... rder_id=89

Please reply to this email if you have any questions.
The order is present in the database and has the status of 0. Why is this not updating to status 1? You can see in the clipped email sent to the client there is no order status.

I also noticed this in my error log:
2009-09-09 0:13:42 - PHP Notice: Undefined index: name in /home/user/public_html/catalog/model/checkout/order.php on line 68
2009-09-09 0:13:42 - PHP Notice: Undefined index: name in /home/user/public_html/catalog/model/checkout/order.php on line 112
2009-09-09 0:35:40 - PHP Notice: Undefined index: name in /home/user/public_html/catalog/model/checkout/order.php on line 68
2009-09-09 0:35:40 - PHP Notice: Undefined index: name in /home/user/public_html/catalog/model/checkout/order.php on line 112
Last edited by kdmp on Wed Sep 09, 2009 1:00 pm, edited 1 time in total.

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by kdmp » Wed Sep 09, 2009 12:57 pm

I did figure out the missing order filter and yes the orders are listed there. However, it appears that is the only filter option. Isn't there supposed to be more than 'missing order's in the status drop down?

Also, I can not change the status of the order, again there is no status options in the drop down when I open a missing order.

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by kdmp » Wed Sep 09, 2009 9:16 pm

Also to note:

There is no order status and download order status in settings in the admin panel.

Edit- Some reason the order_status table was empty. So that has been fixed.

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by Qphoria » Wed Sep 09, 2009 9:33 pm

That order status is the important step. Sounds like you are not using English. You need to create the order statuses for your current language

See all the steps here:
http://www.opencart.com/index.php?route ... n/language

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by kdmp » Wed Sep 09, 2009 9:43 pm

Hey Q,

Fixed. I didn't have any order status options in the database - they disappeared at some point. I re-entered them and I regained that functionality back. I then had to go into the payment modules to set the right order status option to start with.

Thanks!

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by dr.boczek » Sat Sep 26, 2009 2:25 pm

Hi

please look this

/catalog/controller/payment/example_payment_module.php

go to callback function and change one line...

Before:

Code: Select all

$this->model_checkout_order->confirm($order_id, $this->config->get('paypal_order_status_id'));
After:

Code: Select all

$this->model_checkout_order->confirm((int)$order_id, (int)$this->config->get('paypal_order_status_id'));
This is PHP5 !!!!

I had the same problem, but this way it solved.

User avatar
Newbie

Posts

Joined
Sat Sep 26, 2009 2:15 pm
Location - Poland
Who is online

Users browsing this forum: No registered users and 12 guests