Software Search
HELP/FAQs?

Got questions/problems? Take a look through our FAQs (frequently asked questions), or email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly.

Want Discounts?

Are your prices for multiple domains too large? Are you trying to get licences for test domains but being asked to pay full cost? Don't worry; we can add test domains to your licences manually. Just purchase a single domain addon/upgrade for what it is that you need, and then email us about your situation regarding the remaining domains and we'll liaise with you over the options. email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly. click here for more information regarding multiple domains, upgrades, and discount policies.

BigYellowKey News
(click here to view all BYK news)

Imminent: 4/1/2016 4:05:00 PM
BYZ Development Points have been changed
Click Here for details.
The new BYZ Development Points (BYZ192) replace all previous BYZ Points which are now no longer available.

Released: 4/1/2016 3:05:00 PM
BYZ Annual Pass Now Available!
Click Here for details.
The BYZ Annual Pass replaces the BYZ addon subscription service.

Released: 4/1/2016 2:05:00 PM
The BYZ Terms and Conditions have been changed.
Click Here for details.

Apologies, but online Payments are temporary unavailable as we are in the process of changing our payment gateway.
Please contact us if you wish to place an order and we will organize a manual payment process for you.
We hope/expect online payments to be available again soon.

Product/Category Fixing/Reporting Utils for VPCart - BYZ055

<< back to previous screen

This is a set of 12 new Admin screens, with a common menu used at the
top, having 12 different sets of data checks with buttons to auto-fix
the missing/incorrect data where relevant.
If you use 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.



Product/Category Fixing/Reporting Utils for VPCart - BYZ055
Latest version:15/01-APR-2015
From vendor:Big Yellow Zone
For Terms and Conditions, click here
Please do not purchase any BigYellowZone
products/services or request technical
support until you have read and agree with
the terms and conditions.
Price:£30.00
add to cart


Compatibility, Bundling, and Status Notes:
Compatible with VPCart V4.5 to V8
Before installing, you must have installed:
BYZ038
BYZ036

This product includes:
BYZ038
BYZ036

Each of the 12 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.


Technical/Developer Information:
The checks carried out are:

1) Category records with invalid hassubcategory value
"fix data" will correct the hassubcategory values

2) Category records having no sub categories but hassubcategory flag is set to 'Yes'
"fix data" will correct the hassubcategory values

3) Category records having sub categories but hassubcategory flag is set to null ('No')
"fix data" will correct the hassubcategory values

4) 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)

5) Infinite Looping Categories
Shows the relevant branches/categories and allows you to set the highercategoryid of relevant categories.

6) Duplicate Matrix Records
Shows a list of all duplicate prodcategories records (ie where the same catalogid and categoryid combination already exists in an earlier prodcategories record).
"fix data" will delete the duplicated matrix records.

7) Invalid Categories on Matrix
"fix data" will delete these spurious matrix records

8) Invalid Products on Matrix
"fix data" will delete these spurious matrix records

9) 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.

10) SubCategories on matrix but no parent Categories on Matrix
"fix data" will generate the missing parent categories matrix records

11) 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.

12) Categories with no Matrix entries
"fix data" will delete the unused categories


Terms and Conditions:
For terms, conditions, and licensing information for all BigYellowZone products/services, please click here.
Please do not purchase any BigYellowZone products/services or request technical support until you have read and agree with the terms and conditions.


Full Version History:
VerNo Version Date Release Notes
01 01-JAN-2005 Initial version - Big Yellow Zone Category/ProdCategory Fixing Utility For VP-ASP
02 04-JAN-2006 Added four new utilities/steps for category records.
New checks were added for:
1. Category records with hassubcategory value other than Yes or null (No).
2. Category records having no sub categories but hassubcategory flag is set to Yes.
3. Category records having sub categories but hassubcategory flag is set to null (No).
4. Category records with highercategoryid values which do not exist.

Changed documentation to make it VP-ASP V6 compatible.
Added extra warning message to the Categories with no matrix section.
Effected files:
README.htm (changed)
byz055_install.asp (changed)
byz_prodcatcheck_menu.asp (changed)
byz_prodcatcheck_missingcatsonmatrix.asp (changed)
byz_catcheck_correct_hassubcategory_value.asp (new file)
byz_catcheck_flaggedsubcats_nosubcats.asp (new file)
byz_catcheck_higher_category_exists.asp (new file)
byz_catcheck_subcats_flaggednosubcats.asp (new file)
03 21-FEB-2007 Changed to be able to cater for some additional versions of MySQL, as MySQL has restrictive sql syntax relating to using sub-queries compared to Access/SQLServer.
Changed to fully close-down/clear cursors and connections (previously some cursors/connections were being left open).
Added a max-errors-shown config option, changeable for each stage by altering the settings in the new byz_prodcatcheck_$config.asp file.
Changed array size logic to avoid memory problems.
Changed/corrected some boiler-plate text typos.
Added current stage titles to the header of each stages screen.
Changed the formatting to highlight errors and relevant messages in a clearer way.
Added notes regarding indexing columns to speed up the tool/site.
Effected Files:
README.htm (changed)
byz055_install.asp (changed)
byz_catcheck_correct_hassubcategory_value.asp (changed)
byz_catcheck_flaggedsubcats_nosubcats.asp (changed)
byz_catcheck_higher_category_exists.asp (changed)
byz_catcheck_subcats_flaggednosubcats.asp (changed)
byz_prodcatcheck_$config.asp (new file)
byz_prodcatcheck_invalidcatonmatrix.asp (changed)
byz_prodcatcheck_invalidcatonproducts.asp (changed)
byz_prodcatcheck_invalidprdonmatrix.asp (changed)
byz_prodcatcheck_menu.asp (changed)
byz_prodcatcheck_missingcatsonmatrix.asp (changed)
byz_prodcatcheck_missingproductsonmatrix.asp (changed)
byz_prodcatcheck_subcatsnocats.asp (changed)
byz_prodcatcheck_sys.asp (new file)
04 15-MAR-2007 Upgraded BYZ038 (Licensing) module to cater for VP-ASP V6.5.
Changed installation instructions to cater for VP-ASP V6.5 (categories has moved from occasional to everyday menu section between 6.0x and 6.5).
Effected files:
byz055_install.asp (changed file)
README.htm (changed file)
05 03-JUL-2007 Changed to be able to cater for some olders versions SQLServer, similar changes as to what was done on version 03.
Effected files:
byz055_install.asp (changed file)
README.htm (changed file)
byz_catcheck_flaggedsubcats_nosubcats.asp (changed file)
byz_catcheck_subcats_flaggednosubcats.asp (changed file)
06 05-SEP-2007 Changed stage 8 to cater for recent MySql syntax rule changes.
Effected files:
byz055_install.asp (changed file)
README.htm (changed file)
byz_prodcatcheck_subcatsnocats.asp (changed file)
07 08-NOV-2007 Upgraded BYZ038 (from V07 to V08)
Upgraded BYZ036 (from V02 to V04)
Changed instructions to be compatible with bigyellowkey.com licensing notes.
Effected files:
README.htm (changed file)
byz055_install.asp (deleted file)
08 16-JAN-2008 Added explicit command timeouts for database connections.
Effected files:
README.htm (changed file)
byz_catcheck_correct_hassubcategory_value.asp (changed file)
byz_catcheck_flaggedsubcats_nosubcats.asp (changed file)
byz_catcheck_higher_category_exists.asp (changed file)
byz_catcheck_subcats_flaggednosubcats.asp (changed file)
byz_prodcatcheck_invalidcatonmatrix.asp (changed file)
byz_prodcatcheck_invalidcatonproducts.asp (changed file)
byz_prodcatcheck_invalidprdonmatrix.asp (changed file)
byz_prodcatcheck_missingcatsonmatrix.asp (changed file)
byz_prodcatcheck_missingproductsonmatrix.asp (changed file)
byz_prodcatcheck_subcatsnocats.asp (changed file)
09 16-JAN-2009 Upgraded BYZ038 (from V08 to V10)
Upgraded BYZ036 (from V04 to V05)
Created version file for reference/info.
Added more notes to all the stage screens to explain in more detail about the errors/checks.
Effected files:
README.htm (changed file)
byz$055_version.asp (new file)
byz_catcheck_correct_hassubcategory_value.asp (changed file)
byz_catcheck_flaggedsubcats_nosubcats.asp (changed file)
byz_catcheck_higher_category_exists.asp (changed file)
byz_catcheck_subcats_flaggednosubcats.asp (changed file)
byz_prodcatcheck_invalidcatonmatrix.asp (changed file)
byz_prodcatcheck_invalidcatonproducts.asp (changed file)
byz_prodcatcheck_invalidprdonmatrix.asp (changed file)
byz_prodcatcheck_missingcatsonmatrix.asp (changed file)
byz_prodcatcheck_missingproductsonmatrix.asp (changed file)
byz_prodcatcheck_subcatsnocats.asp (changed file)
10 12-JUL-2009 Added an additional stage (stage 5) to check for infinite-looping category branches, and renumbered subsequent stages to bump them up by 1 (eg old stage 5 is now stage 6 etc).
Changed menu (stage selection) links to show current stage/screen as highlighted.
Effected files:
README.htm (changed file)
byz$055_version.asp (changed file)
byz_catcheck_loops.asp (new file)
byz_prodcatcheck_$config.asp (changed file)
byz_prodcatcheck_invalidcatonmatrix.asp (changed file)
byz_prodcatcheck_invalidcatonproducts.asp (changed file)
byz_prodcatcheck_invalidprdonmatrix.asp (changed file)
byz_prodcatcheck_menu.asp (changed file)
byz_prodcatcheck_missingcatsonmatrix.asp (changed file)
byz_prodcatcheck_missingproductsonmatrix.asp (changed file)
byz_prodcatcheck_subcatsnocats.asp (changed file)
byz_prodcatcheck_sys.asp (changed file)
11 15-DEC-2009 Changed installation notes and program files to cater for VPASP V7.
Added version info to pages.
Upgraded BYZ038 (from V10 to V11)
Upgraded BYZ036 (from V05 to V06)
Effected files:
README.htm (changed file)
byz$055_version.asp (changed file; all versions)
byz_catcheck* (changed files; all versions)
byz_prodcatcheck* (changed files; all versions)
12 08-JUL-2010 Speeded up stage 5 (Infinite Loop check) and stopped it from using nested cursors which were causing problems on some servers.
Upgraded BYZ038 (from V11 to V12)
Upgraded BYZ036 (from V06 to V07)
Effected files:
README.htm (changed file)
byz$055_version.asp (changed file; all versions)
byz_catcheck_loops.asp (changed file; all versions)
13 06-NOV-2010 Further changes to speed up stage 5 (Infinite Loop check) and also rejigged the logic of stage 5 as databases with particularly large/complex category trees were causing the variables to become out of synch. This is a tuning (speed) fix as well as a bug fix.
Effected files:
README.htm (changed file)
byz$055_version.asp (changed file; all versions)
byz_catcheck_loops.asp (changed file; all versions)
14 10-DEC-2014 Created a new stage to check/fix duplicate prodcategories records.
Enhanced the overall formatting of the screens (cosmetic/style changes etc).
Changed so that when you click on a menu link (ie stage) it doesnt automatically run the corresponding check (so that you can read the notes before checking for errors, especially useful for large databases).
Changed to use BYZ038 functions/files where appropriate/possible to help keep the code simple/generic/sturdy and to minimise the differences in the files between different vpasp versions for easier maintenance.
Split documentation file into separate files and added version checker to documentation files.
Upgraded BYZ038 (from V12 to V30)
Upgraded BYZ036 (from V07 to V17)
Please Note: You must be using V30 or above of BYZ038 before upgrading to V14 or above of BYZ055.
All existing BYZ055 files were changed (and 2 new files added) by this update, so if upgrading BYZ055 from a previous version, please delete the byz$055_version.asp and byz_catcheck* and byz_prodcatcheck* files from your VPASP admin folder, and then upload the new files.
15 01-APR-2015 Upgraded BYZ038 (from V30 to V31)
Upgraded BYZ036 (from V17 to V18)
Enhanced/changed to cater for VPCart V8.
Changed instances of VP-ASP/VPASP to VPCart as VPASP has now been rebranded/renamed.
Effected Files:
README* (changed files)
All web files for this module have been changed in this version, but no web files have been deleted/created.