| Line 162... |
Line 162... |
| 162 |
sheet.write(0, 7, "Color", heading_xf)
|
162 |
sheet.write(0, 7, "Color", heading_xf)
|
| 163 |
sheet.write(0, 8, "Weight", heading_xf)
|
163 |
sheet.write(0, 8, "Weight", heading_xf)
|
| 164 |
sheet.write(0, 9, "Risky", heading_xf)
|
164 |
sheet.write(0, 9, "Risky", heading_xf)
|
| 165 |
sheet.write(0, 10, "Our SP", heading_xf)
|
165 |
sheet.write(0, 10, "Our SP", heading_xf)
|
| 166 |
sheet.write(0, 11, "Our TP", heading_xf)
|
166 |
sheet.write(0, 11, "Our TP", heading_xf)
|
| 167 |
sheet.write(0, 12, "Offer Price", heading_xf)
|
167 |
sheet.write(0, 12, "Our Offer Price", heading_xf)
|
| 168 |
sheet.write(0, 13, "Our Rank", heading_xf)
|
168 |
sheet.write(0, 13, "Our Rank", heading_xf)
|
| 169 |
sheet.write(0, 14, "Lowest Seller", heading_xf)
|
169 |
sheet.write(0, 14, "Lowest Seller", heading_xf)
|
| 170 |
sheet.write(0, 15, "Lowest SP", heading_xf)
|
170 |
sheet.write(0, 15, "Lowest SP", heading_xf)
|
| 171 |
sheet.write(0, 16, "Lowest TP", heading_xf)
|
171 |
sheet.write(0, 16, "Lowest TP", heading_xf)
|
| 172 |
sheet.write(0, 17, "Lowest Offer Price", heading_xf)
|
172 |
sheet.write(0, 17, "Lowest Offer Price", heading_xf)
|
| Line 213... |
Line 213... |
| 213 |
sheet.write(sheet_iterator, 7, one_line.color)
|
213 |
sheet.write(sheet_iterator, 7, one_line.color)
|
| 214 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
214 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
| 215 |
sheet.write(sheet_iterator, 9, one_line.risky)
|
215 |
sheet.write(sheet_iterator, 9, one_line.risky)
|
| 216 |
sheet.write(sheet_iterator, 10, supc_data.ourSp)
|
216 |
sheet.write(sheet_iterator, 10, supc_data.ourSp)
|
| 217 |
sheet.write(sheet_iterator, 11, round(supc_data.ourSp*0.9597-courierCost))
|
217 |
sheet.write(sheet_iterator, 11, round(supc_data.ourSp*0.9597-courierCost))
|
| 218 |
sheet.write(sheet_iterator, 12, supc_data.offerPrice)
|
218 |
sheet.write(sheet_iterator, 12, supc_data.ourOfferPrice)
|
| 219 |
sheet.write(sheet_iterator, 13, supc_data.rank)
|
219 |
sheet.write(sheet_iterator, 13, supc_data.rank)
|
| 220 |
sheet.write(sheet_iterator, 14, supc_data.lowestSellerName)
|
220 |
sheet.write(sheet_iterator, 14, supc_data.lowestSellerName)
|
| 221 |
sheet.write(sheet_iterator, 15, supc_data.lowestSp)
|
221 |
sheet.write(sheet_iterator, 15, supc_data.lowestSp)
|
| 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
|
| Line 284... |
Line 284... |
| 284 |
sheet.write(0, 7, "Color", heading_xf)
|
284 |
sheet.write(0, 7, "Color", heading_xf)
|
| 285 |
sheet.write(0, 8, "Weight", heading_xf)
|
285 |
sheet.write(0, 8, "Weight", heading_xf)
|
| 286 |
sheet.write(0, 9, "Risky", heading_xf)
|
286 |
sheet.write(0, 9, "Risky", heading_xf)
|
| 287 |
sheet.write(0, 10, "Our SP", heading_xf)
|
287 |
sheet.write(0, 10, "Our SP", heading_xf)
|
| 288 |
sheet.write(0, 11, "Our TP", heading_xf)
|
288 |
sheet.write(0, 11, "Our TP", heading_xf)
|
| 289 |
sheet.write(0, 12, "Offer Price", heading_xf)
|
289 |
sheet.write(0, 12, "Our Offer Price", heading_xf)
|
| 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)
|
| Line 323... |
Line 323... |
| 323 |
sheet.write(i, 7, one_line.color)
|
323 |
sheet.write(i, 7, one_line.color)
|
| 324 |
sheet.write(i, 8, one_line.weight)
|
324 |
sheet.write(i, 8, one_line.weight)
|
| 325 |
sheet.write(i, 9, one_line.risky)
|
325 |
sheet.write(i, 9, one_line.risky)
|
| 326 |
sheet.write(i, 10, supc_data.ourSp)
|
326 |
sheet.write(i, 10, supc_data.ourSp)
|
| 327 |
sheet.write(i, 11, round(supc_data.ourSp*0.9597-courierCost))
|
327 |
sheet.write(i, 11, round(supc_data.ourSp*0.9597-courierCost))
|
| 328 |
sheet.write(i, 12, supc_data.offerPrice)
|
328 |
sheet.write(i, 12, supc_data.ourOfferPrice)
|
| 329 |
sheet.write(i, 13, supc_data.rank)
|
329 |
sheet.write(i, 13, supc_data.rank)
|
| 330 |
sheet.write(i, 14, supc_data.lowestSellerName)
|
330 |
sheet.write(i, 14, supc_data.lowestSellerName)
|
| 331 |
sheet.write(i, 15, supc_data.lowestOfferPrice)
|
331 |
sheet.write(i, 15, supc_data.lowestOfferPrice)
|
| 332 |
sheet.write(i, 16, supc_data.secondLowestSellerName)
|
332 |
sheet.write(i, 16, supc_data.secondLowestSellerName)
|
| 333 |
sheet.write(i, 17, supc_data.secondLowestSellerSp)
|
333 |
sheet.write(i, 17, supc_data.secondLowestSellerSp)
|