new to mysql need help integrating with magento mysql

Some background:

I'm trying to create a ecommerce site using Magento CE. I have a data export tool from a 3rd party service that has 100+ manufacturers and 100,000 + products of things the company I work for sells.

Attached is just one file from the data export tool. The information in there is just for commercial refrigerators from 1 brand name http://ift.tt/1xJjaLZ

For my magento site, I'm using nexcess hosting, and created a stand alone MySQL Database to host all the manufacturer data. Basically list prices change yearly/quarterly, mfrs may add or discontinue items, discounts may change over time, our selling prices may vary over time, etc so I want to have this stand alone database always be up to date.

I will then use this database to run queries to probably write up new attributes for magento, (although I can probably just do this manually through excel, but its a real time drain)

Then I'll use those queries and export into excel, and then import into Magento

I'm fine when it comes to Magento Development though, but the real issues I'm having is wrapping my head around how data is going to be processed and managed. I went through Database management tutorials, w3schools MySQL editor tools, phpmyadmin tutorials but I still am having issues

1. 
   

   Looking at the data, you see in the google docs, column E, how do I seperate out this data into separate columns when porting it into a MySQL database? Can I do it straight from excel into the MySQL database

   
   


2. 
   

   How do I generate new columns in MySQL after the data is ported in? Basically I want to somehow use things in column E as attributes in magento(i.e. cubic feet measurements, side or top mount compressor, # of shelves, etc.)

   
   


3. 
   

   I'm not going put everything from the manufacturer on the website, just select models. How do I tell MySQL in phpmyadmin to port over models I want? I'll have a spreadsheet of model#s that I want imported

   
   


4. 
   

   What's the most efficient / cleanest way to manage all of this?

   
   

Submitted November 24, 2014 at 07:10AM by daphoenix720 http://ift.tt/1FhxsE3 mysql