woolie_recipes.py

#!/usr/bin/python
import requests
from pprint import pprint

def cost(sku, weightInGrams):
   url = 'https://www2.woolworthsonline.com.au/apis/ui/Search/products'
   cookies = {'w-lrkswrdjp': 'dm-Pickup,f-2706,s-16027'} # Acacia Ridge
   r = requests.get(url, params = {'SearchTerm': sku}, cookies = cookies)
   product = r.json()
   product = product['Products'][0]
   name = product['Name']
   product = product['Products'][0]
   # if missing more than than 10%
   quantity = int(weightInGrams) / int(product['UnitWeightInGrams'])
   if ((int(weightInGrams) % int(product['UnitWeightInGrams'])) /
      float(weightInGrams) > 0.1):
      quantity += 1
   print("%d\t%s\t%dg\t%s" % (quantity, product['Price'], product['UnitWeightInGrams'], name))
   return quantity * product['Price']

with open('recipes.tsv','r') as tsv:
   tsv.readline()
   sum = 0
   print("Qty\tPrice\tEach\tName")
   for line in tsv:
      line = line.strip().split('\t')
      sum += cost(line[2], line[3])