oms/backend/test/app/lib/dgjOrderSkuCode.test.js
liufumingren 20147fb391 fix(shop-product): 1688 单靠店管家规格编码匹配店铺商品
1688(Alibaba)订单的 SubOrders[].SkuId 被店管家塞成了商品标题,
平台规格ID 这条路永远匹配不到店铺商品(旧系统 Dianguanjia.php 的 get_sku_bind
只按 SkuId 严格等值,同样匹配不上)。规格的真实唯一键是店管家规格编码:
商品库 Skus[].SkuCode(如 10000446302877)= 订单 PtProductInfo.SkuCode,
抖店/拼多多的 SubOrders[].SkuCode 也是这个值,跨平台通用。

- shop_products 增列 outer_sku_code(迁移 20261109100000),商品同步时写入
  Skus[].SkuCode,并加入 upsert 字段
- 订单明细归一化增补 outer_sku_code(PtProductInfo.SkuCode 优先,退 SkuCode),
  随 platform_snapshot 落库;历史明细由 resolveItemSkuCode 回落到 raw.PtProductInfo.SkuCode
- 匹配口径改为「平台规格ID → 店管家规格编码 → (仅当完全无规格信息)商品ID 兜底」,
  带了规格信息却都没命中时不退化成按商品ID取一条,避免绑错规格
- 拉单逐条匹配、明细解析、商品同步后批量重匹配三处共用 shopProductScopes/createShopProductMatcher
- 实测店铺 19 同步 1438 行后 rematched=44,1688 明细全部指向正确规格
  (10000446302877→420ml*1瓶+排骨梳、…878→99ML黑色、…881→420ML)

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-11-08 18:01:24 +08:00

84 lines
3.3 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

'use strict';
const { assert } = require('egg-mock/bootstrap');
const DgjService = require('../../../app/lib/printPlatform/dgj');
/**
* 店管家订单明细的规格键。
*
* 1688(Alibaba)订单的 `SkuId` 被平台塞成**商品标题**,规格的真实唯一键只剩
* `PtProductInfo.SkuCode`(商品库 `Skus[].SkuCode` 是同一个值);抖店/拼多多则
* `SubOrders[].SkuCode` 本身就是这个编码,规格ID 也是真 ID,两边不能混。
*/
describe('dgj.normalizeOrderItem 规格键口径', () => {
const service = new DgjService({ platform: { code: 'dgj', name: '店管家' }, account: { token: 't', cookie: 'c' } });
it('1688 明细:SkuId 是标题时规格ID 留空,规格编码取 PtProductInfo.SkuCode', () => {
const item = service.normalizeOrderItem({
OrderItemId: '10000311832500',
ProductID: '881526926136',
ProductSubject: '定型喷雾蓬松持久空气刘海发廊同款高颅顶99ML+420ML大小容量组合',
SkuId: '定型喷雾蓬松持久空气刘海发廊同款高颅顶99ML+420ML大小容量组合',
SkuCode: '007+111',
CargoNumber: '007+111',
productCargoNumber: '007',
Color: '420ml*1瓶+排骨梳',
Count: 1,
PtProductInfo: {
PrductId: '881526926136',
SkuCode: '10000446302877',
SpuCode: '007',
CargoNumber: '007+111',
},
});
assert.strictEqual(item.outer_item_id, '881526926136');
assert.strictEqual(item.outer_sku_id, '', '标题不是平台规格ID,不能当成规格ID 落库');
assert.strictEqual(item.outer_sku_code, '10000446302877');
assert.strictEqual(item.sku_code, '007+111', '商家编码口径不变');
});
it('1688 明细:SkuId 是商家编码(006-1)时规格编码仍取 PtProductInfo.SkuCode', () => {
const item = service.normalizeOrderItem({
ProductID: '881526926136',
SkuId: '006-1',
SkuCode: '006-1',
CargoNumber: '006-1',
PtProductInfo: { SkuCode: '10000446302878', SpuCode: '007' },
});
assert.strictEqual(item.outer_sku_id, '006-1');
assert.strictEqual(item.outer_sku_code, '10000446302878');
});
it('抖店明细:规格ID 是真 ID,规格编码取 PtProductInfo.SkuCode(与商品库 Skus[].SkuCode 同值)', () => {
const item = service.normalizeOrderItem({
ProductID: '3773823319627923739',
SkuId: '3548726733104386',
SkuCode: '5cf84d471b5d992b',
CargoNumber: 'wf-C05速干定型喷雾420*1',
PtProductInfo: { SkuCode: '5cf84d471b5d992b' },
});
assert.strictEqual(item.outer_sku_id, '3548726733104386');
assert.strictEqual(item.outer_sku_code, '5cf84d471b5d992b');
});
it('商品库规格里带上 SkuCode(店铺商品第二匹配键)', () => {
const rows = service.normalizeProduct({
PlatformId: '881526926136',
ShopId: 7398588,
Subject: '定型喷雾蓬松持久空气刘海发廊同款高颅顶99ML+420ML大小容量组合',
Status: 'published',
Skus: [
{ SkuId: '5937045124144', SkuCode: '10000446302877', CargoNumber: '007+111', Name: '420ml*1瓶+排骨梳' },
],
});
assert.strictEqual(rows.length, 1);
assert.strictEqual(rows[0].outer_sku_id, '5937045124144');
assert.strictEqual(rows[0].outer_sku_code, '10000446302877');
assert.strictEqual(rows[0].outer_code, '007+111');
});
});