**** NOTE!! Bulk Loader is very sensitive *****
To Start Download the template file for the xml spread sheet and open it in Excel
There are both Mac files and Windows Files in the zip folder open "bulktemp" for Windows
and open MacOSX -> bulktemp for mac
-->> Download Here <<---
Some things to know.. Information already in the Excel sheet will be used over and over the only
things that will change are the things we will over in the steps
For example: In the picture below we see 7 products
Under store we see admin repeated for each product
Under attribute_set we see Default repeated
Under type we see simple repeated
But!!! Under Sku we see the sku changing..
So with that said here we go..
Step 1: Enter in SKU of product
Step 2: Enter Category ID of product
** to find category id log into admin goto Catalog -> Manage Category -> Click on Sub Category you want
product to appear in..The Id is the last number of the URL
Step 3: Enter in price
Step 4: Enter in name
Step 5: Enter in url key **note url key is the same as the name but with "-" as spaces
Step 6: Enter in description
Step 7: Enter in Short Description
Step 8: Enter in qty **How much inventory we have**
Repeat steps 1 - 8 until all products you are uploading have been put into the excel sheet
Step 9: Save excel sheet *make sure to save as .xml file*
Step 10: Login into admin go to System -> Import/Export -> Profiles
Step 11: Click Import all products
Step 12: Click Upload File
Step 13: Click browse and find the file you just saved
Step 14: Click "Save and Continue Editing"
Step 15: Click "Run Profile"
Step 16: Find File you just uploaded
Step 17: Click Run Profile in Popup
Step 18: Enter in product's picture ** refer to steps 13 - 16 in make a product
and click save after uploading image