When exporting data from Elovate, you can choose between three formats:
CSV
Excel
Google Sheets
While the export format determines how you receive the file, it’s also important to understand how data is presented once exported.
How data looks in the export
Categories
If you export products and include category data, you will see category IDs in the export. These IDs correspond to the categories in your Magento store.Dropdown attributes (Google Sheets advantage)
When exporting dropdown attributes to Google Sheets, you benefit from the fact that dropdown options are directly visible in the sheet. This makes it easy to read, review, and update attribute values without needing to remember the option codes.Tier pricing
Tier prices appear as multiple values in a single row, along with the customer group.
Example:200:6,95/500:5,95(meaning 200 units cost €6,95 each, 500 units cost €5,95 each).Stock attributes
Stock attributes will appear either with a value or completely empty.If empty, this means your stock attributes are not enabled in the
getProductsAPI.Enabling them requires action from your development team. If you’re unsure, please contact us for guidance.Output formats