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.

Brand/Manufacturer Mismatches Tool for VPASP - BYZ189

<< back to previous screen

Validate your product brands against your brand categories. If you hold your brands/manufacturers in your products records and also in your categories, then this tool will cross-validate the two aspects and show you any mis-matches.



Brand/Manufacturer Mismatches Tool for VPASP - BYZ189
Latest version:01/05-MAR-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:£20.00
add to cart


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

This product includes:
BYZ038
BYZ036

Lots of vpasp sites hold their brand/manufacturer data in 2 separate places, such as the products.mfg column and ALSO on the categories that the products are stamped with.

This is usually done to either speed-up the queries/site, or because the usage of the 2 aspects on the site is subtly different and needs to be stored twice for the different usages.

For example, products.mfg might be used for product brand filters, whereas the brand categories might be used in a category/tree menu.

This tool will cross-validate those 2 aspects for you, and it will show you the details of any mis-matches.

It will show you a simple, easy-to-read list so that you can quickly read through to see if they're genuine data problems/errors or if the mis-matches are valid given the usages of the respective brand sources.

The column that is used for brands/manufacturers in the report is configurable (eg if you use pother1 instead of mfg, then you just change the config file to set the option to pother1).

The way that your site identifies a brand/manufacturer category is also configurable. For example, you might set it to use all categories that have a highercategory of 2 or 3, or maybe a specific list of categoryids. You can set the "where" clause that it uses as part of the configuration.

The example image of this module on this page is taken from our demo area, our demo area doesn't use brand "categories" (just products.mfg), but it gives you an idea of how the mis-matches get displayed. In that demo example, we set the configuration to think that the "Living" category's sub-categories were brands ("Seating" and "Cofee Tables" are the sub-categories under that category, which is why the sample sees those as brands).

You can cross-check other values too, not just brands!
Because you can configure the products column name, and the category where clause that identify "brands", that means that even if you don't use brands on your site you can still use this tool to cross-reference different types of "products versus prodcategories mismatches" (eg colors, material-types, sizes etc)


Technical/Developer Information:
Mis-Matches are not necessarily all "real" errors.
The usage of your category descriptions for brands, and the usage of your product column's brands values might be slightly different. So when a product's brand value is slightly different to the brand category description that the product is in, it may not necessarily be a problem for your site; it depends on how you use the data in your system.

This tool will report on all mis-matches, but it's up to you to decide whether or not the "errors" shown on the search-results are actually a problem for your site.

What gets reported
This tool will find all products which either have a non-null products brand value, OR which have a brand-category stamped onto the product.

i.e. if a brand is stamped onto a product, or if a category brand is applied to a product, then that brand will get processed and displayed on the search-results screen, and it will show you a unique list of those brands in brand order.

For each brand that gets processed/displayed, it finds all the products that either have that brand stamped onto its products column or which have that brand "category" stamped onto it.

For each product that has the brand on either-side (products or prodcategories), it checks that both sides match exactly the "brand" text that is being processed, and if there are any mis-matches for that product then it'll display all the brand-categories which the product is in, plus the products brand column value.

If a given product matches the brand being processed exactly, then it simply displays a success message and doesn't list any of the underlying products.


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 05-MAR-2015 Initial version - Big Yellow Zone Brand/Manufacturer Mismatches Tool for VPASP