Tiktok Inbound Tracking Upload

TikTok Inbound Tracking Upload

Process the local tracking workbook and upload verified child-package tracking numbers to TikTok Shipping. Treat correctness as more important than speed.

Required tools and inputs

• Use chrome:control-chrome for all TikTok, UPS, and FedEx browser interactions. Reuse the user's logged-in Chrome session.
• Use the spreadsheet skill and its required runtime to read the workbook. Re-read the workbook immediately before making changes in TikTok.
• Default workbook: /Users/luobo/Documents/tracking/tracking nummber upload/trackingnumber-tiktok.xlsx.
• TikTok inbound page: https://scm-us.tiktok.com/stockin/replenish?op_region=US.
• UPS tracking page: https://www.ups.com/track?loc=en_US&requester=ST/.
• Use the existing FedEx tracking page or the official FedEx tracking UI.

Non-negotiable safety rules

1. Treat every tracking number from the workbook as a master tracking number used only to look up the shipment.
2. Before entering anything in TikTok, open All Packages in this Shipment on the carrier site and collect every child tracking number.
3. Read every carrier pagination page. Never stop after the first page.
4. Count the child tracking numbers and the TikTok cartons for the matching shipment. They must be equal. Read the carton count only from that IBR's Shipment tracking detail, never from the inbound-list Split shipment(x/y) label.
5. Never repeat a master tracking number across multiple cartons. A repeated value is allowed only when the carrier explicitly shows one package and TikTok has one carton.
6. Stop before submitting if the IBR number, shipment ID, carrier, package count, carton count, or tracking-number format conflicts.
7. Do not infer or invent missing child tracking numbers. Report the mismatch to the user.
8. Confirm the workbook has not changed since it was read before beginning submission. If the user says it changed, stop and re-read it.

Workflow

1. Read and normalize the workbook

• Read all populated rows.
• Preserve IBR and tracking identifiers as text.
• Normalize carrier values case-insensitively to UPS or FedEx.
• Build a working map of IBR -> master tracking number -> carrier.
• Report malformed rows before browser submission.

2. Locate the TikTok shipments

• Open TikTok Shipping and navigate to Inbound.
• Search each IBR order number from the workbook.
• Open the exact IBR link to its detail page, then select Shipment tracking.
• Record the explicit N Cartons label and every carton ID in the tracking table. These are the authoritative carton count and display order.
• Do not use Split shipment(x/y), planned units, SKU count, carton-label count from another IBR, or the workbook's auxiliary columns as a carton count. Split shipment(x/y) identifies a part of a combined inbound plan, not the carton count for that IBR.
• If Add tracking info opens a combined-plan form with multiple shipment tabs, select the tab whose IBR matches the workbook row and confirm the page heading and carton IDs before filling it.
• Match the IBR/order row to the exact TikTok shipment ID. Do not rely only on visual position.

3. Expand carrier child packages

For UPS:

• Track the workbook master number.
• Expand All Packages in this Shipment.
• Capture the master number and every child number shown.
• Use Next until the final pagination page is reached.
• Deduplicate without changing carrier display order.

For FedEx:

• Track the workbook master number.
• Open the equivalent multi-package or shipment-package view when present.
• Capture every package tracking number across all pages or expanded sections.
• If no multi-package control exists, verify the shipment indicates a single package before treating the master number as the only tracking number.

4. Reconcile before writing

For each shipment, verify:

• Workbook carrier equals carrier site.
• TikTok shipment ID belongs to the correct IBR.
• Carrier child-package count equals the N Cartons count and carton-row count from that IBR's Shipment tracking tab.
• Tracking numbers are unique within the shipment unless the carrier itself shows otherwise.

If any check fails, do not modify or submit that shipment. Report the exact IBR, expected carton count, observed package count, and carrier page result.

5. Enter tracking numbers

• Select the carrier and use Apply to all only for the carrier field.
• Assign child tracking numbers to TikTok cartons in carrier display order and TikTok carton display order.
• Enter one distinct child tracking number per carton.
• Before clicking Submit, read back every carrier and tracking field and compare it with the reconciled map.
• Click Submit only after the comparison passes. Some combined-plan forms discard unsaved fields when switching shipment tabs, so submit and verify one shipment before selecting the next tab.

6. Verify persistence

• Wait for the shipment to show Tracking info added.
• Re-open or re-read the shipment fields.
• Confirm every carton retained its intended carrier and child tracking number.
• Verify all processed shipments after the final submission.
• If a shipment already shows tracking information, compare its existing carton-level carrier and tracking numbers with the reconciled map. Leave it unchanged when they match; use the correction workflow only when a change is required.

Corrections

When correcting previously submitted data:

• Rebuild the carrier child-number list from the live carrier page.
• Confirm the count again.
• Replace each TikTok carton field individually.
• Submit and re-read all fields to prove the correction persisted.

Completion report

Report one line per IBR or shipment with:

• carrier;
• TikTok carton count;
• carrier child-package count;
• submission or correction status.

Explicitly identify any skipped or mismatched shipment. Keep the final TikTok tracking page open for the user.