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 bindings between platform SKUs (product management numbers on e-commerce platforms) and system SKUs (product codes in the OSL warehouse). Once matching is complete, the system will automatically match the corresponding system SKUs and shipping quantities when platform orders are synced, ensuring smooth approval and outbound processing.
Entry: Left Navigation → System Settings → Product Matching
Glossary
| Term | Description |
|---|---|
| Platform Store | The store name entered during Platform Authorization |
| Platform SKU | The product identifier in the store backend; the retrieved information differs by platform, see below for details |
| System SKU | The product code created in Product Management, representing the product actually shipped by the warehouse; only system SKUs in "Approved" status can be used to create matches |
Platform SKU sources by platform:
- Amazon Japan: The SKU in the product information.
- Yahoo!ショッピング: The SKU management number in the product information; if it contains a SubCode, the SubCode is used as the platform SKU, otherwise the ItemId is used.
- 楽天市場: If the product information contains a システム連携用SKU番号, it is used as the platform SKU; otherwise, the 商品番号 is used.
- Qoo10 Japan: The SKU management number in the product information.
Matching Rules
- Matches are established per "platform store + platform SKU", and combo or bundle products are supported.
- One platform SKU can be bound to multiple system SKUs, each with its own quantity, suitable for combo or bundle products.
- One system SKU can also be matched to platform SKUs across multiple platform stores, suitable for scenarios where the same product is sold on multiple platforms.
- Under the same platform store, only one match can be created for the same platform SKU; duplicates are not allowed.
- Once a match is established, the platform SKU will automatically map to its bound system SKUs and quantities when platform orders are synced.
Matching Quantity Explanation
The "Quantity" in a match refers to the number of system SKUs the overseas warehouse needs to ship when a buyer purchases 1 platform SKU, not the inventory quantity.
- Quantity 1: For 1 platform SKU in a store order, the overseas warehouse ships 1 system SKU.
- Quantity 2: For 1 platform SKU in a store order, the overseas warehouse ships 2 system SKUs, and so on.
Common Matching Scenarios
| Scenario | Matching Method | Example |
|---|---|---|
| One-to-one | 1 platform SKU bound to 1 system SKU, quantity 1 | Platform SKU-A → System SKU-A × 1 |
| One-to-many (multiple items) | 1 platform SKU bound to 1 system SKU, quantity greater than 1 | Platform SKU-B → System SKU-B × 3 |
| Combo / Bundle | 1 platform SKU bound to multiple different system SKUs, each with its own quantity | Platform SKU-C → SKU-a × 1, SKU-b × 1, SKU-c × 1 |
Add a Single Match
- On the Product Matching list page, click the 「New」 button.
- 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 "Batch Select" button to multi-select from the warehoused SKU list; multiple rows can be added, one system SKU per row |
| Quantity | Yes | Matching quantity for each system SKU, range 1-9999; see Matching Quantity Explanation |
- To remove a selected system SKU, click the 「Remove」 button on the corresponding row.
- 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.
- On the Product Matching list page, click the 「Import」 button.
- In the pop-up import window, click 「Download Template」 to get the Excel import template.
- Fill in the data according to the template format:
- Each row corresponds to one system SKU binding; required columns: Platform Store, Platform SKU, System SKU, Quantity.
- When multiple rows with the same platform store + platform SKU are filled in, the system will automatically merge them into one match, binding multiple system SKUs to that platform SKU.
- Upload the completed Excel file (only 1 file can be uploaded at a time).
- 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.
Filter Rules
If you do not want certain platform products to generate OMS orders and be shipped, you can exclude them through filter rules. Rules are configured per "platform store + platform SKU"; products matching a rule will not participate in OMS order generation or subsequent outbound processing.
Filter rules apply to both platform orders automatically pulled via API and orders manually imported using the Import by Platform Store Format method in dropship requests.
- On the Product Matching list page, click the 「Filter Rules」 button to open the filter rules window.
- Click 「Add Filter Rule」 to add a new rule:
| Field | Required | Description |
|---|---|---|
| Platform Store | Yes | Select the platform store to filter from the dropdown |
| Platform SKU | Yes | Enter the platform SKU to filter |
- Click the 「Remove」 button on a rule row to delete the corresponding rule.
- Click 「OK」 to save; the filter rules take effect immediately. In subsequently synced platform orders, platform SKUs matching a rule will be automatically filtered out, and no OMS orders or subsequent outbound processing will be generated for them.
Note:
- Platform SKUs are case-sensitive, and leading/trailing spaces are ignored during matching.
- Products matching a rule will not participate in OMS order generation or subsequent outbound processing. Please configure with caution.
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:
- After a match is created, new system SKUs cannot be added to that platform SKU; to change system SKUs or quantities, please delete the match and create a new one.
- 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.