Demos/Samples:
(click on a link below to see the corresponding demo/sample) |
| Feed Generation Parameter/Submission |
|
Shows you a summary of how many products you have, broken-down by in/out-of stock and hidden/non-hidden).
Lets you enter lots of different options (the default values in the parameter screens can also be changed by tweaking a config file). |
| Feed Generation Results Summary |
|
Shows you the progress as it's going along.
Optionally (via a config option) tells you how many of your products had blank images (either blank in the data, or stamped on the products but not physically existing on the server).
Tells you how many products got included in the feed etc, and gives you a direct link to the generated feed file so you can download it to your pc once it's been generated. |
| Feed Generation Results - Screen Output |
|
Allows you to output a copy of the first "x" records of the feed file to the screen so you can check the values/logic without having to open the feed file. Also gives you the option of being able to see the corresponding images that are in your image columns in the feed. |
| Taxonomy (Google Product Category) Upload/Import Submission |
|
Press the browse button, pick your file from your pc via the windows file-browsing window that comes up, press the upload-file button, then press the start-import-process button, and your excel "taxonomy" spreadsheet will automatically be imported into a reference table in vpasp for you.
You can download the taxonomy excel file from google, and use auto-filter on it to delete categories that are irrelevant for your business/site, and then upload/import that trimmed-down excel file so that you don't get thousands of irrelevant categories in the edit-product taxonomy poplist. |
| Taxonomy (Google Product Category) Upload/Import Results |
|
Tells you how many categories records got imported into the vpasp "taxonomy" reference table (this table is specific to BYZ056, it's not used by the rest of vpasp). |
| Edit-Product Page's Taxonomy (Google Product Category) PopList (optional) |
|
You can optionally add a taxonomy poplist to your edit-product page simply by pasting a couple of extra lines in your shopa_addproduct.asp file (detailed instructions included with the addon). |
|
VerNo
|
Version Date
|
Release Notes
|
|
01
|
14-DEC-2004
|
Initial version - Big Yellow Zone Froogle Data Feed Utility For VP-ASP.
(single new version created from previously separated versions of BYZ002, BYZ009, BYZ010, BYZ011 which are now redundant following this combined new single version). |
|
02
|
07-APR-2005
|
Enhanced to allow for very large numbers of products |
|
03
|
10-JUL-2005
|
Enhanced to swap backslashes with forward slashes on generated product URLs and generated image URLs. Files changed were:
shopa_generatefrooglefiles.asp
byz056_install.asp
README.htm |
|
04
|
10-FEB-2006
|
Changed documentation to be VP-ASP V6-compliant.
BYZ036 Upgraded from V01 to V02.
No changes to the main froogle-file generator files were made.
Files changed:
byz056_install.asp
README.htm
BYZ036 |
|
05
|
06-MAR-2006
|
Enhanced to add missing/invalid product-image check as a new option, and submission screen format improved and parameter-field notes clarified.
Files changed were:
shopa_generatefrooglefiles.asp
shopa_generatefrooglefiles_config.asp
byz056_install.asp
README.htm |
|
06
|
22-MAR-2006
|
Minor change to cater for root paths for image data (eg /images/myimage.jpg)
Files changed:
byz056_install.asp
README.htm
shopa_generatefrooglefiles.asp |
|
07
|
05-AUG-2006
|
Enhanced to add special-character translation and to use Google Base logic/fields instead of Froogle.
All files have been changed and renamed and new files created. None of the old shopa_generatefrooglefiles* files are now used |
|
08
|
06-AUG-2006
|
Added extra notes to documentation/screen to warn of excel de-formatting date fields and to explain character translation.
Changed/corrected the translation logic.
Files changed:
byz056_install.asp
README.htm
shopa_generategooglebasefiles.asp
shopa_generategooglebasefiles_translate_chars_html_config.asp
shopa_generategooglebasefiles_translate_chars_raw_config.asp |
|
09
|
11-AUG-2006
|
Changed default config options and added more character translations. Added character translation to label-extras values as it was previously not used.
Added Supplier logic to the Brand field source options.
Files effected:
byz056_install.asp (changed)
README.htm (changed)
shopa_generategooglebasefiles_config.asp (changed)
shopa_generategooglebasefiles_translate_brands.asp (new)
shopa_generategooglebasefiles_translate_chars_raw_config.asp (changed)
shopa_generategooglebasefiles.asp (changed) |
|
10
|
16-AUG-2006
|
Changed/corrected the translation logic.
Enhanced the label fields construction to avoid spurious commas, spaces, and duplicates.
Files changed:
byz056_install.asp
README.htm
shopa_generategooglebasefiles.asp
shopa_generategooglebasefiles_translate_chars_html_config.asp
shopa_generategooglebasefiles_translate_chars_raw_config.asp |
|
11
|
18-MAY-2007
|
Changed to be compatible with VPASP V6.5.
Upgraded BYZ038 (Licensing) module to cater for VP-ASP V6.5.
Brand - existing attribute now always added to the feed, but allows blanks.
Condition - new attribute added and made compulsory, and corresponding config options created.
Location - new optional attribute added, and corresponding config option created.
Product Type - new attribute added and made compulsory, and corresponding config options created.
Label - changed to custom keywords attribute.
Category - new custom category attribute added.
Effected files:
byz056_install.asp (changed file)
README.htm (changed file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles.asp (changed file) |
|
12
|
17-OCT-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:
byz056_install.asp (deleted file)
README.htm (changed file) |
|
13
|
14-JUN-2008
|
Upgraded BYZ038 (from V08 to V09)
Substantial changes made to configuration options/logic and field derivation logic following recent changes to Googles specifications.
Changed config variable to avoid possible conflicts with other BYZ Addons (particularly with the CMS Addon, BYZ110) - tconfig_striphtml has been renamed to tconfig_gbf_striphtml.
Effected files:
README.htm (changed file)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles_system.asp (changed file) |
|
14
|
10-OCT-2008
|
Changed to tune (speed up) the processing of the products when generating the feed file.
Changed to ReDim some arrays to help reduce memory usage.
Effected files:
README.htm (changed file)
shopa_generategooglebasefiles.asp (changed file) |
|
15
|
25-OCT-2008
|
Added weight and payment columns.
Restructured to make it easier to add/change column derivations to the feed output.
Restructured processing for supplier fields to avoid additional calls to the database for each product record.
Added printing of dots and flushing to help avoid timeouts.
Changed to deal better with the SQLServer text column (memo) bug.
Effected files:
README.htm (changed file)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_categories_inc.asp (new file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles_config_details.asp (new file)
shopa_generategooglebasefiles_config_header.asp (new file)
shopa_generategooglebasefiles_formprocessing_inc.asp (new file)
shopa_generategooglebasefiles_globalvars_inc.asp (new file)
shopa_generategooglebasefiles_namedesc.asp (deleted file)
shopa_generategooglebasefiles_products_inc.asp (new file)
shopa_generategooglebasefiles_tools_inc.asp (new file)
shopa_generategooglebasefiles_translate_brands.asp (changed file) |
|
16
|
11-FEB-2009
|
Upgraded BYZ038 (from V09 to V10)
Upgraded BYZ036 (from V04 to V05)
Added version control/file.
Effected files:
README.htm (changed file)
byz$056_version.asp (new file)
shopa_generategooglebasefiles.asp (changed file) |
|
17
|
24-FEB-2009
|
Change of fields (category) logic following the withdrawal of the c:category field from GoogleBases specifications (changed c:category to use c:shopcategory instead in the header file).
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_config_header.asp (changed file) |
|
18
|
21-JUL-2009
|
Added new functions which help keep comma-separated values below a certain number (eg for keywords).
This is needed because GoogleBase have now started to restrict the number of comma-separated values allowed inside custom attributes to be no more than 9. See the Tip (restricting CSV values) topic within the BYZ056 readme file for more info.
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles_config_details.asp (changed file; call added to keywords and category field output to the BYZ_GBF_REPLACE_FORMAX_CSV_VALUE function)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_tools_inc.asp (changed file) |
|
19
|
25-AUG-2009
|
Changed price logic in the feed to take account of minimumquantity of product if set. Note that googlebase now force you to show the (minqty*unitprice) as your price in the feed file when you have a minimum quantity set for the product in question, failure to adhere to this will cause the corresponding items to be rejected by google.
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_config_details.asp (changed file) |
|
20
|
03-DEC-2009
|
Added new config options (tconfig_gbf_columns_to_query_products and tconfig_gbf_columns_to_query_categories) to allow you to speficy columns to select from products/categories (instead of the default select *) which can be used for sites which have very large numbers of products to help minimise memory usage on the main queries.
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles_formprocessing_inc.asp (changed file)
shopa_generategooglebasefiles_globalvars_inc.asp (changed file)
shopa_generategooglebasefiles_products_inc.asp (changed file) |
|
21
|
05-DEC-2009
|
Added extra config option (tconfig_gbf_breakpoint_productcount) for break-points when very large numbers of products are listed, and changed feed generation to create additional feed files at each break-point reached.
Added sql connection timeout setting so that long queries dont time out.
Tuned bottom-level category logic to use a temporary table to store the levels and trees.
NOTE: The tuning aspect of this version is a considerable improvement for large databases and will speed up the feed a lot.
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_categories_inc.asp (changed file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles_formprocessing_inc.asp (changed file)
shopa_generategooglebasefiles_globalvars_inc.asp (changed file)
shopa_generategooglebasefiles_products_inc.asp (changed file) |
|
22
|
01-JAN-2010
|
Changed to be compatible with VPASP V7 (this version does not cater for situations where xSEODynamicEnable=Yes).
Added new config options (tconfig_gbf_default_parent_exc and tconfig_gbf_default_child_exc) to be able to optionally exclude parent and/or sub products.
Added version control settings to the bottom of the shopa_generategooglebasefiles_config.asp file.
Upgraded BYZ038 (from V10 to V11)
Upgraded BYZ036 (from V05 to V06)
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_config.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_formprocessing_inc.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_globalvars_inc.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_products_inc.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_categories_inc.asp (changed file for vpaspv7+ version only)
shopa_generategooglebasefiles_translate_brands.asp (changed file for vpaspv7+ version only) |
|
23
|
13-FEB-2010
|
Added calculated category tree branch description to the end of the select-list to help avoid cursors being blanked out due to sqlserver bugs.
Upgraded BYZ038 (from V11 to V12)
Upgraded BYZ036 (from V06 to V07)
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_products_inc.asp (changed file for all vpasp versions) |
|
24
|
08-MAR-2010
|
Corrected a bug which was not allowing the last column in the products table to be found when using the BYZ_GBF_COLUMN_VALUE functions in the details config files.
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file for all vpasp versions)
shopa_generategooglebasefiles_tools_inc.asp (changed file for all vpasp versions) |
|
25
|
04-AUG-2011
|
NOTE: Your feeds will fail soon if you are still using a version of BYZ056 that is older than this version.
Please note that as from 22-Sep-2011 (when Google start enforcing their rules more strictly), you will need to be using V25 or later of BYZ056, otherwise your feeds will fail.
Added Google Product Category (taxonomy) import/logic.
A very large number of enhancements/changes have been made regarding the feed field source/logic on this version, and extensive changes made to the readme notes, and to the comments in the header/details config files.
This version of BYZ056 has been brought into line with the latest Google specs, and if you have an older version of BYZ056 then you will need to upgrade it if you want your feed to pass validation (especially after 22-Sep-2011 when the new rules will become strictly enforced by Google) or if you want your feed to be in any way workable/maintainable.
Upgraded BYZ038 (from V12 to V13)
Upgraded BYZ036 (from V07 to V08)
Added BYZ025 (V06)
Effected files:
For this version, all the googlebase feed program files have been changed, and new files have been created, and some files have been deleted.
If upgrading from a previous version of BYZ056, then please backup all your existing shopa_generategooglebasefiles* and byz$056_version.asp files, then delete them all from your site, then re-install/reconfigure BYZ056 from scratch using the latest version of the files and using the latest installation notes (the only change you wont need to re-do is adding the googlebase feed to your admin menu; everything else needs to be re-configured/re-read etc).
Also, if upgrading from a previous version, and if you have BYZ163 installed, then make sure you re-apply the relevant changes to make the googlebase feed use static urls (see the BYZ163 usage notes for more info). |
|
26
|
17-AUG-2011
|
Added export option for the imported taxonomy so that if you lose the original trimmed-down excel file that you imported the taxonomy with then you can export the data from vpasp back into a Google Taxonomy format excel file, change it, then re-import.
Added a second export option so that you can export the taxonomy in vpasp format (eg if using BYZ089 and you want to copy/paste the vpasp-formatted taxonomy, ie literals, not separate columns for each branch).
Changed the ordering of the taxonomy poplist in the edit products page (to order by the tree description alphabetically instead of ordering by the row numbers of the spreadsheet that it was imported with).
Added productmatch logic (for sites that use the same database but for different sites/shops), and customer match logic, and various other aspects such as logged-in related fields to restrict relevant data from the output.
Please Note: If upgrading from a previous version of BYZ056, then you must make sure you are using BYZ038 V13 or above before upgrading BYZ056; V26 of BYZ056 or afterwards will not work if your version of BYZ038 is V12 or below.
(for list of effected files, see the BYZ056 readme doc that comes with the zip) |
|
27
|
31-AUG-2011
|
Added more logic to help avoid cursors being blanked out due to sqlserver/vpasp bugs.
Please Note: You must be using V14 or later of BYZ038 before upgrading to V27 or later of BYZ056.
BYZ056 V27 or later will not work with V13 or below of BYZ038.
Upgraded BYZ038 (from V13 to V14)
Upgraded BYZ036 (from V08 to V09)
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles_categories_inc.asp (changed file)
shopa_generategooglebasefiles_products_inc.asp (changed file)
shopa_generategooglebasefiles_tools_inc.asp (changed file)
shopa_generategooglebasefiles_translate_brands.asp (changed file) |
|
28
|
28-SEP-2011
|
Added extra config option (tconfig_gbf_product_whereclause_restriction) and parameter field so that you can exclude products matching a certain criteria from the feed via a where clause restriction (eg to exclude products that dont have a UPC or MPN+Brand on them).
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles_formprocessing_inc.asp (changed file)
shopa_generategooglebasefiles_globalvars_inc.asp (changed file)
shopa_generategooglebasefiles_products_inc.asp (changed file) |
|
29
|
01-NOV-2011
|
Added extra options for Age Group, Gender, Colors, and Sizes, and added extra logic to create split feed rows (for variants), ie to cover all color/size permutations of a given product.
Added extra option to be able to exclude a given product from the feed output during the processing of the product by setting a flag in the shopa_generategooglebasefiles_config_details.asp file.
Changed the additional image logic to not output an additional image if its the same url as the main large image thats already specified.
Upgraded BYZ038 (from V14 to V15)
Upgraded BYZ036 (from V09 to V10)
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles.asp (changed file)
shopa_generategooglebasefiles_config.asp (changed file)
shopa_generategooglebasefiles_config_details.asp (changed file)
shopa_generategooglebasefiles_config_details_splits.asp (new file)
shopa_generategooglebasefiles_config_header.asp (changed file)
shopa_generategooglebasefiles_export_admin.asp (changed file)
shopa_generategooglebasefiles_export_admin_vpasp.asp (changed file)
shopa_generategooglebasefiles_formprocessing_inc.asp (changed file)
shopa_generategooglebasefiles_generate.asp (changed file)
shopa_generategooglebasefiles_globalvars_inc.asp (changed file)
shopa_generategooglebasefiles_import_admin.asp (changed file)
shopa_generategooglebasefiles_import_admin_uploadfile.asp (changed file)
shopa_generategooglebasefiles_products_inc.asp (changed file)
shopa_generategooglebasefiles_tools_inc.asp (changed file) |
|
30
|
10-JAN-2012
|
Changed the image url construction logic as some permutations of shop urls and image values were not calculating the correct url (and were therefore coming up as missing images).
Also changed the file-existence check for images to use a more efficient method.
Please Note: You must be using V15 or later of BYZ038 before upgrading to V30 or later of BYZ056.
BYZ056 V30 or later will not work with V14 or below of BYZ038.
Effected files:
README.htm (changed file)
byz$056_version.asp (changed file)
shopa_generategooglebasefiles_tools_inc.asp (changed file) |
|
31
|
05-FEB-2012
|
Added new options on the parameter screen (and in the main config file) so that you can output the feed headings/data to the admin screen as well as to feed files (to allow easier debugging/tweaking of the config options and as confirmation that the feed is showing the right type of data and using the right logic etc).
For screen output of the feed files, you can specify how many lines you want to display on screen (eg if you have a feed file of 10,000 products, you can choose to only view the first 10 data rows of the feed on-screen as a double-check before you submit your feed file to google).
Corrected the csv-to-arrays function (used for sizes and colors arrays on split-products etc) as it was missing the last returned value in the list (as the ParseRecord generic vpasp function fails to return null values where appropriate).
Changed various function calls in the feed to use the new BYZ038 functions where appropriate instead of having a feed-specific version of the function.
Made minor corrections to some of the admin screen html.
Upgraded BYZ038 (from V15 to V16)
Upgraded BYZ036 (from V10 to V11)
Please Note: You must be using V16 or later of BYZ038 before upgrading to V31 or later of BYZ056.
BYZ056 V31 or later will not work with V15 or below of BYZ038.
(for list of effected files, see the BYZ056 readme doc that comes with the zip) |
