I’m working with Magento 2.4.6 (Open Source) and need to export product price and special price values for all store views, including:
- Default (Admin) scope
- Store view ID 1
- Store view ID 2
- Store view ID 3
The default product export (via System > Data Transfer > Export > Products) only provides the global/default scope prices, and doesn’t include the store-specific overrides for price or special_price.
What I’m looking for:
- A way to export the price and special_price for each store view
separately, ideally with store ID or store view name included per row
or column - I want to extend/customize the default Magento export to include this data
Example Scenario:
Let’s say I have a product with the following values:
| Store View | Price | Special Price |
|---|---|---|
| Default | 100.00 | — |
| Store ID 1 | 95.00 | 90.00 |
| Store ID 2 | 105.00 | — |
| Store ID 3 | 100.00 | 85.00 |
I want to export a CSV that includes all of these values per product.
Any suggestions, examples, or recommended approaches would be greatly appreciated!