How to export/import data in CSV files in magento

1. Log into your Magento administrator area.
2. Go to System -> Import/Export -> Dataflow – Profiles -> Export All Products:
   
   
3. Under Profile Wizard -> Store choose the desired store where you will be exporting the products.
4. Under Data Transfer drop down menu choose Local/Remote Server.
5. Under Data Format make sure CSV / Tab Separated is selected for type and click Save Profile:
   
   
6. Open Run Profile tab and click Run Profile in Popup button:
   
   
7. This will save a file named export_all_products.csv under the var/export/ directory of your Magento installation. The export success screen will look like the following and will specify the file name where the products were exported:
   
   
8. Using an FTP client or CPanel File manager download this file to your local computer. You can edit it with a spreadsheet program (MS Excel, Open Office Spreadsheet) and add the products you would like to import:
   
   

Now we will show how to import the products.

1. Go to the Magento administrator area and choose System -> Import/Export -> Dataflow – Profiles -> Import All Products. Select the required settings in Profile Wizard tab:
   
   
2. Then choose Upload file tab and browse for the .csv file on your computer. Save changes:
   
   
3. Once you have uploaded it, click Import All Products, then Run Profile, select the .csv file you have just uploaded from the drop down menu and click Run Profile in Popup:
   
   
4. When import is completed, you will get an export success message. The similar way you can export and import your customers.

Import/export categories

Unfortunately, by default, Magento does not allow to import or export categories. We will use the free Mageworks extension to do such import/export. To install it, you need to download the zip file and upload its content to the root of your Magento on the server.

1. To export the categories, navigate to Mageworks->Export profiles of your Magento dashboard.
2. Click Categories and wait until the export is completed:
   
   
3. The system generates categories.csv file into var/export/category/ directory on your server.
4. To import categories, navigate to Mageworks->Import profiles and specify the file name located in var/import/category directory (categories.csv by default).
5. Click Submit and wait until the categories import is completed:

How to edit Top header links or customer login dashboard left section in magento

Almost each Magento store has header links like: My Account, My Whishlist, My Cart, Checkout, Log In. Each header link is located in separate XML file.

Open the Magento installation directory on your server then go to "app/design/frontend/default/theme###/layout" folder. Most of the required files are located here.

In case you are missing any files in the "app/design/frontend/default/theme###/layout" folder you can edit them in the "app/design/frontend/base/default/layout" folder

Open customer.xml file. There locate the following code:

<default>

    <!-- Mage_Customer -->

    <reference name="top.links">

        <action method="addLink" translate="label title" module="customer"><label>My Account</label><url helper="customer/getAccountUrl"/><title>My Account</title><prepare/><urlParams/><position>10</position></action>

    </reference>

</default>

?

In order to change the menu button name change the <label> value (<label>My Account</label>)

To change the link URL edit the url helper value: <url helper="customer/getAccountUrl"/>

In the same customer.xml file you can edit the Log In and Log Out links

Log In

<reference name="top.links">

    <action method="addLink" translate="label title" module="customer"><label>Log In</label><url helper="customer/getLoginUrl"/><title>Log In</title><prepare/><urlParams/><position>100</position></action>

</reference>

?

Log Out

<reference name="top.links">

    <action method="addLink" translate="label title" module="customer"><label>Log Out</label><url helper="customer/getLogoutUrl"/><title>Log Out</title><prepare/><urlParams/><position>100</position></action>

</reference>

?

My Whishlist

<reference name="top.links">

    <block type="wishlist/links" name="wishlist_link"/>

    <action method="addLinkBlock"><blockName>wishlist_link</blockName></action>

</reference>

?

My Cart and Checkout

My Cart and Checkout links can not be modified in the XML files. You can only remove them from the header menu.

 The code for these links is located in the checkout.xml file:

<reference name="top.links">

    <block type="checkout/links" name="checkout_cart_link">

        <action method="addCartLink"></action>

        <action method="addCheckoutLink"></action>

    </block>

</reference>

same for sidebar




<reference name="left">

<block type="customer/account_navigation" name="customer_account_navigation" before="-" template="customer/account/navigation.phtml">

<action method="addLink" translate="label" module="customer"><name>account</name><path>customer/account/</path><label>Account Dashboard</label></action>

<action method="addLink" translate="label" module="customer"><name>account_edit</name><path>customer/account/edit/</path><label>Account Information</label></action>

<action method="addLink" translate="label" module="customer"><name>address_book</name><path>customer/address/</path><label>Address Book</label></action>

<action method="addItemRender"><type>simple</type><block>checkout/cart_item_renderer</block><template>checkout/cart/sidebar/default.phtml</template></action>

</block> <block type="checkout/cart_sidebar" name="cart_sidebar" template="checkout/cart/sidebar.phtml">

<action method="addItemRender"><type>configurable</type><block>checkout/cart_item_renderer_configurable</block><template>checkout/cart/sidebar/default.phtml</template></action>

<action method="addItemRender"><type>grouped</type><block>checkout/cart_item_renderer_grouped</block><template>checkout/cart/sidebar/default.phtml</template></action> </block>

</reference>

<block type="catalog/product_compare_sidebar" name="catalog.compare.sidebar" template="catalog/product/compare/sidebar.phtml"/> <remove name="tags_popular"/>

And Same for checkout Links Update in checkout.xml file

?