Magento Product Export: Use price and image of configurable product for linked simple products

I am trying to find a way to export all my simple products with correct prices and images. For this I would also like to export all simple products linked to configurable ones. Since prices for these linked products are not always up to date, I need to find a way to fetch the configurable products price and use that for all linked simple ones. Same goes for the product image. Is there any way to do this?

Solutions

I am trying to find a way to export all my simple products...

This is possible natively by filtering the on the type_id column.

... with correct prices and images.

This is confusing. When you export you get the data that you get.

For this I would also like to export all simple products linked to configurable ones.

This is a subset of the first point, but I think that there is no way to filter on configurable children.

Since prices for these linked products are not always up to date... Same goes for the product image.

This is only important if you are selling them individually (Visibility for linked products set to either catalog or search or both). You can configure the configurable image to display for the simples (this is the default behavior IIRC).

If it's important to have the simple child data sync'ed, rather than handle this via export I'd recommend to set up an observer and/or a sync job which can keep the data unified within the app. Should not be difficult.

Similar questions

Collection of all configurable products (which has children) and simple products ( not belonging to configurable product)
How to get a collection of all configurable products and simple products ( not belonging to configurable product) in Magento custom module? I have a custom code for getting all simple product which does belong to configurable product: And also have code for getting all configurable products: I want to get a collection of above both. How to do that?...
In the Magento Difference between Price, Group Price, Special Price, Tier Price, Display Actual Price and Manufacturer's Suggested Retail Price
In the Magento backend product creation section, In the price tab showing different types of price below. Please tell me the different between above price and how it's will work, and how affect the front-end price showing (Price affecting order) ..? Thank You ...
Get linked manufacturer name on product page and listing page above product title on Magento2
On magento 1.9, I could achieve this with this code but don't know how to do for Magento2. Can anybody help me?
Magento Ordered Products linked to Catalog ID?
Currently in the process of porting over a product database to a development database to make that the new production, I'm running into a few snags, and one is the question; To bring over the customers along with their prior order sales history, I need to copy the exact SQL tables (sales_ and customer_) and bring them over as reuploading the custom...
How to remove products linked to another store view?
In Magento\CatalogImportExport\Model\Export\Product::collectRawData() : There is the following lines starting at line 904: I would like to remove the products that are part of a specific store Code as it is causing duplicates during the export. Is there perhaps a way to get the SQL query that puts the collection for a specific store view together? ...
Names of the associated products of a configurable product are not visible in admin? Simple Configurable Products by Organic Internet
Simple problem - the simple associated product names are not showing in the associated products tab within configurable products in the Magento admin. I'm running the Simple Configurable Products extension by Organic Internet Someone posted a solution here: https://stackoverflow.com/a/8927616/2565123 But the fix is not working in my 1.9.1.0 project...

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.