How to fix Magento 500 Internal Server Error

If you are installing Magento and you have uploaded your Magento files to your host and just when you are about to run the Installation wizard,  you get “500 Internal Server Error”. This error is because of the inappropriate file permissions.

To fix this error,  if you are on cpanel hosting, Error Log will really help solving/fixing this error.

Normally changing the file permission on index.php file will solve this problem. If you check the error log in your cpanel, you will find “/index.php” is writeable by group

So in your cpanel, go to File Manager and then change the file permission of index.php file from 664 to 644.  Also change the permissions of downloader/index.php file to 644 as well otherwise when you will try to access System > Magento Connect >Magento Connect Manager (after magento installation) by logging to magento admin,  you will get 500 Internal Server Error.

And if magento is installed in a folder e.g yourdomain.com/magento, in this case you will also change the permission on magento folder to 644.

You can also fix this error using SSH by running the following command

find . -type d -exec chmod 755 {} \;
find . -type f -exec chmod 644 {} \;

This will change the file permissions on all the folders to 755 and files to 644 and will fix the Internal Server Error.

How to import products into Magento?

November 04, 2012 Update: The following tutorial has been updated for magento version 1.7.0.2

Follow the steps below to import products (bulk) from a csv file into Magento.

1. Go to Magento Admin > Catalog > Manage Categories and then add few categories.

2.  If you want to add extra attributes for your products then go to Catalog >Attributes >Manage Attributes and click Add new Attribute. You can also save your Attributes sets based on the attributes you have defined.

3. Then go to Magento Admin > Catalog > Manage Products and add 4-5 products manually.

4.  Then go to  your Magento Admin > System > Import/Export > Export

5. Select Entity Type > Products

6. Scroll Down and click continue to export your csv with all attributes.

7. The csv will be downloaded.

8. Open this CSV file with Open Office Calc and populate the file. When you will be populating file, consider the following points.

  • sku should be unique
  • _category will have your category name e.g Furniture. If you want to add your product to a sub category then use Furniture/Living Room.
  • If you want to add your product to multiple categories then you can add “,” comma separated e.g Shoes/Men,Shoes/Women
  • For images, first upload all your images to media/import directory using ftp. Then update “image” column in your csv file with the image names e.g if the name of the image is furniture.jpg, you will add /furniture.jpg to the image column against that product that is you will use a forward slash before the image name/extension.
  • To import multiple images,  use/create  “gallery” column in your products import CSV file.Under this column enter images name separated by semicolon ( ; ) . Please enter relative path of images  e.g.    /furniture1_1.jpg;/furniture1_2.jpg

9. After populating your csv file, copy by selecting all and then paste it in a new document and then go File and then Click Save As. Choose Save as Type “Text CSV (.csv)”

10. Choose Character Set “Unicode (UTF-8)” and “check Quote all text cells” and click Ok.

 

 

 

 

 

 

11. Then go to Go to Admin > System > Import/Export >Import

12. Select File to Import by clicking Choose File and Import Behavior “Append Complex Data” and click Check Data.

13. You will get validations results like

Checked Rows: 5035, checked entities 5035, invalid rows: 0, total errors:0

File is valid! To start import process press “import” button.

14. Press Import button to import products from the csv file.

Problems:

If you get errors like

1. Category does not exists in rows: 3, 4, 6, 9, 10

Solution: If the category name is not added in the backend, add that and in your csv file you should have 1 extra space after that category name.

2. Invalid value for ‘manufacturer’ in rows: 4461, 4462, 4463, 4464

Solution: If you are using a dropdown for attributes like manufacturer or color, you might get this error, you can fix this error by adding 1 space after the Manufacturer name in the csv.

3. Images showing up on the frontend but not showing in the admin (For this read my comment below, comment no 6 posted on December 11, 2012)

If you have any questions, do leave your comments below and If you need help in importing products to your magento store Hire me on Odesk.