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 and Categories Verification Tool
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

devshb
Senior Member

United Kingdom
1898 Posts

Posted - December 28 2004 :  15:07:52  Show Profile  Visit devshb's Homepage  Reply with Quote
During our time checking out vpasp data on various sites that we've worked on over the years, we ended up creating a tool that cross-references products, categories, and prodcategories records doing various checks, showing the relevant spurious/invalid/missing records, and having "fix data" buttons at each stage to generate missing entries and to delete spurious entries.

I'm curious if anyone on this forum would find it useful ?

This is particularly relevant to people who do bulk updates and then need to check/tweak their data, or if you just want to get rid of redundant/leftover data, or just check all your data is correct/relevant.

Would anyone here be interested in this ?

It's a biggie; kind of like an admin sub-system; 6 stages of checks; you'd be amazed at the errors in your data you'll see that you otherwise wouldn't be aware of, and having a "fix data" button to do the corrections for you is very useful!

In case anyone's curious, the checks that are done (and corresponding offending data displayed with fix options) 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

(
see posting below; now available for sale:
http://bigyellowzone.com/shopexd.asp?id=74
)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on January 09 2005 11:34:40

bmw000
VP-ASP New User

137 Posts

Posted - December 29 2004 :  13:51:30  Show Profile  Visit bmw000's Homepage  Reply with Quote
I think I would be interested in this. I import large amounts of data almost daily and would be curious to find out if the bulk imports are causing errors or if the data is not going into the database the way vp-asp intends it to.

Brian Weber
BMW Solutions, LLC
http://www.bmwsolutions.com/shopping

Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - January 08 2005 :  18:32:31  Show Profile  Visit devshb's Homepage  Reply with Quote
We've now packaged this up, documented it, and it's now available to buy as an addon:

http://bigyellowzone.com/shopexd.asp?id=74

We've used this on quite a few sites now (including our own), and it works a treat; we tidied up our product, category, and prodcategory data in 2 minutes with this tool; all we had to do was press the "fix" buttons; very handy!

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000