Safe SKU operations only. Duplicate detection, merge, archive, and strict delete require user action. Normal Product SKU pages do not delete records.
Identity
SKU Count
SKU_ID / SKU Code
Cost History
Recommended Target
Action
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 Type
Count
Detail
Select a source SKU and load references.
Global Master Search
Search and read the explanations, aliases, and standard values maintained by the company.
Source
Type
Brand
Matched
Target / Code
CN
EN
Remark
Active
Locked
Action
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
Type
Brand
Code
CN Label
EN Label
Launch Year
Generation
Remark
ERP Master Code
Sort
Active
Locked
Aliases
SKU
Cost
Action
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.
Brand
Current Model
Suggested Standard
Confidence
Reason
SKU
Cost
Alias
Smart Import
Status
Action
Click Generate Suggestions to scan Model_Master.
Model Business Rules
Backend compatibility rules applied after Brand and Model recognition and before SKU matching. Rules only choose an existing Model_Master for a specific Part; they never create, rename, merge, or delete Master data.
Type
Brand
Part
Source Models
Target Model
Status
Priority
Remark
Applied
Last Applied
Action
Open Model_Master to load business rules.
Test Rule
Applied Model Business Rule Log
Time
Module
Rule
Brand
Part
Original Model
Final Model
No application log loaded.
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.
Category
Type
Code
CN
EN
SKU
Cost
Alias
Smart Import
Quick Filter
Rules
Other
Reason / 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.
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
Delete
Status
SKU_ID
Brand
Model
Model Match
Part
Quality
Specification
Factory
Product Identifier
Market
Cost
Cost Date
Remarks
Cost Date Source
System Note
Raw 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
Select
Original
Status
Brand
Model
Part
Quality
Specification
Factory
Qty
Matched SKU
SZ Cost
SZ Date
FCS Cost
FCS Date
SZ-FCS
Profit
Remark
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 *
Specification
Factory
Cost *
Action
Profit Rule Validation
Rules are read only from Profit_Rule_Master.xlsx. The system never generates profit values.
Row
Part
Cost
Suggested Profit
Remark
供应商成本历史
仅追加已确认的成本记录。新导入永远不会覆盖旧成本。
确认时间
产品
供应商
市场
成本
生效日期
来源行号
Cost History
Correct Market, Factory, Supplier, Cost Date, or Cost. Every saved edit is retained in the audit history.
Actions
账号管理
ADMIN拥有全部功能;VIEWER可以查询、查看、下载及导出全部业务资料,但不能修改数据。
账号
显示名称
角色
状态
首次改密
最后登录
操作
编辑账号信息
修改登录账号后,用户下次登录需使用新账号;密码和现有角色不会改变。
Edit Cost History
Edit SKU
Only this Edit SKU window can remove identifiers. Smart Import, Quick Add, Excel import, and batch append keep existing identifiers and only add non-duplicates.