devshb
Senior Member
United Kingdom
1904 Posts |
Posted - January 04 2006 : 06:05:13
|
If you want to check/fix your prodcategories, products, and categories data, then we've got a tool which does all the relevant checks for you, and where most of the errors can be automatically fixed by pressing the "Fix Data" button.
We've just added 4 new checks to it, and made sure that it's compatible with v6 (it's also backward-compatible with 4.5/5/5.5)
See:
http://www.bigyellowzone.com/shopexd.asp?id=74
here's what it does....
This is a set of 10 new Admin screens, with a common menu used at the top, having 10 different sets of data checks with buttons to auto-fix the missing/incorrect data where relevant. If you're using ProdCategories then we guarantee that your data will need cleaning up and this is a great tool which lets you clean up your data at the push of a "fix" button.
Each of the 10 screens shows the precise cause of the data errors, showing summaries of each record that's at fault with relevant links to the product, category, and/or prodcategories records.
The checks carried out are:
1) Invalid Categories on Matrix "fix data" will delete these spurious matrix records
2) Invalid Products on Matrix "fix data" will delete these spurious matrix records
3) Invalid Categories on Products no "fix data" available; just use the links on each record to get to the product screen and edit the categories for the product.
4) SubCategories on matrix but no parent Categories on Matrix "fix data" will generate the missing parent categories matrix records
5) Products with no Matrix entries no "fix data" available; just use the links on each record to get to the product screen and edit the categories for the product.
6) Categories with no Matrix entries "fix data" will delete the unused categories
7) Category records with invalid hassubcategory value "fix data" will correct the hassubcategory values
8) Category records having no sub categories but hassubcategory flag is set to 'Yes' "fix data" will correct the hassubcategory values
9) Category records having sub categories but hassubcategory flag is set to null ('No') "fix data" will correct the hassubcategory values
10) Category records with higercategoryid values which do not exist. (no "fix data" button available; links to the categories are given instead so that you can manually change them)
Simon Barnaby Developer [email protected] www.BigYellowZone.com Web Design, Online Marketing and VPASP addons |
|