Operations service 03

One-click BBD sync

One-click BBD (best-before date) sync lets HKTVmall merchants upload their current warehouse stock sheet. RAID matches products to HKTVmall SKUs by Barcode and lists the BBDs that need updating. Product data in the chosen store is updated only after your team reviews and confirms the change list.

Matches products to HKTVmall SKUs
Barcode
Creates the BBD change list
1 upload
Who it's for
HKTVmall merchants
Data handled
Current warehouse stock sheet
Confirmation
Updated after your team reviews the change list
Management layer
06 Warehouse batch and BBD data

Challenge

The warehouse records the BBD, but HKTVmall product pages often show an old date or none at all.

Staff have to open product pages one by one, check them against the 3PL warehouse list, then enter the dates. Once the SKU count grows, this is hard to sustain, and warehouse batch data drifts out of line with sales channel data.

Approach

Upload your current warehouse stock sheet and the system matches products to HKTVmall SKUs by Barcode, then lists the BBDs that need updating.

The system only reads the warehouse batch data and compares it with the HKTVmall product data from the latest sync in RAID; the page shows when that sync ran. Items that cannot be matched or have data issues are listed separately and are not suggested for update. Uploading, comparing and downloading the Excel file do not change HKTVmall data. Once you confirm, the system updates both the product's BBD field and the date in its title.

Process

  1. 01

    Upload stock sheet

    Upload your current warehouse stock sheet. There is no need to export HKTVmall data separately.

  2. 02

    Match results

    Products are matched to HKTVmall SKUs by Barcode, and the BBDs that need updating are listed.

  3. 03

    Review the change list

    Your team reviews the change list alongside its promotion strategy and ticks the items it trusts, one by one.

  4. 04

    Confirm the update

    Product data in the chosen store is updated only after a second confirmation.

  5. 05

    View results

    The update result for each SKU is listed item by item.

Results and limits

What RAID does

  • Matches products to HKTVmall SKUs by Barcode (rule-based matching, not AI guesswork)
  • Lists the BBDs that need updating in a change list
  • Updates only the items your team has ticked and confirmed
  • Shows the update result for each item

What RAID doesn't do

  • Uploading and comparing do not change HKTVmall data
  • Does not suggest updates for items that cannot be matched or have incomplete data
  • Does not clear stock or cut prices automatically based on dates