Create an export script / query to export SKU and relevant attributes and attribute values to csv file (Magento 1)
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.
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.
Related categories:
PHP
Data Processing
Magento
Software Architecture
MySQL
Database Development
phpMyAdmin
Data Management