Fixed a bug where case images were looking at figure images
Fixed issue with auctions loading as disabled as default for Transformers. Updated visual page so that images are aligned better. Removed figure number from item detail pages as well
Fixed issue with for sale auctions for Transformers and also adjusted logic not to exclude dashes in names to build SEO url
Fixed some sorting issues on Transformers and including Japan auctions
Adding Transformers as well. Perhaps this is getting out of hand...
Adjust the job that caches the site to also dynamically create the sitemap. I hope that pleases the Google Gods
Adjusted price guide pages so BAF figure doesnt mess up results since it technically doesn't have a retail price. BAF figures are a pain to support
Started to add Exclusives
Added the BAF as it's own figure to sets
Created home page with links to BAF and Exclusives
Found a bug where figure detail pages did not include group name in URL. Oh well, leaving it as is
Lots of changes to ensure BAF wasn't shown on Exclusives pages. Now Ill be screwed when I get to an exclusive BAF set!
Still not sure how to images on Exclusives pages
Adjusted stats page for Marvel so it didnt show BAF complete figures, but added dedicated table at bottom
Added Marvel lines
Somewhat of a big change because now I have spawned off the site to include Star Wars Black Series and Marvel Legends with plans to add Transformers. I had to do a lot of work refactoring the code to handle different genres. Some of the UI had to be copied, but the backend code and DB are mostly reusable at this point. I'm hoping it is as useful to the Marvle collectors as it has been for the Star Wars world.
5.x - Dec 18 2016
Added GameStop as new vendor
Added logic to prevent lowest vendor prices of $0
Added vendors of Forbidden Planet and Robot Kingdom
Bug fix for Amazon product urls which suddenly needed to be encoded and decoded.
Adding Target as new vendor to check prices. Good for exclusives
Just noticed I didnt have a h1 tag on product pages.
Added icon next to graph names in visual and price guides to identify they are clickable. Also optimized which pages are responsible for creating new graphs so there isn't duplicate work on startup
Added more graphs for basically all the groups. I may need to migrate to a better graphic program because they are hard to read with the current .png generated system
5.10 - March 18 2017: Finally added 3.75" Black Series Figures from 2013-2015
Fixed timezone issue
Added time left and # of bids while also adjusted formating for cantina and finally got the padding between cells to work
Cosmetic items and some mobile optimization on tables. I left out thead and a tr tag as well and I'm surprised it's been rendering ok all this time. I really love Font Awesomesome icons
Added links to Amazon for items that are available via prime
Minor amp styling app
Seperated the variation and knockoff guides
Jan 21, 2017 - Added brickseek like lookup by SKU for figures that have a SKU identified
Fixed amp issue when ebay auction comes back with no image, don't display in carousel
More tinkering with the movers and shakers. I found that it didnt seem accurate unless you had a detailed view of daily auctions (as opposed to avg by month). Because of this I changed the logic to look at current month vs previous month, but smartly thought about year as it's Jan and the previous year is 2016. Also, no movers/shakers in the beginning of a new month until there is at least 4 auctions
Enhancements to admin interfaces
Added variation of most valuable figure on stats page
Added search with ajax autocomplete
Improvements to admin tools to manage items
Adding Facebook commenting to item detail pages
Fixed issue with elite premium figures not fully being loaded
Added graph of auction loads by month to stats page.
Added price history graph for orange and blue waves. Tough to read as line plots step on each other, but somewhat interesting
Added fancybox for images so that they don't open directly and inside a pretty little frame. Very nice library and easy to implement
Adjustment to image hover so that on touch devices it doesn't stack images
Still not happy with movers/shakers. The problem is that sometimes it shows a bit change in price but it's not reflected in the graph. This is mostly because the graph doesn't have enough auctions to show the current month. Adjusted logic accordingly.
Fixed bug in order of graph so that years comes last
Left some debug code in which was scewing around with php performance. I recommend running grep "opcache_reset" . -Rn on your site. Also setup some cache monitoring pages
Adjusted cache and added method to clear cache before recreating content. This should fix movers/shakers not reflecting changes in figure categories
adusted certchain. google webmaster is saying my cert is self signed, hope that fixes it
updated some path of images from ebay to use https
Optimized most of the images
Updated all coded links to https (oops, forgot to do that)
Added SSL and redirects only to https. Hopefully didn't screw it up
Automatically flagging any auction with "bitnami"
Move hosting to Lightsail. Lots of speed improvements!
4.x - Oct 30, 2016
4.10 Dec 14th - Added pictures of cases for wave figures
Adjusted logic on movers/shakers to match what is shown on the price graph
Adjustment to remove embedded font style for AMP
Oops, accidently broke roll over images
Added auctions carousel and structured data for AMP
Reduced the number of for sale and sold auctions to 10 to reduce size of page
Made max carousel size to 10 so it doesn't try to bring back a lot of images.
4.9 Dec 5th - Included mobile carousel from Flixity to view similar items within in a group.
Adding retailer exclusive SKU's and UPCs when I find them
Updated home page with better pictures to describe the sections.
Added share icon for AMP version of pages. Couldn't use amp-social because Facebook requires an AppId.
4.7 Nov 30th - Added AMP optimized pages for item detail pages
Added Share link for Facebook and eMail to the item detail pages
Added versioning to css so that I could force reload
Changed top nav so it's not sticky and now my in page links don't look off
Added additional og:meta tags to fix link preview and make Facebook happy
Added series description and link to switch views
Added ability to link directly to wave on visual checklist
Fixed a bug in visual checklist for Elite Premium figures
Changed breadcrumb to link to specific section of group page. Also moved group name to after figure name in brackets
Added cache control in headers to improve page load speed
Adjusted breadcrumb nav on item detail pages to also include group name (if there is one)
Added similar items on item detail pages. For example, Obi Orange Wave and Obi Blue Wave
Added job to automatically load cache pages for performance (Nov 15th)
Redesigned index page in traditional bootstrap style
Added image hover on price guide pages to show a thumbnail of the figure
Adjusted order that auctions are retrieved on eBay so they come back in similar groups
Fixed the tabs on the item detail page to properly show and hide current and sold auctions. Now it works like you would expect.
Added a little icon overlay on top of thumbnails to show there is a bigger to view. Positioning CSS is a huge pain but found some examples I could adapt that didn't screw up while in mobile format
Seems like Darth Maul's pics were broke.
Fixed a bug where breadcrumb nav would load wrong guide or none at all for google cached pages
Adjusted movers and shakers so you need at least 3 sold auctions to qualify
Added favicon for /star-wars/*
Added new page to list all the variations which include reproductions and knockoffs
Added logic not to include visual guide links for price guides that don't have one (Hallmark and Variations)
Added rendering to check to see how fast page is loaded from cache
Added movers and shakers depicted by green and red arrows in price guides. These are the figures who had the biggest change in price
While trick or treating I realized that my breadcrumbs would not work when there is no referer so I updated to an ajax call
Added breadcrumbs to item detail pages
Added a little switch icon to go from visual and price guides
Added notice on bottom of price guides that more info can be found if viewed with desktop or tablet
Fixed title and description meta tags to more acurately page content
Added more detail about item on detail page because the smart phone version has it removed
Created an iphone (I assume it works with any smartphone) version of the price guide that hides columns when viewed on a smart phone.
Google didn't like that my site wasn't responsive and it was getting annoying to use on mobile. I looked into Foundation but finally settled on Bootstrap to make it responsive.
It's somewhat of a hack of how the tables just scroll now, but maybe another iteration will include a table with less info on mobile. I personally hate showing less info though because
that normally means trying to get to the desktop version
Added 3.75" Walmart Exclusives to visual check list which also means I had to hunt down images, thumbnails and descriptions for all of them.
3.1.x - Oct 24, 2016
Added variations with description of variation and link to picture
3.0.x - Oct 22, 2016
Added more canonical urls and some h1 tags for SEO goodness
Fixed sort order not including wave and the wrong year on 3.75" luke
Adjusted graph width to match item picture and description
Moving everything under one directory. I originally started with one file and now that it's morphed into something bigger, I decided to tidy
things up by putting everything under /star-wars/. I thought about registering a new domain name, but for now, Ill keep it under my personal domain
created SEO friendly page names, item links and image names so Google is happy
2.8.x Oct 2016
adding figure meta information and description on ebay detail auction pages to help with SEO
small tweak to align VCL images on top so they look more aligned due to wrapping names below
minor cleanup of image sizes and added some SEO for links/titles/images/etc
Added Exclusives and Deluxe sites to visual check list. Had to account for different sized pictures since these are not just standard figures
Added thumbnails to speed up the visual check list
Found a weird bug where cache was not working for result sets and after all this time it finally revealed itself.
Fixed a bug with sort order of figures
Beta of visual check list
Made header menu dynamic
Removed hard coding of "and" type auctions by checking display name
Fixed bug where newly added auctions would always be excluded because avg price was $0
Adjusted figure ordering to include year and name for sort order so that if I add new items, it will appear sorted
Adding Hallmark items (most of them for now)
Adjusted graphs to be wider and less clutter in labels
updated code so I can purty up the names vs what I search for on eBay
Fix for excluding auctions with "and" but also excluding new guy Captain Cassian Andor
Adjustment for stats page
Small fix to auction management tools to sort figures by group rather than added data
Sometimes the auction script would time out connecting to SQL. Added some exception handling so it doesn't abort the entire job.
Fixed a bug where graphs y axis was higher/lower than actual avg monthly values
Adjusted stats page so it doesn't show the current day which is just partial load results.
Auto excluding any auctions from China/Hong Kong as there are lots of repros coming in
Added stats to see daily auctions and how many unique items were loaded by day
Added Elite figures. Not black series, but whatever!
Fixed another issue with figures not sorting properly
Added some rounded corners to the tabs
Some SEO optimization on title/description tags
Similar figures are causing issues try to sort them. Had to build some more admin tools to quickly change
Wrote logic to exclude "and/&" type auctions for multiple figures, but some items naturally have an and so don't exclude those by accident (like Luke and Wampa, Rey and BB8)
Found an issue when adding the new 3.75 Walmart figures as I was sorting by id, but not including group
Setup auto-exclude rules for auctions that include title descriptsion like and, &, 2x, etc. Also excluding any auction that's double the avg price, figuring it's a bundle
Fixed min/max Y axis on graphs
Bunch of updates to backend tools to maintain auction results as they come in
Duh, changed ebay search to only return NEW listings. Might verify listings from China as well
Minor SEO tweaks
Added automatic method to find range of ids to scan daily vs manually changing max id count
Added lightsabers and helmets (wearables) and helmets to titanium
Removed hardcoded group settings
fine tuning of tabs
Fixed urlencoding issue when viewing stored results
Added titanium vehicles as well
Ok, added support for the 3.75 Walmart figures as well! I guess this is no longer just a 6" tool
Lots more behind the scenes stuff to manage all the data and rules coming in.
Added total count of auctions
Lots of work on behind the scenes stuff to administer auctions. Excluding items is a big part
Added graphs of avg price over time on detail page
Adjusted main table to use last 45 days of auctions instead of all
Caching driving me crazy
More adjustments for caching.
Bug fixed with caching routines.
Added a welcome description and fixed the cron job to dump the cache after it's done updating
Added some jquery so you can add up your own collection
Fixed the table so the summary goes into the last row instead of outside the table.
Moved all the groups to one page now that I can easily query all the prices without any eBay API lag. I still have a few things hacked in, but will fix later
Migrated code from file based system into database
Adjusted code to set min price for chinese knockoffs
Fixed issue with some exclusives not appearing.
Added maxPrice per item in query to eliminate sold auctions for cases or groups of items affecting individual figure prices
Fixed a bug with SDCC stuff over 230 bucks not appearing
Added Rey Starkiller base
Adjusted some auctions query terms
Added comparison of retail price vs current avg price
Fixed clone trooper auctions in orange #14 and blue waves #13
Excluding 3.75 from search. 3 3/4 still seems buggy when i try to add it though
For performance, display by waves and added exclusives and deluxe sets
Added Amazon and EE exclusive 4 packs
Forgot to include Google Analytics
Added total value of a collection on bottom of summary page. This only includes items that have had recent completed sales.
globalized some of the debug and utility commands
Added versioning ;-)
Adjusted shipping info to include calculated and free shipping
Added how many days the avg price is calculated against