Saas-voc/tools/jd-import-products.mjs

#!/usr/bin/env node

import crypto from 'node:crypto';

const args = new Set(process.argv.slice(2));
const valueArg = (name, fallback = '') => {
  const prefix = `${name}=`;
  const inline = process.argv.find((value) => value.startsWith(prefix));
  if (inline) return inline.slice(prefix.length);
  const index = process.argv.indexOf(name);
  return index >= 0 ? process.argv[index + 1] || fallback : fallback;
};

const config = {
  sourceParseUrl: process.env.JD_SOURCE_PARSE_URL || 'https://server.fmode.cn/parse',
  sourceParseAppId: process.env.JD_SOURCE_PARSE_APP_ID || '',
  sourceParseMasterKey: process.env.JD_SOURCE_PARSE_MASTER_KEY || '',
  targetParseUrl: process.env.JD_TARGET_PARSE_URL || '',
  targetParseAppId: process.env.JD_TARGET_PARSE_APP_ID || '',
  targetParseMasterKey: process.env.JD_TARGET_PARSE_MASTER_KEY || '',
  jdAppKey: process.env.JD_APP_KEY || '',
  jdAppSecret: process.env.JD_APP_SECRET || '',
  limit: Math.min(20, Math.max(1, Number(valueArg('--limit', '10')) || 10)),
  timeoutMs: Number(process.env.JD_IMPORT_TIMEOUT_MS || 30000),
};

const dryRun = args.has('--dry-run');

function requireConfig(keys) {
  const missing = keys.filter((key) => !config[key]);
  if (missing.length) throw new Error(`缺少环境变量: ${missing.join(', ')}`);
}

function cleanBaseUrl(value) {
  return String(value || '').replace(/\/+$/, '');
}

function parseHeaders(appId, masterKey) {
  return {
    'X-Parse-Application-Id': appId,
    'X-Parse-Master-Key': masterKey,
  };
}

async function requestJson(url, init = {}) {
  const controller = new AbortController();
  const timer = setTimeout(() => controller.abort(), config.timeoutMs);
  try {
    const response = await fetch(url, { ...init, signal: controller.signal });
    const text = await response.text();
    let body;
    try {
      body = text ? JSON.parse(text) : null;
    } catch {
      body = { raw: text.slice(0, 500) };
    }
    if (!response.ok) {
      const detail = body?.error || body?.message || body?.errorList?.[0]?.message || response.statusText;
      throw new Error(`HTTP ${response.status} ${url}: ${detail}`);
    }
    return body;
  } finally {
    clearTimeout(timer);
  }
}

function parseQueryUrl(baseUrl, className, where, extra = {}) {
  const params = new URLSearchParams(extra);
  if (where && Object.keys(where).length) params.set('where', JSON.stringify(where));
  return `${cleanBaseUrl(baseUrl)}/classes/${encodeURIComponent(className)}?${params}`;
}

async function parseFind(parseConfig, className, where, extra = {}) {
  const body = await requestJson(parseQueryUrl(parseConfig.url, className, where, extra), {
    headers: parseHeaders(parseConfig.appId, parseConfig.masterKey),
  });
  return body?.results || [];
}

async function parseUpsert(parseConfig, className, data, uniqueKey) {
  const existing = await parseFind(parseConfig, className, { [uniqueKey]: data[uniqueKey] }, { limit: '1' });
  const headers = { ...parseHeaders(parseConfig.appId, parseConfig.masterKey), 'Content-Type': 'application/json' };
  if (existing[0]?.objectId) {
    return requestJson(`${cleanBaseUrl(parseConfig.url)}/classes/${encodeURIComponent(className)}/${existing[0].objectId}`, {
      method: 'PUT',
      headers,
      body: JSON.stringify(data),
    });
  }
  return requestJson(`${cleanBaseUrl(parseConfig.url)}/classes/${encodeURIComponent(className)}`, {
    method: 'POST',
    headers,
    body: JSON.stringify(data),
  });
}

function jdSignature(params) {
  const plain = Object.keys(params)
    .sort()
    .map((key) => `${key}${params[key] ?? ''}`)
    .join('');
  return crypto.createHash('md5')
    .update(`${config.jdAppSecret}${plain}${config.jdAppSecret}`)
    .digest('hex')
    .toUpperCase();
}

function jdQuery(params) {
  const query = new URLSearchParams();
  for (const [key, value] of Object.entries(params)) {
    query.set(key, Array.isArray(value) ? JSON.stringify(value) : String(value));
  }
  return query;
}

function pickFirst(...values) {
  return values.find((value) => value !== undefined && value !== null && String(value).trim() !== '') ?? '';
}

function stringValue(value) {
  return value === undefined || value === null ? '' : String(value);
}

function flattenText(value) {
  if (!value) return '';
  if (typeof value === 'string' || typeof value === 'number') return String(value);
  if (Array.isArray(value)) return value.map(flattenText).filter(Boolean).join(' ');
  if (typeof value === 'object') return Object.values(value).map(flattenText).filter(Boolean).join(' ');
  return '';
}

function extractId(row, ...keys) {
  return stringValue(pickFirst(...keys.map((key) => row?.[key])));
}

function extractImage(row) {
  return stringValue(pickFirst(
    row?.imageUrl,
    row?.imgUrl,
    row?.logo,
    row?.productFrontDetailDTO?.imageUrl,
    row?.productFrontDetailDTO?.logo,
    row?.productFrontDetailDTO?.image,
  ));
}

function extractBrand(row) {
  return stringValue(pickFirst(
    row?.brand,
    row?.brandName,
    row?.brandDTO?.brandName,
    row?.brandDTO?.name,
    row?.brandDTO?.brandCnName,
  ));
}

function extractCategories(row) {
  const source = row?.categoryDTO || row?.category || {};
  const values = [
    source.category1Name, source.category2Name, source.category3Name,
    source.firstCategoryName, source.secondCategoryName, source.thirdCategoryName,
    source.name1, source.name2, source.name3,
  ].filter(Boolean).map(String);
  if (values.length) return [...new Set(values)];
  if (Array.isArray(source)) return source.map(flattenText).filter(Boolean);
  return [];
}

function extractPrice(row) {
  const price = row?.priceDTO || row?.price || {};
  const value = pickFirst(price.jdPrice, price.price, price.salePrice, row?.jdPrice, row?.price);
  const number = Number(value);
  return Number.isFinite(number) ? number : null;
}

function extractProductId(row) {
  return extractId(row, 'productId', 'wareId', 'id');
}

function extractSkuId(row) {
  return extractId(row, 'skuId', 'id');
}

function normalizeProduct(row, detail, shopId, collectedAt) {
  const productId = extractProductId(row) || extractProductId(detail?.productInfo || detail?.data || {});
  const info = detail?.productInfo || detail?.data || {};
  const title = stringValue(pickFirst(row?.productName, info?.productTitle?.title, info?.productName));
  const rowCategories = extractCategories(row);
  const categories = rowCategories.length ? rowCategories : extractCategories(info);
  const imageUrl = extractImage(row) || extractImage(info);
  const detailPayload = detail && Object.keys(detail).length ? detail : null;
  const businessKey = `jd:${shopId}:${productId}`;
  return {
    platform: 'jd',
    source: 'jd-sp-api',
    role: 'own',
    shopId: String(shopId),
    sellerId: String(shopId),
    productId,
    productKey: businessKey,
    jdProductKey: businessKey,
    asin: productId,
    title,
    itemName: title,
    brand: extractBrand(row) || extractBrand(info),
    category: categories.join(' / '),
    category1: categories[0] || '',
    category2: categories[1] || '',
    category3: categories[2] || '',
    imageUrl,
    images: imageUrl ? [imageUrl] : [],
    price: extractPrice(row) ?? extractPrice(info),
    itemStatus: pickFirst(row?.productStatus, row?.productStatusNew, info?.productStatus, null),
    detailStatus: detailPayload ? 'available' : 'empty',
    rawJdProduct: row,
    rawJdDetail: detailPayload,
    syncedAt: collectedAt,
    collectedAt,
  };
}

async function jdGet(path, query, token, pathParams = {}) {
  const timestamp = String(Date.now());
  const headers = {
    'X-JOS-App-Key': config.jdAppKey,
    'X-JOS-Access-Token': token,
    'X-JOS-Timestamp': timestamp,
    'X-JOS-Sign-Method': 'md5',
    'X-JOS-Request-Identity': 'vender',
  };
  headers['X-JOS-Sign'] = jdSignature({
    ...query,
    ...pathParams,
    'X-JOS-App-Key': config.jdAppKey,
    'X-JOS-Access-Token': token,
    'X-JOS-Timestamp': timestamp,
  });
  const encoded = jdQuery(query).toString();
  const body = await requestJson(`https://api-cn.jd.com/rest${path}${encoded ? `?${encoded}` : ''}`, { headers });
  if (body?.success === false) {
    const error = body.errorList?.[0] || {};
    throw new Error(`京东接口失败 ${error.code || ''}: ${error.message || error.details || 'unknown error'}`);
  }
  return body;
}

async function loadAuthorization() {
  const rows = await parseFind(
    { url: config.sourceParseUrl, appId: config.sourceParseAppId, masterKey: config.sourceParseMasterKey },
    'EcomAuth',
    { platform: 'jd', type: 'access_token' },
    { limit: '1', order: '-createdAt' },
  );
  const row = rows[0];
  const token = row?.data?.access_token;
  const shopId = stringValue(pickFirst(row?.shop_id, row?.data?.uid));
  if (!token || !shopId) throw new Error('主 Parse 中没有可用的京东授权记录');
  return { token, shopId };
}

async function loadBatch(auth) {
  const productsResponse = await jdGet('/sp-product/v0/products', {
    scopeSet: 'productName',
    pageSize: config.limit,
    page: 1,
  }, auth.token);
  const products = productsResponse.data || [];
  const collectedAt = new Date().toISOString();
  const batch = [];
  for (const row of products) {
    const productId = extractProductId(row);
    if (!productId) continue;
    let skus = [];
    try {
      const skuResponse = await jdGet('/sp-product/v0/skus', {
        scopeSet: 'skuName',
        productIdList: productId,
        pageSize: 50,
        page: 1,
      }, auth.token);
      skus = skuResponse.data || [];
    } catch (error) {
      console.warn(`[jd-import] SKU 查询跳过 ${productId}: ${error.message}`);
    }
    const stocks = [];
    for (const sku of skus) {
      const skuId = extractSkuId(sku);
      if (!skuId) continue;
      try {
        const stockResponse = await jdGet('/sp-product/v0/sku-stocks', { skuIdList: skuId }, auth.token);
        stocks.push(...(stockResponse.data || []));
      } catch (error) {
        console.warn(`[jd-import] 库存查询跳过 ${skuId}: ${error.message}`);
      }
    }
    let detail = null;
    try {
      const detailResponse = await jdGet(`/sp-product/v0/products/${productId}`, { scene: 'pop' }, auth.token);
      detail = detailResponse?.data || detailResponse || null;
    } catch (error) {
      console.warn(`[jd-import] 详情查询跳过 ${productId}: ${error.message}`);
    }
    batch.push({ row, detail, skus, stocks, collectedAt });
  }
  return { ...auth, products: batch, total: productsResponse.paginationData?.totalItems ?? null };
}

function buildRecords(batch) {
  const productDetails = [];
  const products = [];
  const mappings = [];
  const stockSnapshots = [];
  for (const item of batch.products) {
    const product = normalizeProduct(item.row, item.detail, batch.shopId, item.collectedAt);
    productDetails.push(product);
    products.push({
      ...product,
      priceAmount: product.price,
      currency: 'CNY',
      productSource: 'jd-sp-api',
      raw: product.rawJdProduct,
    });
    for (const sku of item.skus) {
      const skuId = extractSkuId(sku);
      if (!skuId) continue;
      const mappingKey = `jd:${batch.shopId}:${skuId}`;
      mappings.push({
        platform: 'jd',
        source: 'jd-sp-api',
        asin: product.productId,
        jdProductId: product.productId,
        jdSkuId: skuId,
        sellerSku: skuId,
        productSku: skuId,
        itemName: stringValue(sku.skuName),
        brand: extractBrand(sku),
        price: extractPrice(sku),
        listingPrice: extractPrice(sku),
        itemStatus: pickFirst(sku.skuStatus, sku.valid, null),
        site: 'jd',
        shopId: batch.shopId,
        jdSkuKey: mappingKey,
        rawJdSku: sku,
        syncedAt: item.collectedAt,
      });
    }
    for (const stock of item.stocks) {
      const skuId = extractSkuId(stock);
      if (!skuId) continue;
      stockSnapshots.push({
        platform: 'jd',
        source: 'jd-sp-api',
        shopId: batch.shopId,
        productId: product.productId,
        skuId,
        stockKey: `jd:${batch.shopId}:${skuId}:${item.collectedAt.slice(0, 10)}`,
        stockNum: Number(stock.stockNum ?? 0),
        orderBookingNum: Number(stock.orderBookingNum ?? 0),
        unpaidBookingNum: Number(stock.unpaidBookingNum ?? 0),
        reserveNum: Number(stock.reserveNum ?? 0),
        warehouseId: stringValue(stock.warehouseId),
        rawJdStock: stock,
        collectedAt: item.collectedAt,
      });
    }
  }
  return { productDetails, products, mappings, stockSnapshots };
}

async function main() {
  requireConfig(['sourceParseAppId', 'sourceParseMasterKey', 'jdAppKey', 'jdAppSecret']);
  if (!dryRun) requireConfig(['targetParseUrl', 'targetParseAppId', 'targetParseMasterKey']);
  const auth = await loadAuthorization();
  const batch = await loadBatch(auth);
  const records = buildRecords(batch);
  const summary = {
    shopId: batch.shopId,
    totalProducts: batch.total,
    products: records.productDetails.length,
    skuMappings: records.mappings.length,
    stockSnapshots: records.stockSnapshots.length,
    detailAvailable: records.productDetails.filter((row) => row.detailStatus === 'available').length,
    productIds: records.productDetails.map((row) => row.productId),
  };
  if (dryRun) {
    console.log(JSON.stringify({ mode: 'dry-run', ...summary }, null, 2));
    return;
  }
  const target = {
    url: config.targetParseUrl,
    appId: config.targetParseAppId,
    masterKey: config.targetParseMasterKey,
  };
  for (const row of records.productDetails) await parseUpsert(target, 'ProductDetail', row, 'jdProductKey');
  for (const row of records.products) await parseUpsert(target, 'Product', row, 'jdProductKey');
  for (const row of records.mappings) await parseUpsert(target, 'AsinSkuMapping', row, 'jdSkuKey');
  for (const row of records.stockSnapshots) await parseUpsert(target, 'JdStockSnapshot', row, 'stockKey');
  console.log(JSON.stringify({ mode: 'imported', ...summary }, null, 2));
}

main().catch((error) => {
  console.error(`[jd-import] ${error.message}`);
  process.exitCode = 1;
});