Looking for a couple time saving contributions

[SMC]

So, I've been trying to clean up my companie's online store (just recently took over), and I need to delete thousands old orders and customer records. With the way OSCommerce is currently set up for me, there is no way but to do this one at a time, click on the entry, click on delete, confirm, repeat. Needless to say, this is a staggeringly time consuming (not to mention mind numbing) process when I have to work with so many entries.

 

I'm just curious if anyone knows of a contribution that includes a "tic box" functionality or something similar, so that I can select multiple orders per page and say, delete them all. Conversely, if anyone has an idea of a faster way to do this, I'm all ears.

 

On a related note, I'm wondering if there is any sort of "best of" or "essential" contributions. Stuff that makes using OSCommerce much better/faster/easier/more efficient. You know, functionality that really should have been in there from the beginning, but was inexplicably left out. Anything that you could point me in the direction of would be greatly appreciated.

 

Thanks in advance to anyone that can help me with this, as I'm liable to go insane from the days of work I'll have to put in to do all these one at a time.

[dropdeadred]

I'm just curious if anyone knows of a contribution that includes a "tic box" functionality or something similar, so that I can select multiple orders per page and say, delete them all. Conversely, if anyone has an idea of a faster way to do this, I'm all ears.

 

Working in phpmyadmin enables you to select that way in the database itself. In the table 'orders' you can select with the check boxes, entire pages, whatever you like.

[GemRock]

If there is such a contrib? I am not sure but if you know abou and/or have access tot phpMyAdmin, then you could easy do what you wanted to do there. You could delete a screen full of records at one go, or delete thousands of records in seconds by writing/running some sql scripts. I guess your next question would be to ask how to do that in phpMyAdmin, which any good hosting service would provide.

 

 

 

HTH

 

 

 

Ken

[SMC]

Ah, well, I don't really have a very good hosting service, nor am I really in contact with them (hooray large for companies) could somone tell me what phpmyadmin is, and/or how I would access/acquire it?

[SMC]

ok, so I've found myphpadmin on the server, now how do I use it to edit orders.php?

[spax]

If you know what you need to delete, you could always do it from a database backup. Open the backup in a text editor, delete the "inserts" you don't need, then restore the edited backup from admin.

 

It doesn't get any simpler than that! :huh:

 

Best to backup the backup though, before deleting anything. Just incase!

[dropdeadred]

SMC, you don't use phpmyadmin to edit the php page. phpmyadmin allows you direct access to the database, and all orders.php is doing is telling you certain info that's stored in the database, it's not a hard coded page that contains all the info (the very nut of why we use php at all, in fact, is creating pages 'on the fly' which contain info from the database). To delete orders you simply navigate to the "orders" table within your osc database - the left frame should show you a tree once you select the osc database - click on orders, then click on 'browse' in the top of the main window. What you'll see is all the orders, line by line, stored in the database. There will be check boxes next to them. Select what you want and delete them. When you go back to your orders page in your site's Admin section, they'll be gone.