SMC Posted January 23, 2007 Share Posted January 23, 2007 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. Link to comment Share on other sites More sharing options...
dropdeadred Posted January 23, 2007 Share Posted January 23, 2007 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. Link to comment Share on other sites More sharing options...
GemRock Posted January 23, 2007 Share Posted January 23, 2007 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 commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile). over 20 years of computer programming experience. Link to comment Share on other sites More sharing options...
SMC Posted January 26, 2007 Author Share Posted January 26, 2007 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? Link to comment Share on other sites More sharing options...
SMC Posted January 26, 2007 Author Share Posted January 26, 2007 ok, so I've found myphpadmin on the server, now how do I use it to edit orders.php? Link to comment Share on other sites More sharing options...
spax Posted January 27, 2007 Share Posted January 27, 2007 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! Link to comment Share on other sites More sharing options...
dropdeadred Posted January 31, 2007 Share Posted January 31, 2007 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.