check_product.php

<?php

use Symfony\Component\Dotenv\Dotenv;
use SellingPartnerApi\Api\ListingsV20210801Api;

require __DIR__ . '/vendor/autoload.php';

$dotenv = new Dotenv();
$dotenv->load(__DIR__ . '/.env');

// SKU of the product to query
$sku = $argv[1] ?? null;

if (!$sku) {
    echo "❌ You must provide a SKU\n";
    echo "Usage: php check_product.php [SKU]\n";
    echo "Example: php check_product.php B0182SJFQQ\n";
    exit(1);
}

// Amazon Configuration
$sellerId = $_ENV['AMAZON_SELLER_ID'];
$amazonMarketplace = $_ENV['AMAZON_MARKETPLACE_DEFAULT'];
$amazonRefresh = $_ENV['AMAZON_REFRESH_TOKEN'];
$amazonClientId = $_ENV['AMAZON_CLIENT_ID'];
$amazonClientSecret = $_ENV['AMAZON_CLIENT_SECRET'];
$amazonAccessKey = $_ENV['AMAZON_ACCESS_KEY'];
$amazonSecretKey = $_ENV['AMAZON_SECRET_KEY'];
$amazonRoleArn = $_ENV['AMAZON_ROLE_ARN'];

$config = new SellingPartnerApi\Configuration([
    'lwaClientId' => $amazonClientId,
    'lwaClientSecret' => $amazonClientSecret,
    'lwaRefreshToken' => $amazonRefresh,
    'awsAccessKeyId' => $amazonAccessKey,
    'awsSecretAccessKey' => $amazonSecretKey,
    'endpoint' => SellingPartnerApi\Endpoint::EU,
    'roleArn' => $amazonRoleArn,
]);

// Helper function to safely convert objects to arrays
function toArray($data)
{
    if (is_object($data)) {
        return json_decode(json_encode($data), true);
    }
    return $data;
}

// Helper function to safely get value from object or array
function getValue($data, $key, $default = null)
{
    if (is_array($data)) {
        return $data[$key] ?? $default;
    } elseif (is_object($data)) {
        return $data->$key ?? $default;
    }
    return $default;
}

try {
    $listingsApi = new ListingsV20210801Api($config);

    echo "🔍 Getting information for SKU: {$sku}\n";
    echo str_repeat("=", 60) . "\n";

    // Get product information
    $response = $listingsApi->getListingsItem(
        $sellerId,
        $sku,
        [$amazonMarketplace],
        null, // issue_locale
        ['summaries', 'attributes', 'issues', 'offers', 'fulfillmentAvailability', 'procurement']
    );

    $listingItem = $response;

    if (!$listingItem) {
        echo "❌ No information found for SKU: {$sku}\n";
        exit(1);
    }

    echo "📦 SKU: " . $listingItem->getSku() . "\n\n";

    // Summary information
    $summaries = $listingItem->getSummaries();
    if ($summaries && count($summaries) > 0) {
        echo "📋 GENERAL INFORMATION:\n";
        echo str_repeat("-", 40) . "\n";

        foreach ($summaries as $summary) {
            echo "🌍 Marketplace: " . $summary->getMarketplaceId() . "\n";

            if ($summary->getAsin()) {
                echo "🏷️ ASIN: " . $summary->getAsin() . "\n";
            }

            if ($summary->getProductType()) {
                echo "📂 Product Type: " . $summary->getProductType() . "\n";
            }

            if ($summary->getConditionType()) {
                echo "🔖 Condition: " . $summary->getConditionType() . "\n";
            }

            if ($summary->getStatus()) {
                $status = implode(', ', $summary->getStatus());
                echo "📊 Status: {$status}\n";
            }

            if ($summary->getItemName()) {
                echo "📖 Name: " . $summary->getItemName() . "\n";
            }
        }
        echo "\n";
    }

    // Fulfillment availability information
    $fulfillmentAvailability = $listingItem->getFulfillmentAvailability();
    if ($fulfillmentAvailability && count($fulfillmentAvailability) > 0) {
        echo "📦 INVENTORY AVAILABILITY:\n";
        echo str_repeat("-", 40) . "\n";

        foreach ($fulfillmentAvailability as $availability) {
            $fulfillmentChannelCode = $availability->getFulfillmentChannelCode();
            $quantity = $availability->getQuantity();

            $channelName = match($fulfillmentChannelCode) {
                'DEFAULT' => 'Merchant Fulfilled (MFN)',
                'AMAZON_NA' => 'Amazon Fulfilled (FBA)',
                'AMAZON_EU' => 'Amazon Fulfilled EU (FBA)',
                default => $fulfillmentChannelCode
            };

            echo "🏪 Channel: {$channelName}\n";
            echo "📊 Quantity: {$quantity}\n\n";
        }
    }

    // PRICING INFORMATION - Convert to array to avoid object/array issues
    $attributes = toArray($listingItem->getAttributes());
    echo "💰 PRICING INFORMATION:\n";
    echo str_repeat("-", 40) . "\n";

    if ($attributes && isset($attributes['purchasable_offer'])) {
        $purchasableOffers = $attributes['purchasable_offer'];

        foreach ($purchasableOffers as $offerIndex => $offer) {
            echo "🏷️ Offer #" . ($offerIndex + 1) . ":\n";

            $audience = getValue($offer, 'audience');
            if ($audience) {
                echo "👥 Audience: " . $audience . "\n";
            }

            $currency = getValue($offer, 'currency', 'EUR');
            echo "💱 Currency: " . $currency . "\n";

            // Main pricing information
            $ourPrice = getValue($offer, 'our_price');
            if ($ourPrice && is_array($ourPrice)) {
                foreach ($ourPrice as $priceIndex => $priceData) {
                    echo "💲 Price #" . ($priceIndex + 1) . ":\n";

                    $schedule = getValue($priceData, 'schedule');
                    if ($schedule && is_array($schedule)) {
                        foreach ($schedule as $scheduleIndex => $scheduleItem) {
                            echo "  📅 Schedule #" . ($scheduleIndex + 1) . ":\n";

                            $valueWithTax = getValue($scheduleItem, 'value_with_tax');
                            if ($valueWithTax !== null) {
                                echo "    💰 Price (with tax): " . $valueWithTax . " " . $currency . "\n";
                            }

                            $valueWithoutTax = getValue($scheduleItem, 'value_without_tax');
                            if ($valueWithoutTax !== null) {
                                echo "    💵 Price (without tax): " . $valueWithoutTax . " " . $currency . "\n";
                            }

                            $salePrice = getValue($scheduleItem, 'sale_price');
                            if ($salePrice !== null) {
                                echo "    🏷️ Sale Price: " . $salePrice . " " . $currency . "\n";
                            }

                            $saleStartDate = getValue($scheduleItem, 'sale_start_date');
                            if ($saleStartDate) {
                                echo "    📅 Sale Start: " . $saleStartDate . "\n";
                            }

                            $saleEndDate = getValue($scheduleItem, 'sale_end_date');
                            if ($saleEndDate) {
                                echo "    📅 Sale End: " . $saleEndDate . "\n";
                            }
                        }
                    }
                }
            }

            // Price limits
            $minPrice = getValue($offer, 'minimum_seller_allowed_price');
            if ($minPrice !== null) {
                $minPriceValue = is_array($minPrice)
                    ? getValue($minPrice[0], 'value', json_encode($minPrice))
                    : $minPrice;
                echo "📉 Min Allowed Price: {$minPriceValue} " . $currency . "\n";
            }

            $maxPrice = getValue($offer, 'maximum_seller_allowed_price');
            if ($maxPrice !== null) {
                $maxPriceValue = is_array($maxPrice)
                    ? getValue($maxPrice[0], 'value', json_encode($maxPrice))
                    : $maxPrice;
                echo "📈 Max Allowed Price: {$maxPriceValue} " . $currency . "\n";
            }

            echo "\n";
        }
    } else {
        echo "❌ No pricing information available for this SKU\n";
        echo "💡 This could mean:\n";
        echo "   - The product is not currently active for sale\n";
        echo "   - No pricing has been set for this seller\n";
        echo "   - The SKU belongs to a different seller\n";
        echo "   - The product is inactive or suppressed\n\n";
    }

    // Key product attributes
    if ($attributes) {
        echo "🔍 KEY PRODUCT ATTRIBUTES:\n";
        echo str_repeat("-", 40) . "\n";

        $keyAttributes = [
            'item_name' => '📖 Item Name',
            'brand' => '🏢 Brand',
            'condition_type' => '🔖 Condition',
            'merchant_suggested_asin' => '🏷️ Suggested ASIN'
        ];

        foreach ($keyAttributes as $attrKey => $label) {
            if (isset($attributes[$attrKey]) && is_array($attributes[$attrKey])) {
                $attrData = $attributes[$attrKey];
                if (count($attrData) > 0) {
                    $value = getValue($attrData[0], 'value', json_encode($attrData[0]));
                    echo "{$label}: {$value}\n";
                }
            }
        }
        echo "\n";
    }

    // Issues/problems information
    $issues = $listingItem->getIssues();
    if ($issues && count($issues) > 0) {
        echo "⚠️ DETECTED ISSUES:\n";
        echo str_repeat("-", 40) . "\n";

        foreach ($issues as $issue) {
            $code = $issue->getCode();
            $message = $issue->getMessage();
            $severity = $issue->getSeverity();

            $severityIcon = match($severity) {
                'ERROR' => '❌',
                'WARNING' => '⚠️',
                'INFO' => 'ℹ️',
                default => '❓'
            };

            echo "{$severityIcon} [{$severity}] {$code}: {$message}\n";
        }
        echo "\n";
    } else {
        echo "✅ No issues detected in the listing.\n\n";
    }

    echo str_repeat("=", 60) . "\n";
    echo "✅ Query completed successfully\n";

} catch (Exception $e) {
    echo "❌ Error: " . $e->getMessage() . "\n";
    echo "📁 File: " . $e->getFile() . " Line: " . $e->getLine() . "\n";
}