o vi[@sddlZddlZeeZddlmZddlmZmZddl m Z ddl m Z ddl Z edddZedddZe dZdd d Zd d iZdddZddZddZddZddZedddddZddZd d!Zd"d#Zd$d%Zd&d'Zd(d)Zd*d+Zd,d-Z d.d/Z!d0d1Z"d2d3Z#d4d5Z$d6d7Z%d8d9Z&d:d;Z'dd?Z)d@dAZ*dBdCZ+dDdEZ,dFdGZ-dHdIZ.dJdKZ/ddlmZeddddLdMZ0dNdOZ1dPdQZ2dRdSZ3dTdUZ4dVdWZ5dXdYZ6dZd[Z7d\d]Z8d^d_Z9d`daZ:dbdcZ;dddeZdjdkZ?dldmZ@dndoZAdpdqZBdrdsZCdtduZDdvdwZEdxdyZFdzd{ZGd|d}ZHd~dZIddZJddZKddZLddZMddZNddZOddZPddZQddZRddZSdS)N)retry)datetime timedelta)timezone) validate_asinizAmerica/Toronto%Y-%m-%dc Cs|dus t|tr |dkrdSztt|d}|jtddt}||WSt yE}zt d|d|WYd}~dSd}~ww) z1Converts Keepa time minutes to a datetime string.Nr-minutesUTC)tzinfoz Error converting Keepa minutes (z) to datetime: ) isinstanceintKEEPA_EPOCH_DATETIMErreplacer astimezone TORONTO_TZstrftime Exceptionloggererror) keepa_minutes date_formatdt_utc dt_torontoer6/var/www/agentarbitrage/keepa_deals/stable_products.pykeepa_minutes_to_datetime_str(s rz User-Agentz>Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/90.0.4430.212FcCs4zp||g}td|d|d|d||r t||kr/td|d|dWdS||}td|d|d|t|trRt|d krP|d nd }|d ksZ|dur]WdS|rhd ||d WSt||d WStt t fy}zt d|d|d|dt |WYd}~dSd}~ww)Nzget_stat_value: key=z, index=z, stats[z]=z get_stat_value: No data for key=z, returning '-'r z, value=r$.2f,zget_stat_value failed: stats=z, key=z, error=) getrdebuglenwarningrlistr IndexError TypeErrorAttributeErrorrstr)statskeyindexdivisoris_pricevaluerrrrget_stat_value:s( " &r3c Cstd|dd|di}|ddgdd}|d dgdd}|d ks8|d ks8|dus8|durNtd |ddd |d |ddiSz|||d}|dd}td|d|iWSty}ztdt|ddiWYd}~Sd}~ww)Nzpercent_down_90 input: asinr r-avg90r currentrz#No valid avg90 or current for ASIN z: avg=z, curr=zPercent Down 90d.0f%zpercent_down_90 result: zpercent_down_90 failed: )rr%r$rrr,)productstats_90avgcurrr2percentrrrrpercent_down_90Ps"  $  rAcCsB|dd}d|dkrd|dndi}td|d||S)Nr4r zAMZ linkzhttps://www.amazon.com/dp/z ?psc=1&aod=1zamz_link result for ASIN : r$rr%r<r4resultrrramz_linkrs rFcCs@|dd}d|dkrd|ndi}td|d||S)Nr4r z Keepa Linkzhttps://keepa.com/#!product/1-zkeepa_link result for ASIN rBrCrDrrr keepa_linkzs rGcCsV|dd}|dd}|dkrtd|td|d|ddd |iS) Ntitler r4unknownz#get_title: No title found for ASIN zget_title result for ASIN rB2Titler$rr'r%)r<rHr4rrr get_titles  rMi)stop_max_attempt_number wait_fixedc Cs|dd}td||dkr"td|dddd iSz0tt|d }|jdur5t|}n| t}| d }td |ddd |d|iWSt yr}ztdt |dd iWYd}~Sd}~ww)N trackingSincerzTracking since - raw ts=iz No valid trackingSince for ASIN r4rIzTracking sincer r rzTracking since result for ASIN rBztracking_since failed: ) r$rr%rKEEPA_EPOCH_LEGACYrr rlocalizerrrr,)r<tsdtr formattedrrrrtracking_sinces$      rWcCsF|dg}d|r|ddndi}td|ddd ||S) N categoryTreezCategories - Rootrnamer z categories_root result for ASIN r4rIrBrCr< category_treerErrrcategories_roots r\cCs^|dg}dt|dkrddd|ddDndi}td|d d d ||S) NrXzCategories - Subr7z, cs|]}|dVqdSrYNr.0catrrr z!categories_sub..r zcategories_sub result for ASIN r4rIrB)r$r&joinrr%rZrrrcategories_subs 0recCsN|dg}d|rddd|Dndi}td|dd d ||S) NrXzCategories - Treez > csr]r^rr_rrrrbrcz"categories_tree..r z categories_tree result for ASIN r4rIrB)r$rdrr%rZrrrcategories_trees  rfcCs.|dd}d|i}td|d||S)Nr4r ASINzget_asin result for ASIN rBrCrDrrrget_asins rhcCJ|dd}|r|dkrd}d|i}td|ddd||S) N manufacturerr Manufacturerzmanufacturer result for ASIN r4rIrBr$striprr%)r<manufacturer_valuerErrrrj rjcCri) Nbrandr rkBrandzget_brand result for ASIN r4rIrBrm)r< brand_valuerErrr get_brandrprtcCri) Nauthorr rkAuthorzauthor result for ASIN r4rIrBrm)r< author_valuerErrrrurprucCri) Nbindingr rkBindingzbinding result for ASIN r4rIrBrm)r< binding_valuerErrrrxrprxc Cs|dd}td|d|dp|d}|dur*td|dd d iSd}t|trut|}z&t|d krOd |krFd krOnnt |d}n |dkrZt t |d}Wn9t t fyttd|d|dd}Yn!wt|trgd}|D]}z t ||}Wn t yYqw|r|d}td|d|d|dd |iStd|d|dt|dd d iS)z Retrieves and formats the publication date of the product to a standard 'YYYY-MM-DD' format. Handles Keepa Time Minutes (KTM), YYYYMMDD integers, and various common date string formats. r4rIASIN z5: Attempting to get and standardize publication date.publicationDate releaseDateNzD: Neither 'publicationDate' nor 'releaseDate' found. Outputting '-'.zPublication Dater i%!iL@z%Y%m%drr z : Could not parse integer date ''.)rz%m/%d/%yz%m/%d/%Yz%Y-%mz%b-%yz%Yrz: Parsed date 'z' to standard format 'z: Date value 'z ' (type: z&) could not be parsed. Outputting '-'.)r$rr%r'rrr,r&rstrptimerr ValueErrorr*rinfotype) product_datar4 date_value dt_objectdate_strformats_to_tryfmtformatted_daterrrget_publication_datesD  $    "rcCs6|dd}d|dkr|dddi}|Sdi}|S)N packageWeightr zPackage Weightir"z kgr r$)r<weightrErrrpackage_weightSs rcC@|dd}|dks|dkrddi}|Sd|dddi}|S) N packageHeightr rzPackage HeightMissing .1f cmr)r<heightrErrrpackage_heightZ rcCr) N packageLengthr rzPackage Lengthrrrrr)r<lengthrErrrpackage_lengthdrrcCr) N packageWidthr rz Package Widthrrrrr)r<widthrErrr package_widthnrrc Cs|dd}|dd}td|d||dkr*td|d|d d iSz,tt|d }|jdur=t|}n| t}| d }td |d|d |iWSt yy}zt d|dt |d d iWYd}~Sd}~ww)N listedSincerr4rIzListed since - raw ts= for ASIN zNo valid listedSince (ts= ) for ASIN z Listed sincer r rzListed since result for ASIN rBzlisted_since failed for ASIN )r$rr%rrRrr rrSrrrrr,)r<rTr4rUrrVrrrr listed_sincexs&       rc Cs@|di}t|dddd}|dkrd|iS|d}|rNt|dkrN|drN|d}t|d krN|d }|d krNtd |d d d|d|diS|d}|rt|trd }d }|D] \} }|rt|d kr|d} |d }|d kr| |kr| }|}qb|d krtd |d d d|d|diSddiS)Nr-r8rNFr1r zSales Rank - Currentcsvr7r r{r4rIz%: Using CSV fallback for Sales Rank: r# salesRanksz,: Using salesRanks fallback for Sales Rank: )r$r3r&rrrdictitems) r<r-valrhistorylast_val sales_ranksbest_valmax_tscat_idrTrrrsales_rank_currents8      rcC$|di}dt|ddddi}|S)Nr-zSales Rank - 30 days avg.avg30rNFrr$r3r<r-rErrrsales_rank_30_days_avg rcCsB|di}dt|ddddi}td|dd d ||S) Nr-zSales Rank - 90 days avg.r5rNFrz#Sales Rank - 90 days avg. for ASIN r4rIrBr$r3rr%rrrrsales_rank_90_days_avgs rcCr)Nr-zSales Rank - 180 days avg.avg180rNFrrrrrrsales_rank_180_days_avgrrcCr)Nr-zSales Rank - 365 days avg.avg365rNFrrrrrrsales_rank_365_days_avgrrc C|dd}|di}|dd}td|d||dkr0td |d |d d iSzt|}td |d|d |iWStyg}ztd|dt|d d iWYd}~Sd}~ww)Nr4rIr-salesRankDrops30r z,Sales Rank - Drops last 30 days - raw value=rrz0No valid Sales Rank - Drops last 30 days (value=rzSales Rank - Drops last 30 daysr z0Sales Rank - Drops last 30 days result for ASIN rBz.sales_rank_drops_last_30_days failed for ASIN r$rr%rr,rrr<r4r-r2rVrrrrsales_rank_drops_last_30_days    rc Cr)Nr4rIr-salesRankDrops180r z-Sales Rank - Drops last 180 days - raw value=rrz1No valid Sales Rank - Drops last 180 days (value=rz Sales Rank - Drops last 180 daysr z1Sales Rank - Drops last 180 days result for ASIN rBz/sales_rank_drops_last_180_days failed for ASIN rrrrrsales_rank_drops_last_180_daysrrc Cr)Nr4rIr-salesRankDrops365r z-Sales Rank - Drops last 365 days - raw value=rrz1No valid Sales Rank - Drops last 365 days (value=rz Sales Rank - Drops last 365 daysr z1Sales Rank - Drops last 365 days result for ASIN rBz/sales_rank_drops_last_365_days failed for ASIN rrrrrsales_rank_drops_last_365_days rrcCs|dd}|di}|dd}td|d||dur`|dkr`zd |d d }td |d |d|iWSty_}ztd|d|dt|WYd}~nd}~wwtd|d|d|d}|dd}td|d|d|d|r=|dg}|std|d|dt|D]\} } | d} | d} | dd} td|d| d | d!| d"| d | |kr,| |kr,| dkrz d | d d }td |d#|d$|d%|d|iWSty}ztd|d&| dt|WYd}~qd}~wwtd|d'|d(| d)qtd|d*|d$|d+n td|d,td|d-dd.iS)/Nr4rIr- buyBoxPricer zBuy Box - Current - ASIN z5 - Attempting to use 'buyBoxPrice' field. Raw value: rr!r9r"zBuy Box - Current for ASIN z: Using 'buyBoxPrice', value: zBuy Box - Currentz# - Error formatting 'buyBoxPrice' (): z/ - 'buyBoxPrice' is missing, None, or invalid (z). Attempting fallback.buyBoxSellerIdbuyBoxConditionrz - Fallback: buyBoxSellerId='z', buyBoxCondition=''offersz: - Fallback: No offers array found to search for sellerId .sellerId conditionpricez - Fallback: Checking offer z : sellerId='z', condition='z ', price='z<: Using Fallback Logic - Found matching offer for sellerId 'z' and condition 'z '. Price: z+ - Fallback: Error formatting offer price (z0 - Fallback: Matching offer found for sellerId 'z' but price is invalid ().z3 - Fallback: No matching offer found for sellerId 'z' with a positive price.zI - Fallback: 'buyBoxSellerId' is missing. Cannot perform fallback search.zc - Final decision: No valid Buy Box price found through primary or fallback methods. Returning '-'.r ) r$rr%rrrr,r' enumerate)r<r4r-buy_box_price_rawformatted_pricerbuy_box_seller_idbuy_box_conditionriofferoffer_seller_idoffer_conditionoffer_price_centsrrrbuy_box_currentsT    ,      * ", rcCs|dd}|di}|ddgdd}|dus|dkr+td|dd iSd |d d }td |d|d|iS)Nr4rIr-r8rz)No valid Amazon - Current price for ASIN zAmazon - Currentr r!r9r"z!Amazon - Current result for ASIN rBrLr<r4r-rrVrrramazon_currentas  rc Cs\|dd}|di}d}td|d|dg}td|d ||rt|d kr|d }td|d ||durt|ttfr|d krzd |d d}td|d|Wd|iSty}zt d|d|d|dd}WYd}~d|iSd}~wwt d|d|dd}d|iSt d|dd}d|iS)Nr4rIr-r z Amazon - 365 days avg. for ASIN z$: Attempting to use stats.avg365[0].rr{z: stats.avg365 raw: rz : Raw value at stats.avg365[0]: r!r9r"z : Using stats.avg365[0], value: : Error formatting price rB. Setting to '-'.z/: Invalid or missing price at stats.avg365[0] (). Setting to '-'z8: stats.avg365 array is empty or missing. Setting to '-'zAmazon - 365 days avg. r$rr%r&rrfloatrrrr')r<r4r- price_str avg365_array price_centsrrrramazon_365_days_avgs4    rc Cs|dd}|di}|ddgd}t|dkr|dnd}td|d |d t|d ||d ks>|dkrRtd |dt|d|ddiSzd|dd}td|d|d|iWSty}ztd|dt |ddiWYd}~Sd}~ww)Nr4rIr-r8r r6rzNew - Current - raw value=, current array= , stats_keys=rrzNo valid New - Current (value=, current_length=rz New - Currentr r!r9r"zNew - Current result for ASIN rBznew_current failed for ASIN r$r&rr%r(keysr'rrr,)r<r4r-r8r2rVrrrr new_currents"  *  rc CsF|dd}|di}|dg}d}td|dt|t|dkr|d}td |d ||dur}|d kr}zd |d d}td|d|Wd|iSty|}ztd|d|d|dd}WYd}~d|iSd}~wwtd|d|dd}d|iStd|dt|dd}d|iS)Nr4rIr-r8r z&New, 3rd Party FBA - Current for ASIN z=: Attempting to use stats.current[10]. current_array length: rr{z": Raw value at stats.current[10]: rr!r9r"z": Using stats.current[10], value: rrBrz1: Invalid or missing price at stats.current[10] (r(: stats.current array is too short (len z$) to access index 10. Setting to '-'zNew, 3rd Party FBA - Current)r$rr%r&rrrr')r<r4r- current_arrayrrrrrrnew_3rd_party_fba_currents2     rc Cs|dd}d}z|di}|dg}td|d||rt|dkr|d}td|d |t|trwt|d krw|d }|durjt|ttfrj|d krjd |d d}td|d|dn6t d|d|dn$t d|d|nt d|dt|dWd|iSWd|iSWd|iSWd|iSt y}zt d|dt |d}WYd}~d|iSd}~ww)Nr4rIr r-minr{z, - new_3rd_party_fba_lowest: stats.min raw: rz1 - new_3rd_party_fba_lowest: stats.min[10] pair: rrr!r9r"z%New, 3rd Party FBA - Lowest for ASIN z: Found price z from stats.min[10][1]z+: Invalid price value in stats.min[10][1] (rz%: stats.min[10] is not a valid pair: z3: stats.min array is too short or missing (length: z), cannot access index 10.z3Error processing new_3rd_party_fba_lowest for ASIN rBzNew, 3rd Party FBA - Lowest) r$rr%r&rr(rrrr'rrr,)r<r4rr-min_prices_arrayfba_lowest_pairrrrrrnew_3rd_party_fba_lowests<     rc Cst|dd}|di}|dg}d}d}td|d|t|d kr|d }td |d ||durt|ttfr|d krzd |dd}d}td|d|d|WnHty}zt d|d|d|dd}d}WYd}~n(d}~wwt d|d|dd}d}nt d|dt|dd}d}td|d|d|d|iS) Nr4rIr-r8r Nonez&New, 3rd Party FBM - Current for ASIN z5: Attempting to use stats.current[7]. current_array: r{z!: Raw value at stats.current[7]: rr!r9r"zstats.current[7]z: Using z , value: rz from stats.current[7]: rz#stats.current[7] (formatting error)z5: Invalid or non-positive price at stats.current[7] (rz stats.current[7] (invalid value)rz#) to access index 7. Setting to '-'zstats.current (too short)z: Final result: z , Source: zNew, 3rd Party FBM - Currentr)r<r4r-rrsourcerrrrrnew_3rd_party_fbm_current/s8     rc Cs|dd}d}z|di}|std|dddiWS|dg}td|d |d }t||krm||d urmt||ttfrm||d krm||}|d }d|d}td|d|d|d|}n"td|d|dt||kr||ndd|d}Wd|iSWd|iSt ytd|d|d|didgd}Yd|iSt ytd|d|d|didgd}Yd|iSt y} zt d|dt | d}WYd } ~ d|iSd } ~ ww)z Retrieves the 365-day average price for new items from 3rd party FBM sellers. Corresponds to stats.avg365[7]. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr r-r{z<: 'stats' object missing for new_3rd_party_fbm_365_days_avg.z"New, 3rd Party FBM - 365 days avg.rz5 - new_3rd_party_fbm_365_days_avg: stats.avg365 raw: rNrY@r!r"z,: New, 3rd Party FBM - 365 days avg. found: z from stats.avg365[]zF: New, 3rd Party FBM - 365 days avg. not available or invalid (avg365[z ]). Value: N/Az. avg365 array: z$: IndexError accessing stats.avg365[z7] for New, 3rd Party FBM - 365 days avg. avg365 array: z#: TypeError accessing stats.avg365[z6: Unexpected error in new_3rd_party_fbm_365_days_avg: r$rr'r%r&rrrrr)r*rrr,) rr4rr-r fbm_avg_indexprice_in_centsprice_in_dollarsrrrrrnew_3rd_party_fbm_365_days_avgrsF    6 6  , ,rc Cs~|dd}|di}td|dd}d}|d}|d d}|dur`|d kr`|d ur8|}d |}n(|d d}d|}|durZ|d krZ||}|d|d|7}n|}|d7}|d krzd|dd}td|d|d|d|iWSty} ztd|d|dt| dWYd} ~ nd} ~ wwtd|d|d|dg} t| dkr!| d} td|d| | dur| d krzd| dd}td|d | d!|d|iWSty} ztd|d"| d#t| WYd} ~ n d} ~ wwtd|d$| d%ntd|d&t| d'td|d(|d)dd*iS)+Nr4rIr-z Buy Box Used - Current for ASIN z^: Starting process. Relevant stats keys: buyBoxUsedIsFBA, buyBoxUsedPrice, buyBoxUsedShipping.r zNo valid price foundbuyBoxUsedIsFBAbuyBoxUsedPricerTzFBA item price: buyBoxUsedShippingzFBM item price: z + shipping: z = z$ (shipping not specified or invalid)r!r9r"z!: Price found via primary logic. z . Formatted: zBuy Box Used - Currentz: Error formatting price (z) from primary logic: z. Will attempt fallback.z5: Primary FBA/FBM logic did not yield a valid price (z,). Attempting fallback to stats.current[32].r8 z.: Fallback check of stats.current[32]. Value: z): Using fallback stats.current[32]. Raw: z , Formatted: z,: Error formatting stats.current[32] value (rz:: Fallback stats.current[32] is missing, None or invalid (rz2: Fallback stats.current array is too short (len: z) to access index 32.z4: No valid price found. Initial FBA/FBM price calc: zJ. Fallback stats.current[32] also failed or not applicable. Returning '-'.r ) r$rr%rrrr,r&r') r<r4r-final_price_centsprice_source_infobuy_box_used_is_fbaitem_price_centsshipping_price_centsrrr8value_from_current_32rrrbuy_box_used_currentsZ        .  ,r cCs&|di}dt|dddddi}|S)Nr-zUsed - Currentr8r7r9Tr0r1rrrrr used_currents rcCsD|di}dt|dddddi}td|d d d ||S) Nr-zUsed - 365 days avg.rr7r9Tr z"used_365_days_avg result for ASIN r4rIrBrrrrrused_365_days_avgs rc CsZ|di}|dd}t|ddddd}d |i}td |d |dgd ||S) Nr-r4rIr8r9Tr zUsed, like new - Currentzused_like_new for ASIN z: stats.current=z, current_price=r)r<r-r4 current_pricerErrr used_like_news  $rc C|dd}d}d}z|di}|s!td|dddiWS|d g}td|d |t||kr||}td|d |d ||d urt|ttfr|dkrzd|dd}td|d|d|WnRt y}zt d|d|d|dd}WYd }~n9d }~wwtd|d|d|dd}ntd|dt|d|dd}Wd|iSWd|iSWd|iSWd|iSt y}zt d|dt |d}WYd }~d|iSd }~ww)z Retrieves the 365-day average 'Used - Like New' price from product stats. Corresponds to stats.avg365[19]. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr rr-r{z8: 'stats' object missing for used_like_new_365_days_avg.zUsed, like new - 365 days avg.rz1 - used_like_new_365_days_avg: stats.avg365 raw: : Raw value at stats.avg365[z] for Used, like new: Nrr!r9r"z(Used, like new - 365 days avg. for ASIN : Using stats.avg365[ ], value: rrBr0: Invalid or non-positive price at stats.avg365[] (r': stats.avg365 array is too short (len ) to access index . Setting to '-'z2: Unexpected error in used_like_new_365_days_avg: r$rr'r%r&rrrrrrr,r<r4r source_indexr-rrrrrrused_like_new_365_days_avg-N      "  rcCH|di}|dd}t|ddddd}td |d |d |iS) Nr-r4rIr8r6r9Tr z#Used, very good - Current for ASIN z#: Using stats.current[20], result: zUsed, very good - Currentrr<r-r4rrrrused_very_goodb  r#c Cr)z Retrieves the 365-day average 'Used - Very Good' price from product stats. Corresponds to stats.avg365[20]. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr r6r-r{z9: 'stats' object missing for used_very_good_365_days_avg.zUsed, very good - 365 days avg.rz2 - used_very_good_365_days_avg: stats.avg365 raw: rz] for Used, very good: Nrr!r9r"z)Used, very good - 365 days avg. for ASIN rrrrBrrrrrrrz3: Unexpected error in used_very_good_365_days_avg: rrrrrused_very_good_365_days_avg|r r%cCr!) Nr-r4rIr8r9Tr zUsed, good - Current for ASIN z#: Using stats.current[21], result: zUsed, good - Currentrr"rrr used_goodr$r'c Cr)z Retrieves the 365-day average 'Used - Good' price from product stats. Corresponds to stats.avg365[21]. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr r&r-r{z4: 'stats' object missing for used_good_365_days_avg.zUsed, good - 365 days avg.rz- - used_good_365_days_avg: stats.avg365 raw: rz] for Used, good: Nrr!r9r"z$Used, good - 365 days avg. for ASIN rrrrBrrrrrrrz.: Unexpected error in used_good_365_days_avg: rrr4rrr-rrrrrrused_good_365_days_avgr r)cCs|dd}|di}|ddgdd}|dus|dkr+td|d d iSd |d d }td|d|d |iS)Nr4rIr-r8rrz*No valid Used - Acceptable price for ASIN zUsed, acceptable - Currentr r!r9r"z+Used, acceptable - Current result for ASIN rBrLrrrrused_acceptables  r+c Cr)z Retrieves the 365-day average 'Used - Acceptable' price from product stats. Corresponds to stats.avg365[22]. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr r*r-r{z:: 'stats' object missing for used_acceptable_365_days_avg.z Used, acceptable - 365 days avg.rz3 - used_acceptable_365_days_avg: stats.avg365 raw: rz] for Used, acceptable: Nrr!r9r"z*Used, acceptable - 365 days avg. for ASIN rrrrBrrrrrrrz4: Unexpected error in used_acceptable_365_days_avg: rr(rrrused_acceptable_365_days_avg r r,c Cs"|di}|dd}|ddgd}t|dkr|dnd}td|d |d t|d |d | |d ksA|dkrUtd|dt|d|ddiSzd|dd}td|d|d|iWSty}ztd|dt |ddiWYd}~Sd}~ww)Nr-r4rIr8r r6z!List Price - Current - raw value=rrz , stats_raw=rrz%No valid List Price - Current (value=rrzList Price - Currentr r!r9r"z%List Price - Current result for ASIN rBzlist_price failed for ASIN r)r<r-r4r8r2rVrrrr list_price8s"  0  r.c Cs|dd}z2|didg}|r4t|dkr4|ddur4|ddkr4|d}|dd }d |iWSd d iWStttfyQ}z d d iWYd}~Sd}~ww) z Retrieves the 365-day average 'New' price from product stats. Formats the price to two decimal places. Returns '-' if data is unavailable. r4rIr-rrNrrr"zNew - 365 days avg.r )r$r&r)r*r+)r<r4 avg365_pricesrprice_formattedrrrrnew_365_days_avgKs (   r1c Cs|di}|dd}td|d|d}|d}td|d|d ||durB|durBtd|d d d iSt|trM|d krM|nd }t|trZ|d krZ|nd }||}td|d|d|d|d d t|iS)Nr-r4rIr{z(: Calculating New Offer Count - Current. offerCountFBA offerCountFBMz: offerCountFBA = z, offerCountFBM = z`: Both offerCountFBA and offerCountFBM are missing. Returning '-' for New Offer Count - Current.zNew Offer Count - Currentr rz*: New Offer Count - Current calculated as z (FBA: z, FBM: r)r$rr%r'rrrr,)r<r-r4offer_count_fbaoffer_count_fbmval_fbaval_fbmtotal_new_offersrrrnew_offer_count_currentqs    $ r9cCF|di}|dd}t|dddd}td|d |d |iS) Nr-r4rIr Frr{z9: New Offer Count - 365 days avg. from stats.avg365[11]: zNew Offer Count - 365 days avg.r$r3rrr<r-r4countrrrnew_offer_count_365_days_avg  r?c CsL|di}|dd}td|d|d}|d}|d}td|d |d |d ||dusBt|trB|d krRtd|d |dddiSt|tr]|d kr]|nd }t|trj|d krj|nd }||}||krtd|d|d|dddiS||} td|d| d|d|d|d dt| iS)Nr-r4rIr{z): Calculating Used Offer Count - Current.r2r3totalOfferCountz: totalOfferCount = z, offerCountFBA_new = z, offerCountFBM_new = rz): totalOfferCount is missing or invalid (z0). Returning '-' for Used Offer Count - Current.zUsed Offer Count - Currentr z: totalOfferCount (z&) is less than calculated new offers (zW). This might indicate inconsistent data. Returning '-' for Used Offer Count - Current.z+: Used Offer Count - Current calculated as z (Total: z , New FBA: z , New FBM: r)r$rr%rrr'rr,) r<r-r4offer_count_fba_newoffer_count_fbm_newtotal_offer_count val_fba_new val_fbm_newcurrent_new_totalcalculated_used_offersrrrused_offer_count_currents&     "* rIcCr:) Nr-r4rIr Frr{z8: Used Offer Count - 30 days avg. from stats.avg30[12]: zUsed Offer Count - 30 days avg.r<r=rrrused_offer_count_30_days_avgr@rKcCr:) Nr-r4rIrrJFrr{z:: Used Offer Count - 180 days avg. from stats.avg180[12]: z Used Offer Count - 180 days avg.r<r=rrrused_offer_count_180_days_avgr@rLcCr:) Nr-r4rIrrJFrr{z:: Used Offer Count - 365 days avg. from stats.avg365[12]: z Used Offer Count - 365 days avg.r<r=rrrused_offer_count_365_days_avgr@rMc Cs|dd}z;|di}|sddiWS|dg}d}t||kr=||dur=||d kr=||}|d }d|d iWSddiWStyNddiYStyZddiYStyo}z ddiWYd}~Sd}~ww) zg Retrieves the 365-day average Buy Box price. The Buy Box price usually includes shipping. r4rIr-zBuy Box - 365 days avg.r rNrrr")r$r&r)r*r)r<r4r-rbuy_box_avg_indexrrrrrrbuy_box_365_days_avgs(    $     rPc Cs|dd}zs|di}|std|dddiWS|dg}td|d |d }t||krg||d urgt||ttfrg||d krg||}|d }|d}td|d|d|iWStd|d|d|ddiWSt ytd|d|didgddiYSt ytd|d|didgddiYSt y}zt d|dt |ddiWYd }~Sd }~ww)z Retrieves the average price of new 3rd party FBA offers over the last 365 days. Corresponds to stats.avg365[10]. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr-r{z<: 'stats' object missing for new_3rd_party_fba_365_days_avg.z"New, 3rd Party FBA - 365 days avg.r rz5 - new_3rd_party_fba_365_days_avg: stats.avg365 raw: rNrrr"z-: New, 3rd Party FBA - 365 days avg. found: $zF: New, 3rd Party FBA - 365 days avg. not available or invalid (avg365[z]). avg365 array: zS: IndexError accessing avg365 for New, 3rd Party FBA - 365 days avg. avg365 array: zR: TypeError accessing avg365 for New, 3rd Party FBA - 365 days avg. avg365 array: z6: Unexpected error in new_3rd_party_fba_365_days_avg: r) rr4r-r fba_avg_indexrrrrrrrnew_3rd_party_fba_365_days_avgs8    6   &  & rRc Cr)z Retrieves the 365-day average "Buy Box Used" price from product stats. Assumes index 32 in stats.avg365 corresponds to this value. Prices are in cents, converted to dollars. Returns '-' if data is unavailable or invalid. r4rIr rr-r{z7: 'stats' object missing for buy_box_used_365_days_avg.zBuy Box Used - 365 days avg.rz0 - buy_box_used_365_days_avg: stats.avg365 raw: rz]: Nrr!r9r"z&Buy Box Used - 365 days avg. for ASIN rrrrBrrrrrrrz1: Unexpected error in buy_box_used_365_days_avg: rr(rrrbuy_box_used_365_days_avg*r rSc Cs*|dd}|d}td|d|t|ts+td|d|ddd iS|d }|d us?t|ttfr?|d krOtd|d |ddd iSz|d}d|d}td|d|d|dd|iWSt y}zt d|d|dt |ddd iWYd }~Sd }~ww)z Retrieves the FBA Pick & Pack fee from product data. The fee is expected to be in cents and is converted to a dollar string. Returns '-' if the fee is not available or invalid. r4rIfbaFeesr{z;: Attempting to get FBA Pick&Pack Fee. Raw 'fbaFees' dict: z6: 'fbaFees' is not a dictionary or is missing. Value: . Returning '-'.zFBA Pick&Pack Feer pickAndPackFeeNrz>: 'pickAndPackFee' is missing from fbaFees, None, or invalid (). Returning '-'.rr!r"z: FBA Pick&Pack Fee found: (from raw )z&: Error formatting FBA Pick&Pack Fee (r) r$rr%rrr'rrrrrr,)rr4 fba_fees_data fee_cents fee_dollars formatted_feerrrrget_fba_pick_pack_feeWs(      "r^cCsB|dd}td|dd}d}d|vr*|d}d}td|d |nyd |vrA|d }d }td|d |nbd |vrt|d tr|d }d|vrg|d}d}td|d|nr7rNr-rrNrz[: No current offers found in 'Good' or better condition. Cannot determine Target Buy Price.r!r9r"z!: Target Buy Price calculated as z from z eligible offer(s).z%: Error formatting Target Buy Price (r)r$logging getLogger__name__rr(r'rrappendrrr&rrr,) r<r4rrgood_or_better_conditionseligible_offersrrrmin_price_centsrrrrrtarget_buy_prices>       "  rrc Cs6|dd}tt}|d}|r*t|tr*|dvr*|d|d|d|iS|d|d|d |d g}|rCt|tsP|d|d dd iSt t |d ddD]*}||}t|tr|dvr||d }|d|d|d|dd|iSqZ|d|d|r|dndddd iS)z Extracts the Buy Box Seller ID from the product data by checking the direct 'buyBoxSellerId' field first, then falling back to the 'buyBoxSellerIdHistory'. r4rIr)z-1z-2r{z@: Found Buy Box Seller ID directly from 'buyBoxSellerId' field: zBuy Box Seller IDz1: Direct 'buyBoxSellerId' not found or invalid ('z%'). Checking 'buyBoxSellerIdHistory'.buyBoxSellerIdHistoryzN: 'buyBoxSellerIdHistory' not found or is not a list. Cannot determine seller.r rrrz3: Found last valid Buy Box Seller ID from history: z (at timestamp rYzC: Could not find a valid seller ID in the history. Last entry was 'r rr) r$rkrlrmrr,rr(r'ranger&)r<r4r seller_idrrpotential_seller_id timestamprrrget_buy_box_seller_ids(      $rxc Csddlm}tt}|dd}t|dd}||dd}|dks)|dkr-ddiSz*t|d d }t|d d }|d krGddiWS|||d }d|d diWSt t fy} z| d|d|d|d| ddiWYd} ~ Sd} ~ ww)z Calculates the profit margin based on Target Buy Price and Expected Peak Sell Price. This function depends on other functions for its inputs. r)get_expected_peak_pricer4rIrjr zExpected Peak PricezProfit Margin %r!rkrr9r:r;r{z+: Could not calculate profit margin. Buy: 'z ', Sell: 'z '. Error: N) stable_calculationsryrkrlrmr$rrrrrr*r) r<ryrr4 buy_price_strsell_price_str buy_price sell_pricemarginrrrrprofit_margin_percent&s&    "rc Cs |dd}|di}d}td|d|dg}|ryt|dkry|d}|d urit|ttfri|dkriz d |d d }Wd|iStyh}ztd|d |d|WYd }~d|iSd }~wwt d|d|dd|iSt d|dd|iS)z_ Retrieves the 180-day average Amazon (New) price. Corresponds to stats.avg180[0]. r4rIr-r z Amazon - 180 days avg. for ASIN z$: Attempting to use stats.avg180[0].rrNr!r9r"rrBz/: Invalid or missing price at stats.avg180[0] (rz): stats.avg180 array is empty or missing.zAmazon - 180 days avg.) r$rr%r&rrrrrr')r<r4r-r avg180_arrayrrrrramazon_180_days_avgIs(   &r)r)rF)Trequestsrkrlrmrretryingrrrpytzr stable_dealsrjsonrrRrr API_HEADERSr3rArFrGrMrWr\rerfrhrjrtrurxrrrrrrrrrrrrrrrrrrrrrrr rrrrr#r%r'r)r+r,r.r1r9r?rIrKrLrMrPrRrSr^rdrirrrxrrrrrrs        "      T   ,   C  (&>/C?G5.4.& $   &*- =3% #