Jump to content



Latest News: (loading..)

- - - - -

Database Check Tool


  • Please log in to reply
2 replies to this topic

#1   azer

azer
  • Members
  • 842 posts
  • Real Name:azer
  • Location:Paris, france

Posted 16 June 2009 - 02:18 PM

http://addons.oscommerce.com/info/5962

This contribution will check your database for duplicate product names, products price $0, products no weight, duplicate products_to_categories, categories no products and more. Results have clickable buttons and links to delete records or edit them through categories.php in admin. Minimum file editing for easy install. Please see the readme file for installation instructions and additional notes. Enjoy! :)


it s defintly a usefull report tools since you can monitor some important catalog problems within our site

let's share and improve this tool

thanks to geoffreywalton and ohioman
MS2

#2   azer

azer
  • Members
  • 842 posts
  • Real Name:azer
  • Location:Paris, france

Posted 16 June 2009 - 02:23 PM

I will do here a list of improvement i think we could work out :

REQ : Being able to update or change directly in the listing the field like with the contribution quick price update
BUG : Products with duplicate titles
i dont know why but i got several time the same product with the same model numer (id) so it s not a duplicate

like here :

Quote

70 1000-90-50 D-Squared2 - Chemise à M. L. - Multi 2006-03-05 20:55:04 D-Squared2 Click to delete record
71 1000-90-49 D-Squared2 - Chemise à M. L. - Multi 2006-03-05 20:55:05 D-Squared2 Click to delete record
70 1000-90-50 D-Squared2 - Chemise à M. L. - Multi 2006-03-05 20:55:04 D-Squared2 Click to delete record
71 1000-90-49 D-Squared2 - Chemise à M. L. - Multi 2006-03-05 20:55:05 D-Squared2       Click to delete record

MS2

#3   gameserv

gameserv
  • Members
  • 1 posts
  • Real Name:Janusz
  • Gender:Male

Posted 10 October 2011 - 10:02 AM

Hello thanks for your contribution is very good.

But such a module is missing here that would make the order in my database if it can be embedded in it?
After removing the old card I have free product number in the database which is bypassed and add new card numbers, whether it is possible to add these new products of deleted numbers