Tech-Today
How to Export Magento Products
1.) login to the magento admin
2.) go to System->Import/Export->Profiles
3.) select Export All Products
4.) select Run Profile and on the middle-right click the "Run Profile in Popup", this will open a new tab and will start the export process
5.) export data is saved /var/export/ with the filename: export_all_products.csv, you should see the following screen after export:
Note: This template can be use as the basis for importing product data in the magento system, until the products' attributes is/are changed.
How to Import Magento Products With Images
*Note: We should use the csv template we got from exporting magento products
1.) login to the magento admin
2.) go to System->Import/Export->Profiles
3.) select Import All Products
4.) in this state we assume that you have added a new product in the: export_all_products.csv template
-to add an image add an entry in the "image" column, example /nikon-d5000.jpg, BTW TAKE NOTE OF THE / (forward slash), it's very important
-note that nikon-d5000.jpg should be uploaded via ftp or any upload tool in the /media/import directory
5.) select "Upload File" and browse and select our template: export_all_products.csv template
6.) click Save
7.) again select Import All Products
8.) select "Run Profile", and in the dropdown box we will see our newly uploaded product data
9.) click "Run Profile in Popup"
10.) you should arrive at the following screen:
To check the newly uploaded products, goto Catalogs->Manage Products and search for our newly uploaded products.
- Mysql Desc Operation In Mssql. This Query Imitate The Desc Operation From Mysql Into Mssql
This query imitate the desc operation from mysql into mssql. It produces the columns and descriptions of the Products table from the Northwind database. SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS a...
- Magento Email To A Friend Not Working, Even After Updating Product_share.html
After we have successfuly setup our magento store, we've been testing its functionality and found out that email to a friend is not working properly. The product link and image are missing. What we did: 1.) After checking the controller for sendfriend,...
- Remove Compare Products And Recently Viewed Boxes On Magento
To do this first I enable the block outlining so I will be able to determine which layout and block a box is located. To remove these boxes using the xml layout config files, you have to open and change 2 files 1.) For Compare Products Box open: app/design/frontend/default/youttheme/layout/catalog.xml...
- How To Add A Customize Product Admin Fields In Zencart By Editing/adding Extra Codes
Problem: How to add a product custom field named length. This to consider (modifications in): 1.) database 2.) scripts ----------------------------------- 1.) Database - a custom column should be add to the products table. Execute this line (for column...
- Magento's Block And Template
This blog is not the authors original, instead his notes on the key steps in playing with blocks and templates. Objective: To create a block that will call a template and will be displayed on the home page. Steps: 1.) Create a namespace inside the local...
Tech-Today
Magento Export and Import Products with Images
How to Export Magento Products
1.) login to the magento admin
2.) go to System->Import/Export->Profiles
3.) select Export All Products
4.) select Run Profile and on the middle-right click the "Run Profile in Popup", this will open a new tab and will start the export process
5.) export data is saved /var/export/ with the filename: export_all_products.csv, you should see the following screen after export:
Note: This template can be use as the basis for importing product data in the magento system, until the products' attributes is/are changed.
How to Import Magento Products With Images
*Note: We should use the csv template we got from exporting magento products
1.) login to the magento admin
2.) go to System->Import/Export->Profiles
3.) select Import All Products
4.) in this state we assume that you have added a new product in the: export_all_products.csv template
-to add an image add an entry in the "image" column, example /nikon-d5000.jpg, BTW TAKE NOTE OF THE / (forward slash), it's very important
-note that nikon-d5000.jpg should be uploaded via ftp or any upload tool in the /media/import directory
5.) select "Upload File" and browse and select our template: export_all_products.csv template
6.) click Save
7.) again select Import All Products
8.) select "Run Profile", and in the dropdown box we will see our newly uploaded product data
9.) click "Run Profile in Popup"
10.) you should arrive at the following screen:
To check the newly uploaded products, goto Catalogs->Manage Products and search for our newly uploaded products.
- Mysql Desc Operation In Mssql. This Query Imitate The Desc Operation From Mysql Into Mssql
This query imitate the desc operation from mysql into mssql. It produces the columns and descriptions of the Products table from the Northwind database. SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS a...
- Magento Email To A Friend Not Working, Even After Updating Product_share.html
After we have successfuly setup our magento store, we've been testing its functionality and found out that email to a friend is not working properly. The product link and image are missing. What we did: 1.) After checking the controller for sendfriend,...
- Remove Compare Products And Recently Viewed Boxes On Magento
To do this first I enable the block outlining so I will be able to determine which layout and block a box is located. To remove these boxes using the xml layout config files, you have to open and change 2 files 1.) For Compare Products Box open: app/design/frontend/default/youttheme/layout/catalog.xml...
- How To Add A Customize Product Admin Fields In Zencart By Editing/adding Extra Codes
Problem: How to add a product custom field named length. This to consider (modifications in): 1.) database 2.) scripts ----------------------------------- 1.) Database - a custom column should be add to the products table. Execute this line (for column...
- Magento's Block And Template
This blog is not the authors original, instead his notes on the key steps in playing with blocks and templates. Objective: To create a block that will call a template and will be displayed on the home page. Steps: 1.) Create a namespace inside the local...