Product Matching

Prerequisites

• E-commerce platform stores have been authorized in the system (see Platform Authorization).
• At least one product SKU has been created and approved (see Product Management).

Objective

Establish a one-to-one mapping between platform SKUs (product codes on e-commerce platforms) and system SKUs (product codes in the OSL warehouse). Once matching is complete, synced platform orders will automatically match system SKUs, enabling smooth approval and outbound processing.

Entry: Left Navigation → System Settings → Product Matching

Matching Rules

• One match = one platform store + one platform SKU + one system SKU + one quantity.
• Under the same platform store, the same platform SKU can only be matched to one system SKU; duplicates are not allowed.
• Once a match is established, that SKU in platform orders will automatically map to the corresponding system SKU.

Add a Single Match

1. On the Product Matching list page, click the 「New」 button.
2. In the pop-up dialog, fill in the matching information:

Field	Required	Description
Platform Store	Yes	Select an authorized platform store from the dropdown (display format: store name (platform name)); platform type is auto-filled upon selection
Platform SKU	Yes	Enter the product SKU on the e-commerce platform, up to 50 characters
System SKU	Yes	Click the "Select Product" button to choose from the warehoused SKU list (single selection only)
Quantity	Yes	Matching quantity, default 1, range 1-99; platform SKU = system SKU × quantity

3. Click 「OK」 to submit; the match is created successfully.

Bulk Import Matches

Suitable for scenarios where a large number of SKU matches need to be created at once.

1. On the Product Matching list page, click the 「Import」 button.
2. In the pop-up import window, click 「Download Template」 to get the Excel import template.
3. Fill in the data according to the template format:
   • Each row corresponds to one match record.
   • Required columns: Platform Store, Platform SKU, System SKU, Quantity.
4. Upload the completed Excel file (only 1 file can be uploaded at a time).
5. The system automatically validates the data format:
   • Validation Passed: Import success is displayed; the matching list refreshes automatically.
   • Validation Failed: An error details pop-up appears, showing the specific reason for each failed record (e.g., "Platform SKU already exists", "System SKU does not exist"). Correct the issues based on the prompts and re-upload.

Match Management

• Search: Filter by platform SKU, system SKU, product name, platform store, or creation time.
• Export: Export selected records or all records.
• Delete: Delete individual records or batch delete selected matching records.

Tip: It is recommended to complete product matching immediately after authorizing a platform store. Otherwise, synced platform orders will not be able to automatically match system SKUs, and products will need to be manually added to orders.