When you export data from Elovate, you may notice that some cells in the file are completely empty. This is intentional and can mean different things depending on the type of attribute or data being exported.
What an empty field means
Attribute has no value in Magento
If a product has no value for the exported attribute, the cell will be blank.
Example: a product with no description will have an empty
descriptioncolumn.
Stock attributes not enabled in your API
If you export stock attributes (e.g.,
qty,is_in_stock) and the cells are empty, this usually means yourgetProductsAPI does not return stock data.To enable this, your development team must adjust your Magento API configuration. Contact us if you’re unsure.
Filtered-out data
If your export uses filters, some products may not have values in certain fields because the attributes are irrelevant to those products.
Editing empty fields
You can manually fill in empty cells before re-importing if you want to add data to Magento.
If you plan to re-import the file, ensure you use the correct format and that the attribute exists in Magento.
If the empty cell is for a required attribute when creating a new product, the import will fail unless the attribute is filled.
Example:
sku | color | description | qty |
PROD-001 | Red | High-quality... | 50 |
PROD-002 |
| Durable chair |
|
PROD-003 | Blue |
| 25 |
PROD-002: missing
colorandqty→ No color assigned, stock attribute not enabled.PROD-003: missing
description→ No description in Magento.
Best practices
Always review empty fields to determine if they require attention before re-importing.
For bulk filling empty fields, you can use the “Update empty” option in the import mapping settings.