Hey Cheapies,
This is for all the DataHoarders and "lowest price per TB" HDD hunters. I've made a Google Sheet to parse the 3 main HDD categories on East Digitals website, namely:
Features:
- Tables can be sorted and filtered by Date, Drive Size, Price Per TB, Price, Sale Price, Stock Status and Sale Status
- Pivot Table per category for consolidated stats per unique product
- Script is adaptable to any other similar Shopify website (see source code linked below)
- Added bonus, even though the sale prices are hidden on the website, it is still in the page source code, the script will parse for this info as well, so you can see the last sale price
- Products are hyperlinked with previews (no affiliate links)
- HDD Lookup table - enter your desired size and it will spit out the lowest price, date and link to the relative cell
- Pagination handling - script will go through as many pages of listings as there are in each category
Things to Note:
- Script automatically runs once a day (7pm-8pm each day)
- Most cells are locked except for the Drive Lookup section and the Pivot tables.
TODO (i.e if someone smarter than me can help, that would be awesome):
* Pull stock status (in or out of stock) | Github PR
* Column / Cell formatting if a drive is on sale | Github PR
* Obtain NZD from website instead of calculating it (room for error) | Github PR
Check your drives
old used seagate exos drives sold as new
get real "power on hours" for seagate exos drives (only, not WD) using:
"smartctl -l farm $dev" instead of "smartctl -A $dev"
Original post from ozbargain: https://www.ozbargain.com.au/node/891267?utm_source=searchal…
FARM checker tool: https://github.com/gamestailer94/farm-check?tab=readme-ov-fi…
Background: https://www.heise.de/en/news/Fraud-with-Seagate-hard-disks-D…
Feedback welcomed, feel free to make a copy and use as you wish.
Great work MoodKiller!