I need to update the price of more than 100 products in one go. What steps to follow?
Export products to CSV file
Log into your Magento administrator area.
Go to System -> Import/Export -> Dataflow – Profiles -> Export All Products
Under Profile Wizard -> Store choose the desired store where you will be exporting the products.
Under Data Transfer drop down menu choose Local/Remote Server.
Under Data Format make sure CSV / Tab Separated is selected for type and click Save Profile
Open Run Profile tab and click Run Profile in Popup button.
This will save a file named export_all_products.csv under the var/export/ directory of your Magento installation.
Using an FTP client or CPanel File manager download this file to your local computer. You can edit the PRICE field with a spreadsheet program (MS Excel, Open Office Spreadsheet) and add the products prices you would like to import.
Now we will show how to import the products.
Go to the Magento administrator area and choose System -> Import/Export -> Dataflow – Profiles -> Import All Products. Select the required settings in Profile Wizard tab.
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.
When import is completed, you will get an export success message. The similar way you can export and import your customers.
It looks like you're new here. If you want to get involved, click one of these buttons!