Lincoln | 230 Posted December 29, 2020 Share Posted December 29, 2020 (edited) I'm trying to put together a list of zip codes to cover all (or pretty close) gamestop stores using their 100 mile search. Does anyone have a good list for this? I started with the 100 most populous zips but it skews pretty heavy and there are a bunch that look redundant with clustering. this was a free map tool i found online but the radius feature is included in the paid version. if anyone can recommend a free tool to plot points+radius i'd appreciate it willing to put together a shared doc if anyone wants to help work on it Edited December 30, 2020 by Lincoln Link to comment Share on other sites More sharing options...
Tabonga | 2,325 Posted December 30, 2020 Share Posted December 30, 2020 This is supposed to allow you to download an excel file of all the gamestop locations. Assuming there is column for the just the zip codes you should be able to sort by that. https://www.scrapehero.com/location-reports/GameStop-USA/ Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 1 minute ago, Tabonga said: This is supposed to allow you to download an excel file of all the gamestop locations. Assuming there is column for the just the zip codes you should be able to sort by that. https://www.scrapehero.com/location-reports/GameStop-USA/ i came across that, it's $75 to download Link to comment Share on other sites More sharing options...
Tabonga | 2,325 Posted December 30, 2020 Share Posted December 30, 2020 6 minutes ago, Lincoln said: i came across that, it's $75 to download I didn't look closely - unless a person had a real specific need seems a bit excessive. Link to comment Share on other sites More sharing options...
Tabonga | 2,325 Posted December 30, 2020 Share Posted December 30, 2020 Did you contact corporate to see if they can provide a list for you? I can't see why they wouldn't provide that if they thought it might drum up some business. Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 I haven't done that, it might help to have a complete list but it would entail a lot of cultivating. I'm trying to find zips that cover the bulk of the stores while eliminating those that are redundant. May end up having to figure out point to point distance eventually but I'm hoping for something better to start with. Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 What's the end goal? 1 Link to comment Share on other sites More sharing options...
Tabonga | 2,325 Posted December 30, 2020 Share Posted December 30, 2020 5 minutes ago, Lincoln said: I haven't done that, it might help to have a complete list but it would entail a lot of cultivating. I'm trying to find zips that cover the bulk of the stores while eliminating those that are redundant. May end up having to figure out point to point distance eventually but I'm hoping for something better to start with. If you can get a sortable file from them the clusters should stand out - since the zips are assigned geographically you should be able to put in the mid zip code from each cluster to give you something resembling a 100 mile radius. Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 16 minutes ago, Gloves said: What's the end goal? efficiently do a store inventory search for a given product Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 3 minutes ago, Lincoln said: efficiently do a store inventory search for a given product Where are you intending to get that information? Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 15 minutes ago, Gloves said: Where are you intending to get that information? gamestop website lets you search. for example contra https://www.gamestop.com/video-games/retro-gaming/nintendo/games/products/contra/10122770.html is apparently in stock at a store near me Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 3 minutes ago, Lincoln said: gamestop website lets you search. for example contra https://www.gamestop.com/video-games/retro-gaming/nintendo/games/products/contra/10122770.html is apparently in stock at a store near me I'm not sure, then, that I understand what you're trying to do here? Why not just literally use their website's search? Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 (edited) 4 minutes ago, Gloves said: I'm not sure, then, that I understand what you're trying to do here? Why not just literally use their website's search? it only does 100 mile radius. so, assuming there is one of something in some store somewhere in the country, you have to find a close enough zip code to get the location with the item. i'm trying to come up with a minimum list of zip codes that I can run to check all/most of the stores. afaik there's no way to search all stores at once, only by the radius thing. Edited December 30, 2020 by Lincoln Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 Just now, Lincoln said: it only does 100 mile radius. so, assuming there is one of something in some store somewhere in the country, you have to find a close enough zip code to get the location with the item. i'm trying to come up with a minimum list of zip codes that I can run to check all/most of the stores. Why not just centralize on city in that case? A list of cities is easy to obtain. Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 2 minutes ago, Gloves said: Why not just centralize on city in that case? A list of cities is easy to obtain. that would be more comprehensive than what i have now. but, there are lots of cities in the country, and very many of those will fall within 100 miles of the next city. you're looking at thousands of zip codes, versus maybe a few dozen i think i could get away with when optimized. as i'm feeding this into the gamestop website, which is garbage and slow as shit, execution time is a consideration. Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 2 minutes ago, Lincoln said: that would be more comprehensive than what i have now. but, there are lots of cities in the country, and very many of those will fall within 100 miles of the next city. you're looking at thousands of zip codes, versus maybe a few dozen i think i could get away with when optimized. as i'm feeding this into the gamestop website, which is garbage and slow as shit, execution time is a consideration. With a bit of math you could always just find the central point for circles on a globe every 200 miles and feed in the latlng value. The USPS API is free to use apparently, and if it provides similar information to the Canada Post API you could use that for your initial data gathering. You just have to create a matrix and get the data once, then iterate over it when making calls in future. Google Maps, last I checked, has some simple "Get X within Y Radius" features. Have you looks into the Maps API recently? Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 6 minutes ago, Gloves said: With a bit of math you could always just find the central point for circles on a globe every 200 miles and feed in the latlng value. The USPS API is free to use apparently, and if it provides similar information to the Canada Post API you could use that for your initial data gathering. You just have to create a matrix and get the data once, then iterate over it when making calls in future. Google Maps, last I checked, has some simple "Get X within Y Radius" features. Have you looks into the Maps API recently? i haven't worked with google maps that i remember, so i'm putting that option off as it means learning something new. i might get there eventually, but i was hoping for a shortcut to get started. thanks for the tip on the usps thing, i might look into that. Link to comment Share on other sites More sharing options...
Makar | 1,946 Posted December 30, 2020 Share Posted December 30, 2020 I wish they just had a search all option. “I want this ds game. Search all the stores in the country so I can have it shipped to my store.” it’s extremely frustrating and time consuming to go through all the zipcodes. When I had lots of time I remember going through every 1000 zipcodes, so start with 01000 then 02000 03000 and so on all the way up to 99000. For every....single.....game..... it was worth it though. Ended up getting a couple games I really wanted but boy does it take a while. Good luck @Lincoln! Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 @Lincoln FYI, the Gamestop internal API looks to be not particularly strict. You can edit the value of the Option tag on the dropdown for radius, and it'll actually pass that value to their server call. Looks like you CAN go too high, but this might help you do more at once at a wider radius, if nothing else. 1000 was too high (500 internal server error), but 110 worked fine: So somewhere between 100 and 1000, there's a "highest possible" number, likely due to some timeout or something server-side. Find that sweet spot number and your life is that little bit easier. EDIT: 500 worked fine: Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 18 minutes ago, Gloves said: @Lincoln FYI, the Gamestop internal API looks to be not particularly strict. You can edit the value of the Option tag on the dropdown for radius, and it'll actually pass that value to their server call. Looks like you CAN go too high, but this might help you do more at once at a wider radius, if nothing else. 1000 was too high (500 internal server error), but 110 worked fine: So somewhere between 100 and 1000, there's a "highest possible" number, likely due to some timeout or something server-side. Find that sweet spot number and your life is that little bit easier. EDIT: 500 worked fine: that is an excellent find, thanks. will simplify things considerably. too bad i can't hit that service url directly, that would make it so easy. i was doing that for quite a while but they got smart about it. Link to comment Share on other sites More sharing options...
FireHazard51 | 2,047 Social Team · Posted December 30, 2020 Share Posted December 30, 2020 16 minutes ago, Gloves said: @Lincoln FYI, the Gamestop internal API looks to be not particularly strict. You can edit the value of the Option tag on the dropdown for radius, and it'll actually pass that value to their server call. Looks like you CAN go too high, but this might help you do more at once at a wider radius, if nothing else. 1000 was too high (500 internal server error), but 110 worked fine: So somewhere between 100 and 1000, there's a "highest possible" number, likely due to some timeout or something server-side. Find that sweet spot number and your life is that little bit easier. EDIT: 500 worked fine: This is the best way by far. You can do a few searches. Hell you could probably write a script to open a web page for each search with the specific key word search. This seems like a fun project. I'll keep this in mind when I pick up learning Python again. Link to comment Share on other sites More sharing options...
Gloves | 11,807 Administrator · Posted December 30, 2020 Share Posted December 30, 2020 1 minute ago, Lincoln said: that is an excellent find, thanks. will simplify things considerably. too bad i can't hit that service url directly, that would make it so easy. i was doing that for quite a while but they got smart about it. If you can help it, do it on a VPN. If they see these API calls they're likely to IP ban. Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 3 minutes ago, Gloves said: If you can help it, do it on a VPN. If they see these API calls they're likely to IP ban. i hammered on their site for like 5 years before i had any issues. i got temp banned for a while, and now i can access the site again but i believe they've locked down all their services to prevent direct calls. so i'm doing it the hard way through a headless browser, we'll see how long it lasts. Link to comment Share on other sites More sharing options...
FireHazard51 | 2,047 Social Team · Posted December 30, 2020 Share Posted December 30, 2020 2 hours ago, Lincoln said: gamestop website lets you search. for example contra https://www.gamestop.com/video-games/retro-gaming/nintendo/games/products/contra/10122770.html is apparently in stock at a store near me So goes GameStop actually have good prices for old cart games? Link to comment Share on other sites More sharing options...
Lincoln | 230 Posted December 30, 2020 Author Share Posted December 30, 2020 7 minutes ago, FireHazard51 said: So goes GameStop actually have good prices for old cart games? there are some yes, particularly when there are deals like now or when discount codes work (cag16) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now