Order does not appear in admin section unless I search by number

Hi, I have freshly installed version 1.3.9d.

For testing purposes I defined a customer and added some articles.

When the customer orders an article he receives the confirmation email. The number of available products is decreased by one. However, in the admin section I don't see the order when I look in the Customers/Orders menu. The screen is empty at the start. Only when I search for the specific order number, it does appear.

I expect that there would be a central place where the shop owner is notified about all orders.

Is there some settting that I still have to change?
What is the normal way that the shop owner is notified about new orders?

Fred

This sounds like you do not have the Modules ... Order Total ... Total ot_total installed ...

If you go to the Modules ... Order Total ... do you see the Total ot_total is installed?

What color is the icon for it?

What is its Sort Order?

When I go to Modules in the admin section, I see only three menu entries:
(translated by me from Dutch)

Payment method
Shipment method
Invoice structure

So, nothing about Order Total.

I have a relatively fresh installation. Did I have to install this additional module?

Try the Modules ... Invoice structure ...

Do you see things like the:

COD Fee ot_cod_fee
Discount Coupon ot_coupon 280
Group Discount ot_group_pricing 290
Gift Certificates ot_gv 840
Low Order Fee ot_loworderfee 400
Shipping ot_shipping 200
Sub-Total ot_subtotal 100
Tax ot_tax 300
Total ot_total 999

NOTE: if not installed there will not be a Sort Order ...

If you look in your database via phpMyAdmin and browse the table:
orders_total

and do a search on the:
orders_id

for one of these Orders that you do not see ... what records come up for it?

Hi , thank you for helping me.

The ot_total is installed, the icon is green, the sort order is 9999.

I attached a screenshot from phpMyAdmin while in the orders_total table.

Could you browse the table:
orders_status

and post what you see?

I can not browse table order_status. phpMyAdmin answers: table seems to be empty.

The table order_status_history contains 4 orders. For each of them oder_status_id and customer_notified equal 1.

Nothing in the orders_status table? :blink:

If you go to your Zen Cart Admin and go to the Localization ... Orders Status ... what do you see?

0 out of 0 orders

You see that in the Localization ... Order Status ... menu?

I see 0 orders when I go to the menu

Languages & Currencies (6th entry from the left) and then to Order Status (third entry after the entries Currencies and Languages).

(These are my translations of the dutch menu entries. I should switch to English again in the admin section !)

In you Admin, change the URL to be this file:
/orders_status.php

What do you see there?

If sounds like you have no Order Status definitions ...

No,

I see no orders in orders_status.php and in orders.php.

I do see new orders on index.php

strange.

Fred

There are not orders in the orders_status.php this is the statuses that Orders can be ...

You appear to be missing the data from the table:
orders_status

it should never be empty ...

Do you have a backup of your database where you can get a good copy of the table:
orders_status

By default, the orders_status table contains:

orders_status_id language_id orders_status_name
1 1 Pending
2 1 Processing
3 1 Delivered
4 1 Update

However, you are using multiple languages so this would be different for your site ...

However, without having this table you are having issues in displaying the orders ...

If I dump this table, I lose the orders ... if I rebuild the table I get the orders ...

OK,

I probably do not have a backup, as my installation was fresh.

Does Zen Cart have an option to (automatically) backup the database?

Is it possible to completely empty the database and start all over again ( e.g. by running an install.php, such as can be done with a Drupal site)

This are the original records:

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');

But you would need to manually manage them for your other languages ...

By default, this is set for language_id 1 ... you would need to have a set for each language ...

Check the values of your languages for the language_id, and just change the second value, '1' to what you need, such as '2', example:

INSERT INTO orders_status VALUES ( '1', '2', 'Pending');
INSERT INTO orders_status VALUES ( '2', '2', 'Processing');
INSERT INTO orders_status VALUES ( '3', '2', 'Delivered');
INSERT INTO orders_status VALUES ( '4', '2', 'Update');

Once you have a set for each language, see the table:
languages

for the values ... you can then you can edit them for the proper names that you want to use in your Zen Cart Admin in the Localization ... Order Status ...

Be sure to backup your database before adding these ...

OK, I'm going to give that a try.

(have been offline for a while)

Fred

Hi Ajeh,

I entered the SQL codes into the table. Now everything seems to work fine !

Thanks for your support.

Fred

Thanks for the update that things appear to be working correctly now ... :smile: