Forums / Managing Customers and Orders / Orders not appearing at the list

Orders not appearing at the list

Locked

Started by i2c2k on 5 Jan 2008, 8:15 PM · Views: 2,693

Results 1 to 18 of 18
This thread is locked. New replies are disabled.
5 Jan 2008, 8:15 PM
#1
i2c2k avatar

i2c2k

New Zenner

Join Date:
Oct 2007
Posts:
13
Plugin Contributions:
0

Orders not appearing at the list

Hi,
after orders being checked out they don't show up in the list. Also when I look it up at a member's list of oders, there are no new orders. When I have a look into the database they are there! I tried to find some conspicuities but the entries look all the same.
What can be the reason here?
Every hint yould be appreciated, thanks!

5 Jan 2008, 8:45 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: Orders not appearing at the list

What version of Zen Cart?
What version(s) has it been upgraded from?
What addons/contributions are installed?
What kinds of customizations have you done to the code?
Which payment modules are being used, esp for the orders that aren't appearing correctly?
Does this happen with "all" orders, or just some?
How long has it been happening?
Do the orders show up in the customer's My Account history?
What's the URL?

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

5 Jan 2008, 9:07 PM
#3
i2c2k avatar

i2c2k

New Zenner

Join Date:
Oct 2007
Posts:
13
Plugin Contributions:
0

Re: Orders not appearing at the list

Very many questions :-)

What version of Zen Cart?
1.3.7

What version(s) has it been upgraded from?
no upgrade

What addons/contributions are installed?
no addons

What kinds of customizations have you done to the code?
only layout

Which payment modules are being used, esp for the orders that aren't appearing correctly?
only moneyorder

Does this happen with "all" orders, or just some?
all orders

How long has it been happening?
since i removed the paypal payment module and set up the zones shipping.

Do the orders show up in the customer's My Account history?
no, they don't

What's the URL?
https://www.equos-shop.com

Thanks!

5 Jan 2008, 9:11 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Orders not appearing at the list

Could you peek in the Modules ... Order Totals ... and make sure that Total ot_total is installed ...

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!

6 Jan 2008, 8:42 PM
#5
i2c2k avatar

i2c2k

New Zenner

Join Date:
Oct 2007
Posts:
13
Plugin Contributions:
0

Re: Orders not appearing at the list

How can I do this? And what should that do?

6 Jan 2008, 8:54 PM
#6
ajeh avatar

ajeh

Oba-san

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

Re: Orders not appearing at the list

Go to your Zen Cart Admin ...

Go to the Menu and you will see Modules ...

Go to the Order Total ...

Look at the list of Order Total modules ...

Click on Total ot_total ...

Is it installed?

Does it have the same Sort Order as another Order Total module?

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!

9 Jan 2008, 6:28 PM
#7
i2c2k avatar

i2c2k

New Zenner

Join Date:
Oct 2007
Posts:
13
Plugin Contributions:
0

Re: Orders not appearing at the list

I installed ot_total now and it has order 999.
What does that mean now?
Besides that only ot_shipping is installed with order 200.

9 Jan 2008, 6:47 PM
#8
i2c2k avatar

i2c2k

New Zenner

Join Date:
Oct 2007
Posts:
13
Plugin Contributions:
0

Re: Orders not appearing at the list

hey it works! that's it! thank you!

10 Jan 2008, 1:35 AM
#9
dreamz avatar

dreamz

New Zenner

Join Date:
Oct 2007
Posts:
52
Plugin Contributions:
0

Re: Orders not appearing at the list

Hi I have the same problem, but Total ot_total is installed enabled along with ot_shipping, ot_subtotal and ot_tax which all have unique ort #'s. I can see the orders in the database and in the admin Orders area if I type the order id in. Orders do not show in the customers section either.

I just upgraded to ZC 1.38, but was having this issue previously. I think it started after I installed "How did you hear about us 1.3.7". At that point the orders in the admin area just showed a blank screen. After I updated that mod to 1.3.8a and ZC to 1.3.8, the orders page is now not blank, but I just can't see any orders.

The only active payment module is - Credit Card - Offline Processing


Zen Cart 1.3.8a (upgraded from 1.3.7)
Database Patch Level: 1.3.8
PHP Version 5.0.4
Mods: fual slimbox v0.1.4, How did you hear about us 1.3.8.a, image handler 2.0

10 Jan 2008, 2:00 AM
#10
ajeh avatar

ajeh

Oba-san

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

Re: Orders not appearing at the list

If you do a search on the orders_id do you see the order?

If you look in the orders table do you see the order?

If you look in the orders_total table and sort on orders_id what records for the class field do you see for each order?

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 Jan 2008, 3:47 AM
#11
dreamz avatar

dreamz

New Zenner

Join Date:
Oct 2007
Posts:
52
Plugin Contributions:
0

Re: Orders not appearing at the list

When I'm in Admin --> Customers --> Orders and I do a search from the 3 search input items:

  • Search - nothing
  • Search by Product Name or ID:XX or Model - Nothing - searched on id, product name
  • Order ID - yes this is the only way to see an order

Database:

  • I do see the orders in the orders table.
  • When I sort on orders_id the records I see for the class field are: ot_shipping,
    ot_subtotal & ot_total
10 Jan 2008, 5:12 AM
#12
dreamz avatar

dreamz

New Zenner

Join Date:
Oct 2007
Posts:
52
Plugin Contributions:
0

Re: Orders not appearing at the list

I did notice that when I do a search by id and I'm able to see the order, the status field drop down is empty. Checking the db orders table for orders_status shows 1. I don't know if that means anything.

10 Jan 2008, 8:42 AM
#13
drbyte avatar

drbyte

Sensei

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

Re: Orders not appearing at the list

What entries do you have in Admin->Localization->Order Status?

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

10 Jan 2008, 5:27 PM
#14
dreamz avatar

dreamz

New Zenner

Join Date:
Oct 2007
Posts:
52
Plugin Contributions:
0

Re: Orders not appearing at the list

DrByte:

What entries do you have in Admin->Localization->Order Status?

I have no entries there

10 Jan 2008, 5:38 PM
#15
dreamz avatar

dreamz

New Zenner

Join Date:
Oct 2007
Posts:
52
Plugin Contributions:
0

Re: Orders not appearing at the list

DrByte:

What entries do you have in Admin->Localization->Order Status?
I just inserted a new one for "Processing" and the order now shows up! I guess I have to add each "Order Status" individually for the payment module I'm using (offline CC) , right?

:smile:

10 Jan 2008, 8:04 PM
#16
drbyte avatar

drbyte

Sensei

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

Re: Orders not appearing at the list

That table should never be empty. Somehow you've done something to lose the default data from it.

The smartest way to rebuild it to its default setup is to run this via Admin->Tools->Install SQL Patch:```

Table structure for table 'orders_status'

DROP TABLE IF EXISTS orders_status;
CREATE TABLE orders_status (
orders_status_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
orders_status_name varchar(32) NOT NULL default '',
PRIMARY KEY (orders_status_id,language_id),
KEY idx_orders_status_name_zen (orders_status_name)
) TYPE=MyISAM;
INSERT INTO orders_status VALUES ( '1', '1', 'Pending');
INSERT INTO orders_status VALUES ( '2', '1', 'Processing');
INSERT INTO orders_status VALUES ( '3', '1', 'Delivered');
INSERT INTO orders_status VALUES ( '4', '1', 'Update');

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

11 Jan 2008, 1:23 AM
#17
dreamz avatar

dreamz

New Zenner

Join Date:
Oct 2007
Posts:
52
Plugin Contributions:
0

Re: Orders not appearing at the list

Thanks again DrByte. I would have been pulling hair still!

11 Jan 2008, 6:28 AM
#18
drbyte avatar

drbyte

Sensei

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

Re: Orders not appearing at the list

dreamz:

Thanks again DrByte. I would have been pulling hair still!

At least you have some to pull!! :cry:

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