Notes to Version 11.00.00 of the Bookzangle Database (BZ-DB)1. New HTML Routines for eBay
These have been substantially upgraded, primarily to create a full RESPONSIVE HTML array at eBay in the Description text block. ["Responsive" means that the display will alter subtly depending on whether a customer is browsing via a Mobile Phone, Tablet or Desktop PC, so as to maximise market impact. Test have shown dramatic increases in eBay sales when this new responsive HTML is activated]. Users who have trialled this much-enhanced HTML upload from our database are reporting dramatically increased sales therefrom – not surprising given that eBay has for some time been advising that purchases via mobiles and tablets are now out-stripping purchases from desktop/laptop PC platforms. Members upgrading to new version who have listings already at eBay should immediately send up a bulk REVISE on all of them, so as to take full advantage of this database enhancement. All new listings (ADDS) will of course contain the upgraded HTML.
2. Improved automation in Upload Routines for Amazon
Your Amazon files (for Amazon US and/or UK) will now auto-create and auto-name, exactly as do your eBay upload files. Files will lodge in the new UploadsAZON folder in the convention AZUS_[date/timestamp] or AZUK_[date/timestamp] which means they will be auto-sorted chronologically and by exact time. DAILY DELETES auto-files for Amazon will work to the same convention, except they will have a DELETES in the filename for easy identification. Uploads can be created for any number of other Amazon sites (e.g. Canada, Mexico etc) by changing the Currency Converter field for Amazon US at your Amazon Global page, and creating files in sequence for each “new” site.
3. VIEW LISTING buttons at Main Menu - Bookzangle and eBay
Two new buttons at right-of-screen central allow a single click view of the record on display, either at Bookzangle or eBay. Clicking these buttons will take you straight to your listing at either site, for quick checks, lookups, looking at picture(s) attached to aid with "gets" from storage etc. On Entry or other pages where these buttons do not exist you can select either quick-lookup using GO TO menu (top toolbar) and either of the View Listings options there at the top of that drop-down menu.
4. Check BZ listings Script
In the Scripts (top menu) menu there is now an entry called Check BZ Database. Running this script will create a file in the root C:WBMBB directory called "check_bzdb.WBX". When that exact file is uploaded to Bookzangle, our fileserver will send you back a report showing which listings are marked "For Sale" in your database but which are NOT at Bookzangle, and vice versa (marked SOLD in your database but still showing FOR SALE at Bookzangle. A handy mini-audit tool to maintain your BZ-DB listings in exact kilter with what is showing at the BZ fileserver.
5. Protection on DUPE button – activate/deactivate
Some members have complained that accidental hitting of the DUPE button causes problems. So the DUPE activation is set to OFF and the following message will appear when that button is hit: "DUPE button is turned off by default - you can turn it on globally by going to your Admin Page and changing NO to YES in the Activate Dupe field there. Or you can force a one-off DUPE by using the command in the RECORDS Menu (top of screen)." If you use DUPE often set your button to YES, otherwise leave it at NO.
6. All users (with FMP software v. 8.5 through 11.0) can now use LAYOUT MODE
NB: This feature only applies to those who have installed a copy of Filemaker Pro (FMP) v. 8.5 or higher – these are available at eBay and elsewhere for $80 or so. Do NOT install version 12 or higher, which use a different format]. By clicking "Layout" in the little toolbar extreme bottom left (defaults to "Browse) your database will enter LAYOUT mode. In this mode you can change field colours and sizes to your exact design preferences. You can copy field from one layout across to another, remove unwanted fields from existing layouts, and generally design your database to your exact specifications.
7. Backload data from Turbolister and import into BZ-DB: new Easy Edit Page
If you have listings at eBay which are not in your database, then a backload of data via Turbolister can be massaged into BZ-DB importable shape by our fileserver [NB this latter still under development, but available shortly. In the meantime anyone in this position should contact us privately and a manually-derived file will be organised for them]. Once so massaged by either the fileserver or manually, an Import File will be created which you will import using one of the existing Import Scripts [details to be advised later]. Once imported, you then have an [existing] Layout Option called TURBOLISTER EDIT which is accessed via the EBAY menu (top menu bar]. This edit page allows a simple edit and clean-up routine for the (not always complete or coherent) data returned from Turbolister backload.
8. Export eBay Upload List
New Script in EBAY menu (top toolbar). This will generate from any Found Set (usually SHOW ALL TO UPLOAD from the EBAY Menu at top) a 6-field tab-delimited file for inspection in a spreadsheet or text editor of your choice. The 6 fields exported are:
Action Type: one of End, New, Revise, Quantity Differs, Price Differs, Number of Pics differs
Price Differs between eBay and BZ-DB(by this amount)
Pic Count Differs between eBay and BZ-DB(by this amount)
eBay Item ID (if a Revise or End Listing and if stamped in your database after an eBay backload. Will be blank for NEW items.9. New USE UPC per-listing fields at eBay Entry Page
A YES/NO button (Blank = NO] called USE UPC, extreme right at top of EBAY ENTRY Page. Allows a per-listing uplift of the EAN (13-digit ISBN) in the Universal Product Code (UPC) field for eBay. You can set this to happen globally as well, but this is not really recommended, since triggering the UPC generates a whole mass of frequently-wrong"generic" data for each listing with EAN as UPC. But there are some listings which eBay "rejects" on the grounds in error report that "there is no ISBN" even when there IS an ISBN included. A great many of these rejects can be got to eBay by selecting YES on this per-listing button, which will insert the EAN for that listing only (or group of listings in a Found Set with a Replace Field Contents routine) into the eBay UPC field. A re-upload of that listing/those listings will see most of them "take" at eBay after an initial failure for "lack of ISBN" as given reason.
10. Create Full Upload Script
Script number three in SCRIPTS menu (top toolbar) will create a full purge file of all listings which can then be uploaded to BZ server - via ordinary upload dashboard, or via FTP (if over 50 megabytes in size, as will often be the case - check before choosing upload method. The file created is always called "full_upload_purge.tab" and is always placed in the UploadsWBM sub-folder of C:WBMBB main database folder. Recommended that members run this script and upload purge file at least once every month. Will flush out any and all "missed" listings at BZ server and also at most other sites to which it is auto-forwarded by the BZ server.
11. New BOOK TYPE drop-down menu list complies with ABE's new system
The new Drop-down menu list for Book Type contains at its head the 6 new "Collectibles" sub-categories at ABE, these being:
Fine Art Print
Abebooks' BZ-DB filter has been updated to recognise these entries in this field (where relevant) and when used the record will be included in Abebooks' sub-category Advanced Search list for Collectibles. Definitely a market-enhance there, and worth updating whole database to stamp relevant items in this field, after which a full upload purge file to Abebooks will trigger the inclusions there automatically. You can use Replace Field Contents routines to auto-update whole Found Sets of relevant items.
12. Pic Count box Find Options enhanced
You can now search for Variables in the PIC COUNT box e.g. PIC COUNT = >0 or >1 or range of 1 .. 3 etc. Formerly you could only do a find in this box of any digit 0 through 9.
13. Former bug in Keywords Auto Add fixed
This very useful routine was malfunctioning slightly in previous versions - that is now fixed. Use GO TO Menu (top toolbar) to access this page. You can Find whole sets of listings types and then auto-add a Keyword or group of keywords across the whole Found Set with a single click. For example, you might want to find all your Category "Ships & the Sea" and auto-add something like the following string to Keywords field in all those listings: "Nautical Marine Ocean Seafaring Boat. Common mis-spells by searching buyers should also be auto-entered here: Steven/Stephen, Phillip/Philip in Author and Title, or Artic/Arctic and Antartic/Antarctic (in all cases both ways). Sidney/Sydney, Leslie/Lesley are some others worth mentioning. Cunning use of variable-spelling Keywords will definitely increase your sales at all sites. The procedure is swift: using a pre-prepared list, an update of 20-30 auto-add Keywords across a database of 30k or so listings will take less than half an hour.
14. Auto-add filtered Titles and Authors to Keywords
Some sites have difficulties with apostrophes and other “noise” entered into listings by either the seller or the searching buyer. The new BZ-DB now auto-adds to Keywords an Author and Title text string stripped off all bar alphanumeric characters e.g. Author: “Patrick O’Brien” TITLE: “O’Connor’s Irish Legacy” will auto-insert the string “Patrick OBrien OConnors Irish Legacy” into Keywords, which will help get you “hits” from searchers wrongly entering the “noise” (which is a common event). This will be particularly helpful for you at eBay, which handles such “noise” fairly badly in searches.
15. Bug in RESTORE routine fixed & eBay fields now included in Restore
A small bug prevented SHIPPING COSTS at the INVOICE page/layout being properly restored in the Restore backload from the fileserver after a computer crash or loss of data. This has now been fixed. All Over-ride and eBay-specific fields are now also included in a RESTORE routine.
16. All picture references changed to "https" from "http"
A required change by eBay - the BZ-DB will now auto-reference all .jpg files at Bookzangle as "https" instead of the former "http". Existing users of eBay need to upgrade to this version ASAP to prevent listings failing there under the old routine.
17. Some ancient "wrong" Categories fixed automatically on upgrade
Some members still have an old "formerly permitted" BZ category called "Music Scores & Sheet" and "Engineering, Industrial & Trades". These were changed some time ago to "Music Sheets & Scores" and "Engineering, Industrial, Trade". Upon upgrading to this version the two "offending/non-compliant" categories will be automatically updated to the correct ones.