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

[Goofy2k]

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 !)

[Ajeh]

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

[Goofy2k]

No,

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

I do see new orders on index.php

strange.

Fred

[Ajeh]

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

[Goofy2k]

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)

[Ajeh]

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

[Goofy2k]

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

(have been offline for a while)

Fred

[Goofy2k]

Hi Ajeh,

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

Thanks for your support.

Fred

[Ajeh]

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