search

driscoll42 / ebayMarketAnalyzer

Scrape all eBay sold listings to determine average/median pricing, plot listings over time with trend lines, and extract to excel
195 stars 26 forks source link

Duplicates of multilistings #34

Closed driscoll42 closed 3 years ago

driscoll42 commented 3 years ago

Describe the bug It appears that for multilistings the code is duplicating lines. And example is:

https://www.ebay.com/itm/GIGABYTE-GeForce-RTX-3070-VISION-OC-8-GB-GDDR6-Graphics-Card/333873783226?epid=27042451253&hash=item4dbc6da1ba:g:07IAAOSwXJpgFZP3

It is in the spreadsheet twice.

Screenshots It should only be in there once.

driscoll42 commented 3 years ago

There were two/three bugs that fixed this:

  1. In the check to write to the excel file, was using item_datetime instead of the datetime of the sale itself in two places
  2. Did not realize that sometimes eBay would have just an offer history without a purchase history