Skip to content

Tags

#ecommerce

Posts tagged #ecommerce on Dynamo Geeks: 4 posts from the community, most useful first.

4 posts

Posts tagged #ecommerce

  1. Question

    Daily sales report across timezones: which day does an order at 11:30pm Bangkok belong to?

    We store created_at as timestamptz. Until now all markets were UTC+8 (Singapore, Malaysia) so we just did: select (created_at at time zone 'Asia/Singapore')::date as day, sum(amount) from orders group by 1; Now we add Thailand (UTC+7). Order at 23:30 Bangkok time is 00:30 next day in Singapore. Thai team want it in their day, regional report want one number per day. Options: convert each order using its market…

    Lin Wei3likes3comments

  2. Experience

    Watching a customer with low vision use our checkout changed my priorities

    Last week we did usability sessions for the new checkout, and one participant, a retired teacher, uses her phone with the text size at maximum and display zoom on. I almost didn't include her because "she is not our typical user". I am very happy I did. In 20 minutes she couldn't finish the purchase. Things we saw: Our sticky "Pay now" bar at the bottom grew with the big text until it covered almost half of the…

    Mariana Costa4likes3comments

  3. Article

    Why finance and marketing never agree on revenue (checklist from 6 months of pain)

    Every month same meeting. Marketing dashboard say revenue X, finance report say Y, difference 4-8%, and data team (me) is asked to explain. After 6 months I made a checklist. Sharing in case it help someone. Where the numbers split Gross vs net. Marketing count order value at checkout. Finance count after cancellations, refunds and returns. Biggest gap is always this one. Which date. Order date, payment date,…

    Lin Wei4likes3comments

  4. Article

    We removed 4 fields from checkout. What we actually tested (and what failed)

    Some months ago my team got the classic request: "checkout conversion is low, make it better". Very clear, thank you. I want to share what we did, because the result was good but not for the reasons people think, and one of our ideas failed completely. Context: we are a mid size e-commerce in Brazil, home goods, and most of the traffic is mobile (around 80%). Checkout was one long page with 14 fields. First we make…

    Mariana Costa4likes4comments