Create an export script / query to export SKU and relevant attributes and attribute values to csv file (Magento 1)

Job ID: 39960644

Budget: €30 – €250 EUR

Hi everyone,

Description:

I am looking for a freelancer who can help me create an export script or MySQL query (preferably usable in phpMyAdmin) that allows me to export product SKUs along with their assigned attributes and attribute values to a CSV file.

Requirements:

The query should support the option to define a variable, such as:

“Show only SKUs that are linked to fewer than X attribute values.”
For example, I may want to find all SKUs connected to less than 5 attribute values.
This number (X) must be easily adjustable.
It should also be possible to export all SKUs with all their assigned attributes and attribute values, regardless of the number of values — by disabling the limit/filter.
The export must be pulled from store view ID: 2 (Dutch).
The script must convert the attribute value IDs (option IDs) into readable attribute value labels, so I can understand the actual content rather than just seeing ID numbers.

Result CSV File Structure:

Column A: SKU
Column B: Attribute name
Column C: All assigned attribute values for that attribute, in a single cell, separated by comma and space (, )
An SKU can appear on multiple rows — one for each connected attribute and its values.
Column D: Total number of attribute values the SKU is connected to (across all attributes).

Goal:

To get a clear, human-readable export of SKUs, their attributes, and the related attribute values — with flexibility to filter SKUs based on how many attribute values are linked.

See attachment: example.csv


My maximum budget for this task is €50.