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.

Bulk Product Updater for VPCart - BYZ089

<< back to previous screen

This time saving utility allows you to perform bulk product updates based on selectable criteria.



Bulk Product Updater for VPCart - BYZ089
Latest version:11/08-SEP-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:£40.00
add to cart


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

This product includes:
BYZ038
BYZ036
BYZ025

Demos/Samples:
(click on a link below to see the corresponding demo/sample)
Define your Search Criteria Parameter block which tells the module which products to update.
Define your Changes Parameter block which tells the module what changes to make to the "hit" products.
Perform a Test Run Results block from doing a test run to see which products are effected by the proposed update and how they're effected.
Do a live run to update your products Results block from doing a live (update) run to apply the changes and see which products were effected by the update and how they were effected.


For example, you might want to increase all your prices by 10%, or you might want to change all your Hide values from Yes to No, or you might want to add $2.00 to all your product prices within a single category, or you might want to add a given set of products to a category (or remove them from a category), or you might want to strip-out all instances of "Special Offer" from your product descriptions, or you might want to correct typos changing all instances of "komputer" to "computer" in your product names.

First you define the criteria that you want to use to find the products that you want to change, then you choose what you want to update, then choose/enter the type of change that you want to make.

It also allows you to do a test run so that you can see your potential changes before they get applied so that you can double-check your settings before you apply the change.

Customer quote:
You just turned 100's of hours of work into minutes..... it just so saves the man hours required to maintain a big site.

Mitchell Wilson
APS Water Services Corporation
www.aspwater.com


Technical/Developer Information:
Change Example
Increase / decrease number fields by a percentage Increase all your prices by 10%
Increase / decrease number fields by a fixed amount Take $5 off prices in a specific category for a special offer (so you can now run daily promotions!)
Set a number field to a specific value Set all products that were $2.99 to $3.99
Set yes / no field values Release a whole category of products for sale at the same time by changing hide from N to Y
Set text field values Change manufacturers name when switching suppliers for selected products
Use powerful SQL statements to perform more complex updates. Decrease price by 10% for all stock items with more than 10 in stock.
Add products to a category. Add all products that are priced under $10 to your "Special Offers" category if you're running a sale.
Remove products from a category. Take all your products that are between $5 and $10 out of your "Special Offers" category (if you're running a new sale of lower values than before).
Strip out text strings. Delete the words "special offer" from all your product descriptions.
Replace text strings. Change all instances of "Christmas" to "Easter" in all your product extended descriptions


The sql "Replace" function isn't available to Access databases via ADO (web based programs), and also can't work on SQLServer text/ntext (memo) fields, and similar logic applies to MySQL; so we've created a function that you can use in BYZ089 to do case-sensitive (or case-insensitive) replaces on any product field on any database.

This means that you can now strip out text values, or swap text values, within your fields via BYZ089.


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 28-JUL-2005 Initial version - Big Yellow Zone Bulk Product Updater For VP-ASP
02 04-FEB-2006 Checked and tweaked files and documentation to be fully compatible with VP-ASP V6 and added notes/help on the Replace function problem with some Access Jet Engines.
Files changed:
byz089_install.asp
byz_bku_bulkupdate.asp
byz_bku_config.asp
README.htm
03 29-JUL-2006 Added new styles/titles for the submission buttons to more easily tell the difference between test run and live run.
Files changed:
byz089_install.asp
byz_bku_bulkupdate.asp
byz_bku_admin.css
README.htm
04 18-OCT-2007 Upgraded BYZ038 (from V06 to V08)
Upgraded BYZ036 (from V02 to V04)
Upgraded BYZ025 (from V02 to V03)
Changed instructions to be compatible with bigyellowkey.com licensing notes.
Effected files:
byz089_install.asp (deleted file)
README.htm (changed file)
05 13-JUL-2008 Changed to automatically detect the existence of version-specific category columns (the byz_bku_config_vpaspversion config option is no longer used/in-place).
Changed to cater for separate products databases.
Upgraded BYZ038 (from V08 to V09)
Files effected:
byz_bku_bulkupdate.asp (changed file)
byz_bku_categorytreedatautils.asp (changed file)
byz_bku_config.asp (changed file)
byz_bku_inc.asp (changed file)
byz_bku_system.asp (changed file)
README.htm (changed file)
06 13-JUL-2010 Upgraded BYZ038 (from V09 to V12)
Upgraded BYZ036 (from V04 to V07)
Upgraded BYZ025 (from V03 to V06)
Added version control file.
Restructured to simplify category tree logic and to help minimise memory usage.
Altered to cater for sql/ado text/ntext (memo) bugs.
General visual enhancements made to screen.
Changed stylesheet to be included within the screen itself so that it doesnt need to be applied to the general admin header files.
Added extra options so that you can add/remove products to/from a given category in bulk.
Made compatible with VPASP V7.
Effected files:
README*.htm (changed files)
byz$089_version.asp (new file)
byz_bku_admin.css (changed file)
byz_bku_bulkupdate.asp (changed file)
byz_bku_categorytreedatautils.asp (deleted file)
byz_bku_categorytreedatautils_config.asp (deleted file)
byz_bku_config.asp (deleted file)
byz_bku_inc.asp (deleted file)
byz_bku_inc_fun.asp (new file)
byz_bku_inc_vars.asp (new file)
byz_bku_system.asp (deleted file)
07 28-DEC-2010 Added BYZSQLREPLACE functionality so that you can use Replace logic to swap/strip-out text strings (standard SQL Replace functions are not available for Access databases on ADO, or for SQLServer Text (memo) columns etc, so this extra functionality has been added so that you can replicate what a SQL Replace function does even though its not available/possible to do it via SQL/ADO; the BYZSQLREPLACE function also has a case-sensitive/insensitive option).
Added more data types and logic to the check when finding out the datatype of columns and when retrieving their values from cursors into arrays.
Split-out vpasp-version-specific differences into separate files so that the core logic can be common where possible (to allow for easier maintenance of the addon).
Added detailed usage notes.
Effected files:
README*.htm (changed files)
byz$089_version.asp (changed file)
byz_bku_bulkupdate.asp (changed file)
byz_bku_inc_fun.asp (changed file)
byz_bku_inc_fun_headers.asp (new file)
byz_bku_inc_fun_opendb.asp (new file)
byz_bku_inc_fun_startup.asp (new file)
byz_bku_inc_vars.asp (changed file)
byz_bku_inc_vars_version.asp (new file)
byz_bku_inc_vpasp_inc.asp (new file)
08 17-FEB-2011 Added extra encoding logic to cater for special characters better (html characters and other special characters) in the fields, data, and output.
Effected files:
README*.htm (changed files)
byz$089_version.asp (changed file)
byz_bku_bulkupdate.asp (changed file)
byz_bku_inc_fun.asp (changed file)
09 01-SEP-2011 Added more logic to help avoid cursors being blanked out due to sqlserver/vpasp bugs.
Added flushing commands to avoid buffer overflow errors when a large number of products are being displayed.
Added extra parameter to be able to restrict the number of products displayed on the results section.
Applied some minor html corrections/changes.
Please Note: You must be using V14 or later of BYZ038 before upgrading to V09 or later of BYZ089.
BYZ089 V09 or later will not work with V13 or below of BYZ038.
Upgraded BYZ038 (from V12 to V14)
Upgraded BYZ036 (from V07 to V09)
Effected files:
README*.htm (changed files)
byz$089_version.asp (changed file)
byz_bku_inc_fun.asp (changed file)
byz_bku_inc_vars.asp (changed file)
byz_bku_bulkupdate.asp (changed file)
10 06-JAN-2014 Enhancements made to deal with European-style decimals (ie with commas instead of periods).
Boolean column logic fixed for access databases.
Changed to use BYZ038 tools/functions where appropriate.
Added version checks to documentation files.
Upgraded BYZ038 (from V14 to V28)
Upgraded BYZ036 (from V09 to V17)
Upgraded BYZ025 (from V06 to V08)
Please Note: You must be using V28 or later of BYZ038 before upgrading to V10 or later of BYZ089.
BYZ089 V10 or later will not work with V27 or below of BYZ038.
Effected files:
README*.htm (changed files)
byz$089_version.asp (changed file)
byz_bku_bulkupdate.asp (changed file)
byz_bku_inc_fun.asp (changed file)
byz_bku_inc_fun_headers.asp (deleted file)
byz_bku_inc_fun_opendb.asp (changed file)
byz_bku_inc_fun_startup.asp (deleted file)
byz_bku_inc_vars.asp (changed file)
byz_bku_inc_vars_version.asp (deleted file)
byz_bku_inc_vpasp_inc.asp (deleted file)
11 08-SEP-2015 Upgraded BYZ038 (from V28 to V34)
Upgraded BYZ036 (from V17 to V18)
Upgraded BYZ025 (from V08 to V09)
Changed the category-tree logic to avoid problems with too many nested cursors.
Cleaned up the html in the screen.
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)
vpcartv4.5to5.5/byz$089_version.asp (changed file)
vpcartv4.5to5.5/byz_bku_bulkupdate.asp (changed file)
vpcartv4.5to5.5/byz_bku_inc_fun.asp (changed file)
vpcartv6.0to6.5/byz$089_version.asp (changed file)
vpcartv6.0to6.5/byz_bku_bulkupdate.asp (changed file)
vpcartv6.0to6.5/byz_bku_inc_fun.asp (changed file)
vpcartv7/byz$089_version.asp (changed file)
vpcartv7/byz_bku_bulkupdate.asp (changed file)
vpcartv7/byz_bku_inc_fun.asp (changed file)
vpcartv8andabove* (new files)