o Lei/ @snddlmZddlmZmZmZmZddlm Z m Z m Z m Z m Z mZmZddlmZmZddlmZmZddlmZmZmZmZmZddlmZmZmZdd l m!Z!dd l"Z"dd l#Z#ee$Z%e#j&'e#j&(e)d Z*ze+e*d  Z,e"-e,Z.Wd n1swYWne/yZ0ze%1d e*de0gZ.WYd Z0[0nd Z0[0wwddZ2ddZ3ddZ4ddZ5d S)) getLogger)calculate_all_in_costcalculate_profit_and_margincalculate_min_listing_price load_settings)get_1yr_avg_sale_priceget_percent_discount get_trendanalyze_sales_rank_trendsget_offer_count_trendget_offer_count_trend_180get_offer_count_trend_365)classify_seasonalityget_sells_period)get_used_product_infoCONDITION_CODE_MAP)analyze_sales_performancerecent_inferred_sale_priceinfer_sale_eventscalculate_seller_quality_scoreget_expected_trough_price)sales_rank_drops_last_30_dayssales_rank_drops_last_180_daysamazon_current) FUNCTION_LISTNz headers.jsonrzFailed to load headers from : cCsdt|ttfr t|St|tr|dvrdSzt|ddddWSty1YdSw)N-N/A$r!, isinstanceintfloatstrstripreplace ValueError value_strr/1/var/www/agentarbitrage/keepa_deals/processing.py _parse_prices r1cCs\t|ttfr t|St|tr|dvrdSz t|ddWSty-YdSw)Nrr"%r!r%r-r/r/r0_parse_percent"sr3c4 Cs|d}|s dSd|i}|dr|d|d<|dr$|d|d<zt|}|r1|ddur=td|d WdS|\}}}} |d |d <||d <||d <t| d|d<|r|r||vr||} | d| d||d <| d|d<| d|d<| d} | dur| dd} t| tr| r| d} | d} | dur| dd} t| tr| r| d} | dur| durt| ttfrt| ttfrt| d | } t | | |d<nd|d<n d|d<d|d<d|d<Wn!t y }ztj d|d|ddWYd}~dSd}~wwzit }t tD]`\}}|rsz*||}t|tr4|r1tt|nd}n|}|t|krC||||<Wqt yr}z td|d|t|kr_||ndd |WYd}~qd}~wwqWn t y}ztj d|d!|ddWYd}~nd}~ww|d"}|r|d#ks|dkrtd|d$dSt}t|\}}zt||}|durtd|d%WdS||d&|vr|d&dkrd'|d&d(d)|d*<nd|d*<t|d"d+}|d d}|d,p i}|d-}|dus|dkrd.}|d }|d/}|dus0|dkr2d0}d1}d2|vro|d2ro|d2D],} | d3g}!t|!d4krm|!d|!d5dkr_|!d5nd|krm|!d5dk}nqBt||||||}"t||"}#t|"|}$||"|#d6|#d7|$d8Wn t y}ztj d|d9|ddWYd}~nd}~wwzOt|}%|%r||%|d:durtd|d;WdSt|}&|&r||&t|d:|d }'|'r||'|t ||t!|Wn t y!}ztj d|d<|ddWYd}~nd}~wwz<|dd=}(d>"d?d@|dAgD})|dd=}*|dBd#}+|dCd#},t#|(|)|*|+|,|dD}-|-|dE<t$|-|dF<Wn t y~}ztj d|dG|ddWYd}~nd}~wwz_t%|}.|.r|dH|.dId#it&|}/|/r||/t'|}0|0r||0t(|}1|1r||1t)|}2|2r|2dJnd#}3|3r|3d#kr|3dkrdK|dL<W|Sd=|dL<W|St y}ztj d|dM|ddWYd}~|Sd}~ww)NNasinASINtitleTitle manufacturer ManufacturerrzASIN z*: No used offer found. Halting processing.gY@z Price NowSellerFBAr Condition sellerNamenameratingz Seller Rating ratingCountzSeller Review Count currentRatingcurrentRatingCountSeller_Quality_Scorer"z(: Failed to get live price/seller info: T)exc_infoz: Error extracting Unknownrz%: Error in generic field extraction: zList atrz]: Excluding deal because 'List at' is missing (Price validation failed or insufficient data).z0: Could not analyze sales performance. Skipping.expected_trough_price_centsr#dz.2fzExpected Trough Price0fbaFeespickAndPackFeei&referralFeePercentageg.@FoffersofferCSVrprofitmargin)z All-in CostProfitMarginzMin. Listing Pricez : Failed business calculations: z 1yr. Avg.zJ: Excluding deal because '1yr. Avg.' is missing (insufficient sales data).z!: Failed analytics calculations: r!z, cSsg|]}|dqS)r>r/).0catr/r/r0 sz(_process_single_deal.. categoryTreezPeak Sales MonthzTrough Sales Month) xai_api_keyDetailed_SeasonalitySellsz%: Failed seasonality classification: DropszSales Rank - Drops last 30 dayszAmazon - Currentu⚠️AMZz!: Failed new columns extraction: )*getrloggerinforr&listr'r(r ExceptionerrorHEADERS enumeraterdictnextitervalueslenwarningbusiness_load_settingsrrupdater1rrrrr r rr joinrrrr r rr)4 product_dataseller_data_cacherXr4row_dataused_product_info price_now seller_idis_fbacondition_codeseller_detailsrating_percent rating_countpositive_ratingseheadersifuncresvalval_listbusiness_settings sale_events_ sales_perf list_at_price now_price fba_fees_obj pick_and_packfba_feereferral_percentshipping_included_flagoffer offer_csv all_in_cost profit_margin min_listing yr_avg_info trend_info discount_infor6 categoriesr8peak_season_strtrough_season_strdetailed_season drops_data offers_dataoffers_data_180offers_data_365amz_dataamz_valr/r/r0_process_single_deal(s\          ,   @ &          6     &   &    &     $rc s|D]}\}|dust|tsq|dddd}dvs&dvr>zt||<Wqttfy=d|<Yqwd|vr^z t|dd|<Wqttfy]d|<Yqwt fdd d Drzt||<Wqttfyd|<Yqwq|S) zV Cleans and converts numeric string values in the row data to actual numbers. Nr#r!r$RankCountr2c3s|]}|vVqdS)Nr/)rTkkeyr/r0 sz'clean_numeric_values..)PriceCostFeerRrS) itemsr&r)r*r+r'r, TypeErrorr(any)rpvalue cleaned_valuer/rr0clean_numeric_valuessr)6loggingrbusiness_calculationsrrrrrk new_analyticsrr r r r r rseasonality_classifierrr seller_inforrstable_calculationsrrrrrstable_productsrrrfield_mappingsrjsonos__name__r^pathrmdirname__file__ HEADERS_PATHopenfloadrcrarzrbr1r3rrr/r/r/r0s6 $    W