Posts

I Had 11,000 Messy Legacy Inventory Rows. Making Sense of Them Became an ERPNext Workflow

Image
I Had 11,000 Messy Legacy Inventory Rows. Making Sense of Them Became an ERPNext Workflow A few months ago, I started trying to make sense of years of messy inventory data so we could recreate the useful parts of it properly in ERPNext. I was new to ERPNext, so I spent a lot of time in the documentation first. I started with the Item master , because for a medium-sized business such as ours that is really the backbone of the inventory side of the system. I needed to understand item codes, item names, descriptions, barcodes, buying and selling prices, and how those records fed into the rest of ERPNext. Because I also decided to add the Webshop app, I had the Website Item fields to think about too: website names, short descriptions, images and the other catalogue information. Not all of that went in first time round, but I understood enough to get started. Our business had used other inventory and POS systems before ERPNext. We had moved between a couple of providers over the yea...