@dkf said in Redesigning my retail software/database - part 2:
@Zenith said in Redesigning my retail software/database - part 2:
That nightmare went from bad to worse between 2018 and 2019.
I've got bad news about 2020…
Oh, I know it's going to be awful from a business standpoint. I would be somewhat surprised if sales broke into four digit territory. At this point I'm somewhere in the ~$800 range. On the bright side, that's more than I sold online* last year. It also might be more than I spent on inventory acquisition but that's a little hazier at the moment.
Still, per the topic, I think I'll have worked out most of the software problems for awhile. I don't see any major new quirks to the business model on the horizon. I've been formulating some more ways to verify the data but they don't make sense to implement until more of that data is available. That'll probably be part 4 if I get to it.
Edit: A side goal for 2020 is to balance some accounts. Back when business was much better, the plan was to shift inventory purchases from my money to business money. eBay was doing pretty well and I had a few vendors that used PayPal, so I decided to start with that account. Unfortunately, sales sort of collapsed and preorders outstripped my buffer, so I had to transfer money in from other accounts.
I've been wanting to repay those "loans" for some time but it's sort of complicated. I figured out how to repay them exactly (awfully slow view because of so many joins), including missed interest, so it'll look like it was never borrowed. The easiest way to do that, though, was to make one lump payment per account, which meant saving up significant eBay sales. As I said, eBay sale shave been in full-on collapse for a few years, so it's been slow going.
I estimate that I have between 1/2 and 2/3 of the funds necessary. Mangled Payments is coming by the end of the year, which has been my deadline for exiting eBay. Five months is probably not enough time but maybe I'll make it. The shutdown may have wrecked business overall but it has marginally helped online sales so who knows.