For instance, you have a product SKU 10001 (“Planet Express Babydoll”) for which you need to reduce the price from $19.99 to $9.99, and a product SKU 10007 (“Electronic Drum Kit Shirt”) for which you need to increase the stock level from 5 to 15 units. Let us first consider the easiest case when both these products don't have options or variants.
The process is pretty straightforward:
Use the “Export” page of your store’s Admin area (Catalog > Export) to export your existing products. Also, see general export guides here.
Download the resulting export file and open it in any spreadsheet editor to view the file contents separated into columns.
For the sake of example, we’ll do it with Google Sheets on Google Docs.
The file you get has many columns, so it is good to remove the columns you don't need to update to make the file more manageable. However, care not to remove the required columns.
To find out which columns are required for your file, check the guide CSV Import: Products. The table describing the data format for importing products shows that there are only two required fields (they are marked with asterisks): sku and name. So you will need to keep these two columns. In addition, the price that needs to be updated can be found in the column price and the product quantity - in the column stockLevel. So, these columns will also have to be kept. Basically, you can safely remove all the columns except for sku, name, price, and stockLevel. After you do so, your spreadsheet should look something like the following:
* On the screenshot above, the column name has the name name_en because it contains values for the English language; for other languages, the column name will have a different language code appended.
On the SKUs' lines for which you need to update the price and the stock quantity, edit the contents of the price and stockLevel fields as you require.
Save the file and re-import it into your store via the “Import by CSV” section in your store’s back end (Catalog > Import).
After the import process is completed, you should see the updated product information in the respective products' details.