6 replies to this topic

[David @ gfe.]

On the default install an invoice was generated for about 600.00. I have cancelled it, but how can i get rid of it so that it doesn't impact total sales on real orders?

thanks

David

[rocky]

There are a couple of ways you can do this. This post might help you.

[David @ gfe.]

Unfortunately, that post made no sense to me. I have no idea how to implement whatever it is he is describing.

David

[rocky]

The first way you could do it is to open tabs/AdminOrders.php in your renamed admin directory, then find this line (it should be line 23):

$this->colorOnBackground = true;

Then copy the below line on a new line after it:

$this->delete = true;

You can then go to the Order tab as usual and a delete button should appear for each order.

The second way you could do it is to open your database using phpMyAdmin and remove all rows in ps_order_credit_data, ps_orders, ps_order_detail, ps_order_discount and ps_order_history with the id_order of the order you want to delete.

[David @ gfe.]

Rippa! Beauty! That worked. Thank you very much, Rocky.

[Amish Gramish]

Bump!

Thanks, but I just have one question:
Is there a way to delete the data that says the product has already sold a copy?
(I was testing out Google Checkout and PayPal, but now the GC order still shows up as sold, and it shows up as being a top seller, but the PP order just shows up as being sold. Is there any way to do away with this?)

[Balefire]

From 1247182472:

Bump!

Thanks, but I just have one question:
Is there a way to delete the data that says the product has already sold a copy?
(I was testing out Google Checkout and PayPal, but now the GC order still shows up as sold, and it shows up as being a top seller, but the PP order just shows up as being sold. Is there any way to do away with this?)

I wanted the same thing. Read through the blockbestsellers module, figured out it is stored in product_sale table.

Back up your database before doing this!
Use phpmyadmin (or whichever tool your hosts provides) and empty the product_sale table. No more top sellers!
Back up your database before doing this!

Hope that was enough warning! Although I haven't noticed any side effects (yet), there may be some further down the road.

Still looking for the perfect, clean database for a fresh installation method. Something always gets left behind.