I’ve got an aggressive schedule lined up at Probus OneTouch this month, one that I’m really excited about. The goal in front of me is to fully automate order processing, and set up integration between Magento and SAP Business One.
First, however, I’m working on a little database application that we’re going to use to help us keep track of our SKUs. I call it SKUtee. I’m writing it in PHP using Zend Framework. While I’ve had a bunch of exposure to Zend Framework by working with Magento this is my first project from scratch using ZF.
I’ll write more about SKUtee in the next couple of weeks as a case study of writing a small custom application to solve a unique business problem.
After SKUtee is done, I’ll be implementing an addon to Magento to import customer orders from Ebay and Amazon. In the past we’ve used another application in house to funnel orders from Ebay, Amazon, and Magento into a single database to use for order processing. This addon will import all orders into Magento, so our customer service staff will have a single place to go for all orders. Getting this set up is a priority for our SAP implementation project as we’re only planning on integrating SAP with Magento — not with Ebay or Amazon. Orders from those channels will come into the SAP system from the Magento feed for processing.
Later this month, I’ll be adding a product called Help Desk Ultimate to our Magento install to enable our Customer Service staff to more easily keep track of customer requests. This product will also get integrated with SAP, as we’ll link “service calls” in SAP with customer tickets on Magento. Our customer service agents will use Help Desk Ultimate to manage their open issues with customers. Our tech service crew will use SAP for anything that involves receiving returns or pulling items from stock for repairs. Our goal is to better track cost of service and identify warranty issues to charge back to our factories, while also making it easier for customer service to keep track of who needs help and who doesn’t.
Looking at the calendar, it looks like there’s only about 3 more weeks in the month, so I’m going to be busy! I’m hoping I can get this all banged out in time because Jenny and I have a baby on the way. If he decides to come ahead of schedule, then some of this stuff might have to happen in June. We’ll see! It’s good to be busy.