登录手机配件产品系统

请输入管理员提供的账号和密码。

Phone Parts Product System V1

标准化供应商价格表,并保留每一条已确认的成本记录。

产品 SKU-
供应商-
成本历史-
待审核-

ERP Control Tower

Real-Time Event Stream

ERP Health Score

Score-

Trend Charts

Supplier Intelligence

SupplierRequestsError RateAuto Fix RateAmbiguous

Model Health

TypeModel/InputCountConfidence

Master Data Locks

TypeCodeCNENQuality FamilyStatus

Control Functions

AI Settings

AI_AUTO_FILL locked
Exact is default. Compatibility expands only when selected.

产品 SKU 数据库

Quick Filters

按 SKU 最新 SZ/FCS 成本日期筛选
已选 0 只修改 SKU 主档,不直接修改成本历史。
未知别名:

建议匹配不会自动使用。请点击建议或手动选择正确的标准值,然后确认保存。

显示方式

Product Families

View only: grouped by Brand + Model + Part. Existing SKU and cost history are not changed.

Family CodeBrandModelPartShared Inventory GroupCompatible ModelsVariant CountApproved VariantsLatest Cost RangeLowest CostHighest CostPotential Family IDAction

最近录入与批次回退

默认按真实创建时间显示当前最新100条。请先筛选、检查和确认;“移入回收站”只停用SKU并保留成本及审计记录,可在回收站恢复为草稿。永久删除仍只在下方受控操作区处理。

已选 0 条
选择创建时间来源 / 批次SKU_ID品牌型号物料质量规格工厂状态关联记录风险操作
打开SKU管理后加载最新100条。

SKU Management

Safe SKU operations only. Duplicate detection, merge, archive, and strict delete require user action. Normal Product SKU pages do not delete records.

IdentitySKU CountSKU_ID / SKU CodeCost HistoryRecommended TargetAction
Open SKU Management to load duplicate report.

Safe SKU Actions

Load References first. Archive hides a SKU from normal search and keeps history. Strict delete is only allowed when no references exist.

Production Mode: Force Delete hidden.
Reference TypeCountDetail
Select a source SKU and load references.

Global Master Search

Search and read the explanations, aliases, and standard values maintained by the company.

SourceTypeBrandMatchedTarget / CodeCNENRemarkActiveLockedAction
Enter a keyword to search all Master data.

Master Data Management Console

Database is the source of truth. Excel is for backup, review, import/export, and audit. Smart Import, OCR, AI, and Quick Add cannot automatically create Master records.

Master Values

TypeBrandCodeCN LabelEN LabelLaunch YearGenerationRemarkERP Master CodeSortActiveLockedAliasesSKUCostAction

Model Master Optimization

Suggestion workflow only. The system scans possible non-standard Model_Master values, then you choose Merge, Create Alias Only, or Ignore. No model is changed automatically.

BrandCurrent ModelSuggested StandardConfidenceReasonSKUCostAliasSmart ImportStatusAction
Click Generate Suggestions to scan Model_Master.

Master Cleanup

Only Quality_Master and Specification_Master are scanned here. The report is read-only until you select SAFE TO DELETE rows and confirm deletion.

CategoryTypeCodeCNENSKUCostAliasSmart ImportQuick FilterRulesOtherReason / Recommendation
Click Generate Report to scan Quality_Master and Specification_Master.

Add Alias To Standard Value

Use this when supplier wording or daily wording should map to an official Master value. For Model Alias, choose Brand first. Example: SAMSUNG / A12 (2020) -> A12. The Master value itself is not renamed.

Alias Tables

TypeBrandAliasTarget CodeTarget CNTarget ENAction

Model Code Master

Code IDBrandBusiness ModelOfficial CodeNormalizedRegionNetworkStatusActiveRemarkAction

快捷筛选管理

这里控制产品SKU页面上方的快捷筛选按钮。只配置是否显示、分组、排序和按钮名称,不修改主数据编码。

类型Master Code中文名显示分组排序启用按钮名称操作

Change Log

TimeActionTypeCodeBrandOperatorOldNew

Business Notes

序列号越小越靠前(1、2、3……);未填写序列号的事项排在已编号事项后,并继续按优先级和更新时间排列。

Notes

序号PriorityCategoryTitleScopeFeeMOQNoteUpdatedStatusAction

导入供应商价格表

必需列:Brand、Model、Part 或 Parts、Quality,以及 Cost 或 Price。导入的数据会先进入审核暂存区,确认后才会保存到成本历史。

标准化审核

选择状态供应商 / 市场原始产品标准化产品Cost Date成本备注

Smart Import

Paste supplier text, or upload an image and use OCR to extract editable text first. OCR does not parse or import data automatically.

AI Assistant: OFF - Rule Only
高级功能(图片OCR)
Smart Table OCR result appears here.

Preview Rows

DeleteStatusSKU_IDBrandModelModel MatchPartQualitySpecificationFactoryProduct IdentifierMarketCostCost DateRemarksCost Date SourceSystem NoteRaw Line

AI Explanation

Click a parsed row to see why Smart Import inferred each field.

Quote Builder

Customer quotation preparation only. It does not create SKU records or supplier cost history.

Quotation Query Conditions

Brand and Model use Auto and are recognized per customer line. Part is required and supports multiple selections. Quality also supports multiple selections; for optional Quality, Specification, and Factory, blank means no restriction and shows all matching active variants.

AI Analysis

Paste customer request text and click Preview Quote.

Quote Preview

SelectOriginalStatusBrandModelPartQualitySpecificationFactoryQtyMatched SKUSZ CostSZ DateFCS CostFCS DateSZ-FCSProfitRemark

Post-Parse Batch Edit

Optional: modify already parsed rows. This does not change the quotation context above.

Quick Add Lite

Add 1-10 cost records quickly. Blank Cost Date uses today automatically.

Brand *Model *Part *Quality *SpecificationFactoryCost *Action

Profit Rule Validation

Rules are read only from Profit_Rule_Master.xlsx. The system never generates profit values.

RowPartCostSuggested ProfitRemark

供应商成本历史

仅追加已确认的成本记录。新导入永远不会覆盖旧成本。

确认时间产品供应商市场成本生效日期来源行号

Cost History

Correct Market, Factory, Supplier, Cost Date, or Cost. Every saved edit is retained in the audit history.

Actions

账号管理

ADMIN拥有全部功能;VIEWER可以查询、查看、下载及导出全部业务资料,但不能修改数据。

账号显示名称角色状态首次改密最后登录操作