Meesho Seller Portal

This app helps a Meesho seller handle both daily tasks from one portal:

• generate 4x6 labels from Meesho PDFs
• extract order details into one central Excel sheet and optional Google Sheet

Features

• Upload one or more Meesho label PDFs
• Generate 4x6 cropped labels for printing
• Extract customer name and address
• Extract AWB / barcode number
• Extract SKU, size, quantity, and color
• Extract order number, purchase order number, invoice number, order date, and invoice date
• Save all extracted rows into one Excel backend file
• Skip duplicate orders when the same PDF is uploaded again

Run

cd c:\Users\aadddiiii\Music\Codes\meesho_order_portal
pip install -r requirements.txt
streamlit run app.py

You can also double-click:

Run Meesho Order Portal.bat

Important: do not run python app.py. That causes the missing ScriptRunContext warning because Streamlit apps must be started with streamlit run or python -m streamlit run.

Google Sheet Live Sync

If you already have a live Google Sheet, this app can append new extracted orders into it on every upload.

Files to add

1. Copy google_sheet_config.example.json to google_sheet_config.json
2. Put your Google service account key file in this folder as:

google_service_account.json

Config format

{
  "spreadsheet_id": "YOUR_GOOGLE_SHEET_ID",
  "worksheet_name": "Orders"
}

One-time Google setup

1. Open Google Cloud Console
2. Create a project or use an existing one
3. Enable the Google Sheets API and Google Drive API
4. Create a Service Account
5. Create a JSON key and download it
6. Save that file here as google_service_account.json
7. Open your Google Sheet and share it with the service account email
8. Give that email Editor access

Where to find the sheet ID

If your sheet URL is:

https://docs.google.com/spreadsheets/d/1ABCxyz1234567890/edit#gid=0

Then the spreadsheet_id is:

1ABCxyz1234567890

Publish To GitHub And Deploy Live

Before uploading to GitHub

Do not upload these private files:

• google_service_account.json
• google_sheet_config.json
• data/meesho_orders.xlsx

This project now includes a .gitignore file so those stay out of GitHub.

GitHub steps

1. Create a new GitHub repository
2. Upload the contents of meesho_order_portal
3. Make sure the private JSON files are not included

Fastest live hosting option

The easiest way to make this app live is Streamlit Community Cloud:

1. Push this project to GitHub
2. Open https://share.streamlit.io/
3. Sign in with GitHub
4. Choose your repository
5. Set the main file to:

app.py

6. Deploy

Add secrets on Streamlit Cloud

In Streamlit Cloud app settings, open Secrets and paste the contents using the format from:

.streamlit/secrets.example.toml

This app supports Streamlit secrets, so you do not need to upload your JSON credential files to GitHub.

Protect The Live App With Login

You can enable a simple login page for the live app by adding this to Streamlit Cloud Secrets:

[auth]
username = "your-username"
password = "your-password"

After saving and rebooting the app, users must log in before using the tool.

Output

The central backend Excel file is created here:

meesho_order_portal\data\meesho_orders.xlsx

Note

The extractor is built for Meesho-style label PDFs like the sample you shared. If your labels have a different layout, we can adjust the parser rules quickly.