thank you all for dedicating your time and effort to share your knowledge with other members..
i'm new to Magento....yet i find it fabulous ... but i have this question that would help me alot in launching my new online store
Can Magento compare products prices with excel sheet and tell me what are the products that need to be updated?...as my sales department update the prices on daily basis on their pricing sheet for our retail store and obviously this has to reflect on the online store,which requires a lot of time to revise all the products one by one manually and change only the updated products and would also increase the possibility of "Human Error"
so i would really appreciate your guidance for this question
is there an "intelligent" way to do this price comparison to an existing sheet and inform me only with the products that need price updating?
thank you very much for your help
Solved! Go to Solution.
There is no such compare functionality in Magento out of the box, however, you can use import functionality to update all products in bulk.
To do this simply prepare excel sheet with two columns: "sku" and "price", save it in CSV format and import it from Admin panel -> "System" -> "Data Transfer" -> "Import" menu (for Magento 2). All prices will be set to what is specified in your excel sheet.
If you need to ensure the format of CSV file is correct, update more attributes, or just have an excel sheet template to work on, you can first export products from Admin panel -> "System" -> "Data Transfer" -> "Export". Keep only columns you'd like to update in the excel file for import.