DEV Community

SEO - NT Tech Innovation
SEO - NT Tech Innovation

Posted on

Bangladesh Time (UTC+6) Order Reports for a Small SMM Reseller, with Node.js

Running a small SMM reseller shop from Bangladesh? Your customers message at night, orders pile up, and in the morning you're trying to remember who ordered what. Here's a tiny Node.js script that builds a daily order summary in Bangladesh time from a CSV log. No database needed.

The log

Keep one CSV line per order, written the moment your supplier returns an order ID:

created_at_utc,order_id,customer,service,qty,charged_bdt,status
2026-11-10T18:42:00Z,90311,Rahim,FB page followers BD,1000,420,completed
2026-11-10T21:05:00Z,90328,Sadia,IG Reel views,10000,150,in_progress
2026-11-11T03:15:00Z,90337,Tanvir,YT likes,500,90,pending
Enter fullscreen mode Exit fullscreen mode

The script

import { readFileSync } from "node:fs";

const BD_OFFSET_MIN = 6 * 60; // Bangladesh Standard Time, UTC+6, no DST

const toBdDate = iso => {
  const d = new Date(new Date(iso).getTime() + BD_OFFSET_MIN * 60000);
  return d.toISOString().slice(0, 10);
};

const rows = readFileSync("orders.csv", "utf8").trim().split("\n").slice(1).map(l => {
  const [created, id, customer, service, qty, charged, status] = l.split(",");
  return { day: toBdDate(created), id, customer, service, qty: +qty, charged: +charged, status };
});

const byDay = {};
for (const r of rows) (byDay[r.day] ??= []).push(r);

for (const [day, list] of Object.entries(byDay).sort()) {
  const total = list.reduce((s, r) => s + r.charged, 0);
  const open = list.filter(r => r.status !== "completed").length;
  console.log(`${day}  orders: ${list.length}  revenue: ৳${total}  still open: ${open}`);
}
Enter fullscreen mode Exit fullscreen mode

The order at 21:05 UTC on the 10th is actually 03:05 on the 11th in Dhaka. Without the offset it lands in the wrong day's report, which makes daily revenue look odd.

Small habits that help

  • Log before you reply to the customer.
  • Use the customer's phone number as an ID if names repeat.
  • Back up the CSV daily to Google Drive.

For background on what SMM panels in Bangladesh offer and how buyers compare them, this review of the best SMM panel in Bangladesh is a helpful read. SMM Booster BD is one local supplier with bKash top-ups if you need one.

Top comments (0)