// Inventory lots FIFO costing practice dataset (inventory-lots-fifo-costing-practice-dataset) v1 — Prisma seed
// Synthetic sample data, CC0-1.0. Generated deterministically; re-running the
// generator with the same spec and seed reproduces this file exactly.
//
// Delegates are named after the tables (prisma.products), which assumes models
// mapped to those table names. Rename the delegates if your models differ.
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
    await prisma.products.createMany({
        data: [
            { id: 1, name: "Tasty Concrete Computer", base_cost: "58.17", first_receipt_on: "2026-01-09", first_issue_on: "2026-01-11" },
            { id: 2, name: "Oriental Steel Chair", base_cost: "8.70", first_receipt_on: "2026-01-16", first_issue_on: "2026-01-21" },
            { id: 3, name: "Unbranded Bamboo Table", base_cost: "29.91", first_receipt_on: "2026-01-06", first_issue_on: "2026-01-07" },
            { id: 4, name: "Refined Rubber Soap", base_cost: "36.57", first_receipt_on: "2026-01-14", first_issue_on: "2026-01-19" },
            { id: 5, name: "Practical Concrete Towels", base_cost: "49.25", first_receipt_on: "2026-01-09", first_issue_on: "2026-01-11" },
            { id: 6, name: "Practical Cotton Fish", base_cost: "19.50", first_receipt_on: "2026-01-16", first_issue_on: "2026-01-19" },
            { id: 7, name: "Frozen Ceramic Towels", base_cost: "43.36", first_receipt_on: "2026-01-05", first_issue_on: "2026-01-07" },
            { id: 8, name: "Unbranded Cotton Computer", base_cost: "21.29", first_receipt_on: "2026-01-06", first_issue_on: "2026-01-12" },
            { id: 9, name: "Awesome Marble Shirt", base_cost: "4.44", first_receipt_on: "2026-01-06", first_issue_on: "2026-01-09" },
            { id: 10, name: "Recycled Wooden Soap", base_cost: "4.02", first_receipt_on: "2026-01-08", first_issue_on: "2026-01-09" },
        ],
    });
    await prisma.issues.createMany({
        data: [
            { id: 1, product_id: 1, issued_on: "2026-01-11", qty_issued: 37, issue_type: "sale", order_ref: "SO-58638" },
            { id: 2, product_id: 2, issued_on: "2026-01-25", qty_issued: 41, issue_type: "sale", order_ref: "SO-11926" },
            { id: 3, product_id: 5, issued_on: "2026-01-13", qty_issued: 37, issue_type: "sale", order_ref: "SO-51749" },
            { id: 4, product_id: 4, issued_on: "2026-01-23", qty_issued: 36, issue_type: "sale", order_ref: "SO-04774" },
            { id: 5, product_id: 7, issued_on: "2026-01-10", qty_issued: 42, issue_type: "sale", order_ref: "SO-13072" },
            { id: 6, product_id: 4, issued_on: "2026-01-27", qty_issued: 45, issue_type: "sale", order_ref: "SO-57410" },
            { id: 7, product_id: 10, issued_on: "2026-01-12", qty_issued: 47, issue_type: "sale", order_ref: "SO-38329" },
            { id: 8, product_id: 9, issued_on: "2026-01-10", qty_issued: 39, issue_type: "sale", order_ref: "SO-40211" },
            { id: 9, product_id: 6, issued_on: "2026-01-20", qty_issued: 45, issue_type: "sale", order_ref: "SO-74246" },
            { id: 10, product_id: 6, issued_on: "2026-01-25", qty_issued: 42, issue_type: "sale", order_ref: "SO-07908" },
            { id: 11, product_id: 5, issued_on: "2026-01-18", qty_issued: 42, issue_type: "sale", order_ref: "SO-00239" },
            { id: 12, product_id: 9, issued_on: "2026-01-12", qty_issued: 50, issue_type: "sale", order_ref: "SO-76220" },
            { id: 13, product_id: 2, issued_on: "2026-01-31", qty_issued: 32, issue_type: "sale", order_ref: "SO-17762" },
            { id: 14, product_id: 7, issued_on: "2026-01-16", qty_issued: 31, issue_type: "sale", order_ref: "SO-28117" },
            { id: 15, product_id: 2, issued_on: "2026-02-03", qty_issued: 40, issue_type: "sale", order_ref: "SO-71825" },
            { id: 16, product_id: 10, issued_on: "2026-01-17", qty_issued: 44, issue_type: "sale", order_ref: "SO-90347" },
            { id: 17, product_id: 8, issued_on: "2026-01-15", qty_issued: 38, issue_type: "sale", order_ref: "SO-01829" },
            { id: 18, product_id: 7, issued_on: "2026-01-21", qty_issued: 46, issue_type: "sale", order_ref: "SO-68218" },
            { id: 19, product_id: 3, issued_on: "2026-01-07", qty_issued: 42, issue_type: "sale", order_ref: "SO-95724" },
            { id: 20, product_id: 6, issued_on: "2026-01-31", qty_issued: 49, issue_type: "sale", order_ref: "SO-94204" },
            { id: 21, product_id: 4, issued_on: "2026-02-01", qty_issued: 37, issue_type: "sale", order_ref: "SO-23991" },
            { id: 22, product_id: 8, issued_on: "2026-01-18", qty_issued: 33, issue_type: "sale", order_ref: "SO-67689" },
            { id: 23, product_id: 10, issued_on: "2026-01-21", qty_issued: 46, issue_type: "sale", order_ref: "SO-85484" },
            { id: 24, product_id: 7, issued_on: "2026-01-23", qty_issued: 39, issue_type: "sale", order_ref: "SO-06247" },
            { id: 25, product_id: 1, issued_on: "2026-01-17", qty_issued: 39, issue_type: "sale", order_ref: "SO-70257" },
            { id: 26, product_id: 7, issued_on: "2026-01-28", qty_issued: 23, issue_type: "sale", order_ref: "SO-15556" },
            { id: 27, product_id: 9, issued_on: "2026-01-14", qty_issued: 35, issue_type: "sale", order_ref: "SO-36415" },
            { id: 28, product_id: 9, issued_on: "2026-01-18", qty_issued: 37, issue_type: "sale", order_ref: "SO-61891" },
            { id: 29, product_id: 3, issued_on: "2026-01-13", qty_issued: 35, issue_type: "sale", order_ref: "SO-63157" },
            { id: 30, product_id: 1, issued_on: "2026-01-20", qty_issued: 43, issue_type: "sale", order_ref: "SO-38759" },
            { id: 31, product_id: 4, issued_on: "2026-02-06", qty_issued: 34, issue_type: "sale", order_ref: "SO-78725" },
            { id: 32, product_id: 3, issued_on: "2026-01-15", qty_issued: 30, issue_type: "sale", order_ref: "SO-44399" },
            { id: 33, product_id: 6, issued_on: "2026-02-04", qty_issued: 48, issue_type: "sale", order_ref: "SO-26014" },
            { id: 34, product_id: 5, issued_on: "2026-01-22", qty_issued: 30, issue_type: "sale", order_ref: "SO-10431" },
            { id: 35, product_id: 6, issued_on: "2026-02-06", qty_issued: 37, issue_type: "scrap", order_ref: "SO-69885" },
            { id: 36, product_id: 10, issued_on: "2026-01-23", qty_issued: 37, issue_type: "sale", order_ref: "SO-61425" },
            { id: 37, product_id: 2, issued_on: "2026-02-08", qty_issued: 35, issue_type: "sale", order_ref: "SO-25212" },
            { id: 38, product_id: 5, issued_on: "2026-01-26", qty_issued: 41, issue_type: "transfer", order_ref: "SO-07835" },
            { id: 39, product_id: 2, issued_on: "2026-02-13", qty_issued: 44, issue_type: "sale", order_ref: "SO-38924" },
            { id: 40, product_id: 3, issued_on: "2026-01-18", qty_issued: 52, issue_type: "transfer", order_ref: "SO-20390" },
            { id: 41, product_id: 10, issued_on: "2026-01-27", qty_issued: 43, issue_type: "sale", order_ref: "SO-65518" },
            { id: 42, product_id: 1, issued_on: "2026-01-22", qty_issued: 31, issue_type: "sale", order_ref: "SO-37747" },
            { id: 43, product_id: 7, issued_on: "2026-02-02", qty_issued: 35, issue_type: "sale", order_ref: "SO-41355" },
            { id: 44, product_id: 4, issued_on: "2026-02-11", qty_issued: 44, issue_type: "sale", order_ref: "SO-13539" },
            { id: 45, product_id: 4, issued_on: "2026-02-14", qty_issued: 37, issue_type: "sale", order_ref: "SO-82169" },
            { id: 46, product_id: 6, issued_on: "2026-02-11", qty_issued: 41, issue_type: "sale", order_ref: "SO-22238" },
            { id: 47, product_id: 1, issued_on: "2026-01-26", qty_issued: 36, issue_type: "sale", order_ref: "SO-11123" },
            { id: 48, product_id: 2, issued_on: "2026-02-17", qty_issued: 34, issue_type: "sale", order_ref: "SO-65068" },
            { id: 49, product_id: 7, issued_on: "2026-02-07", qty_issued: 36, issue_type: "sale", order_ref: "SO-88920" },
            { id: 50, product_id: 6, issued_on: "2026-02-16", qty_issued: 52, issue_type: "sale", order_ref: "SO-79034" },
            { id: 51, product_id: 5, issued_on: "2026-02-01", qty_issued: 32, issue_type: "sale", order_ref: "SO-73353" },
            { id: 52, product_id: 5, issued_on: "2026-02-04", qty_issued: 41, issue_type: "sale", order_ref: "SO-88466" },
            { id: 53, product_id: 2, issued_on: "2026-02-19", qty_issued: 36, issue_type: "sale", order_ref: "SO-04747" },
            { id: 54, product_id: 6, issued_on: "2026-02-20", qty_issued: 54, issue_type: "sale", order_ref: "SO-74740" },
            { id: 55, product_id: 8, issued_on: "2026-01-24", qty_issued: 37, issue_type: "sale", order_ref: "SO-45113" },
            { id: 56, product_id: 5, issued_on: "2026-02-10", qty_issued: 41, issue_type: "sale", order_ref: "SO-25404" },
            { id: 57, product_id: 5, issued_on: "2026-02-14", qty_issued: 38, issue_type: "sale", order_ref: "SO-61247" },
            { id: 58, product_id: 5, issued_on: "2026-02-19", qty_issued: 52, issue_type: "transfer", order_ref: "SO-46611" },
            { id: 59, product_id: 5, issued_on: "2026-02-24", qty_issued: 42, issue_type: "sale", order_ref: "SO-81947" },
            { id: 60, product_id: 10, issued_on: "2026-01-30", qty_issued: 42, issue_type: "sale", order_ref: "SO-53860" },
            { id: 61, product_id: 2, issued_on: "2026-02-23", qty_issued: 29, issue_type: "sale", order_ref: "SO-87840" },
            { id: 62, product_id: 10, issued_on: "2026-02-04", qty_issued: 38, issue_type: "sale", order_ref: "SO-60769" },
            { id: 63, product_id: 1, issued_on: "2026-01-30", qty_issued: 35, issue_type: "sale", order_ref: "SO-60696" },
            { id: 64, product_id: 4, issued_on: "2026-02-17", qty_issued: 49, issue_type: "sale", order_ref: "SO-95134" },
            { id: 65, product_id: 10, issued_on: "2026-02-08", qty_issued: 29, issue_type: "sale", order_ref: "SO-01132" },
            { id: 66, product_id: 4, issued_on: "2026-02-21", qty_issued: 47, issue_type: "sale", order_ref: "SO-93331" },
            { id: 67, product_id: 3, issued_on: "2026-01-23", qty_issued: 42, issue_type: "sale", order_ref: "SO-44358" },
            { id: 68, product_id: 8, issued_on: "2026-01-29", qty_issued: 33, issue_type: "sale", order_ref: "SO-15375" },
            { id: 69, product_id: 8, issued_on: "2026-02-01", qty_issued: 41, issue_type: "sale", order_ref: "SO-17942" },
            { id: 70, product_id: 9, issued_on: "2026-01-22", qty_issued: 43, issue_type: "sale", order_ref: "SO-22131" },
            { id: 71, product_id: 10, issued_on: "2026-02-14", qty_issued: 38, issue_type: "sale", order_ref: "SO-09677" },
            { id: 72, product_id: 2, issued_on: "2026-03-01", qty_issued: 42, issue_type: "sale", order_ref: "SO-91422" },
            { id: 73, product_id: 9, issued_on: "2026-01-27", qty_issued: 34, issue_type: "sale", order_ref: "SO-80252" },
            { id: 74, product_id: 3, issued_on: "2026-01-26", qty_issued: 47, issue_type: "sale", order_ref: "SO-26765" },
            { id: 75, product_id: 8, issued_on: "2026-02-03", qty_issued: 26, issue_type: "sale", order_ref: "SO-82657" },
            { id: 76, product_id: 7, issued_on: "2026-02-13", qty_issued: 26, issue_type: "sale", order_ref: "SO-56960" },
            { id: 77, product_id: 5, issued_on: "2026-02-27", qty_issued: 46, issue_type: "sale", order_ref: "SO-76954" },
            { id: 78, product_id: 8, issued_on: "2026-02-07", qty_issued: 34, issue_type: "sale", order_ref: "SO-66209" },
            { id: 79, product_id: 10, issued_on: "2026-02-17", qty_issued: 49, issue_type: "sale", order_ref: "SO-22417" },
            { id: 80, product_id: 4, issued_on: "2026-02-26", qty_issued: 39, issue_type: "scrap", order_ref: "SO-13612" },
            { id: 81, product_id: 8, issued_on: "2026-02-09", qty_issued: 32, issue_type: "sale", order_ref: "SO-63241" },
            { id: 82, product_id: 1, issued_on: "2026-02-03", qty_issued: 37, issue_type: "sale", order_ref: "SO-07368" },
            { id: 83, product_id: 8, issued_on: "2026-02-13", qty_issued: 53, issue_type: "sale", order_ref: "SO-64488" },
            { id: 84, product_id: 8, issued_on: "2026-02-18", qty_issued: 39, issue_type: "sale", order_ref: "SO-15310" },
            { id: 85, product_id: 8, issued_on: "2026-02-23", qty_issued: 55, issue_type: "sale", order_ref: "SO-42281" },
            { id: 86, product_id: 6, issued_on: "2026-02-23", qty_issued: 39, issue_type: "sale", order_ref: "SO-18178" },
            { id: 87, product_id: 3, issued_on: "2026-01-30", qty_issued: 35, issue_type: "sale", order_ref: "SO-58180" },
            { id: 88, product_id: 7, issued_on: "2026-02-15", qty_issued: 45, issue_type: "sale", order_ref: "SO-14965" },
            { id: 89, product_id: 10, issued_on: "2026-02-19", qty_issued: 37, issue_type: "sale", order_ref: "SO-16967" },
            { id: 90, product_id: 6, issued_on: "2026-02-27", qty_issued: 45, issue_type: "sale", order_ref: "SO-77545" },
            { id: 91, product_id: 1, issued_on: "2026-02-08", qty_issued: 41, issue_type: "sale", order_ref: "SO-76471" },
            { id: 92, product_id: 6, issued_on: "2026-03-05", qty_issued: 28, issue_type: "sale", order_ref: "SO-97974" },
            { id: 93, product_id: 4, issued_on: "2026-02-28", qty_issued: 32, issue_type: "sale", order_ref: "SO-02468" },
            { id: 94, product_id: 9, issued_on: "2026-02-02", qty_issued: 46, issue_type: "scrap", order_ref: "SO-82564" },
            { id: 95, product_id: 9, issued_on: "2026-02-08", qty_issued: 32, issue_type: "sale", order_ref: "SO-47934" },
            { id: 96, product_id: 7, issued_on: "2026-02-17", qty_issued: 41, issue_type: "scrap", order_ref: "SO-18847" },
            { id: 97, product_id: 1, issued_on: "2026-02-13", qty_issued: 34, issue_type: "transfer", order_ref: "SO-76598" },
            { id: 98, product_id: 8, issued_on: "2026-02-26", qty_issued: 32, issue_type: "sale", order_ref: "SO-11149" },
            { id: 99, product_id: 9, issued_on: "2026-02-14", qty_issued: 44, issue_type: "sale", order_ref: "SO-98539" },
            { id: 100, product_id: 3, issued_on: "2026-02-01", qty_issued: 31, issue_type: "sale", order_ref: "SO-23323" },
            { id: 101, product_id: 1, issued_on: "2026-02-15", qty_issued: 29, issue_type: "sale", order_ref: "SO-41343" },
            { id: 102, product_id: 6, issued_on: "2026-03-07", qty_issued: 52, issue_type: "sale", order_ref: "SO-76243" },
            { id: 103, product_id: 10, issued_on: "2026-02-22", qty_issued: 43, issue_type: "sale", order_ref: "SO-70270" },
            { id: 104, product_id: 5, issued_on: "2026-03-04", qty_issued: 38, issue_type: "sale", order_ref: "SO-66139" },
            { id: 105, product_id: 3, issued_on: "2026-02-06", qty_issued: 39, issue_type: "transfer", order_ref: "SO-00523" },
            { id: 106, product_id: 2, issued_on: "2026-03-05", qty_issued: 44, issue_type: "scrap", order_ref: "SO-33415" },
            { id: 107, product_id: 7, issued_on: "2026-02-19", qty_issued: 36, issue_type: "sale", order_ref: "SO-48836" },
            { id: 108, product_id: 5, issued_on: "2026-03-09", qty_issued: 49, issue_type: "scrap", order_ref: "SO-41557" },
            { id: 109, product_id: 7, issued_on: "2026-02-23", qty_issued: 30, issue_type: "sale", order_ref: "SO-29003" },
            { id: 110, product_id: 4, issued_on: "2026-03-02", qty_issued: 56, issue_type: "sale", order_ref: "SO-82834" },
            { id: 111, product_id: 10, issued_on: "2026-02-24", qty_issued: 36, issue_type: "sale", order_ref: "SO-82111" },
            { id: 112, product_id: 7, issued_on: "2026-02-26", qty_issued: 35, issue_type: "sale", order_ref: "SO-18351" },
            { id: 113, product_id: 6, issued_on: "2026-03-12", qty_issued: 45, issue_type: "sale", order_ref: "SO-43877" },
            { id: 114, product_id: 6, issued_on: "2026-03-15", qty_issued: 34, issue_type: "transfer", order_ref: "SO-39878" },
            { id: 115, product_id: 8, issued_on: "2026-03-03", qty_issued: 35, issue_type: "sale", order_ref: "SO-24278" },
            { id: 116, product_id: 5, issued_on: "2026-03-15", qty_issued: 39, issue_type: "sale", order_ref: "SO-51593" },
            { id: 117, product_id: 7, issued_on: "2026-03-04", qty_issued: 36, issue_type: "sale", order_ref: "SO-35349" },
            { id: 118, product_id: 3, issued_on: "2026-02-10", qty_issued: 44, issue_type: "sale", order_ref: "SO-43483" },
            { id: 119, product_id: 3, issued_on: "2026-02-16", qty_issued: 28, issue_type: "sale", order_ref: "SO-35890" },
            { id: 120, product_id: 3, issued_on: "2026-02-18", qty_issued: 41, issue_type: "sale", order_ref: "SO-24852" },
            { id: 121, product_id: 5, issued_on: "2026-03-21", qty_issued: 32, issue_type: "sale", order_ref: "SO-72740" },
            { id: 122, product_id: 4, issued_on: "2026-03-08", qty_issued: 38, issue_type: "sale", order_ref: "SO-05102" },
            { id: 123, product_id: 7, issued_on: "2026-03-06", qty_issued: 39, issue_type: "sale", order_ref: "SO-42929" },
            { id: 124, product_id: 10, issued_on: "2026-02-26", qty_issued: 46, issue_type: "sale", order_ref: "SO-45297" },
            { id: 125, product_id: 3, issued_on: "2026-02-23", qty_issued: 40, issue_type: "scrap", order_ref: "SO-70185" },
            { id: 126, product_id: 3, issued_on: "2026-02-26", qty_issued: 44, issue_type: "sale", order_ref: "SO-16298" },
            { id: 127, product_id: 1, issued_on: "2026-02-18", qty_issued: 34, issue_type: "sale", order_ref: "SO-75233" },
            { id: 128, product_id: 9, issued_on: "2026-02-18", qty_issued: 38, issue_type: "sale", order_ref: "SO-56188" },
            { id: 129, product_id: 3, issued_on: "2026-03-04", qty_issued: 35, issue_type: "sale", order_ref: "SO-18536" },
            { id: 130, product_id: 7, issued_on: "2026-03-12", qty_issued: 38, issue_type: "sale", order_ref: "SO-98354" },
            { id: 131, product_id: 1, issued_on: "2026-02-23", qty_issued: 36, issue_type: "sale", order_ref: "SO-16662" },
            { id: 132, product_id: 1, issued_on: "2026-03-01", qty_issued: 49, issue_type: "sale", order_ref: "SO-30336" },
            { id: 133, product_id: 5, issued_on: "2026-03-27", qty_issued: 43, issue_type: "sale", order_ref: "SO-94983" },
            { id: 134, product_id: 4, issued_on: "2026-03-12", qty_issued: 47, issue_type: "sale", order_ref: "SO-60470" },
            { id: 135, product_id: 10, issued_on: "2026-03-01", qty_issued: 40, issue_type: "sale", order_ref: "SO-87087" },
            { id: 136, product_id: 9, issued_on: "2026-02-24", qty_issued: 39, issue_type: "scrap", order_ref: "SO-68420" },
            { id: 137, product_id: 4, issued_on: "2026-03-17", qty_issued: 42, issue_type: "sale", order_ref: "SO-06220" },
            { id: 138, product_id: 7, issued_on: "2026-03-14", qty_issued: 39, issue_type: "sale", order_ref: "SO-31482" },
            { id: 139, product_id: 1, issued_on: "2026-03-07", qty_issued: 41, issue_type: "sale", order_ref: "SO-97036" },
            { id: 140, product_id: 4, issued_on: "2026-03-23", qty_issued: 53, issue_type: "sale", order_ref: "SO-54397" },
            { id: 141, product_id: 9, issued_on: "2026-03-02", qty_issued: 37, issue_type: "sale", order_ref: "SO-96317" },
            { id: 142, product_id: 3, issued_on: "2026-03-10", qty_issued: 31, issue_type: "sale", order_ref: "SO-87630" },
            { id: 143, product_id: 9, issued_on: "2026-03-06", qty_issued: 34, issue_type: "sale", order_ref: "SO-68742" },
            { id: 144, product_id: 2, issued_on: "2026-03-08", qty_issued: 53, issue_type: "sale", order_ref: "SO-55479" },
            { id: 145, product_id: 2, issued_on: "2026-03-11", qty_issued: 43, issue_type: "sale", order_ref: "SO-74720" },
            { id: 146, product_id: 2, issued_on: "2026-03-16", qty_issued: 45, issue_type: "sale", order_ref: "SO-43037" },
            { id: 147, product_id: 5, issued_on: "2026-04-01", qty_issued: 45, issue_type: "sale", order_ref: "SO-37099" },
            { id: 148, product_id: 4, issued_on: "2026-03-28", qty_issued: 41, issue_type: "sale", order_ref: "SO-57825" },
            { id: 149, product_id: 3, issued_on: "2026-03-14", qty_issued: 49, issue_type: "sale", order_ref: "SO-48604" },
            { id: 150, product_id: 5, issued_on: "2026-04-07", qty_issued: 45, issue_type: "transfer", order_ref: "SO-95288" },
            { id: 151, product_id: 10, issued_on: "2026-03-04", qty_issued: 53, issue_type: "sale", order_ref: "SO-63308" },
            { id: 152, product_id: 8, issued_on: "2026-03-05", qty_issued: 25, issue_type: "transfer", order_ref: "SO-17265" },
            { id: 153, product_id: 9, issued_on: "2026-03-08", qty_issued: 47, issue_type: "sale", order_ref: "SO-93427" },
            { id: 154, product_id: 3, issued_on: "2026-03-19", qty_issued: 51, issue_type: "sale", order_ref: "SO-49464" },
            { id: 155, product_id: 1, issued_on: "2026-03-11", qty_issued: 39, issue_type: "sale", order_ref: "SO-79359" },
            { id: 156, product_id: 1, issued_on: "2026-03-15", qty_issued: 30, issue_type: "sale", order_ref: "SO-01737" },
            { id: 157, product_id: 2, issued_on: "2026-03-19", qty_issued: 46, issue_type: "sale", order_ref: "SO-42570" },
            { id: 158, product_id: 2, issued_on: "2026-03-25", qty_issued: 53, issue_type: "sale", order_ref: "SO-19056" },
            { id: 159, product_id: 6, issued_on: "2026-03-20", qty_issued: 41, issue_type: "sale", order_ref: "SO-89794" },
            { id: 160, product_id: 4, issued_on: "2026-04-01", qty_issued: 30, issue_type: "sale", order_ref: "SO-35690" },
            { id: 161, product_id: 5, issued_on: "2026-04-10", qty_issued: 46, issue_type: "sale", order_ref: "SO-58564" },
            { id: 162, product_id: 10, issued_on: "2026-03-10", qty_issued: 30, issue_type: "sale", order_ref: "SO-83522" },
            { id: 163, product_id: 3, issued_on: "2026-03-25", qty_issued: 41, issue_type: "sale", order_ref: "SO-98447" },
            { id: 164, product_id: 8, issued_on: "2026-03-10", qty_issued: 41, issue_type: "sale", order_ref: "SO-38409" },
            { id: 165, product_id: 8, issued_on: "2026-03-15", qty_issued: 35, issue_type: "sale", order_ref: "SO-35794" },
            { id: 166, product_id: 6, issued_on: "2026-03-23", qty_issued: 33, issue_type: "sale", order_ref: "SO-71495" },
            { id: 167, product_id: 5, issued_on: "2026-04-16", qty_issued: 42, issue_type: "sale", order_ref: "SO-90709" },
            { id: 168, product_id: 5, issued_on: "2026-04-20", qty_issued: 45, issue_type: "sale", order_ref: "SO-43525" },
            { id: 169, product_id: 9, issued_on: "2026-03-12", qty_issued: 30, issue_type: "sale", order_ref: "SO-55778" },
            { id: 170, product_id: 3, issued_on: "2026-03-31", qty_issued: 37, issue_type: "sale", order_ref: "SO-20298" },
            { id: 171, product_id: 9, issued_on: "2026-03-17", qty_issued: 26, issue_type: "sale", order_ref: "SO-84364" },
            { id: 172, product_id: 6, issued_on: "2026-03-29", qty_issued: 45, issue_type: "sale", order_ref: "SO-33216" },
            { id: 173, product_id: 8, issued_on: "2026-03-20", qty_issued: 43, issue_type: "sale", order_ref: "SO-88805" },
            { id: 174, product_id: 2, issued_on: "2026-03-27", qty_issued: 42, issue_type: "sale", order_ref: "SO-92805" },
            { id: 175, product_id: 8, issued_on: "2026-03-23", qty_issued: 40, issue_type: "sale", order_ref: "SO-67324" },
            { id: 176, product_id: 5, issued_on: "2026-04-23", qty_issued: 34, issue_type: "sale", order_ref: "SO-85681" },
            { id: 177, product_id: 3, issued_on: "2026-04-06", qty_issued: 31, issue_type: "sale", order_ref: "SO-68442" },
            { id: 178, product_id: 8, issued_on: "2026-03-28", qty_issued: 34, issue_type: "sale", order_ref: "SO-91235" },
            { id: 179, product_id: 10, issued_on: "2026-03-15", qty_issued: 39, issue_type: "sale", order_ref: "SO-13623" },
            { id: 180, product_id: 1, issued_on: "2026-03-20", qty_issued: 46, issue_type: "sale", order_ref: "SO-62736" },
            { id: 181, product_id: 9, issued_on: "2026-03-23", qty_issued: 36, issue_type: "sale", order_ref: "SO-04245" },
            { id: 182, product_id: 4, issued_on: "2026-04-04", qty_issued: 51, issue_type: "sale", order_ref: "SO-40495" },
            { id: 183, product_id: 7, issued_on: "2026-03-20", qty_issued: 41, issue_type: "sale", order_ref: "SO-67261" },
            { id: 184, product_id: 3, issued_on: "2026-04-09", qty_issued: 45, issue_type: "sale", order_ref: "SO-94740" },
            { id: 185, product_id: 7, issued_on: "2026-03-25", qty_issued: 34, issue_type: "sale", order_ref: "SO-22325" },
            { id: 186, product_id: 2, issued_on: "2026-03-30", qty_issued: 49, issue_type: "sale", order_ref: "SO-97410" },
        ],
    });
    await prisma.lots.createMany({
        data: [
            { id: 1, product_id: 8, received_on: "2026-01-06", qty_received: 177, cost_index: "0.974", unit_cost: "20.74" },
            { id: 2, product_id: 4, received_on: "2026-01-14", qty_received: 224, cost_index: "0.979", unit_cost: "35.80" },
            { id: 3, product_id: 1, received_on: "2026-01-09", qty_received: 201, cost_index: "1.020", unit_cost: "59.33" },
            { id: 4, product_id: 9, received_on: "2026-01-06", qty_received: 207, cost_index: "1.014", unit_cost: "4.50" },
            { id: 5, product_id: 5, received_on: "2026-01-09", qty_received: 198, cost_index: "1.013", unit_cost: "49.89" },
            { id: 6, product_id: 4, received_on: "2026-01-28", qty_received: 205, cost_index: "1.041", unit_cost: "38.07" },
            { id: 7, product_id: 10, received_on: "2026-01-08", qty_received: 189, cost_index: "1.000", unit_cost: "4.02" },
            { id: 8, product_id: 2, received_on: "2026-01-16", qty_received: 208, cost_index: "0.994", unit_cost: "8.65" },
            { id: 9, product_id: 5, received_on: "2026-01-23", qty_received: 212, cost_index: "1.043", unit_cost: "51.37" },
            { id: 10, product_id: 1, received_on: "2026-01-23", qty_received: 177, cost_index: "1.026", unit_cost: "59.68" },
            { id: 11, product_id: 3, received_on: "2026-01-06", qty_received: 211, cost_index: "1.006", unit_cost: "30.09" },
            { id: 12, product_id: 10, received_on: "2026-01-22", qty_received: 176, cost_index: "1.039", unit_cost: "4.18" },
            { id: 13, product_id: 9, received_on: "2026-01-20", qty_received: 200, cost_index: "1.039", unit_cost: "4.61" },
            { id: 14, product_id: 5, received_on: "2026-02-06", qty_received: 180, cost_index: "1.052", unit_cost: "51.81" },
            { id: 15, product_id: 5, received_on: "2026-02-20", qty_received: 197, cost_index: "1.099", unit_cost: "54.13" },
            { id: 16, product_id: 2, received_on: "2026-01-30", qty_received: 165, cost_index: "1.027", unit_cost: "8.93" },
            { id: 17, product_id: 8, received_on: "2026-01-20", qty_received: 164, cost_index: "1.041", unit_cost: "22.16" },
            { id: 18, product_id: 8, received_on: "2026-02-03", qty_received: 206, cost_index: "1.060", unit_cost: "22.57" },
            { id: 19, product_id: 6, received_on: "2026-01-16", qty_received: 174, cost_index: "0.987", unit_cost: "19.25" },
            { id: 20, product_id: 9, received_on: "2026-02-03", qty_received: 185, cost_index: "1.071", unit_cost: "4.76" },
            { id: 21, product_id: 4, received_on: "2026-02-11", qty_received: 156, cost_index: "1.026", unit_cost: "37.52" },
            { id: 22, product_id: 6, received_on: "2026-01-30", qty_received: 195, cost_index: "1.045", unit_cost: "20.38" },
            { id: 23, product_id: 7, received_on: "2026-01-05", qty_received: 170, cost_index: "0.998", unit_cost: "43.27" },
            { id: 24, product_id: 7, received_on: "2026-01-19", qty_received: 162, cost_index: "1.038", unit_cost: "45.01" },
            { id: 25, product_id: 5, received_on: "2026-03-06", qty_received: 184, cost_index: "1.120", unit_cost: "55.16" },
            { id: 26, product_id: 6, received_on: "2026-02-13", qty_received: 186, cost_index: "1.081", unit_cost: "21.08" },
            { id: 27, product_id: 8, received_on: "2026-02-17", qty_received: 177, cost_index: "1.110", unit_cost: "23.63" },
            { id: 28, product_id: 3, received_on: "2026-01-20", qty_received: 189, cost_index: "1.039", unit_cost: "31.08" },
            { id: 29, product_id: 2, received_on: "2026-02-13", qty_received: 195, cost_index: "1.082", unit_cost: "9.41" },
            { id: 30, product_id: 9, received_on: "2026-02-17", qty_received: 209, cost_index: "1.131", unit_cost: "5.02" },
            { id: 31, product_id: 5, received_on: "2026-03-20", qty_received: 209, cost_index: "1.170", unit_cost: "57.62" },
            { id: 32, product_id: 9, received_on: "2026-03-03", qty_received: 182, cost_index: "1.153", unit_cost: "5.12" },
            { id: 33, product_id: 6, received_on: "2026-02-27", qty_received: 202, cost_index: "1.110", unit_cost: "21.65" },
            { id: 34, product_id: 6, received_on: "2026-03-13", qty_received: 183, cost_index: "1.148", unit_cost: "22.39" },
            { id: 35, product_id: 2, received_on: "2026-02-27", qty_received: 207, cost_index: "1.117", unit_cost: "9.72" },
            { id: 36, product_id: 4, received_on: "2026-02-25", qty_received: 172, cost_index: "1.096", unit_cost: "40.08" },
            { id: 37, product_id: 8, received_on: "2026-03-03", qty_received: 210, cost_index: "1.149", unit_cost: "24.46" },
            { id: 38, product_id: 3, received_on: "2026-02-03", qty_received: 224, cost_index: "1.087", unit_cost: "32.51" },
            { id: 39, product_id: 2, received_on: "2026-03-13", qty_received: 196, cost_index: "1.146", unit_cost: "9.97" },
            { id: 40, product_id: 3, received_on: "2026-02-17", qty_received: 187, cost_index: "1.105", unit_cost: "33.05" },
            { id: 41, product_id: 7, received_on: "2026-02-02", qty_received: 152, cost_index: "1.083", unit_cost: "46.96" },
            { id: 42, product_id: 6, received_on: "2026-03-27", qty_received: 194, cost_index: "1.187", unit_cost: "23.15" },
            { id: 43, product_id: 4, received_on: "2026-03-11", qty_received: 160, cost_index: "1.145", unit_cost: "41.87" },
            { id: 44, product_id: 2, received_on: "2026-03-27", qty_received: 160, cost_index: "1.180", unit_cost: "10.27" },
            { id: 45, product_id: 7, received_on: "2026-02-16", qty_received: 151, cost_index: "1.117", unit_cost: "48.43" },
            { id: 46, product_id: 8, received_on: "2026-03-17", qty_received: 165, cost_index: "1.181", unit_cost: "25.14" },
            { id: 47, product_id: 3, received_on: "2026-03-03", qty_received: 215, cost_index: "1.129", unit_cost: "33.77" },
            { id: 48, product_id: 1, received_on: "2026-02-06", qty_received: 184, cost_index: "1.070", unit_cost: "62.24" },
            { id: 49, product_id: 10, received_on: "2026-02-05", qty_received: 198, cost_index: "1.086", unit_cost: "4.37" },
            { id: 50, product_id: 6, received_on: "2026-04-10", qty_received: 168, cost_index: "1.209", unit_cost: "23.58" },
            { id: 51, product_id: 10, received_on: "2026-02-19", qty_received: 214, cost_index: "1.086", unit_cost: "4.37" },
            { id: 52, product_id: 1, received_on: "2026-02-20", qty_received: 193, cost_index: "1.103", unit_cost: "64.16" },
            { id: 53, product_id: 8, received_on: "2026-03-31", qty_received: 192, cost_index: "1.200", unit_cost: "25.55" },
            { id: 54, product_id: 1, received_on: "2026-03-06", qty_received: 152, cost_index: "1.135", unit_cost: "66.02" },
            { id: 55, product_id: 7, received_on: "2026-03-02", qty_received: 194, cost_index: "1.127", unit_cost: "48.87" },
            { id: 56, product_id: 10, received_on: "2026-03-05", qty_received: 192, cost_index: "1.138", unit_cost: "4.57" },
            { id: 57, product_id: 1, received_on: "2026-03-20", qty_received: 202, cost_index: "1.182", unit_cost: "68.76" },
        ],
    });
}

main()
    .then(() => prisma.$disconnect())
    .catch(async error => {
        console.error(error);
        await prisma.$disconnect();
        process.exit(1);
    });