I like how the import / export functionality in the PIM works with real Excel files, with locked cells and such. What I don't get is why that works for a single product only. What's the use case for that? Exporting a single product, editing it in Excel and then importing it back into Dynamicweb seems like a lot more work that simply updating the product in the PIM directly.
Instead I would love to see import / export for a selection of products. Consider a 10% price increase for all products in a group. Currently that requires a lot of manual work. Here's a use case I would love to see to make that much simpler:
1. Use the PIM repository and query to quickly find all products that need the update.
2. Hit Export on the ribbon which gives me an Excel file with rows for the selected products and columns for the selected fields. The appropriate things, such as the product ID, are read-only to prevent accidental editing
3. I use Excel and all of its features like I normally do. I.e. I could use a formula to quickly update all product prices by 10%.
4. I import the Excel document again, and presto, all my product prices are changed.
Am I crazy for wanting this? Or do others want it too?