Forums / Managing Customers and Orders / completed orders are not showing up under "orders" options

completed orders are not showing up under "orders" options

Locked

Views: 3,155

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
13 Aug 2007, 6:36 PM
#1
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

completed orders are not showing up under "orders" options

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?

13 Aug 2007, 9:21 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: completed orders are not showing up under "orders" options

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 ...

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!

14 Aug 2007, 1:45 AM
#3
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

Re: completed orders are not showing up under "orders" options

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 ...

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

14 Aug 2007, 1:55 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: completed orders are not showing up under "orders" options

james739:

Ok, I installed ot_total under module, I still don't see my completed orders under orders!Um ... why wasn't it already installed ?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

14 Aug 2007, 1:56 AM
#5
ajeh avatar

ajeh

Oba-san

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

Re: completed orders are not showing up under "orders" options

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 ...

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!

14 Aug 2007, 2:34 AM
#6
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

Re: completed orders are not showing up under "orders" options

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 ...

will this bring up my old orders?

14 Aug 2007, 2:37 AM
#7
ajeh avatar

ajeh

Oba-san

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

Re: completed orders are not showing up under "orders" options

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 ...

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!

14 Aug 2007, 2:59 AM
#8
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

Re: completed orders are not showing up under "orders" options

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 ...

is there a thread on how to do this?

14 Aug 2007, 3:13 AM
#9
ajeh avatar

ajeh

Oba-san

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

Re: completed orders are not showing up under "orders" options

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)

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!

14 Aug 2007, 3:20 AM
#10
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

Re: completed orders are not showing up under "orders" options

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)

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

14 Aug 2007, 10:39 PM
#11
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

Re: completed orders are not showing up under "orders" options

james739:

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

cool, it worked. Your are the best!

Thanks!

15 Aug 2007, 3:29 AM
#12
ajeh avatar

ajeh

Oba-san

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

Re: completed orders are not showing up under "orders" options

Glad to hear that all is right in the world once more ... :cool:

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!