<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: MindMoxie</title>
    <description>The latest articles on DEV Community by MindMoxie (@mindmoxie).</description>
    <link>https://dev.to/mindmoxie</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4182993%2F320a2ec6-ec91-42c1-8a15-8cac0cea133f.jpg</url>
      <title>DEV Community: MindMoxie</title>
      <link>https://dev.to/mindmoxie</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/mindmoxie"/>
    <language>en</language>
    <item>
      <title>Air Jordan 4 resale: the size you buy changes the price more than the colorway hype</title>
      <dc:creator>MindMoxie</dc:creator>
      <pubDate>Tue, 13 Oct 2026 19:39:34 +0000</pubDate>
      <link>https://dev.to/mindmoxie/air-jordan-4-resale-the-size-you-buy-changes-the-price-more-than-the-colorway-hype-37g4</link>
      <guid>https://dev.to/mindmoxie/air-jordan-4-resale-the-size-you-buy-changes-the-price-more-than-the-colorway-hype-37g4</guid>
      <description>&lt;p&gt;Sneaker price talk usually quotes one number per shoe. On GOAT there is no single price. Every size has its own lowest ask, and the gap between sizes of the same shoe is often bigger than the gap between two different colorways.&lt;/p&gt;

&lt;p&gt;I pulled per-size prices for 21 Air Jordan 4 colorways from GOAT (US market, new in box) on October 13, 2026. That gave 458 size-level prices. Here is what they show.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Eight of 21 colorways are available below retail
&lt;/h2&gt;

&lt;p&gt;A lot of recent Jordan 4s can be bought new for less than the store price, if you take the cheapest size.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Colorway&lt;/th&gt;
&lt;th&gt;Retail&lt;/th&gt;
&lt;th&gt;Lowest ask&lt;/th&gt;
&lt;th&gt;vs retail&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;SE Craft 'Photon Dust'&lt;/td&gt;
&lt;td&gt;$210&lt;/td&gt;
&lt;td&gt;$125&lt;/td&gt;
&lt;td&gt;-40%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'Flight Club' (2026)&lt;/td&gt;
&lt;td&gt;$220&lt;/td&gt;
&lt;td&gt;$149&lt;/td&gt;
&lt;td&gt;-32%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'Rare Air - Tour Yellow' (2026)&lt;/td&gt;
&lt;td&gt;$220&lt;/td&gt;
&lt;td&gt;$155&lt;/td&gt;
&lt;td&gt;-30%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'Bred Reimagined'&lt;/td&gt;
&lt;td&gt;$215&lt;/td&gt;
&lt;td&gt;$178&lt;/td&gt;
&lt;td&gt;-17%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'Military Blue' (2024)&lt;/td&gt;
&lt;td&gt;$215&lt;/td&gt;
&lt;td&gt;$189&lt;/td&gt;
&lt;td&gt;-12%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;The ones that hold a real premium are the older, proven pairs:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Colorway&lt;/th&gt;
&lt;th&gt;Retail&lt;/th&gt;
&lt;th&gt;Lowest ask&lt;/th&gt;
&lt;th&gt;vs retail&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;'Red Thunder' (2022)&lt;/td&gt;
&lt;td&gt;$190&lt;/td&gt;
&lt;td&gt;$371&lt;/td&gt;
&lt;td&gt;+95%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'White Thunder' (2024)&lt;/td&gt;
&lt;td&gt;$215&lt;/td&gt;
&lt;td&gt;$329&lt;/td&gt;
&lt;td&gt;+53%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'Military Black' (2022)&lt;/td&gt;
&lt;td&gt;$210&lt;/td&gt;
&lt;td&gt;$319&lt;/td&gt;
&lt;td&gt;+52%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;SE 'Black Canvas' (2022)&lt;/td&gt;
&lt;td&gt;$210&lt;/td&gt;
&lt;td&gt;$304&lt;/td&gt;
&lt;td&gt;+45%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;'Black Cat' (2025)&lt;/td&gt;
&lt;td&gt;$225&lt;/td&gt;
&lt;td&gt;$324&lt;/td&gt;
&lt;td&gt;+44%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;h2&gt;
  
  
  2. The "lowest ask" is usually for a size you do not wear
&lt;/h2&gt;

&lt;p&gt;For the typical colorway, the middle-priced size costs 25% more than the cheapest size. The headline price on a product page is the cheapest size, so most buyers pay more than that number.&lt;/p&gt;

&lt;p&gt;Example: 'Military Blue' 2024 has a lowest ask of $189 (size 14). The median size is $246. Size 6.5 is $613.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Small sizes cost the most
&lt;/h2&gt;

&lt;p&gt;I compared each size to the median ask of its own shoe, then took the middle value across all 21 colorways.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;US men's size&lt;/th&gt;
&lt;th&gt;Price vs the shoe's median&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;5.5 to 6.5&lt;/td&gt;
&lt;td&gt;+37% to +62%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;4&lt;/td&gt;
&lt;td&gt;+34%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;7 to 7.5&lt;/td&gt;
&lt;td&gt;+7% to +9%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;8 to 9&lt;/td&gt;
&lt;td&gt;about the median&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;9.5 to 12&lt;/td&gt;
&lt;td&gt;6% to 11% below&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;15 to 17&lt;/td&gt;
&lt;td&gt;+17% to +39%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Sizes 9.5 to 12 are the cheapest because that is where the supply is. Sizes 5.5 to 6.5 carry the largest premium. If you resell, the same shoe in a 6 can be worth $100 more than in an 11.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Asks sit close to the last sale
&lt;/h2&gt;

&lt;p&gt;Across the 458 size prices, the median gap between the current lowest ask and the last sold price for that size was 0%. About 40% of asks were above the last sale and 60% at or below it. For in-stock sizes, the lowest ask is a fair guide to what the pair actually trades at. The extreme asks ($2,000+ on a rare size) are the exception: those are single sellers with no competition, not a market price.&lt;/p&gt;

&lt;h2&gt;
  
  
  How to pull this yourself
&lt;/h2&gt;

&lt;p&gt;GOAT has no public price API and blocks plain requests. I built a tool on Apify that returns this data as a table: &lt;a href="https://apify.com/malek_oweis/goat-sneaker-price-scraper" rel="noopener noreferrer"&gt;GOAT Sneaker Price Scraper&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;Input used for this article:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"queries"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"air jordan 4 retro"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"maxProductsPerInput"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"includeSizePrices"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="kc"&gt;true&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each product row has the retail price, release date, lowest ask, cheapest and most expensive size, premium vs retail, and a list of every size with its lowest ask, instant-ship ask, last sold price, and stock. Export to CSV, Excel, or JSON. It costs $3 per 1,000 products.&lt;/p&gt;

&lt;h2&gt;
  
  
  Limits to know about
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Prices are US market, in US dollars. GOAT shows different prices to visitors from other countries.&lt;/li&gt;
&lt;li&gt;"New" means new shoes in a good box. Used and damaged-box pairs are a separate option.&lt;/li&gt;
&lt;li&gt;This is a one-day snapshot of 21 colorways. One unreleased pair with a single $2,059 listing was removed.&lt;/li&gt;
&lt;li&gt;Size-level runs can be slow when GOAT is under load. A 25-product run with all sizes took about 10 minutes on the day I wrote this.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If a number looks wrong for a pair you know well, tell me and I will check it.&lt;/p&gt;

</description>
      <category>webscraping</category>
      <category>datascience</category>
      <category>python</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>What a used Nintendo Switch actually sells for on Mercari (and how to pull sold prices yourself)</title>
      <dc:creator>MindMoxie</dc:creator>
      <pubDate>Tue, 13 Oct 2026 19:38:49 +0000</pubDate>
      <link>https://dev.to/mindmoxie/what-a-used-nintendo-switch-actually-sells-for-on-mercari-and-how-to-pull-sold-prices-yourself-5ae4</link>
      <guid>https://dev.to/mindmoxie/what-a-used-nintendo-switch-actually-sells-for-on-mercari-and-how-to-pull-sold-prices-yourself-5ae4</guid>
      <description>&lt;p&gt;If you resell consoles, the asking prices on Mercari tell you very little. Sellers list high and then cut. What matters is the price the item sold at.&lt;/p&gt;

&lt;p&gt;I pulled the most recent sold listings for three searches on Mercari US on October 13, 2026 and cleaned them up. Here is what came out, and how you can run the same check for any product.&lt;/p&gt;

&lt;h2&gt;
  
  
  The numbers
&lt;/h2&gt;

&lt;p&gt;I kept only listings in the Consoles category and removed boxes, cases, and "for parts" units.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Nintendo Switch OLED&lt;/strong&gt; (31 sold consoles)&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Condition&lt;/th&gt;
&lt;th&gt;Sales&lt;/th&gt;
&lt;th&gt;Median sold price&lt;/th&gt;
&lt;th&gt;Range&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Like new&lt;/td&gt;
&lt;td&gt;11&lt;/td&gt;
&lt;td&gt;$189&lt;/td&gt;
&lt;td&gt;$139 to $279&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Good&lt;/td&gt;
&lt;td&gt;18&lt;/td&gt;
&lt;td&gt;$161&lt;/td&gt;
&lt;td&gt;$106 to $355&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;New&lt;/td&gt;
&lt;td&gt;2&lt;/td&gt;
&lt;td&gt;$290&lt;/td&gt;
&lt;td&gt;$243 to $337&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Nintendo Switch Lite&lt;/strong&gt; (33 sold consoles)&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Condition&lt;/th&gt;
&lt;th&gt;Sales&lt;/th&gt;
&lt;th&gt;Median sold price&lt;/th&gt;
&lt;th&gt;Range&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Like new&lt;/td&gt;
&lt;td&gt;8&lt;/td&gt;
&lt;td&gt;$113&lt;/td&gt;
&lt;td&gt;$83 to $189&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Good&lt;/td&gt;
&lt;td&gt;19&lt;/td&gt;
&lt;td&gt;$90&lt;/td&gt;
&lt;td&gt;$50 to $180&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Fair or Poor&lt;/td&gt;
&lt;td&gt;5&lt;/td&gt;
&lt;td&gt;about $48&lt;/td&gt;
&lt;td&gt;$44 to $65&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Nintendo Switch 2&lt;/strong&gt;: only 12 real console sales in the sample, median about $395. Too few to split by condition.&lt;/p&gt;

&lt;p&gt;These are small samples from one day, so treat them as a snapshot, not a price guide.&lt;/p&gt;

&lt;h2&gt;
  
  
  Three things the data showed
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;1. Most sellers had to cut their price to sell.&lt;/strong&gt; 26 of the 31 OLED consoles and 26 of the 33 Lite consoles sold below their first asking price. The median cut was about 27%. The median first ask for an OLED was $250; the median sale was $167. If you price from active listings, you are pricing from numbers that mostly did not work.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;2. "Like new" is worth about $25 more than "Good".&lt;/strong&gt; On both models the gap between the two most common conditions was $23 to $28. That is the real value of a clean screen and a box, and it is smaller than many sellers assume.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;3. A keyword search is mostly noise.&lt;/strong&gt; The search "nintendo switch 2 console" returned 300 sold listings. Only 30 were in the Consoles category, and only 12 were actual Switch 2 consoles. The rest were games, cases, and boxes. The raw median for that search was $40, which is meaningless. You have to filter by category and read the titles before you trust any average.&lt;/p&gt;

&lt;h2&gt;
  
  
  How to pull the same data
&lt;/h2&gt;

&lt;p&gt;Mercari has no public API, and the search page loads its results in the browser, so a simple page download returns an empty shell.&lt;/p&gt;

&lt;p&gt;I built a small tool for this on Apify: &lt;a href="https://apify.com/malek_oweis/mercari-sold-listings-scraper" rel="noopener noreferrer"&gt;Mercari Sold Listings Scraper&lt;/a&gt;. You give it search terms, it returns one row per listing.&lt;/p&gt;

&lt;p&gt;Input used for this article:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"queries"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"nintendo switch oled console"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"nintendo switch lite console"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"nintendo switch 2 console"&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"sold"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"maxItemsPerSearch"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;300&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each row has the title, sold price, first asking price, price drop in percent, condition, brand, category, listing date, and the listing URL. You can export to CSV, Excel, or JSON.&lt;/p&gt;

&lt;p&gt;This run returned 462 listings in about 25 seconds. The tool costs $1.50 per 1,000 listings, so this article's data cost less than one dollar.&lt;/p&gt;

&lt;h2&gt;
  
  
  Cleaning steps that matter
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Filter to the right category (&lt;code&gt;category = Consoles&lt;/code&gt; here).&lt;/li&gt;
&lt;li&gt;Drop titles with "box only", "case", "for parts", "won't charge".&lt;/li&gt;
&lt;li&gt;Set a price floor that removes accessories (I used $90 for the OLED, $35 for the Lite).&lt;/li&gt;
&lt;li&gt;Split by condition before taking a median. Mixing "Poor" and "Like new" hides the number you need.&lt;/li&gt;
&lt;li&gt;Use the median, not the average. One bundle with ten games moves the average a lot.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Limits to know about
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Mercari does not show the sale date. The tool sorts by most recently sold and gives you the listing date.&lt;/li&gt;
&lt;li&gt;Mercari returns at most about 1,000 results per search. Narrow searches give cleaner data anyway.&lt;/li&gt;
&lt;li&gt;Prices are item prices. Shipping is not included.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you run it on a category you know well and something looks wrong, tell me. I fix reported problems quickly.&lt;/p&gt;

</description>
      <category>webscraping</category>
      <category>datascience</category>
      <category>python</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
