VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 Prodcategories check/fix tool for v6 and below
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

devshb
Senior Member

United Kingdom
1898 Posts

Posted - January 04 2006 :  06:05:13  Show Profile  Visit devshb's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000