Thank you. At least i'm not super crazy in thinking them putting 4 different files is dumb. Nonetheless, I did attempt changing the column headings on the product description file and imported and it did work. However, it appears it is going to be quite a challenge as I will have to compile my own category columns as theirs is BS, which means a lot of work figuring out categories for 400 plus products that can go into multiple categories (for example one product can go into wedding favors, baby showers, bridal shower category etc.). This is just too time consuming.

Then there is the matter of products having multiple pricing tier. For example, one product can be purchased in different quantities. If they buy 1-11 products each price is XXX. If they purchase 11-20 the price is XXX. How would that work? The quantity with respective pricing is in the excel sheet, but how would I label the columns to have EP import that information?

It is just too much. Is there anyone out there willing to do this and I will pay? lol Seriously.