completed orders are not showing up under "orders" options

[james739]

Hi, I have a slight problems with the "orders" in my admin. WHen I log into my admin, it shows the I have 8 orders, which is correct. WHen I click on customer then orders, I don't see any of the orders. Anybody know why this is happening?

[Ajeh]

Browse your orders_total table in phpMyAdmin ... do you have the ot_total class listed for each order?

Check that in your Zen Cart Admin that you have in the Modules ... Order Total ... the Total ot_total installed and enabled ...

[james739]

Browse your orders_total table in phpMyAdmin ... do you have the ot_total class listed for each order?

Check that in your Zen Cart Admin that you have in the Modules ... Order Total ... the Total ot_total installed and enabled ...

Ok, I installed ot_total under module, I still don't see my completed orders under orders!
Anything else i can try?

[DrByte]

Ok, I installed ot_total under module, I still don't see my completed orders under orders!

Um ... why wasn't it already installed ?

[Ajeh]

This will only work on NEW Orders and not existing ones ...

You could look at how the orders_total table should have the ot_class added and fix this ...

But be sure to backup your database before attempting this ...

[james739]

This will only work on NEW Orders and not existing ones ...

You could look at how the orders_total table should have the ot_class added and fix this ...

But be sure to backup your database before attempting this ...

will this bring up my old orders?

[Ajeh]

IF you add a record to the orders_total table correctly, then you can see the order in the listing without having to search for it ...

If you have never had a record that utilizes the orders_total table for the ot_class you will want to make an order yourself so that you can see how this record looks in order to make a properly configured record ...

[james739]

IF you add a record to the orders_total table correctly, then you can see the order in the listing without having to search for it ...

If you have never had a record that utilizes the orders_total table for the ot_class you will want to make an order yourself so that you can see how this record looks in order to make a properly configured record ...

is there a thread on how to do this?

[Ajeh]

Not that I am aware of ...

If you add a test order to your site, you will see how an order is correctly built now that you have the ot_total installed ...

Look at how that record is made in the orders_total table for when the class is ot_total ...

Then, add a new record and set the values for the fields:
orders_total_id (leave blank this is auto-incremented)
orders_id (whatever the missing orders_id is)
title Total:
text (amount of order in text, example $12.99)
value (amount of order in numbers only)
class ot_total
sort_order (this matches the test you create, default is 999)

[james739]

Not that I am aware of ...

If you add a test order to your site, you will see how an order is correctly built now that you have the ot_total installed ...

Look at how that record is made in the orders_total table for when the class is ot_total ...

Then, add a new record and set the values for the fields:
orders_total_id (leave blank this is auto-incremented)
orders_id (whatever the missing orders_id is)
title Total:
text (amount of order in text, example $12.99)
value (amount of order in numbers only)
class ot_total
sort_order (this matches the test you create, default is 999)

Thanks alot for the prompt reply Ajeh, I will give a try.