I've already done a lot of the leg work here and I've assumed that I was going to do it this one way, but I'm not sure that it will work now. I have created an inventory system for my business using excel and it has a number of Macros (VBA scripts) - let's call it Inventory Master. I'm trying to keep track of all of my inventory across all of the different selling mediums (Amazon, eBay, personal store).

I've created a PHP script to pull sales data from Amazon and convert the XML date (request data from Amazon) into two separate csv files - for those who care, the way Amazon's API works, I have to make one request to pull of Sales Order IDs for that day and then another request using the Sales Order ID to get the actual order information.

THE PROBLEM is that I'm not sure what the best way to import the data that I need from the two files, into my inventory master. Also, I have to be able to filter the data that I want to import and place it into the appropriate columns in the Inventory Master.

I was going to create an VBA script to import the files, but I'm sure if I can manipulate the data this way, since the import data is a csv and doesn't have macros enabled. I'm sure I could still find a way, but I was then thinking that I might just be able to do all of this via PHP, but the only PHPExcel library I see doesn't work in xlsm formats.

This is where I turn to the internet. Can anyone think of a better way to import this data?