WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/catalog/script/AmazonHistoryPopulator.py

 syncPrice=config_client.get_property('sync_price_on_marketplace')
 amazonAsinPrice={}
 amazonLongTermActivePromotions = {}
 amazonShortTermActivePromotions = {}
+notListed = []
 saleMap = {}
 categoryMap = {}
 DataService.initialize(db_hostname=host)
 amScraper = AmazonAsyncScraper.Products("AKIAII3SGRXBJDPCHSGQ", "B92xTbNBTYygbGs98w01nFQUhbec1pNCkCsKVfpg", "AF6E3O0VE0X4D")
         if runType=='FAVOURITE':
             if not (fbaInventoryItem.item_id in favourites):
                 continue
         d_amazon_listed = Amazonlisted.get_by(itemId=fbaInventoryItem.item_id)
         if d_amazon_listed is None:
+            if fbaInventoryItem.location==0:
+                sku = 'FBA'+str(fbaInventoryItem.item_id)
+                notListed.append(sku)
+            elif fbaInventoryItem.location==1:
+                sku = 'FBB'+str(fbaInventoryItem.item_id)
+                notListed.append(sku)
+            else:
+                pass
             continue
         if d_amazon_listed.overrrideWanlc:
             wanlc = d_amazon_listed.exceptionalWanlc
             if wanlc is None:
                 wanlc = 0.0
             <th>Commission %</th>
             <th>Return Provision %</th>
             <th>Inventory</th>
             <th>Sales History</th>
             <th>Category</th>
+            <th>isListed</th>
+            <th>Price Feed Suppressed</th>
             </tr></thead>
             <tbody>"""
     for item in successfulAutoDecrease:
         it = Item.query.filter_by(id=item.item_id).one()
+        amItem = Amazonlisted.get_by(itemId=item.item_id)
+        isListed =""
+        priceSuppress =""
+        if item.warehouseLocation==1:
+            if amItem.isFba:
+                isListed = "Yes"
+            else:
+                isListed = "No"
+            if amItem.suppressFbaPriceUpdate:
+                priceSuppress = "Yes"
+            else:
+                priceSuppress = "No"
         vatRate = getNewVatRate(item.item_id,item.warehouseLocation,item.proposedSp)
         #oldMargin = item.ourSellingPrice - item.lowestPossibleSp
         oldMargin = item.promoPrice - item.lowestPossibleSp
         newMargin = round(item.proposedSp - getNewLowestPossibleSp(item,12.36,vatRate))
         sku = ''
                 <td style="text-align:center">"""+str(item.commission)+" %"+"""</td>
                 <td style="text-align:center">"""+str(item.returnProvision)+" %"+"""</td>
                 <td style="text-align:center">"""+str(item.ourInventory)+"""</td>
                 <td style="text-align:center">"""+getOosString(saleMap.get(sku))+"""</td>
                 <td style="text-align:center">"""+str(CompetitionCategory._VALUES_TO_NAMES.get(item.competitiveCategory))+"""</td>
+                <td style="text-align:center">"""+isListed+"""</td>
+                <td style="text-align:center">"""+priceSuppress+"""</td>
                 </tr>"""
     message+="""</tbody></table><h3>Auto Increase Items</h3><table border="1" style="width:100%;">
             <thead>
             <tr><th>Item Id</th>
             <th>Amazon SKU</th>
             <th>Commission %</th>
             <th>Return Provision %</th>
             <th>Inventory</th>
             <th>Sales History</th>
             <th>Category</th>
+            <th>isListed</th>
+            <th>Price Feed Suppressed</th>
             </tr></thead>
             <tbody>"""
     for item in successfulAutoIncrease:
         it = Item.query.filter_by(id=item.item_id).one()
+        amItem = Amazonlisted.get_by(itemId=item.item_id)
+        isListed =""
+        priceSuppress =""
+        if item.warehouseLocation==1:
+            if amItem.isFba:
+                isListed = "Yes"
+            else:
+                isListed = "No"
+            if amItem.suppressFbaPriceUpdate:
+                priceSuppress = "Yes"
+            else:
+                priceSuppress = "No"
-        vatRate = getNewVatRate(item.item_id,item.warehouseLocation,math.ceil(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)))
+        vatRate = getNewVatRate(item.item_id,item.warehouseLocation,math.ceil(item.promoPrice+max(10,.01*item.promoPrice)))
         #oldMargin = item.ourSellingPrice - item.lowestPossibleSp
         oldMargin = item.promoPrice - item.lowestPossibleSp
-        newMargin = round(math.ceil(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)) - getNewLowestPossibleSp(item,12.36,vatRate))
+        newMargin = round(math.ceil(item.promoPrice+max(10,.01*item.promoPrice)) - getNewLowestPossibleSp(item,12.36,vatRate))
         sku = ''
         if item.warehouseLocation==1:
             sku='FBA'+str(item.item_id)
         else:
             sku='FBB'+str(item.item_id)
         message+="""<tr>
                 <td style="text-align:center">"""+str(item.item_id)+"""</td>
                 <td style="text-align:center">"""+sku+"""</td>
                 <td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
                 <td style="text-align:center">"""+str(item.promoPrice)+"""</td>
-                <td style="text-align:center">"""+str(math.ceil(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)))+"""</td>
+                <td style="text-align:center">"""+str(math.ceil(item.promoPrice+max(10,.01*item.promoPrice)))+"""</td>
                 <td style="text-align:center">"""+str(round(subsidy))+"""</td>
-                <td style="text-align:center">"""+str(round((oldMargin),1))+" ("+str(round((oldMargin/item.ourSellingPrice)*100,1))+"%)"+"""</td>
+                <td style="text-align:center">"""+str(round((oldMargin),1))+" ("+str(round((oldMargin/item.promoPrice)*100,1))+"%)"+"""</td>
-                <td style="text-align:center">"""+str(newMargin)+" ("+str(round((newMargin/(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)))*100,1))+"%)"+"""</td>
+                <td style="text-align:center">"""+str(newMargin)+" ("+str(round((newMargin/(item.promoPrice+max(10,.01*item.promoPrice)))*100,1))+"%)"+"""</td>
                 <td style="text-align:center">"""+str(item.commission)+" %"+"""</td>
                 <td style="text-align:center">"""+str(item.returnProvision)+" %"+"""</td>
                 <td style="text-align:center">"""+str(item.ourInventory)+"""</td>
                 <td style="text-align:center">"""+getOosString(saleMap.get(sku))+"""</td>
                 <td style="text-align:center">"""+str(CompetitionCategory._VALUES_TO_NAMES.get(item.competitiveCategory))+"""</td>
+                <td style="text-align:center">"""+isListed+"""</td>
+                <td style="text-align:center">"""+priceSuppress+"""</td>
                 </tr>"""
+    message+="""</tbody></table><h3>Create Listing On Our Dashboard - Stock is present in FC</h3><table border="1" style="width:100%;">
+            <thead>
+            <tr><th>Item Id</th>
+            <th>Amazon SKU</th>
+            <th>Product Name</th></tr></thead>
+            <tbody>
+            """
+    for sku in notListed:
+        it = Item.query.filter_by(id=int(sku[3:])).one()
+        message+="""<tr>
+        <td style="text-align:center">"""+sku[3:]+"""</td>
+        <td style="text-align:center">"""+sku+"""</td>
+        <td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
+        </tr>"""
     message+="""</tbody></table></body></html>"""
     print message
     mailServer = smtplib.SMTP("smtp.gmail.com", 587)
     mailServer.ehlo()
     mailServer.starttls()
         sender = 'build@shop2020.in'
         try:
             smtpServer.sendmail(sender, recipients, msg.as_string())
             print "Successfully sent email"
         except:
             print "Error: unable to send email."
+def commitPricing(successfulAutoDecrease,successfulAutoIncrease):
+    print "inside commit pricing"
+    if len(successfulAutoDecrease)==0 and len(successfulAutoIncrease)==0 :
+        return
+    for item in successfulAutoDecrease:
+        amItem = Amazonlisted.get_by(itemId=item.item_id)
+        if item.warehouseLocation==1:
+            if item.isPromotion:
+                amItem.fbaPromoPrice = math.ceil(item.proposedSp)
+            else:
+                amItem.fbaPrice = math.ceil(item.proposedSp)
+            amItem.fbaPriceLastUpdatedOn = datetime.now()
+        elif item.warehouseLocation==2:
+            if item.isPromotion:
+                amItem.fbbPromoPrice = math.ceil(item.proposedSp)
+            else:
+                amItem.fbbPrice = math.ceil(item.proposedSp)
+            amItem.fbaPriceLastUpdatedOn = datetime.now()
+    for item in successfulAutoIncrease:
+        amItem = Amazonlisted.get_by(itemId=item.item_id)
+        if item.warehouseLocation==1:
+            if item.isPromotion:
+                amItem.fbaPromoPrice = math.ceil(item.promoPrice+max(10,.01*item.promoPrice))
+            else:
+                amItem.fbaPrice = math.ceil(item.promoPrice+max(10,.01*item.promoPrice))
+            amItem.fbaPriceLastUpdatedOn = datetime.now()
+        elif item.warehouseLocation==2:
+            if item.isPromotion:
+                amItem.fbbPromoPrice = math.ceil(item.promoPrice+max(10,.01*item.promoPrice))
+            else:
+                amItem.fbbPrice = math.ceil(item.promoPrice+max(10,.01*item.promoPrice))
+            amItem.fbbPriceLastUpdatedOn = datetime.now()
 def main():
     parser = optparse.OptionParser()
     parser.add_option("-t", "--type", dest="runType",
                    default="FULL", type="string",
     autoDecreaseItems = fetchItemsForAutoDecrease(timestamp)
     autoIncreaseItems = fetchItemsForAutoIncrease(timestamp)
     previousAutoFav, nowAutoFav = markAutoFavourites(timestamp)
     writeReport(timestamp,autoDecreaseItems,autoIncreaseItems,previousAutoFav,nowAutoFav,options.runType)
     print "send auto pricing email"
+    commitPricing(autoDecreaseItems,autoIncreaseItems)
     sendAutoPricingMail(autoDecreaseItems,autoIncreaseItems)
     if options.runType == 'FULL-OTHER':
         sendAlertForNegativeMargins(timestamp)
         sendAlertForCantCompete(timestamp)
 if __name__=='__main__':

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/AmazonHistoryPopulator.py – Rev 12680 → 12711