ziogref / pepsimaxhunter Goto Github PK

Woolworths seem to have incorrect prices. The API url does not change but the contents does depending on the selected store.

See if a store cookie can be found to pass to the URL to get the correct prices for preferred store

see if the API has these values.

Add support for amazon (if possible). Unsure how amazon will work as search can reveal multiple results for the same item, however the user has to select a link to put into python.

Will have to support break-out incase the link dies due to the seller removing them item also unsure if a link is tied to a seller or item.

requires investigation

The coles JSON api url changes each week. The format appears to be

The URL starts with
https://www.coles.com.au/_next/data/

Next is a date, that could possibly be based on UTC 0 time. that updates weekly on Wednesdays. So this weeks it is
20230510
and next week should be
20230517

So in this URL example, its
20230510

Next is
.01_
I suspect this is possibly a price revision version.

next is a version number
v3.35.0
each week it increments by 0.01 I am unsure on the exact format being used.

Next is general unchanging text
/en/product/

And last is the product "name" which is found at the end of the coles customer facing URL. e.g
pepsi-soft-drink-cola-max-24-pack-7366022

lastly we have our json format
.json

full URL for example
https://www.coles.com.au/_next/data/20230510.01_v3.35.0/en/product/pepsi-soft-drink-cola-max-24-pack-7366022.json

last week was
https://www.coles.com.au/_next/data/20230502.01_v3.34.0/en/product/pepsi-soft-drink-cola-max-24-pack-7366022.json

Current code relies on search terms specific to pepsi max. Here is regex provided by Google BARD to a better job

# Import the necessary libraries
import re

# Create a regular expression to match the pack size
regex = re.compile(r"(\d+)x(\d+)ml")

# Loop through the products
for product in products:

    # Match the pack size in the product description
    match = regex.match(product)

    # If a match is found, extract the pack size
    if match:
        print(match.groups()[0])

    # If no match is found, print an error message
    else:
        print(f"No pack size found for {product}")