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



        amDetails = negativeMarginItem[1]
        amPricing = negativeMarginItem[2]
        spm = val.sourcePercentage
        amazonScrapingHistory = AmazonScrapingHistory()
        amazonScrapingHistory.item_id = val.sku[3:]
        amazonScrapingHistory.asin = val.asin
        amazonScrapingHistory.warehouseLocation = val.state_id
        amazonScrapingHistory.parentCategoryId = val.parent_category
        amazonScrapingHistory.ourSellingPrice = amDetails.ourSp
        amazonScrapingHistory.promoPrice = amDetails.promoPrice
        amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp

        amDetails = cheapestItem[1]
        amPricing = cheapestItem[2]
        spm = val.sourcePercentage
        amazonScrapingHistory = AmazonScrapingHistory()
        amazonScrapingHistory.item_id = val.sku[3:]
        amazonScrapingHistory.asin = val.asin
        amazonScrapingHistory.warehouseLocation = val.state_id
        amazonScrapingHistory.parentCategoryId = val.parent_category
        amazonScrapingHistory.ourSellingPrice = amDetails.ourSp
        amazonScrapingHistory.promoPrice = amDetails.promoPrice
        amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp

        amDetails = amongCheapestAndCanCompeteItem[1]
        amPricing = amongCheapestAndCanCompeteItem[2]
        spm = val.sourcePercentage
        amazonScrapingHistory = AmazonScrapingHistory()
        amazonScrapingHistory.item_id = val.sku[3:]
        amazonScrapingHistory.asin = val.asin
        amazonScrapingHistory.warehouseLocation = val.state_id
        amazonScrapingHistory.parentCategoryId = val.parent_category
        amazonScrapingHistory.ourSellingPrice = amDetails.ourSp
        amazonScrapingHistory.promoPrice = amDetails.promoPrice
        amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp

        amDetails = canCompeteItem[1]
        amPricing = canCompeteItem[2]
        spm = val.sourcePercentage
        amazonScrapingHistory = AmazonScrapingHistory()
        amazonScrapingHistory.item_id = val.sku[3:]
        amazonScrapingHistory.asin = val.asin
        amazonScrapingHistory.warehouseLocation = val.state_id
        amazonScrapingHistory.parentCategoryId = val.parent_category
        amazonScrapingHistory.ourSellingPrice = amDetails.ourSp
        amazonScrapingHistory.promoPrice = amDetails.promoPrice
        amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp

        amDetails = almostCompeteItem[1]
        amPricing = almostCompeteItem[2]
        spm = val.sourcePercentage
        amazonScrapingHistory = AmazonScrapingHistory()
        amazonScrapingHistory.item_id = val.sku[3:]
        amazonScrapingHistory.asin = val.asin
        amazonScrapingHistory.warehouseLocation = val.state_id
        amazonScrapingHistory.parentCategoryId = val.parent_category
        amazonScrapingHistory.ourSellingPrice = amDetails.ourSp
        amazonScrapingHistory.promoPrice = amDetails.promoPrice
        amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp

        amDetails = cantCompeteItem[1]
        amPricing = cantCompeteItem[2]
        spm = val.sourcePercentage
        amazonScrapingHistory = AmazonScrapingHistory()
        amazonScrapingHistory.item_id = val.sku[3:]
        amazonScrapingHistory.asin = val.asin
        amazonScrapingHistory.warehouseLocation = val.state_id
        amazonScrapingHistory.parentCategoryId = val.parent_category
        amazonScrapingHistory.ourSellingPrice = amDetails.ourSp
        amazonScrapingHistory.promoPrice = amDetails.promoPrice
        amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, item.weight)
        sheet.write(sheet_iterator, 7, amScraping.courierCost)

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, item.weight)
        sheet.write(sheet_iterator, 7, amScraping.courierCost)

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, item.weight)
        sheet.write(sheet_iterator, 7, amScraping.courierCost)

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, item.weight)
        sheet.write(sheet_iterator, 7, amScraping.courierCost)

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, item.weight)
        sheet.write(sheet_iterator, 7, amScraping.courierCost)

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, item.weight)
        sheet.write(sheet_iterator, 7, amScraping.courierCost)

            loc = 'MUMBAI'
        else:
            sku = 'FBB'+str(amScraping.item_id)
            loc = 'BANGLORE'
        sheet.write(sheet_iterator, 1, sku)
        sheet.write(sheet_iterator, 2, amScraping.asin)
        sheet.write(sheet_iterator, 3, loc)
        sheet.write(sheet_iterator, 4, item.brand)
        sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))
        sheet.write(sheet_iterator, 6, amScraping.reason)
        sheet_iterator+=1      

Subversion Repositories SmartDukaan

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

Rev 12470		Rev 12471
Line 607...		Line 607...
607	`amDetails = negativeMarginItem[1]`	607	`amDetails = negativeMarginItem[1]`
608	`amPricing = negativeMarginItem[2]`	608	`amPricing = negativeMarginItem[2]`
609	`spm = val.sourcePercentage`	609	`spm = val.sourcePercentage`
610	`amazonScrapingHistory = AmazonScrapingHistory()`	610	`amazonScrapingHistory = AmazonScrapingHistory()`
611	`amazonScrapingHistory.item_id = val.sku[3:]`	611	`amazonScrapingHistory.item_id = val.sku[3:]`
-		612	`amazonScrapingHistory.asin = val.asin`
612	`amazonScrapingHistory.warehouseLocation = val.state_id`	613	`amazonScrapingHistory.warehouseLocation = val.state_id`
613	`amazonScrapingHistory.parentCategoryId = val.parent_category`	614	`amazonScrapingHistory.parentCategoryId = val.parent_category`
614	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`	615	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`
615	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`	616	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`
616	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`	617	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`
Line 651...		Line 652...
651	`amDetails = cheapestItem[1]`	652	`amDetails = cheapestItem[1]`
652	`amPricing = cheapestItem[2]`	653	`amPricing = cheapestItem[2]`
653	`spm = val.sourcePercentage`	654	`spm = val.sourcePercentage`
654	`amazonScrapingHistory = AmazonScrapingHistory()`	655	`amazonScrapingHistory = AmazonScrapingHistory()`
655	`amazonScrapingHistory.item_id = val.sku[3:]`	656	`amazonScrapingHistory.item_id = val.sku[3:]`
-		657	`amazonScrapingHistory.asin = val.asin`
656	`amazonScrapingHistory.warehouseLocation = val.state_id`	658	`amazonScrapingHistory.warehouseLocation = val.state_id`
657	`amazonScrapingHistory.parentCategoryId = val.parent_category`	659	`amazonScrapingHistory.parentCategoryId = val.parent_category`
658	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`	660	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`
659	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`	661	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`
660	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`	662	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`
Line 707...		Line 709...
707	`amDetails = amongCheapestAndCanCompeteItem[1]`	709	`amDetails = amongCheapestAndCanCompeteItem[1]`
708	`amPricing = amongCheapestAndCanCompeteItem[2]`	710	`amPricing = amongCheapestAndCanCompeteItem[2]`
709	`spm = val.sourcePercentage`	711	`spm = val.sourcePercentage`
710	`amazonScrapingHistory = AmazonScrapingHistory()`	712	`amazonScrapingHistory = AmazonScrapingHistory()`
711	`amazonScrapingHistory.item_id = val.sku[3:]`	713	`amazonScrapingHistory.item_id = val.sku[3:]`
-		714	`amazonScrapingHistory.asin = val.asin`
712	`amazonScrapingHistory.warehouseLocation = val.state_id`	715	`amazonScrapingHistory.warehouseLocation = val.state_id`
713	`amazonScrapingHistory.parentCategoryId = val.parent_category`	716	`amazonScrapingHistory.parentCategoryId = val.parent_category`
714	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`	717	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`
715	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`	718	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`
716	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`	719	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`
Line 755...		Line 758...
755	`amDetails = canCompeteItem[1]`	758	`amDetails = canCompeteItem[1]`
756	`amPricing = canCompeteItem[2]`	759	`amPricing = canCompeteItem[2]`
757	`spm = val.sourcePercentage`	760	`spm = val.sourcePercentage`
758	`amazonScrapingHistory = AmazonScrapingHistory()`	761	`amazonScrapingHistory = AmazonScrapingHistory()`
759	`amazonScrapingHistory.item_id = val.sku[3:]`	762	`amazonScrapingHistory.item_id = val.sku[3:]`
-		763	`amazonScrapingHistory.asin = val.asin`
760	`amazonScrapingHistory.warehouseLocation = val.state_id`	764	`amazonScrapingHistory.warehouseLocation = val.state_id`
761	`amazonScrapingHistory.parentCategoryId = val.parent_category`	765	`amazonScrapingHistory.parentCategoryId = val.parent_category`
762	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`	766	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`
763	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`	767	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`
764	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`	768	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`
Line 803...		Line 807...
803	`amDetails = almostCompeteItem[1]`	807	`amDetails = almostCompeteItem[1]`
804	`amPricing = almostCompeteItem[2]`	808	`amPricing = almostCompeteItem[2]`
805	`spm = val.sourcePercentage`	809	`spm = val.sourcePercentage`
806	`amazonScrapingHistory = AmazonScrapingHistory()`	810	`amazonScrapingHistory = AmazonScrapingHistory()`
807	`amazonScrapingHistory.item_id = val.sku[3:]`	811	`amazonScrapingHistory.item_id = val.sku[3:]`
-		812	`amazonScrapingHistory.asin = val.asin`
808	`amazonScrapingHistory.warehouseLocation = val.state_id`	813	`amazonScrapingHistory.warehouseLocation = val.state_id`
809	`amazonScrapingHistory.parentCategoryId = val.parent_category`	814	`amazonScrapingHistory.parentCategoryId = val.parent_category`
810	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`	815	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`
811	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`	816	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`
812	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`	817	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`
Line 854...		Line 859...
854	`amDetails = cantCompeteItem[1]`	859	`amDetails = cantCompeteItem[1]`
855	`amPricing = cantCompeteItem[2]`	860	`amPricing = cantCompeteItem[2]`
856	`spm = val.sourcePercentage`	861	`spm = val.sourcePercentage`
857	`amazonScrapingHistory = AmazonScrapingHistory()`	862	`amazonScrapingHistory = AmazonScrapingHistory()`
858	`amazonScrapingHistory.item_id = val.sku[3:]`	863	`amazonScrapingHistory.item_id = val.sku[3:]`
-		864	`amazonScrapingHistory.asin = val.asin`
859	`amazonScrapingHistory.warehouseLocation = val.state_id`	865	`amazonScrapingHistory.warehouseLocation = val.state_id`
860	`amazonScrapingHistory.parentCategoryId = val.parent_category`	866	`amazonScrapingHistory.parentCategoryId = val.parent_category`
861	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`	867	`amazonScrapingHistory.ourSellingPrice = amDetails.ourSp`
862	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`	868	`amazonScrapingHistory.promoPrice = amDetails.promoPrice`
863	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`	869	`amazonScrapingHistory.lowestPossibleSp = amPricing.lowestPossibleSp`
Line 1004...		Line 1010...
1004	`loc = 'MUMBAI'`	1010	`loc = 'MUMBAI'`
1005	`else:`	1011	`else:`
1006	`sku = 'FBB'+str(amScraping.item_id)`	1012	`sku = 'FBB'+str(amScraping.item_id)`
1007	`loc = 'BANGLORE'`	1013	`loc = 'BANGLORE'`
1008	`sheet.write(sheet_iterator, 1, sku)`	1014	`sheet.write(sheet_iterator, 1, sku)`
1009	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1015	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1010	`sheet.write(sheet_iterator, 3, loc)`	1016	`sheet.write(sheet_iterator, 3, loc)`
1011	`sheet.write(sheet_iterator, 4, item.brand)`	1017	`sheet.write(sheet_iterator, 4, item.brand)`
1012	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1018	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1013	`sheet.write(sheet_iterator, 6, item.weight)`	1019	`sheet.write(sheet_iterator, 6, item.weight)`
1014	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`	1020	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`
Line 1111...		Line 1117...
1111	`loc = 'MUMBAI'`	1117	`loc = 'MUMBAI'`
1112	`else:`	1118	`else:`
1113	`sku = 'FBB'+str(amScraping.item_id)`	1119	`sku = 'FBB'+str(amScraping.item_id)`
1114	`loc = 'BANGLORE'`	1120	`loc = 'BANGLORE'`
1115	`sheet.write(sheet_iterator, 1, sku)`	1121	`sheet.write(sheet_iterator, 1, sku)`
1116	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1122	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1117	`sheet.write(sheet_iterator, 3, loc)`	1123	`sheet.write(sheet_iterator, 3, loc)`
1118	`sheet.write(sheet_iterator, 4, item.brand)`	1124	`sheet.write(sheet_iterator, 4, item.brand)`
1119	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1125	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1120	`sheet.write(sheet_iterator, 6, item.weight)`	1126	`sheet.write(sheet_iterator, 6, item.weight)`
1121	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`	1127	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`
Line 1227...		Line 1233...
1227	`loc = 'MUMBAI'`	1233	`loc = 'MUMBAI'`
1228	`else:`	1234	`else:`
1229	`sku = 'FBB'+str(amScraping.item_id)`	1235	`sku = 'FBB'+str(amScraping.item_id)`
1230	`loc = 'BANGLORE'`	1236	`loc = 'BANGLORE'`
1231	`sheet.write(sheet_iterator, 1, sku)`	1237	`sheet.write(sheet_iterator, 1, sku)`
1232	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1238	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1233	`sheet.write(sheet_iterator, 3, loc)`	1239	`sheet.write(sheet_iterator, 3, loc)`
1234	`sheet.write(sheet_iterator, 4, item.brand)`	1240	`sheet.write(sheet_iterator, 4, item.brand)`
1235	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1241	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1236	`sheet.write(sheet_iterator, 6, item.weight)`	1242	`sheet.write(sheet_iterator, 6, item.weight)`
1237	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`	1243	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`
Line 1334...		Line 1340...
1334	`loc = 'MUMBAI'`	1340	`loc = 'MUMBAI'`
1335	`else:`	1341	`else:`
1336	`sku = 'FBB'+str(amScraping.item_id)`	1342	`sku = 'FBB'+str(amScraping.item_id)`
1337	`loc = 'BANGLORE'`	1343	`loc = 'BANGLORE'`
1338	`sheet.write(sheet_iterator, 1, sku)`	1344	`sheet.write(sheet_iterator, 1, sku)`
1339	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1345	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1340	`sheet.write(sheet_iterator, 3, loc)`	1346	`sheet.write(sheet_iterator, 3, loc)`
1341	`sheet.write(sheet_iterator, 4, item.brand)`	1347	`sheet.write(sheet_iterator, 4, item.brand)`
1342	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1348	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1343	`sheet.write(sheet_iterator, 6, item.weight)`	1349	`sheet.write(sheet_iterator, 6, item.weight)`
1344	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`	1350	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`
Line 1441...		Line 1447...
1441	`loc = 'MUMBAI'`	1447	`loc = 'MUMBAI'`
1442	`else:`	1448	`else:`
1443	`sku = 'FBB'+str(amScraping.item_id)`	1449	`sku = 'FBB'+str(amScraping.item_id)`
1444	`loc = 'BANGLORE'`	1450	`loc = 'BANGLORE'`
1445	`sheet.write(sheet_iterator, 1, sku)`	1451	`sheet.write(sheet_iterator, 1, sku)`
1446	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1452	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1447	`sheet.write(sheet_iterator, 3, loc)`	1453	`sheet.write(sheet_iterator, 3, loc)`
1448	`sheet.write(sheet_iterator, 4, item.brand)`	1454	`sheet.write(sheet_iterator, 4, item.brand)`
1449	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1455	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1450	`sheet.write(sheet_iterator, 6, item.weight)`	1456	`sheet.write(sheet_iterator, 6, item.weight)`
1451	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`	1457	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`
Line 1543...		Line 1549...
1543	`loc = 'MUMBAI'`	1549	`loc = 'MUMBAI'`
1544	`else:`	1550	`else:`
1545	`sku = 'FBB'+str(amScraping.item_id)`	1551	`sku = 'FBB'+str(amScraping.item_id)`
1546	`loc = 'BANGLORE'`	1552	`loc = 'BANGLORE'`
1547	`sheet.write(sheet_iterator, 1, sku)`	1553	`sheet.write(sheet_iterator, 1, sku)`
1548	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1554	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1549	`sheet.write(sheet_iterator, 3, loc)`	1555	`sheet.write(sheet_iterator, 3, loc)`
1550	`sheet.write(sheet_iterator, 4, item.brand)`	1556	`sheet.write(sheet_iterator, 4, item.brand)`
1551	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1557	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1552	`sheet.write(sheet_iterator, 6, item.weight)`	1558	`sheet.write(sheet_iterator, 6, item.weight)`
1553	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`	1559	`sheet.write(sheet_iterator, 7, amScraping.courierCost)`
Line 1609...		Line 1615...
1609	`loc = 'MUMBAI'`	1615	`loc = 'MUMBAI'`
1610	`else:`	1616	`else:`
1611	`sku = 'FBB'+str(amScraping.item_id)`	1617	`sku = 'FBB'+str(amScraping.item_id)`
1612	`loc = 'BANGLORE'`	1618	`loc = 'BANGLORE'`
1613	`sheet.write(sheet_iterator, 1, sku)`	1619	`sheet.write(sheet_iterator, 1, sku)`
1614	`sheet.write(sheet_iterator, 2, (amazonAsinPrice.get(sku).asin))`	1620	`sheet.write(sheet_iterator, 2, amScraping.asin)`
1615	`sheet.write(sheet_iterator, 3, loc)`	1621	`sheet.write(sheet_iterator, 3, loc)`
1616	`sheet.write(sheet_iterator, 4, item.brand)`	1622	`sheet.write(sheet_iterator, 4, item.brand)`
1617	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`	1623	`sheet.write(sheet_iterator, 5, xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color))`
1618	`sheet.write(sheet_iterator, 6, amScraping.reason)`	1624	`sheet.write(sheet_iterator, 6, amScraping.reason)`
1619	`sheet_iterator+=1`	1625	`sheet_iterator+=1`