Yes, it is possible to do with a little work on the Excel file.
Assume you have the product ID in column A, and the stock level in column B. I'll assume you have column titles in the first row, and the first data fields are in row 2.
In the second row of column C, enter this formula:
Code:
=CONCATENATE("UPDATE TABLE products SET products_quantity = ",B2," WHERE products_id = ",A2,";")
Then copy that formula and paste it into the rest of the column C rows.
Now you can just select the whole of column C, and either paste it into your Admin > Tools > Install SQL Patches page, or paste it into a blank text file that you can then import into either phpmyadmin or the Admin > Install SQL Patches page.
Note: if you have a prefix on your tables and plan to import the file via phpmyadmin, you will need to add the prefix into that formula in Excel. If you plan to use the Admin SQL patch page, do NOT add the table prefix, as it gets added automatically by the cart.
Bookmarks