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 File Management Enhancements for VPCart (Static Product Detail Pages) - BYZ163

<< back to previous screen

Create search engine friendly product pages at the push of a button.



Product File Management Enhancements for VPCart (Static Product Detail Pages) - BYZ163
Latest version:12/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:£50.00
add to cart


Compatibility, Bundling, and Status Notes:
Compatible with VPCart V4.5 to V8
This bundle includes:
BYZ038
BYZ036
BYZ033
BYZ143

Demos/Samples:
(click on a link below to see the corresponding demo/sample)
Demo System Our demo area is loaded with most of the SEO modules, BYZ110 for static content pages, BYZ163 for static product-detail pages, BYZ164 for static category pages, BYZ116 for enhanced searching/paging, BYZ121 for related-categories on search results, BYZ158 for the browsable sitemap, BYZ161 for predictive search on the search mini-form at the top.


Use the "Product File Manager" (a suite of admin screens provided with the addon) to automatically set filenames on your product records and then create all those files in bulk.


Technical/Developer Information:
The "Product File Manager" has 5 screens/tools:

1) Auto-Set FileName data
Using an existing column as your base (such as cname, or cdescription) you can set all your product record filename values to an automatically-translated valid filename (eg turn "Sony TV" as a product name value to "sony-tv.asp" in your filename field) - This can be done in a single shot without editing the individual records. This also has a test-run facility so that you can see the old/new file status without updating the data.
It also allows you to base your urls on multiple product columns if you want to, using logic that you can easily tweak, for example you can use ccode and cname and text between those 2 values as your value to base the static url on.

2) Bulk-Edit FileName data
Using a multi-record screen (one row per product record), you can, if you want, edit all your filename values in one simple screen.

3) Validate FileName data
Displays a summary of any product records which have invalid (or duplicate) filename values.

4) Create Folders
Automatically create any missing product folders using your product filename data (this stage/option is only relevant/usable if you've also got BYZ027 installed).

5) Create Files
Press a button to generate all your static product files in one go. This also has a test-run facility so that you can see the old/new file status without creating the new files.



If using the combination of BYZ027 and BYZ163 then you can create any product file in any folder with any name, and validate/generate all the folders/files at the push of a button (if you're not using BYZ027 then the static product files can only be browsed from your main VPCart folder). We know that VPCart V7/V8 already allows you to do something similar, but this is a totally dedicated product file/folder management solution/sub-system.

Redirection from your dynamic (shopexd.asp) urls to the corresponding static (eg "sony-tv.asp") files is included within the module; you can configure it to do "301" redirects, "Canonical" header tags, or no redirection. 301 and canonical will allow search engines to not penalise duplicate urls and will keep your ranking. This module will also allow you to change your static urls (eg "sonytv.asp" to "sony-tv.asp") and the old static url will automatically redirect/canonical-tag in the same way when people land on the old static page.


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 13-APR-2010 Initial version - Big Yellow Zone Product File Management Enhancements for VP-ASP
02 07-JUN-2010 Changed to cater for SqlServer text/ntext bugs (where cursors get blanked out).
Changed folder/file logic for calculating the urls and physical files etc.
Added extra option to be able to display only the records with errors on the filenames in the edit-filenames screen.
Added maximum number of records to display as parameters.
Added physical file check when redirecting (and when getting the static filename) so that if the static filename is set on the data but the file doesnt exist yet/anymore on the server then the user will stay on the dynamic page and not get sent to a non-existent static page so that you dont get 404 (page not found) errors while tweaking your static filename data.
Files effected:
README*.htm (changed files)
byz$163_version.asp (changed file; all vpasp versions)
byz_pfm_$config.asp (changed file; all vpasp versions)
byz_pfm_inc_fun.asp (changed file; all vpasp versions)
byz_pfm_inc_vars.asp (changed file; all vpasp versions)
byz_pfm_redirection_inc.asp (changed file; all vpasp versions)
byz_pfm_redirection_shopexd_inc.asp (changed file; all vpasp versions)
byz_pfm_createfiles_bulk_editdata.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_filecreate.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_foldercreate.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_setdata.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_valdata.asp (changed file; for vpasp 6.5 or below)
admin/byz_pfm_createfiles_bulk_editdata.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_filecreate.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_foldercreate.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_setdata.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_valdata.asp (changed file; for vpasp v7 or above)
03 13-JUL-2010 Added extra logic to the admin screens to help avoid timeouts and buffer errors, and added an extra (optional) installation step to explain how to create an index on the filename column.
Files effected:
README*.htm (changed files)
byz$163_version.asp (changed file; all vpasp versions)
byz_pfm_createfiles_bulk.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_editdata.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_filecreate.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_foldercreate.asp (changed file; for vpasp 6.5 or below)
byz_pfm_createfiles_bulk_valdata.asp (changed file; for vpasp 6.5 or below)
admin/byz_pfm_createfiles_bulk_editdata.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_filecreate.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_foldercreate.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_setdata.asp (changed file; for vpasp v7 or above)
admin/byz_pfm_createfiles_bulk_valdata.asp (changed file; for vpasp v7 or above)
04 18-FEB-2011 Added extra redirection logic so that static urls can be changed, and the old static file will redirect (or use a canonical tag depending on your config options) to the corresponding new static url.
Files effected:
README*.htm (changed files)
byz$163_version.asp (changed file; all vpasp versions)
byz_pfm_redirection_inc.asp (changed file; all vpasp versions)
05 23-FEB-2011 Added a new variable (byz_pfm_thispage_product_detail_flag) to hold a flag to say whether or not the user is currently browsing a product detail page (works for shopexd.asp browsing urls, and also on static equivalents) so that relevant code can be added by the site-owner for different kinds of tag/header formatting etc. This will automatically be set to Y for all product detail pages, and N for all other pages.
Added a new variable (byz_pfm_thispage_product_catalogid) to hold the current catalogid being browsed; this will automatically be set if youre on a product detail page, otherwise itll be null/empty. If set, itll be a CLng casted datatype.
Added extra installation steps to help avoid copying static urls onto new products when you use the copy-record process in admin, and to label the static URL field in the admin edit-product page.
Added BYZ033 (V09).
Added extra functions and template fields to get the product detail urls for different formats/instances.
Changed redirection default config option to be NONE (and changed usage notes accordingly) so that its only enabled after the site owner has checked the static pages following their first file-creation run.
Corrected html error on the stage 2 screen.
Files effected:
README*.htm (changed files)
byz$163_version.asp (changed file; all vpasp versions)
byz_pfm_$config.asp (changed file; all vpasp versions)
byz_pfm_$config_bcarg.asp (new file; all vpasp versions)
byz_pfm_createfiles_bulk_editdata.asp (changed file; for vpasp 6.5 or below)
byz_pfm_inc_vars.asp (changed file; all vpasp versions)
byz_pfm_inc_fun.asp (changed file; all vpasp versions)
byz_pfm_redirection_inc.asp (changed file; all vpasp versions)
byz_pfm_redirection_shopexd_inc.asp (changed file; all vpasp versions)
byz_template_codes_codes_pfm.asp (new file; all vpasp versions)
byz_template_codes_functions_pfm.asp (new file; all vpasp versions)
admin/byz_pfm_createfiles_bulk_editdata.asp (changed file; for vpasp v7 or above)
06 28-APR-2011 Upgraded BYZ038 (from V12 to V13).
Upgraded BYZ036 (from V07 to V08).
Upgraded BYZ033 (from V09 to V11).
Added 2 new config options (xbyz_pfm_config_parent_exc and xbyz_pfm_config_child_exc) to allow for exclusion of parent and/or child products from using static urls.
Split out some admin screen logic into separate files to allow for easier maintenance when dealing with vpasp version-specific differences.
Files effected:
README*.htm (changed files)
vpaspv6.5andbelow/byz$163_version.asp (changed file)
vpaspv6.5andbelow/byz_pfm_$config.asp (changed file)
vpaspv6.5andbelow/byz_pfm_admin_inc_fun_opendb.asp (new file)
vpaspv6.5andbelow/byz_pfm_admin_inc_fun_startup.asp (new file)
vpaspv6.5andbelow/byz_pfm_admin_inc_vars_version.asp (new file)
vpaspv6.5andbelow/byz_pfm_admin_vpasp_inc.asp (new file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_editdata.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_filecreate.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_foldercreate.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_setdata.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_valdata.asp (changed file)
vpaspv6.5andbelow/byz_pfm_inc_vars.asp (changed file)
vpaspv6.5andbelow/byz_pfm_redirection_inc.asp (changed file)
vpaspv6.5andbelow/byz_template_codes_functions_pfm.asp (changed file)
vpaspv7andabove/byz$163_version.asp (changed file)
vpaspv7andabove/byz_pfm_$config.asp (changed file)
vpaspv7andabove/byz_pfm_inc_vars.asp (changed file)
vpaspv7andabove/byz_pfm_redirection_inc.asp (changed file)
vpaspv7andabove/byz_template_codes_functions_pfm.asp (changed file)
vpaspv7andabove/admin/byz_pfm_admin_inc_fun_opendb.asp (new file)
vpaspv7andabove/admin/byz_pfm_admin_inc_fun_startup.asp (new file)
vpaspv7andabove/admin/byz_pfm_admin_inc_vars_version.asp (new file)
vpaspv7andabove/admin/byz_pfm_admin_vpasp_inc.asp (new file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_editdata.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_filecreate.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_foldercreate.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_setdata.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_valdata.asp (changed file)
07 28-MAY-2011 Added extra template fields so that a template can get the product detail url for a given catalogid even if the template-file in question is processing a different catalogid or is not processing a products record.
Files effected:
README*.htm (changed files)
vpaspv6.5andbelow/byz$163_version.asp (changed file)
vpaspv6.5andbelow/byz_template_codes_codes_pfm.asp (changed file)
vpaspv6.5andbelow/byz_template_codes_functions_pfm.asp (changed file)
vpaspv7andabove/byz$163_version.asp (changed file)
vpaspv7andabove/byz_template_codes_codes_pfm.asp (changed file)
vpaspv7andabove/byz_template_codes_functions_pfm.asp (changed file)
08 20-JUL-2011 Changed file/folder encoding to deal better with special characters (eg to return tea-pot-and-kettle.asp instead of tea-pot-kettle.asp by replacing ampersands with and etc).
Added an extra note to the usage file to explain how to change the bc=no argument logic when you also have BYZ116+BYZ164 installed.
Files effected:
README*.htm (changed files)
vpaspv6.5andbelow/byz$163_version.asp (changed file)
vpaspv6.5andbelow/byz_pfm_system.asp (changed file)
vpaspv6.5andbelow/byz_pfm_inc_fun.asp (changed file)
vpaspv6.5andbelow/byz_pfm_admin_$configencoding.asp (new file)
vpaspv6.5andbelow/byz_pfm_admin_menu.asp (changed file)
vpaspv6.5andbelow/byz_pfm_admin_fun_encode_file.asp (new file)
vpaspv6.5andbelow/byz_pfm_admin_fun_encode_folder.asp (new file)
vpaspv7andabove/byz$163_version.asp (changed file)
vpaspv7andabove/byz_pfm_system.asp (changed file)
vpaspv7andabove/byz_pfm_inc_fun.asp (changed file)
vpaspv7andabove/admin/byz_pfm_admin_$configencoding.asp (new file)
vpaspv7andabove/admin/byz_pfm_admin_menu.asp (changed file)
vpaspv7andabove/admin/byz_pfm_admin_fun_encode_file.asp (new file)
vpaspv7andabove/admin/byz_pfm_admin_fun_encode_folder.asp (new file)
09 23-AUG-2011 Added extra option so that you can base the static url on more than one product column and so that you can use complex logic when calculating the values to base the URL on.
eg to use the product code and name and literal text between etc.
This relates to the xbyz_pfm_default_product_base_columnname config option in the byz_pfm_$config.asp file which now allows a value of {calc} for those kind of complex base url derivations, which in turn gets calculated using the new byz_pfm_admin_$configbaseurl.asp file.
Files effected:
README*.htm (changed files)
vpaspv6.5andbelow/byz$163_version.asp (changed file)
vpaspv6.5andbelow/byz_pfm_$config.asp (changed file)
vpaspv6.5andbelow/byz_pfm_admin_$configbaseurl.asp (new file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_setdata.asp (changed file)
vpaspv7andabove/byz$163_version.asp (changed file)
vpaspv7andabove/byz_pfm_$config.asp (changed file)
vpaspv7andabove/admin/byz_pfm_admin_$configbaseurl.asp (new file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_setdata.asp (changed file)
10 18-SEP-2011 Changed the function which checks the static file exists to use a more efficient method.
Changed the function which gets the column values/names for a given query to use the BYZ method instead of the generic VPASP method as some versions of VPASP have bugs in the GetFieldValues logic.
Changed the admin screens to use the generic BYZ cursor opening/closing functions to help avoid cursors getting blanked-out with 8k/memo (text/ntext) bugs.
Added extra notes to explain Ongoing Maintenance on the usage notes.
Upgraded BYZ038 (from V13 to V14).
Upgraded BYZ036 (from V08 to V09).
Upgraded BYZ033 (from V11 to V12).
Please Note: If upgrading from a previous version of BYZ163, you must make sure you are using V14 or above of BYZ038 before upgrading to BYZ163 V10 or above.
Files effected:
README*.htm (changed files)
vpaspv6.5andbelow/byz$163_version.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_editdata.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_filecreate.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_foldercreate.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_setdata.asp (changed file)
vpaspv6.5andbelow/byz_pfm_createfiles_bulk_valdata.asp (changed file)
vpaspv6.5andbelow/byz_pfm_inc_fun.asp (changed file)
vpaspv7andabove/byz$163_version.asp (changed file)
vpaspv7andabove/byz_pfm_inc_fun.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_editdata.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_filecreate.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_foldercreate.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_setdata.asp (changed file)
vpaspv7andabove/admin/byz_pfm_createfiles_bulk_valdata.asp (changed file)
11 27-NOV-2011 Changed more functions to use the generic BYZ cursor opening/closing functions to help avoid cursors getting blanked-out with 8k/memo (text/ntext) bugs and to use less memory.
Upgraded BYZ038 (from V14 to V15).
Upgraded BYZ036 (from V09 to V10).
Upgraded BYZ033 (from V12 to V13).
Files effected:
README*.htm (changed files)
vpaspv6.5andbelow/byz$163_version.asp (changed file)
vpaspv6.5andbelow/byz_pfm_redirection_inc.asp (changed file)
vpaspv7andabove/byz$163_version.asp (changed file)
vpaspv7andabove/byz_pfm_redirection_inc.asp (changed file)
12 01-APR-2015 Upgraded BYZ038 (from V15 to V31).
Upgraded BYZ036 (from V10 to V18).
Upgraded BYZ033 (from V13 to V20).
Upgraded BYZ143 (from V03 to V05).
Enhanced/changed to cater for VPCart V8.
Changed instances of VP-ASP/VPASP to VPCart as VPASP has now been rebranded/renamed.
Added extra logic to set the currenturl session value as appropriate.
Corrected target link in the admin screen for the version block.
Effected Files:
README* (changed files)
vpcartv6.5andbelow/byz$163_version.asp (changed file)
vpcartv6.5andbelow/byz_pfm_$config.asp (changed file)
vpcartv6.5andbelow/byz_pfm_admin_menu.asp (changed file)
vpcartv6.5andbelow/byz_pfm_createfiles_bulk_foldercreate.asp (changed file)
vpcartv6.5andbelow/byz_pfm_redirection_shopexd_inc.asp (changed file)
vpcartv7andabove/byz$163_version.asp (changed file)
vpcartv7andabove/byz_pfm_$config.asp (changed file)
vpcartv7andabove/byz_pfm_redirection_shopexd_inc.asp (changed file)
vpcartv7andabove/admin/byz_pfm_admin_menu.asp (changed file)
vpcartv7andabove/admin/byz_pfm_createfiles_bulk_foldercreate.asp (changed file) (changed file)