Software Search
Search For:
In Price Range (GBP) :
£ - £


or: all BigYellowZone software
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.

BYZ089 - Bulk Product Updater for VPASP
<< back to previous screen

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


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

This product includes:
BYZ038
BYZ036
BYZ025
Latest version:06/13-JUL-2010
From vendor:BigYellowZone
Price:£40.00
add to cart

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

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

Sample Screen Snapshots:
(all of the following snapshots are part of a single screen, but we've split-up the images so you can see what each section of the screen is for and how it flows - click on a link below to see the screenshot)
1. Set your Search Criteria (ie tell it which products to update)
2. Choose what changes you want to make (ie tell it what update to do)
3. Do a test run to see which products are effected and how they're effected
4. Do a live run to update your products


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




For further information from the vendor about this product, please visit:
http://www.bigyellowzone.com/shopexd.asp?id=103

Full Version History:
VerNo Version Date Release Notes
01 28-JUL-2005 Initial version - Big Yellow Zone Bulk Product Update 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)