Shopping Discussion

StockTrack - Inventory Checker tool for some Canadian B&M stores

  • Last Updated:
  • Jun 14th, 2022 12:50 pm
[OP]
Deal Fanatic
Aug 3, 2008
5315 posts
11062 upvotes
Ottawa
raskal wrote: I noticed on Stocktrack.ca, it mentioned a FF extension. So I added that, but unfortunately, I haven't got any information yet from the extension at all. Doesn't show up like CCC does when I'm on Amazon. I haven't seen anything on Canadian Tire or Walmart

any ideas Seafish?

thanks
The extension adds a button that will send you to stocktrack.ca with product number or upc to check.
Deal Addict
User avatar
Dec 7, 2005
4347 posts
8299 upvotes
Abbotsford B.C.
seafish wrote: The extension adds a button that will send you to stocktrack.ca with product number or upc to check.
thanks for the reply! I did find it a few days ago, I was just expecting something different but it is very useful.
Deal Expert
Aug 22, 2006
28644 posts
14191 upvotes
seafish wrote: HD seems to be blocking permanently, or at least I can't see when it actually work.
"Hey! Someone made a better search than ours. What should we do"
"Obviously we should block them instead of working with them. Duh!"

Side note: Learn about bitcoin. I'd totally send you a couple bucks.
Do you not have anything else to do rather than argue with strangers on the internet
Nope. That's why I'm on the internet arguing with strangers. If I had anything better to do I'd probably be doing it.
Newbie
Aug 12, 2019
5 posts
2 upvotes
Hey seafish, I made an account here to get in contact with you. I'm part of the Lego community and your tool is invaluable to us for finding hidden deals. I'm a web developer and I'm wondering if you're interested in collaborating to make the site mobile-friendly for users who navigate the website while in-store. Not looking for money or recognition of any kind, your site has saved me and my group literally thousands of dollars so I just want to help however I can to improve it. If you're interested send me a message on here (I can't due to being a new user) and we can further discuss some details.
[OP]
Deal Fanatic
Aug 3, 2008
5315 posts
11062 upvotes
Ottawa
tbeverly wrote: Hey seafish, I made an account here to get in contact with you. I'm part of the Lego community and your tool is invaluable to us for finding hidden deals. I'm a web developer and I'm wondering if you're interested in collaborating to make the site mobile-friendly for users who navigate the website while in-store. Not looking for money or recognition of any kind, your site has saved me and my group literally thousands of dollars so I just want to help however I can to improve it. If you're interested send me a message on here (I can't due to being a new user) and we can further discuss some details.
Hi Taylor,
Thanks for your support with paypal donation and your offer to help improve stocktrack. I'll contact you shortly as indeed mobile experience is miserable but I couldn't find time and will to improve it :) Perhaps something will come out of it.
I know some other RFDer was working on mobile app based on stocktrack, but I'm not sure at which stage this development is.
Deal Addict
User avatar
Dec 7, 2005
4347 posts
8299 upvotes
Abbotsford B.C.
Hi.
I've got some weird behaviour that in wondering if you could explain.

My local store has 11 of these canopies at $89 each.

But on stocktrack it has this;
Screenshot_2019-08-19-16-51-06.png

Any ideas why? Thanks!
[OP]
Deal Fanatic
Aug 3, 2008
5315 posts
11062 upvotes
Ottawa
raskal wrote: Hi.
I've got some weird behaviour that in wondering if you could explain.

My local store has 11 of these canopies at $89 each.

But on stocktrack it has this;
Screenshot_2019-08-19-16-51-06.png


Any ideas why? Thanks!
Are you sure about UPC? It must match. Did you go in store to check availability and price?
Might be a newer model that you saw in store.
Deal Addict
User avatar
Dec 7, 2005
4347 posts
8299 upvotes
Abbotsford B.C.
seafish wrote: Are you sure about UPC? It must match. Did you go in store to check availability and price?
Might be a newer model that you saw in store.
Oh man... what a rookie mistake I've made!

Yeah, a different UPC

while I have you on the phone ....

what does the "Status" mean? I've seen a quantity of 2 and a status of "sold out"

thanks!
Deal Expert
Aug 22, 2006
28644 posts
14191 upvotes
seafish wrote: Walmart reports both status and inventory numbers and sometimes they don't match.
Through my single experience, look at inventory.
I bought a thing that was "sold out" that weren't actually sold out.
I get the idea of ghosts, but I'm surprised that 3 units of something large is still considered sold out.

Also <3
Do you not have anything else to do rather than argue with strangers on the internet
Nope. That's why I'm on the internet arguing with strangers. If I had anything better to do I'd probably be doing it.
Deal Expert
Aug 22, 2006
28644 posts
14191 upvotes
death_hawk wrote: Side note: Learn about bitcoin. I'd totally send you a couple bucks.
@seafish

I sent you a few bucks.
Do you not have anything else to do rather than argue with strangers on the internet
Nope. That's why I'm on the internet arguing with strangers. If I had anything better to do I'd probably be doing it.
Deal Addict
Dec 16, 2011
2793 posts
1255 upvotes
QC, Canada
seafish wrote: Thanks! I appreciate it a lot.
Already had to upgrade hosting for double the price to get more processing power and storage. Might have to do it again soon.
Have you thought about adding fews smalls banners? I'm pretty sure you have more and more visit so it should be interesting for you
Member
Sep 8, 2003
328 posts
464 upvotes
FYI @seafish I messaged you through the convoluted RFD system.
Digital Improvements
Most posts are via my mobile, so sorry for any duplicate posts, poor spelling/grammar, lack of photos and other details.
Sr. Member
Feb 23, 2008
844 posts
78 upvotes
I used this to find my Garmin Drive 50 LMT for $79.93 rather than $189.99-10 at Staples recently at the Markham East Canadian Tire for a future road trip and not rely on cell phone Anyway got it when there were 22 left and saw it go to 21 then 14 and now sold out. Likely RFD effect lol

Next level would be turning this into a camel camel camel type thing to track prices but I guess you are doing real time aggregation of data from different stores rather than tracking historical data
Sr. Member
Feb 23, 2008
844 posts
78 upvotes
seafish wrote: I do actually collect historical data, but only for walmart.
oh ok, would be good to know if you are getting a good price at Canadian Tire for something.
Banned
Jul 18, 2019
13 posts
3 upvotes
seafish wrote: Hi there,
I recently created a tool to check local inventory status and price of some B&M stores using similar requests that their websites do, but it provides more results at once and makes it easier to find a product at a better possible price. While I made it for my personal use as nothing similar was available anywhere else, I thought I share it with the RFD community.

I already posted links to it in some Hot Deals threads, but thought I create a separate post here with a little list of features and where people could leave comments and suggestions.

Walmart:
  • Check price and inventory status using UPC code (can be obtained on the walmart.ca, receipt or in store by looking at the barcode/tag). Product page might have 2 UPC listed, enter the last one which is just 1 digit shorter. Same with barcode from the box you may have to skip thr last digit. It will also try to find product information using UPC on the walmart.ca and will display the first available result. It is not guaranteed that this information will match actual product with supplied UPC.
  • Mobile devices can use barcode scanner to automatically scan UPC codes and check stock info in walmarts nearby. Handy if you're shopping around and want to check if any walmart carry particular item or want to quickly compare prices while at walmart. The button to start scanning will be displayed next to UPC field. It will ask for permission to use your camera and will start barcode scan. To cancel scanning just tap the screen.
  • Search by keyword, same as if you search on walmart.ca. Will display results with online price and stock info that you can click and also get local stock around specified location. Search results can be sorted via an option (before clicking 'Search')
  • Check by Walmart SKU. It will try to get UPC using the SKU and then search for stock info.
  • Deals! Lists recently found products in stores with discounts. This is now stopped working. Might redo later.
    • Can include prices from stores where item is OOS
    • Can only search deals in stores specified by location setting
    • Sort by more recently updated, max discount, max/min regular price
    • Filter by savings %
  • Location: can either leave blank and it will try to use your browser location or enter city/postal code/address.
  • Stores: number of stores to look for around specified location. Right now there is no limit and technically it's possible to search across whole Canada.
  • You can hide stores in results table where a product is not sold and stock information is not available.
  • Results table can be sorted by any column and filtered by price and stock.
  • Walmart.ca Daily/Weekly Price Drops shows products that are discounted today and available to buy from walmart.ca. The difference is shown not with the 'regular' price, but with yesterday/weekly price. Clicking on the item will also show availability and price in stores near the location.
  • Online price history chart when mouse over an item in the Price Drops or Search Results area. On touch devices it works when you tap and hold. History is updated automatically several times a day for those items that ever were searched/requested.
  • Store price/status history chart when mouse over price in the Stores Inventory results grid. This history is only updated when someone requests the info for that store.
Advantages:
  • walmart.ca does not allow to check price and stock status for every item (just for some, where 'Buy in store' button is active). Here it allows checking any item, even if it's no longer listed online, just provide a proper SKU number.
  • walmart.ca limit your search to 3 stores
  • walmart.ca has a bug in the system and displays correct information only for the 1st store out of those 3, other 2 stores just copy 1st store info. walmart fixed their bug
  • Online search results display how many items are available in stock, which is not shown on walmart.ca. I have no idea how accurate that information is though.
  • Online price history chart
Drawbacks:
  • Stock availability information is not real-time, lagging probably day or two. Nothing I can do about it, it is what is given by the walmart server. Price appears to be correct.
  • Not much filtering of search results.
ToDos:
  • Add barcode scanner to automatically scan UPC codes and check stock info Done
  • Add filtering/ordering search results Done
  • Add price history tracking similar to 3camels. Already saving data once a day for items that ever appeared in search results (no time machine though to go back). Also saving store prices changes when they are checked (no automatic updates as it's just too much) Done

CanadianTire:
  • Check price and inventory number using Product #(can be obtained on the canadiantire.ca or in store by looking at the price tag) It should include at least first 7 digits from a product # that usually is provided in a format similar to xxx-xxxx-x. The last digit and dashes are optional, but you can just copy the number as it provided on the website.
  • Search by keyword, same as if you search on canadiantire.ca. Will display results with online price that you can click and get local price and stock numbers. Search results can be sorted similarly to what canadiantire.ca offers.
  • Location: can either leave blank and it will try to use your browser location or enter city/postal code/address.
  • Store distance: search radius in km for stores around specified location. Right now there is no limit and technically it's possible to search across whole Canada.
  • Can choose stores from which provinces to search. Useful when shipping is available and in-store price is the same as online.
  • You can hide stores in results table where a product is not sold and stock information is not available or stores where item is OOS.
  • Results table can be sorted by any column.
  • I don't store any information, everything is retrieved directly from canadiantire.ca.
Advantages:
  • canadiantire.ca does not show price information for each particular store, my tool does.
  • No limit on number of stores to scan.
  • Some store-specific clearance and sale prices are not published online. I was able to get the same info as what store kiosk does and you can easily compare prices. I found that if there is no chainwide sale, prices might be quite different in canadiantire stores across the same city.
Drawbacks:
  • Search sometimes does not give any results, but tries to redirect to some canadiantire page (usually when you enter particular brand name) Some redirects(like 'lego') I was able to overcome by specifying the same keyword twice but some still try to redirect no matter what.
  • No filtering search results. Might add later.
  • When search item contains multiple product #'s (for choosing colors, size, etc) it will only show the first one. You can still lookup particular product # and use it instead to get stock info.
ToDos:
  • It's possible to automatically get Product# using UPC, so I will add check using UPC&barcode scanner.
  • Fix issue with multiple product #'s by displaying a dropdown list in search result item.
  • Add search filtering

HomeDepot:
  • Unfortunately, price information is not always accurate. It shows whatever homedepot.ca gives it and the actual in-store price might differ.
  • I store internally stock nad price information and give cached results if they exist. This is done because HD doesn't like too many requests being sent within a short period of time and if a lot of people start pulling it blocks my tracker and no one will be able to get anything. The last column in the result table indicates how long ago information was retrieved and if it was >10 minutes ago you can click on it to refresh.
  • The same reason is to lock the maximum number of stores to 10
  • You can try to get stock and price information using either SKU or UPC
  • Search option might actually give more results than when you search on homedepot.ca (it also shows results that are no longer listed there, but might be available in stores)

BestBuy and IKEA checkers are similar to what their corresponding websites are offering. There is no per-store price info. The only advantage is that you can check many stores at once.
I tried to do similar checkers for Lowes, Toys'r'Us and the Source, but it's more complicated and they don't seem to allow sending stock requests directly. At least I couldn't find an easy way by pretending to be a browser.

I also created Google Chrome and FireFox plugins that when you browse walmart.ca, canadiantire.ca and bestbuy.ca it adds a 'StockTrack' button to open stocktrack.ca with the UPC of a browsed item.


General ToDo:
Let me know if you have any questions on how to use this tool or any suggestions.
I do this in my spare time and I'm not a professional web developer, so be easy :)
I am not profiting in any way from people using stocktrack.ca. there are no ads, affiliate links or subscription fees for premium features. If you like it and want to support its running costs, you can do it by hitting 'Donate' button.
Cheers!

Update 2018/10/18:
  • Mobile devices can use barcode scanner to automatically scan UPC codes and check stock info in walmarts nearby. The button to start scanning will be displayed next to UPC field. It will ask for permission to use your camera and will start barcode scan. To cancel scanning just tap the screen.
Update 2018/11/01:
  • Check by Walmart SKU. It will try to get UPC using the SKU and then search for stock info.
  • BestBuy checker stopped working so I removed it altogether. I find it useless and don't have time & will to investigate.
Update 2018/11/05:
  • Deals! Lists recently found products with discounts.
Update 2018/11/09:
  • Added some filtering and ordering of product in Deals search.
  • Can include prices from stores where item is OOS
  • Can only search deals in stores specified by location setting
  • Sort by more recently updated, max discount, max/min regular price
Update 2018/11/10:
  • Page address is modified when checking for product to include upc/product number in a path to load results automatically if page reloads. You can also copy and share that address with someone.
Update 2018/11/16:
  • Added 'keyword' option to Walmart Deals. Can specify any word that must appear in the product name.
Update 2018/11/19:
  • Added filters to Walmart search. Can only show products that are sold by Walmart and change result sorting.
Update 2018/11/22:
  • Added 'Walmart Daily Price Drops' which shows products that were discounted today and available to buy from walmart.ca. Clicking on the item will also show availability and price in stores near the location. I'm only tracking items that were ever searched through my tool
Update 2018/11/25:
  • Added 'Weekly Price Drops' after noticing there were no daily drops at some point on Sunday. It will show items which current price is lowest over the last 7 days and how much it dropped from the highest.
Update 2018/12/05:
  • Added online price history chart when mouse over an item in the Price Drops area for Walmart. On touch devices it works when you tap and hold.
Update 2018/12/10:
  • Added store price/status history chart when mouse over price in the Stores Inventory results grid.
Update 2019/01/08 for Canadian Tire:
  • Can choose in which provinces stores to search. Still need to use distance, but can put a large number like 5000 if you want to search whole province. Usefull when shipping is available and in-store price is the same as online (not always the case though)
  • Can hide stores without stock
Update 2019/01/16:
  • Created Google Chrome plugin that when you browse walmart.ca adds a button near 'Buy In-Store' to open stocktrack.ca with the UPC of a browsed item. Will add support for canadiantire.ca and bestbuy.ca soon.
Update 2019/01/17: Update 2019/01/18: Update 2019/01/22:
  • Walmart now shows quantity information too.
Update 2019/01/29:
  • Walmart deals section can now be filtered by savings %
Update 2019/06/29:
  • Added beta version of HomeDepot stock checker https://stocktrack.ca/?s=hd
  • To limit amount requests to HD it does not update stock information automatically, but shows cached numbers. You can refresh by clicking on the last cell of the row where it's shown how long ago it was updated. This can be done only if it was longer then 10 min. ago.
  • Price is not always accurate, especially for yellow tags.
  • Instead of SKU you can also use UPC from the barcode or receipt.
  • Limited number of stores to 10
Update 2019/07/03:
  • Added Search option for HomeDepot stock checker
How you could create the website yourself and got all the API access ?
Are you an individual or an entity ?
Regardless, you dont have to answer if you dont want you as the the job done is great.
Deal Expert
Aug 22, 2006
28644 posts
14191 upvotes
seafish wrote: Added Search option for HomeDepot stock checker
OH MY $DEITY I LOVE YOU
Home depot's search is a dumpster fire.

Could you make an option to open this in a larger window (preferably with more results per page?)

Now... if you could only find a way to fix Loblaw's dumpster fire of a website in general.
Do you not have anything else to do rather than argue with strangers on the internet
Nope. That's why I'm on the internet arguing with strangers. If I had anything better to do I'd probably be doing it.

Top

Thread Information

There is currently 1 user viewing this thread. (0 members and 1 guest)