craft2prints/check_print_areas.js

const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();

async function main() {
  const products = await prisma.product.findMany({
    where: {
      slug: {
        in: ['awd-t-shirt-at001', 'awd-hoodie']
      }
    },
    select: {
      'slug': true,
      'name': true,
      'printArea': true,
      'printAreaBack': true,
      'mockup': true
    }
  });

  products.forEach(p => {
    console.log(`\n${p.name} (${p.slug}):`);
    console.log(`  Mockup: ${p.mockup}`);
    const front = JSON.parse(p.printArea);
    console.log(`  Front Print Area: x=${front.xPct}, y=${front.yPct}, w=${front.wPct}, h=${front.hPct}`);
    if (p.printAreaBack) {
      const back = JSON.parse(p.printAreaBack);
      console.log(`  Back Print Area:  x=${back.xPct}, y=${back.yPct}, w=${back.wPct}, h=${back.hPct}`);
    }
  });
}

main()
  .then(() => process.exit(0))
  .catch(err => {
    console.error(err);
    process.exit(1);
  });