Consumer Transitions, Replacement Order Updates, CS Ticketing & Dark Deck Purchases

Total Unlocked: $170

Spent: $84.60

Balance: $85.40

Cards:
[Whimsicott V deck]
[Misc Support cards]
[Regi deck]
[Ice Rider cards]
Hisuian Sneasler V x3
Duraludon V x3
Shaymin V x2
Darkrai V x3
Gengar VMax

The last couple of weeks, I have spent a fair amount of time pursuing projects that don't-quite-finish. Sometimes that has been due to other priorities rising to the top. In other cases, it's because of factors outside the company's control. In any case, that leaves me very close to finishing up a number of stages, but not quite there on any of them. Here's the blow by blow:

• Customer Support Ticket Interfacing & Tracking: We have a third-party customer support system. It's currently entirely separate from the rest of our backend site. But we are integrating things together to make it easier on our Customer Support Agents to keep on top of things, since happy customers mean good things to the whole business. Except, this was put on pause while we worked with the third party site to overcome some obstacles (e.g. their API had very low rate limits). We've sorted out a few ways around this issue, but won't be circling back to it until the high priority projects are done, as well as the Consumer Transition project (below). This is probably at 80% complete.
• Consumer-to-Business Transitions: We are around 90% complete with a single-level stage around the project to enable automated transitions from an account and all connected features to go from being an individual user's consumer account to being part of a business's heirarchy of accounts. This will ease a lot of work for our account staff, but went on hold this week to address two large projects that were higher priority.
• Replacement Order Updates: After an onsite demo/test of the Replacement Order System, a few small bugs were found, and a laundry list of nice-to-have requests came back. The goal has been to get this ready for release by the end of the week. It became the highest priority item, as it apparently makes a ton of things easier and will actually support a much broader part of the business than us Engineers even realized. Moreover, I achieved that goal. The high priority stuff is done now! But there's one lower priority task remaining before this stage is deemed complete. I'm splitting the stage into 3 levels:
  
  1) Listing Page Updates -- Complete ($5 unlocked)
  2) Details Page Updates -- Complete ($5 unlocked)
  3) Database Efficiency Updates -- Pending
  
  The first two levels were by far the most important in terms of fast turn-around and ability to deploy everything to production. The DB Efficiency Updates basically consist of shifting a large number of Entity-Framework database pings into a single database call of a stored procedure, and then using in-memory datatables to more efficiently load and process everything for these pages. The EF version works fine, and was probably preferrable for getting the initial version out fast while allowing easy rapid adjustments. But now that things are getting finalized, EF methods result in a lot more database hits than we want, which will be slower page performance as things grow. So we're getting ahead of that ever being a problem, by moving it all to an SP-driven system with a single DB hit.
• Return Status: Lastly, the next highest priority after the finishing the Replacement Orders, is a new 6-part project around Return Statuses. I haven't delved into what this one is about yet, but it will be the largest priority for next week. I'm not sure how many levels will feel like the right number for this stage, but I'll figure it out next week.

All together, that's another $100+ worth of work-stages that will be unlocked in the next couple weeks. For now, I've stepped forward to acquire some of the parts for a couple of different Dark Decks. I traded to get 2x Gengar V + 1x Gengar Vmax. Then I purchased 3x Darkrai V + 1x Gengar Vmax. The goal here is to end up able to run up to a 2-2 line of Gengar Vmax and up to a 3-3 line of Darkrai Vstar. Testing will determine exactly which counts we want to settle on. I'm still holding off on purchasing Darkrai Vstars as they are the only cards involved that are still likely to see a significant reduction in price (and because I don't know if I will end up wanting 2 or 3 of them).