shop opening start with order #1

[yps]

I'm planning on opening a store soon and wanted to know what would be the best way to start with a fresh database (and order #1 as opposed to all the tests I ran).

I hab emptied all tables that start with orders_* and customers_* using phpmyadmin. But now the new orders where no more shown under orders . What hab i done wrong? Have some of you any idea?

Thanks for help
yps

[yps]

I think one Problem is that if i empty the order_total then at the admin the whole Module -> Order total is missing and ask for istallation but the installation failed.
Has anyone of you an idea.

yps

[GSIS]

Think about starting your customer ids somewhere over at least a few hundred and your order ids in the thousands.

I'd get very nervous if I found I was customer number 1, placing order number 1.

Some will disagree, claiming this is dishonest (I can guess who in particular) but I've been trading successfully online for a long time so I think raising my starting numbers would have given a more accurate image, rather than a misleading one. In fact, I didn't do this but wish I had.

Watch out for the tax man, though. if you start your order numbers at 12345 and he does an audit he'll want to know what happened to the other 12344.

[yps]

Yes, thats a good point but the order count 2008/00001, 2008/00002 ... 2008/00022 etc. so i want to start at 1.

[yps]

I think one Problem is that if i empty the order_total then at the admin the whole Module -> Order total is missing and ask for istallation but the installation failed.
Has anyone of you an idea.

yps

No that was not the problem, i looked to fast after emptying the mysql. Thats fine but the new orders were not shown if i put the nummber in the orders id then its not shown but not under folder order?

[yps]

I try to explain it better: i want to clear the order table,

1. i went to phpmyadmin an emptyied the folder,

the effect was: orders are deleted and costumers get order no.1, but it was not shown in admin-> orders

and i used my backup afterwards, then i tried 2.

2. someone told we use admin sql tool for that, so i type in

TRUNCATE TABLE `orders` ;
TRUNCATE TABLE `orders_products`;
TRUNCATE TABLE `orders_products_attributes`;
TRUNCATE TABLE `orders_products_download`;
TRUNCATE TABLE `orders_status_history`;
TRUNCATE TABLE `orders_total`;

and then comes the following error:

ERROR: Cannot drop table because it does not exist.

But it is there and the whole system work fine. I have no idea what is wrong!?

[d1rage5]

on the note of tax man on order numbers. if you are using a accounting program then you would start the order number out with what you want want as long as the two match its not a problem.

You are right customers do not want to see they are the first to place an order (if you read any good marketing books this is highlighted as top 10 to start you cart or ordering process as 100?? (this is not dishonest its part of the marketing world we live in) if you dont live in that world then i assume you dont have a very big business or dont plan on growing that bis to care what your customers think) (Maybe just a very nitch market).