Product information sent by vendors is often incomplete and not exactly what you'd like to present to consumers. In these cases you typically replace the missing information with "N/A" or "Contact customer service for more information."
Replacing these missing values at the attribute level is simple to implement while building an export. Follow the steps below to replace missing information during export:
1. Navigate to the field to which your attribute with the missing information will be mapped.
2. Click on the Advanced tab and select Missing Values.
3. Give your new custom attribute a name, choose a list (if you're working with multiple lists), select the attribute that you will map to this field, and enter the text that will replace the missing information.
In the image below the name of the new custom attribute is "ForMissingPrices" and the name of the sample product list we're working from is "myproducts". The attribute that we're mapping to this field is "price" and the text that will replace the missing price is "Contact customer service for more info".
4. Click Apply.