Deleting orders?

Author Message

Adolfo Barragán

Monday 22 September 2003 2:32:47 am

How can I delete (selected) orders from admin siteaccess?

Regards
Adolfo Barragán

Tony Wood

Monday 22 September 2003 2:37:04 am

Hi Adolfo,

I am interesting in find that too, the only way i thought was to write a script to delete them from the DB in ezorder and related tables.

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Adolfo Barragán

Monday 22 September 2003 3:19:26 am

> I am interesting in find that too, the only way i thought
> was to write a script to delete them from the DB in
> ezorder and related tables,

And wich are these tables?

I think they are the following tables but, there is any more?

ezorder, ezorder_item, ezproductcollection, ezproductcollection_item, ezproductcollection_item_opt

Regards
Adolfo Barragan

Tony Wood

Monday 22 September 2003 3:25:23 am

This is a good guide http://ez.no/sdk/doc/view/database_diagram/

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Tony Wood

Wednesday 08 October 2003 2:42:08 pm

Did you ever write this script? I need to right a routine that clears down the test orders prior to launch of a site.
Let me know if you have none, otheriwse i will write and post here.

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 31 2025 06:25:27
Script start
Timing: Jan 31 2025 06:25:27
Module start 'layout'
Timing: Jan 31 2025 06:25:27
Module start 'content'
Timing: Jan 31 2025 06:25:27
Module end 'content'
Timing: Jan 31 2025 06:25:27
Script end

Main resources:

Total runtime0.0159 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0053 588.0078151.1953
Module start 'layout' 0.00530.0029 739.203136.6172
Module start 'content' 0.00820.0062 775.820394.1250
Module end 'content' 0.01440.0015 869.945333.9922
Script end 0.0159  903.9375 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002817.4297140.0002
Check MTime0.00127.4592140.0001
Mysql Total
Database connection0.00085.306810.0008
Mysqli_queries0.002314.580430.0008
Looping result0.00000.080810.0000
Template Total0.00127.410.0012
Template load0.00095.520710.0009
Template processing0.00031.812810.0003
Override
Cache load0.00063.802110.0006
General
dbfile0.00127.704580.0002
String conversion0.00000.058340.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs