The saga of the upgrade continues....

I've upgraded from 1.3.9a > h.

Now, when a customer attempts to use some of the GV balance, two problems occur:

1. Their GV balance is actually INCREASED by the amount they attempt to apply to the order;

2. Their order (which is successful) is placed on a "pending" status, making downloaded products unavailable.

Help.....

Sorry, I need to correct this:

The GV balance is reduced appropriately. However, the second problem still exists:

The order is placed on a "pending" status, making downloaded products unavailable.

Configuration > GV Coupons "Default Order Status For Zero Balance Orders" is set to "Processing"
Modules > Payment Freecharger is enabled and set to processing

What else could be causing this?

John

As discussed in your other thread on similar topics, what is the payment/shipping associated with that order?

The same that appeared before GV/DC free

Just an FYI:

Under Localization > Order Status, the default status was listed as "Pending".

When I change that to "Processing" this problem goes away.

But I'm not sure if that will cause problems with other orders?

John

Hmmm, and another FYI -- a google search brought up the information below -- I tried it and it seems to work:

========
If you have set configuration->GV Coupons->Default Order Status For Zero Balance Orders to Processing, but your download orders still stay at Pending, this may help:
In 1.3.8 and 1.3.9, orders with sales tax which are reduced to 0 through a coupon still have a tiny non-zero value in their order total, so the following check in includes/classes/order.php fails:

if ($this->info['total'] == 0) {

this is on line 568 in 1.3.9h and line 554 in 1.3.8a.

change this to

if ($this->info['total'] < 0.01) {

and it will work.

Note: This solution has also been posted to the Zen Cart forum.

The link for the complete blog posting is:

http://thecartblog.com/2011/04/04/zen-cart-100-coupon-on-download-still-creates-order-with-status-pending/

Go to phpMyAdmin and search the configuration table for the configuration_key that reads:
DEFAULT_ZERO_BALANCE_ORDERS_STATUS_ID

and make sure that the configuration_value is set to the value for your Processing ID ...

Also make sure that you only have 1 record for that configuration_key of:
DEFAULT_ZERO_BALANCE_ORDERS_STATUS_ID

Next, check that the Order class for:
/includes/classes/order.php

is current and up to date and matches the file that comes with a clean v1.3.9h ...

Also be sure that the database table being used in the Admin is the same as what is used in the Catalog by checking the two files:
/includes/configure.php
/your_secret_admin/includes/configure.php

Hi Ajeh -- thanks so much for the tips. Here's some feedback:

Ajeh:

Go to phpMyAdmin and search the configuration table for the configuration_key that reads:
DEFAULT_ZERO_BALANCE_ORDERS_STATUS_ID

and make sure that the configuration_value is set to the value for your Processing ID ...

Yes, it is (2, Processing)

Ajeh:

Also make sure that you only have 1 record for that configuration_key of:
DEFAULT_ZERO_BALANCE_ORDERS_STATUS_ID

That is the case

Ajeh:

Next, check that the Order class for:
/includes/classes/order.php

is current and up to date and matches the file that comes with a clean v1.3.9h ...

This file has been modified by the Stock by Attributes mod. Maybe that's introducing the problem?

Ajeh:

Also be sure that the database table being used in the Admin is the same as what is used in the Catalog by checking the two files:
/includes/configure.php
/your_secret_admin/includes/configure.php

Yes, this is the case.

The constant for the GV when the total is at 0 on the Order Status is:
DEFAULT_ZERO_BALANCE_ORDERS_STATUS_ID

this is managed in the Order Class in:
/includes/classes/order.php

You might check to see if you are using the original order.php or if that has been customized in some way that is altering how it works ...

Also, in phpMyAdmin, browse the table:
orders

and see what the content is for the field:
order_total

on these GV orders that did not work correctly ... is it 0.0 or something else?

Ajeh:

The constant for the GV when the total is at 0 on the Order Status is:
DEFAULT_ZERO_BALANCE_ORDERS_STATUS_ID

this is managed in the Order Class in:
/includes/classes/order.php

You might check to see if you are using the original order.php or if that has been customized in some way that is altering how it works ...

The order.php file has been altered by the "Stock with Attributes" addon. But as far as I can tell, those are the only changes.

Ajeh:

Also, in phpMyAdmin, browse the table:
orders

and see what the content is for the field:
order_total

on these GV orders that did not work correctly ... is it 0.0 or something else?

The amounts are 0.0

So, I'm stumped, sort of. But to return to my first fix, setting the default order status to "processing" under Localization > orders status... will that cause any problems that I'm not aware of?

Changing the default will result in any Order Status not otherwise specified will be set to that default setting ...

Thanks -- I'll give it a try.

John