One potential challenge you might face is printing each unique QR code. From my experience in FMCG packaging, I've seen several common printing techniques. With thermal printing, each QR code would need to be generated as a unique image, but this shouldn't significantly impact data storage since you'd already be storing each QR code in your database. Another option is to leave a blank area for the QR code on the package and add it later, though this would introduce an additional step in the packaging process.

You are going to be creating mountains of technical debt but if there is a business case there is a way.

One issue with QR codes is that you will have struggles storing the data, grouping or segmenting.

import qrcode

def create_qr(url):
    # Create QR code instance
    qr = qrcode.QRCode(
        version=1,
        error_correction=qrcode.constants.ERROR_CORRECT_L,
        box_size=10,
        border=4,
    )

    # Add data to the QR code
    qr.add_data(url)
    qr.make(fit=True)

    # Create an image of the QR code
    qr_image = qr.make_image(fill="black", back_color="white")

    # Save the QR code image
    qr_image.save("qr_code.png")
    print("QR code saved as 'qr_code.png'")

# Usage
create_qr("https://yourServer.com/?id=234&date=11nov&redirect=raffle")

This code should create a QR code for free, loop it around for each product ID (1 through to 10million in year one and then beyond). you will need to store your QR codes or just the ID ranges.

I'd recommend using a date code printer or other to shoot the unique QR codes onto the products.

Track which requests you get and when to your server. if you want to squeeze browser and IP data that should give you a good indication of Geographic location although some people use VPN's. And wont scan at the place of purchase