Reports in seconds, updates in days
An established department store asked us for one thing: a faster loyalty sign-up. It grew into three projects, and the reporting system became the one they use every day. Here is how it went, including what we would do differently.
The problem, in their words
The store already ran on Microsoft Business Central with LS Central for its cashier counters (POS) and back office. What it lacked was a website where shoppers could sign up for the loyalty program and see their QR code and points. They had asked their previous supplier for about a year and were told it was hard to do.
What we saw
It was not hard, as long as we could get the system documentation. We had worked with LS Retail years before, but never with Business Central, and we said so. Learning it was written into the contract. We proposed three stages: the sign-up site first, then online selling, then growth. We promised the first stage in a month.
How we solved it
We built the sign-up site on WordPress and connected it to Business Central, so a new member gets their QR code and points right away. Then we built a Shopify store. The products in their system were only short codes, like the names on a grocery receipt, with no titles or descriptions. So we used automation to research and write about 40,000 product listings, adding sizes, weights, country of origin and categories as the store asked. The store itself took about three days to set up. The product data took about 400 hours over several months. When new management asked for reports, we built a reporting system for them (we call it the omnichannel). It holds the store and online data on a server at their site, set up so each report is quick to pull. The key daily, weekly and hourly reports are worked out every hour ahead of time, so they open instantly. Each department head told us what they need to see, and we built their view around that: marketing sees top loyalty buyers and what they bought, while purchasing, the warehouse and finance each see their own numbers.
What went wrong
We promised the sign-up site in a month and took about two. We had not planned for an established company's approval process: getting system access took two weeks, and moving the website needed a sign-off from their foreign headquarters. Our first reporting system was also the wrong design. It downloaded the data to each computer, and a terabyte covers only six to eight months of sales, so we moved it to a server at their site. The online store is built and runs as a catalog for now, with the online launch planned for review in early 2027.
The effect
This project is about time and information, not online sales, so there is no sales number here. Here is what changed.
What changed
- Loyalty sign-up with QR code and points: live about two months after we started, after a wait of about a year with their previous supplier.
- About 40,000 product codes turned into full listings.
- Key reports open instantly, worked out ahead of time every hour.
- The reports keep running even when cloud services go down, as long as the on-site server is online.
- Most change requests ship in two to three days.
Where it stands now
The sign-up site and the reporting system are used every day. The online store waits for the client's go-ahead, and we have proposed ways to use the site to bring people to the store instead, like coupons the site can track. We are now discussing next projects with them: digital shelf labels, so the shelf price always matches the system and shoppers are not surprised at the counter, and a parking system that is faster at the exit and handles PWD and senior discounts properly. Neither is built yet.
What we do differently now
Before we promise a date to an established company, we now map who approves what and how long each step takes, and build that into the timeline. We also ask early who will run an online store day to day. What we would do again, exactly the same way: sit down with each department head, build what they need to see, and ship changes in days. More than a year in, they are still bringing us their next project, and that is the result we value most.
Related
- Custom systems and integrations: scoped in writing
- Shopify stores
- Automation: the kind that wrote 40,000 product listings
- See all case studies
Send us your brief and get a price.
A short brief, then a written proposal within 1 working day. We talk once the work needs it.
