Xiaofei Sun

Context. Cookbay needed one consistent view of products and inventory across several sales channels and five active stock locations.

What I did. I reconciled 207 master SKUs and 16 aliases, mapped conflicting item names, and recorded mismatches for review. I built a repeatable spreadsheet structure so product and stock changes could be checked against the master catalogue.

Deliverable. A SKU master, alias map, stock reconciliation log, and prioritised exception list. This is an example from my own business, not a claim of third-party client results.

Full case on Contra: https://www.twine.net/signin

Context. Product revenue alone did not show whether individual items or bundles made commercial sense after platform and fulfilment charges.

What I did. I built a worksheet to compare single-item and bundle economics using selling price, product cost, platform fees, fulfilment charges and other stated assumptions. The model highlights contribution margin and the sensitivity of results to fees and pricing choices.

Deliverable. A reusable margin and bundle-pricing worksheet with assumptions documented, so a seller can test alternatives before changing a listing. This work describes my own operation and does not imply a verified sales uplift.

Full case on Contra: https://www.twine.net/signin

Context. Fulfilment invoices and stock records were spread across different reports, making it hard to see whether charges and movements matched expectations.

What I did. I compared 3PL invoices with agreed fee schedules and recorded stock movements, categorised mismatches, and documented which items needed follow-up. I translated the findings into an exception register and review workflow that could be repeated each billing period.

Deliverable. An invoice and stock exception log with evidence references, issue categories and suggested next actions. This is an internal Cookbay operations example, not a regulated financial audit.

Full case on Contra: https://www.twine.net/signin