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 most uncomplicated case when these products don't have options or variants.
The process is pretty straightforward:
Use the CSV Export page of your store's Admin area (Catalog > Import & Export > CSV Export) to export your existing products. Also, see the general export guides here.
Download the resulting export file and open it in any spreadsheet editor to view the file contents separated into columns.
NOTE: For the sake of example, we'll do it with Google Sheets on Google Docs.
The file you get has many columns, so removing the columns you don't need to update makes the file more manageable. However, please be careful not to remove the columns that are required.
To find the required columns for your file, check the CSV Import: Products guide. The table describing the data format for importing products shows only two required fields (marked with asterisks): sku and name. The name field, however, is required only in the case of performing an import to create new products. We are not going to create products but are going to update the information for existing products. So, we want to keep the sku field, and we can either keep or omit the name field.Product prices can be found in the price column, and product quantities - in the stockLevel column. We are going to update the price and stock quantity values, so, we need to also keep those columns. And we can safely remove the rest of the columns.
NOTE: If you need to update other price values, use the following columns:
costPrice - cost price;
marketPrice - market price;
wholesalePrices - wholesale prices;
sale - discount set as either an absolute or a percent value;
saleDiscounts - global product discount.
After removing the unnecessary columns, our spreadsheet looks like the following:
NOTE: We chose not to remove the name column, and you can see it in the screenshot above. The actual name of the column in the spreadsheet is name_en because it contains values for the English language; the column name will have a different language code for other languages.
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 CSV Import page in your store's Admin area (Catalog > Import & Export > CSV Import).
After completing the import process, you should see the updated product information in the respective products' details.
Read on:
Related pages: