| Line 222... |
Line 222... |
| 222 |
if one_line.parent_category ==10011:
|
222 |
if one_line.parent_category ==10011:
|
| 223 |
lowestTp = (supc_data.lowestSp*(1-.0803))-courierCost
|
223 |
lowestTp = (supc_data.lowestSp*(1-.0803))-courierCost
|
| 224 |
else:
|
224 |
else:
|
| 225 |
lowestTp = supc_data.lowestSp*0.9497-courierCost
|
225 |
lowestTp = supc_data.lowestSp*0.9497-courierCost
|
| 226 |
sheet.write(sheet_iterator, 16, round(lowestTp))
|
226 |
sheet.write(sheet_iterator, 16, round(lowestTp))
|
| 227 |
sheet.write(sheet_iterator, 17, )
|
227 |
sheet.write(sheet_iterator, 17, supc_data.lowestOfferPrice)
|
| 228 |
sheet.write(sheet_iterator, 18, supc_data.otherInventory)
|
228 |
sheet.write(sheet_iterator, 18, supc_data.otherInventory)
|
| 229 |
sheet.write(sheet_iterator, 19, supc_data.ourInventory)
|
229 |
sheet.write(sheet_iterator, 19, supc_data.ourInventory)
|
| 230 |
sheet.write(sheet_iterator, 20, one_line.our_nlc)
|
230 |
sheet.write(sheet_iterator, 20, one_line.our_nlc)
|
| 231 |
if supc_data.rank==1:
|
231 |
if supc_data.rank==1:
|
| 232 |
i+=1
|
232 |
i+=1
|
| Line 290... |
Line 290... |
| 290 |
sheet.write(0, 13, "Our Rank", heading_xf)
|
290 |
sheet.write(0, 13, "Our Rank", heading_xf)
|
| 291 |
sheet.write(0, 14, "Lowest Seller", heading_xf)
|
291 |
sheet.write(0, 14, "Lowest Seller", heading_xf)
|
| 292 |
sheet.write(0, 15, "Lowest Offer Price", heading_xf)
|
292 |
sheet.write(0, 15, "Lowest Offer Price", heading_xf)
|
| 293 |
sheet.write(0, 16, "Second Lowest Seller", heading_xf)
|
293 |
sheet.write(0, 16, "Second Lowest Seller", heading_xf)
|
| 294 |
sheet.write(0, 17, "Second Lowest Price", heading_xf)
|
294 |
sheet.write(0, 17, "Second Lowest Price", heading_xf)
|
| - |
|
295 |
sheet.write(0, 18, "Second Lowest Offer Price", heading_xf)
|
| 295 |
sheet.write(0, 18, "Our Inventory", heading_xf)
|
296 |
sheet.write(0, 19, "Our Inventory", heading_xf)
|
| 296 |
sheet.write(0, 19, "Second Lowest Seller Inventory", heading_xf)
|
297 |
sheet.write(0, 20, "Second Lowest Seller Inventory", heading_xf)
|
| 297 |
sheet.write(0, 20, "Our NLC", heading_xf)
|
298 |
sheet.write(0, 21, "Our NLC", heading_xf)
|
| 298 |
sheet.write(0, 21, "Second Lowest Seller TP", heading_xf)
|
299 |
sheet.write(0, 22, "Second Lowest Seller TP", heading_xf)
|
| 299 |
|
300 |
|
| 300 |
i=1
|
301 |
i=1
|
| 301 |
|
302 |
|
| 302 |
for data in buyBoxItems:
|
303 |
for data in buyBoxItems:
|
| 303 |
supc_data =data[0]
|
304 |
supc_data =data[0]
|
| Line 325... |
Line 326... |
| 325 |
sheet.write(i, 10, supc_data.ourSp)
|
326 |
sheet.write(i, 10, supc_data.ourSp)
|
| 326 |
sheet.write(i, 11, round(supc_data.ourSp*0.9597-courierCost))
|
327 |
sheet.write(i, 11, round(supc_data.ourSp*0.9597-courierCost))
|
| 327 |
sheet.write(i, 12, supc_data.offerPrice)
|
328 |
sheet.write(i, 12, supc_data.offerPrice)
|
| 328 |
sheet.write(i, 13, supc_data.rank)
|
329 |
sheet.write(i, 13, supc_data.rank)
|
| 329 |
sheet.write(i, 14, supc_data.lowestSellerName)
|
330 |
sheet.write(i, 14, supc_data.lowestSellerName)
|
| 330 |
sheet.write(i, 15, )
|
331 |
sheet.write(i, 15, supc_data.lowestOfferPrice)
|
| 331 |
sheet.write(i, 16, supc_data.secondLowestSellerName)
|
332 |
sheet.write(i, 16, supc_data.secondLowestSellerName)
|
| 332 |
sheet.write(i, 17, supc_data.secondLowestSellerSp)
|
333 |
sheet.write(i, 17, supc_data.secondLowestSellerSp)
|
| - |
|
334 |
sheet.write(i, 17, supc_data.secondLowestSellerOfferPrice)
|
| 333 |
sheet.write(i, 18, supc_data.ourInventory)
|
335 |
sheet.write(i, 19, supc_data.ourInventory)
|
| 334 |
sheet.write(i, 19, supc_data.secondLowestSellerInventory)
|
336 |
sheet.write(i, 20, supc_data.secondLowestSellerInventory)
|
| 335 |
sheet.write(i, 20, one_line.our_nlc)
|
337 |
sheet.write(i, 21, one_line.our_nlc)
|
| 336 |
if one_line.parent_category ==10011:
|
338 |
if one_line.parent_category ==10011:
|
| 337 |
lowestTp = (supc_data.secondLowestSellerSp*(1-.0803))-courierCost
|
339 |
lowestTp = (supc_data.secondLowestSellerSp*(1-.0803))-courierCost
|
| 338 |
else:
|
340 |
else:
|
| 339 |
lowestTp = supc_data.secondLowestSellerSp*0.9497-courierCost
|
341 |
lowestTp = supc_data.secondLowestSellerSp*0.9497-courierCost
|
| 340 |
sheet.write(i, 21, round(lowestTp))
|
342 |
sheet.write(i, 22, round(lowestTp))
|
| 341 |
i+=1
|
343 |
i+=1
|
| 342 |
|
344 |
|
| 343 |
|
345 |
|
| 344 |
def main():
|
346 |
def main():
|
| 345 |
parser = optparse.OptionParser()
|
347 |
parser = optparse.OptionParser()
|