9
xewl
6y

So, just pulled another all-nighter..

On our platform I switched a quite big customer to another stock keeping system to pull them into automatic FEFO handling etc. Just a better stock keeping system overall.. I made it.. *self hi-5*

Evidently the crons caught that change, and CLEARED ALL THE STOCK LEVELS as they're now managed by said system...

Had to pull the counts, locations, expiry dates and lot numbers from the history table and old database fields, add them to an Excel sheet and then add all gathered locations by hand back into the new system, whilst also setting the new settings for them.

39 unique products that were gathered over 190+ sku objects... (Somebody didn't get object oriented, or was trying to KISS themselves, clearly...)

That's 6 hours of extra work for a stupid fuck up.. Oops? (:

Comments
  • 2
    @irene We're all just human, I guess 😁 Luckily the monitor for that company's all green!! *yayme*
  • 0
    I just finished doing the exact same thing
  • 0
    @rant1ng Merging SKU systems?
  • 1
    @xewl merging affiliate and product databases
  • 0
    @rant1ng Yeah, saw the matrix thing, I also have a side project in the works with such hiarchy, but I'm always falling back upon multiple systems to do it, and I ended up abandoning it for the time being.

    Running, building, maintaining and supporting my current work takes too much atm. E-commerce is god damn stressful if the base you're building upon is mostly bullshit you have to work around asap. I made myself familiar with so much over the years, webshop platforms, erp, crm, ... It's all 💩
Add Comment