craft2prints/check_product_images.js

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

async function main() {
  const product = await prisma.product.findUnique({
    where: { slug: 'awd-t-shirt-at001' }
  });

  if (!product) {
    console.log('Product not found');
    return;
  }

  console.log('\n=== T-Shirt Images ===');
  console.log(`\nColors: ${product.colors}`);
  console.log(`\nimagUrl: ${product.imageUrl ? 'SET' : 'NOT SET'}`);
  console.log(`imageUrlBack: ${product.imageUrlBack ? 'SET' : 'NOT SET'}`);
  
  if (product.colorPhotos) {
    const colors = JSON.parse(product.colorPhotos);
    console.log(`\ncolorPhotos: ${Object.keys(colors).length} colors have photos`);
    Object.keys(colors).forEach(color => {
      console.log(`  - ${color}: ${colors[color] ? 'HAS IMAGE' : 'NO IMAGE'}`);
    });
  } else {
    console.log('\ncolorPhotos: NOT SET');
  }

  if (product.colorPhotosBack) {
    const colors = JSON.parse(product.colorPhotosBack);
    console.log(`\ncolorPhotosBack: ${Object.keys(colors).length} colors have back photos`);
  } else {
    console.log('\ncolorPhotosBack: NOT SET');
  }
}

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