from openpyxl import Workbook

wb = Workbook()
ws = wb.active
ws.title = "Walibazar_SKU_2200"

# headers
ws.append(["SKU", "Category", "Product Name", "Unit", "Price Min (BDT)", "Price Max (BDT)"])

def add_items(category, base_items, variants, unit, price_min, price_max, sku_start):
    rows = []
    sku = sku_start
    for item in base_items:
        for v in range(1, variants+1):
            name = f"{item} ({v})"
            rows.append([f"WB-{sku:05d}", category, name, unit, price_min, price_max])
            sku += 1
    return rows, sku

sku = 1
all_rows = []

# simplified base lists (Bangla+English mix)
rice = ["Miniket Rice","Nazirshail Rice","Basmati Rice","Jeera Rice","Atap Rice","Brown Rice","Chinigura Rice","Paijam Rice"]
pulses = ["Masoor Dal","Moong Dal","Chola Dal","Motor Dal","Aroar Dal","Mash Dal","Lentil Mix","Organic Dal"]
oil = ["Soybean Oil","Mustard Oil","Sunflower Oil","Olive Oil","Rice Bran Oil","Palm Oil","Coconut Oil","Corn Oil"]
veg = ["Potato","Onion","Tomato","Eggplant","Cucumber","Carrot","Garlic","Ginger","Green Chili","Bottle Gourd","Pumpkin","Cabbage","Cauliflower","Spinach","Amaranth","Okra"]
fruits = ["Banana","Apple","Orange","Grape","Mango","Papaya","Guava","Pineapple","Watermelon","Pomegranate","Dates","Lemon","Lime","Dragon Fruit"]
fish = ["Hilsa","Rui","Katla","Tilapia","Pangash","Shing","Magur","Boal","Pabda","Koi","Tengra","Chingri","Sea Fish Mix","Dry Fish"]
meat = ["Beef Curry Cut","Beef Bone","Mutton Curry Cut","Chicken Broiler","Chicken Sonali","Duck Meat","Goat Meat","Chicken Wings","Chicken Breast","Chicken Liver","Beef Mince","Marinated Meat","Frozen Meat"]
baby = ["Baby Diaper","Baby Wipes","Baby Lotion","Baby Shampoo","Baby Soap","Baby Oil","Baby Powder","Baby Food","Baby Formula","Baby Snack"]
beauty = ["Shampoo","Conditioner","Face Wash","Body Lotion","Soap","Deodorant","Lip Balm","Hair Oil","Face Cream","Sunscreen"]
health = ["Paracetamol","ORS","Zinc","Vitamin C","Calcium","Iron Tablet","Antiseptic","Hand Sanitizer","Thermometer","Bandage","Cough Syrup"]
cleaning = ["Dish Wash","Floor Cleaner","Toilet Cleaner","Detergent","Hand Wash","Tissue","Air Freshener","Bleach","Scrubber","Mop"]
stationery = ["Pen","Pencil","Notebook","Eraser","Sharpener","Marker","Highlighter","File Folder","Stapler","Glue","Paper","School Bag","Calculator"]
hardware = ["Hammer","Screwdriver","Nail","Screw","Pipe","Switch","Bulb","Wire","Tape","Lock","Drill Tool","Wrench","Tool Box"]

def expand(category, items, target_count, unit, price_min, price_max, sku_start):
    rows=[]
    sku=sku_start
    i=0
    while len(rows) < target_count:
        item = items[i % len(items)]
        variant = (len(rows) % 5) + 1
        name = f"{item} Pack {variant}"
        rows.append([f"WB-{sku:05d}", category, name, unit, price_min, price_max])
        sku+=1
        i+=1
    return rows, sku

all_rows, sku = [], 1

r, sku = expand("Rice", rice, 80, "kg", 55, 140, sku); all_rows += r
r, sku = expand("Pulses", pulses, 80, "kg", 90, 220, sku); all_rows += r
r, sku = expand("Oil", oil, 80, "ltr", 160, 320, sku); all_rows += r
r, sku = expand("Vegetables", veg, 160, "kg", 20, 120, sku); all_rows += r
r, sku = expand("Fruits", fruits, 140, "kg", 80, 350, sku); all_rows += r
r, sku = expand("Fish", fish, 180, "kg", 180, 1200, sku); all_rows += r
r, sku = expand("Meat", meat, 140, "kg", 250, 900, sku); all_rows += r
r, sku = expand("Baby", baby, 250, "unit", 50, 2000, sku); all_rows += r
r, sku = expand("Beauty", beauty, 250, "unit", 50, 1500, sku); all_rows += r
r, sku = expand("Health", health, 200, "unit", 5, 800, sku); all_rows += r
r, sku = expand("Cleaning", cleaning, 200, "unit", 20, 600, sku); all_rows += r
r, sku = expand("Stationery", stationery, 220, "unit", 5, 500, sku); all_rows += r
r, sku = expand("Hardware", hardware, 220, "unit", 20, 2000, sku); all_rows += r

for row in all_rows:
    ws.append(row)

file_path = "/mnt/data/walibazar_2200_sku.xlsx"
wb.save(file_path)

file_path