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)

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.

Released: 6/16/2014 2:05:00 PM
Full list of Demos Now Available in one place! Click Here to see our new Demo area/list, or click on the "Demos" link at the top/right of the screen.

Released: 3/9/2014 2:05:00 PM
New modules released:
Speed Tester
Error Logger
SQLServer Space Clearer
Click Here to See What Other New Modules we have
or click here to see newly released enhancements/fixes

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 within the next day or so.

Cross-Selling Enhanced/Secondary Template Fields for VP-ASP - BYZ086

<< back to previous screen

Shows cross-sold products for a given product in a more flexible way, and also displays cross-sold products for what the customer currently has in their cart.



Cross-Selling Enhanced/Secondary Template Fields for VP-ASP - BYZ086
Latest version:05/05-MAR-2010
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:£25.00
add to cart


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

This product includes:
BYZ038
BYZ036
BYZ033

Demos/Samples:
(click on a link below to see the corresponding demo/sample)
Standard Listing
Side-by-side with also-bought (BYZ080)
Mini-Cart Listing


This add on will work straight out of the box but we've also made it easy to customise so that you can use your own html tags.

You can set your own values in the header, trailer, and body files, we've made available some extra values that you can use if you want to, such as:

1) Current Display Record Number (relevant to body only)

2) Total Number of Records Shown (available to header, body, and trailer) - Yes, that's right, the total number of records that will be displayed is even available on the header, before they've been shown, (and the body, before they've all been shown) so that you can use that value in the header/body if you want, and not just in the trailer.


Technical/Developer Information:
1) Headers
You can change the heading to read what you like (e.g. "Related Products...." or "Other products of interest ...." etc.)

2) Trailers
As per the headers, you can add a customisable trailer.

3) Body
You can format the way the list of products is presented. You can change where it links to (product pages, category pages, templated pages etc.), the format of the text, etc.

4) Max Records to show
By default it'll only show the top-5 matching records in the list, but you can change this to any value you want (including blank to not use max-records and to display everything).

5) Use product codes in your cross-selling lists
You can configure it to use any product column you like for the cross-selling matching. For example, you can set it to use "ccode" and record the list of product codes in your cross-selling field instead of catalogids.

6) Use other columns to store the list
You can configure it to use any product column you like for the source of the cross-selling list. For example, if you already use crossselling to store the cross-selling list, then you can set this up to use "pother1" for your secondary cross-selling list.

7) SQL Logic/Query
This feature controls how your products are extracted from your database. Any values that you select in this statement will automatically be available from within the body (point 3). By default it will return every column in the products table. You can add extra columns/joins (e.g. supplier names etc), or you can change the ordering, or you can even change the matching-logic.


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 25-JUN-2005 Initial version - Big Yellow Zone Cross-Selling Template Fields For VP-ASP
02 15-SEP-2005 Changed the ordering of the cross-sold products in its query. This was done to avoid unable to order by text columns in SQLServer, but applies to all database types as the extendeddesc ordering was spurious anyway. It now orders the cross-sold products by cname,catalogid.
Files effected were:
README.htm (changed file)
byz086_install.asp (changed file)
byz_template_codes_functions_cross_selling_config_generatesql.asp (changed file)

Note that this version was actually released on 15-Sep-2006, but has been set to 15-Sep-2005 here as the byz086_install.asp file had the wrong date in it for this version and the install.asp date is needed in preference to the actual version date in order for successful byz/byk backfills to work.
03 12-AUG-2007 Upgraded BYZ038 (Licensing) module to cater for VP-ASP V6.5.
Upgraded BYZ033 (Template Fields) module for additional argument types.
Changed body to default to showing thumbnails and descriptions and prices.
Enhanced to cater for split databases.
Enhanced to cater for sqlserver text (memo) bugs.
Enhanced to cater for stock levels, product match, customer match, and sub-products.
Files effected:
README.htm (changed file)
byz086_install.asp (changed file)
byz_template_codes_functions_cross_selling.asp (changed file)
byz_template_codes_functions_cross_selling_config.asp (changed file)
byz_template_codes_functions_cross_selling_config_generatesql.asp (changed file)
byz_template_codes_functions_cross_selling_config_html_body.asp (changed file)
byz_template_codes_functions_cross_selling_config_html_header.asp (changed file)
04 03-SEP-2007 Added new functionality to allow the merchant to show relevant cross-sold lists on the view-cart/order pages.
Files effected were:
README.htm (changed file)
byz086_install.asp (changed file)
byz_template_codes_codes_cross_selling.asp (changed file)
byz_template_codes_functions_cross_selling.asp (changed file)
byz_template_codes_functions_cross_selling_config.asp (changed file)
byz_template_codes_functions_cross_selling_config_generatesql.asp (changed file)
byz_template_codes_functions_cross_selling_config_html_cart_body.asp (new file)
byz_template_codes_functions_cross_selling_config_html_cart_header.asp (new file)
byz_template_codes_functions_cross_selling_config_html_cart_trailer.asp (new file)
05 05-MAR-2010 Upgraded BYZ038 (from V07 to V12)
Upgraded BYZ036 (from V02 to V07)
Upgraded BYZ033 (from V04 to V09)
Changed to be compatible with VPASP V7.
Corrected a bug which was not allowing the last column in the products table to be found when using the BYZ_CRS_PRODUCTVALUE function in the body config files.
NOTE: If upgrading from a previous version, please note that the installation process now needs you to also add includes to the byz_sys_cust_vars_inc.asp and byz_sys_cust_fun_inc.asp files, see installation notes for more info.
Files effected:
README.htm (changed file)
byz086_install.asp (deleted file; all vpasp versions)
byz$086_version.asp (new file; all vpasp versions)
byz_crs_vars_inc.asp (new file; all vpasp versions)
byz_crs_fun_inc.asp (new file; all vpasp versions)
byz_template_codes_functions_cross_selling.asp (changed file; all vpasp versions)
byz_template_codes_functions_cross_selling_config_generatesql.asp (changed file; vpaspv7+ version only)