Before doing any data project, must align with business users on entity definitions/conceptual design and metrics
- Apply for both [[Add2Cart]] and [[Internal]]
DONE Review S3 directory structure
Project: [[Add2Cart]] Priority: #P1
- 1P vs 3P semantics: Shopee Supermarket (1P) vs marketplace sellers (3P). We need a flag (
retailer_kind) to separate them for analytics.- Do we actually need that flag? -> Ask Simon
- Promo provenance & stacking: Distinguish platform-funded vs seller-funded components (voucher, coins, shipping). This affects “current price” calculations and must be modeled, not inferred.
- Country scoping: Shopee operates per country. Decide if
platform_idis global with acountryattribute, or country-scoped IDs - In the backend I see there’s Platform, but on the mock dashboards I dont see it. Is it some intention behind hiding the platform?
- The barcode is used to match the same product across different platforms, of course, within the same retailer.
- Barcode vs. retailer code
- One app: one product and it shows different price per different retailers
- Simon knows his responsibility and how to move things forward. I’d better the same as him.
- I think he’s a person I can learn more from, not only add2cart.
- 1P vs 3P semantics: Shopee Supermarket (1P) vs marketplace sellers (3P). We need a flag (
DONE Reply Natalia Jay
Project: [[Personal]] Priority: #P2
/ 2025-11-18
Created Tue, 18 Nov 2025 00:00:00 +0000
Modified Mon, 25 May 2026 06:02:25 +0000