Software Search
or: browse all software/services
Categories
SEO (19)
WebSite Software (71)
E-Commerce (69)
Database Tools (13)
Security Tools (6)
Image Tools (6)
Developer Tools (24)
Data Management Tools (18)
Admin Tools (29)
WebSite Visitor Experience (32)
B-2-Customer Interaction (6)
Services (Points) (6)
Subscriptions (5)
Shopping Carts »
    AspDotNetStorefront (8)
    Magento (8)
    VPASP (69)
Vendors »
    Big Yellow Zone (78)
Web Design Services (6)
Web Development Services (8)
 
(all products/services(78))
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: 7/30/2011 11:50:00 PM
We've now got 4 maillists you can signup to, eg "My BYZ Updates" for personalized upgrade info on your products so that you get informed as soon as a new version of *your products* come out. click here for more info.
Released: 4/12/2011 6:00:00 AM
Twitter: You can now keep up with BigYellowKey developments/news using twitter: http://twitter.com/bigyellowkey If you're a Twitter user, Click the "Follow" link on http://twitter.com/bigyellowkey to keep up to date.
Released: 4/9/2011 2:05:00 PM
Do you sell website tools/applications? We are currently looking for developers and software vendors to help beta-test the new system. Want to sell your own stuff via this site? Contact us and beta-test the system and see what you think.
Released: 3/26/2011 2:05:00 PM
Our software has now been categorized on the right-panel of the site, so you can get a quick/easy overview of what's available.
Released: 3/10/2010 2:05:00 PM
Twitter: You can now keep up with BigYellowZone releases and news using twitter: http://twitter.com/bigyellowzone If you're a Twitter user, Click the "Follow" link on http://twitter.com/bigyellowzone to keep up to date.
Released: 12/14/2009 2:45:00 PM
VPASP V7 status for BigYellowZone Addons:
click here for details
Released: 8/25/2009 2:05:00 PM
We've decided to extend the discounting of the BYZ subscription services, where the initial fee element is reduced by the cost of BYZ Addons that you've purchased in the last 12 months. This relates to the subscription services of BYZ147, BYZ148, and BYZ149. The reduced price will be shown when you get to the confirm-order page (ie after you have entered your domain).
Released: 4/25/2009 10:45:00 AM
BYZ Subscription Services added! You can now subscribe to get addons, or hosting, or both. For people who have bought BYZ addons in the last 12 months, you can trade-in what you've spent on addons in the last 12 months against a reduction in the relevant initial-fee element of the subscription service. This trade-in offer will only last for the next 30 days, so trade-in now! This trade-in relates to BYZ147, BYZ148, and BYZ149. See "subscription services" in the right-panel above or click on "services list" at the top. You'll get/see your discounted price of the subscription when you get to the final "confirm order" page (ie before you make payment, but after you've chosen your domain(s)). For example, if you've spent £120 on BYZ addons in the last 12 months, then you can get BYZ147 for just £37. If you've spent £200 on BYZ addons in the last 12 months then BYZ147 would only cost you £7. The prices concerned relate to prices excluding vat/tax and do not include installation cover/services. PLEASE NOTE: If you already have BYZ072/02 (Installation Cover) then that installation cover becomes invalid after you subscribe.
Released: 4/14/2009 2:00:05 PM
The My-Software screen has been changed to show a traffic-light system which shows a red cross for any modules which need upgrading, and a green tick for any modules which are up to date, which allows you to see at a glance if you need upgrades. NOTE: Please check your my-software screen regularly to see if upgrades are available.
Released: 4/14/2009 2:00:00 PM
Upgrade protection has been added which you can optionally purchase whenever you buy new modules, domains, or upgrade. It will give you permanent cover against the cost of future software upgrades for your module/domain. This is a major change to the bigyellowkey.com system; please let us know if you have any problems/questions.
Released: 2/23/2009 11:05:00 PM
**Notice: There was a temporary glitch with the bigyellowkey.com checkout process today; we have now investigated/fixed the problem. Apologies for any inconvenience this may have caused.
Released: 12/1/2008 12:00:01 AM
VAT Reduced to 15% - Following the recent government announcements in the UK, VAT (only payable on orders placed from the EU) has now been reduced from 17.5% to 15% with immediate effect from Midnight 1st December 2008, and will remain at 15% for 13 months. All of the bigyellowkey.com ordering and payment processes have been changed to accommodate this. Customers outside the EU do not pay any VAT. Customers from the UK always pay VAT. Customers from the EU (but outside the UK) who have a valid VAT/Tax number do not pay vat. Customers from the EU (but outside the UK) who do not have a valid VAT/Tax number pay VAT.
Released: 11/10/2008 1:05:00 PM
FAQs (Frequently Asked Questions) section has been added. Click on the Help link at the top of the page, or click on the FAQs link on the right panel help section.
Released: 10/17/2008 5:05:00 PM
What's New Link added to the top of the BYK screens. This allows you to see all new software released, and all new versions (upgrades) released, in descending date order. Want to know what's been happening on the software front? Just click on "what's new?" at the top of the screen.
Released: 9/2/2008 6:00:00 PM
New Software Vendor! SQLInjectionScanner.com (a sister company of BigYellowZone) is now using the BigYellowKey.com site to distribute anti-hacker tools and other products/services which site owners will find very useful. Visit SQLInjectionScanner.com for more info. If you previously bought the BYZ "hack checker", then check your my-software screen to grab the latest update; it has now become the "SQLInjectionScanner.com Scanner" and the new version has lots more features. A data cleaner is also available, as are check/fix services.
Released: 11/22/2007 4:29:00 PM
Mail-Lists (with discounts) added. Your profile now has a mail-list option at the bottom where you can optionally sign up to mail-lists. Some mail-lists will give you discounts (these discounts will be explained on the mail-list description). Default will always be "no sign up" for any customer, either historic or new customers. You will need to explicitly tick the sign-up box and save the changes to get added to the mail-list (and receive the relevant discount).
Released: 10/16/2007 11:57:00 AM
Live/Archived radio buttons fixed - the live/archived/all radio buttons at the top of your "My Software" (and other "My") screens have now been fixed. They were previously one-step behind what you pressed, but are now correct and automatically refresh as soon as you click on one of the radio buttons.
Released: 10/16/2007 11:56:00 AM
localhost assigned for free - you can now add localhost to any of your licenses during purchases/upgrades, or via your "My Domains" tab, and it will automatically give you the localhost key for free.
Released: 10/16/2007 11:55:00 AM
New version of byk released - if your customer control panel shows you the login screen, then please login again. Once logged in you will no longer need to login again.
Released: 10/11/2007 12:30:00 PM
Upgrade fix applied. There was a problem when upgrading Backfilled BYZ licences, this has now been fixed, but if you upgraded on BYK prior to this news item being added then go into your "My Software" screen, and check if you have multiple versions of a given product for a given domain; if you have multiple versions then press the archive link on the old versions, then go to your license keys page and create a new license key file, then download that key file and upload it to your site.
Released: 10/8/2007 11:50:00 PM
Sub-Modules added to your software lists - We have now ensured that all of your sub-modules are now listed for your main modules on your software screen. This means that you can now upgrade/download either the main module, and/or the sub-modules. Our upgrading and purchasing procedures use "intelligent" bundling, whereby if you've upgraded/bought all the corresponding sub-modules then you'd automatically also be assigned all appropriate parent bundls, and if you buy/upgrade a bundle then it will automatically assign access to all the sub-modules as well. Checkout your "My Software" screen, as it may now be showing you additional/new sub-modules.
Released: 9/28/2007 8:15:00 AM
BYZ Interface Improved - We have now changed our sister site (bigyellowzone.com) so that you will only get directed to bigyellowkey when you checkout, and not each time you add an item to your cart. This means that you can continue freely shopping/browsing on bigyellowzone.com without having to jump between byk/byz sites for each item. Note that for upgrades you should always use bigyellowkey.com for browsing/purchasing, and not bigyellowzone.com.
Released: 9/25/2007 11:45:00 PM
Version History Displays - We've added a link on the product-codes on your "My Software" screen which will popup a printer-friendly page that displays all the product details and the full version history (ie all the release notes of all versions) so that you can now see if you want/need to upgrade specific modules.
Released: 9/23/2007 2:05:00 PM
We're Live ! - BigYellowKey.com has now become a live system. There might be some teething questions/problems following its release, so if you have any questions/problems then please do let us know.

Bulk Product Updater for VPASP - BYZ089

<< back to previous screen

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



Bulk Product Updater for VPASP - BYZ089
Latest version:09/01-SEP-2011
From vendor:Big Yellow Zone
Price:£40.00
add to cart


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

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

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




For further information from the vendor about this product, please visit:


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