CatalogProcessingResultItemIssues
Returns item-level issues detected during catalog processing.
Table Specific Information
Select
The add-in will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in. FeedProcessingResultId is a required column to access this view.
- ItemNumber supports the '=' operator.
- AdAccountId supports the '=' operator.
- ItemValidationIssue supports the '=' operator.
Select * from CatalogProcessingResultItemIssues where FeedProcessingResultId = '1249732834965724159' Select * from CatalogProcessingResultItemIssues where FeedProcessingResultId = '1249732834965724159' AND ItemNumber = '0' SELECT * from CatalogProcessingResultItemIssues where FeedProcessingResultId = '1249732834965724159' AND AdAccountId = '549768518755'
Columns
| Name | Type | References | Description |
| ItemId [KEY] | String | The merchant-created unique ID that represents the product. | |
| FeedProcessingResultId | String | Unique identifier of a feed processing result. | |
| ItemNumber | Integer | Item number based on order of appearance in the Catalogs Feed. | |
| ErrorAdultInvalidName | String | Item attribute that has an invalid adult value. | |
| ErrorAdultInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorAdwordsFormatInvalidName | String | Item has an ad link URL that is duplicate of the link URL. | |
| ErrorAdwordsFormatInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorAvailabilityInvalidName | String | Item is missing availability value in its product metadata, this item will not be published. | |
| ErrorAvailabilityInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorBlocklistedImageSignatureName | String | Item will not be published because it doesn't meet Pinterest's Merchant Guidelines. | |
| ErrorBlocklistedImageSignatureValue | String | Provided value that caused the validation issue. | |
| ErrorDescriptionMissingName | String | Item is missing description in its product metadata, this item will not be published. | |
| ErrorDescriptionMissingValue | String | Provided value that caused the validation issue. | |
| ErrorDuplicateProductsName | String | This product is duplicated. The duplicate entry will not be published. | |
| ErrorDuplicateProductsValue | String | Provided value that caused the validation issue. | |
| ErrorImageLinkInvalidName | String | Image link is invalid. | |
| ErrorImageLinkInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorImageLinkLengthTooLongName | String | Item has image_link URL that contains too many characters, so the item will not be published. | |
| ErrorImageLinkLengthTooLongValue | String | Provided value that caused the validation issue. | |
| ErrorImageLinkMissingName | String | Item is missing an image link URL in its product metadata, this item will not be published. | |
| ErrorImageLinkMissingValue | String | Provided value that caused the validation issue. | |
| ErrorInvalidDomainName | String | Product link value doesn't match the verified domain associated with this account. | |
| ErrorInvalidDomainValue | String | Provided value that caused the validation issue. | |
| ErrorItemIdMissingName | String | Item is missing item id in its product metadata, this item will not be published. | |
| ErrorItemIdMissingValue | String | Provided value that caused the validation issue. | |
| ErrorItemMainImageDownloadFailureName | String | Main image can't be found. | |
| ErrorItemMainImageDownloadFailureValue | String | Provided value that caused the validation issue. | |
| ErrorLinkFormatInvalidName | String | Link is invalid. | |
| ErrorLinkFormatInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorLinkLengthTooLongName | String | Product link contains too many characters, this item will not be published. | |
| ErrorLinkLengthTooLongValue | String | Provided value that caused the validation issue. | |
| ErrorListPriceInvalidName | String | Item has a list price formatting error, this item will not be published. | |
| ErrorListPriceInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorMaxItemsPerItemGroupExceededName | String | Item exceed the maximum number of items per item group, this item will not be published. | |
| ErrorMaxItemsPerItemGroupExceededValue | String | Provided value that caused the validation issue. | |
| ErrorParseLineErrorName | String | Item contains formating errors. | |
| ErrorParseLineErrorValue | String | Provided value that caused the validation issue. | |
| ErrorPinJoinContentUnsafeName | String | Item will not be published because it doesn't meet Pinterest's Merchant Guidelines. | |
| ErrorPinJoinContentUnsafeValue | String | Provided value that caused the validation issue. | |
| ErrorPriceCannotBeDeterminedName | String | Item price cannot be determined because the price, list price, and sale price are all different. | |
| ErrorPriceCannotBeDeterminedValue | String | Provided value that caused the validation issue. | |
| ErrorPriceMISSINGName | String | Product is missing a price, this item will not be published. | |
| ErrorPriceMISSINGValue | String | Provided value that caused the validation issue. | |
| ErrorProductLinkMissingName | String | Item is missing a link URL in its product metadata, this item will not be published. | |
| ErrorProductLinkMissingValue | String | Provided value that caused the validation issue. | |
| ErrorProductPriceInvalidName | String | Item has a price formatting error in its product metadata, this item will not be published. | |
| ErrorProductPriceInvalidValue | String | Provided value that caused the validation issue. | |
| ErrorTitleMissingName | String | Item is missing title in its product metadata, this item will not be published. | |
| ErrorTitleMissingValue | String | Provided value that caused the validation issue. | |
| WarningAdLinkFormatWarningName | String | Item has an ad link that is formatted incorrectly. | |
| WarningAdLinkFormatWarningValue | String | Provided value that caused the validation issue. | |
| WarningAdLinkSameAsLinkName | String | Item has an ad link URL that is duplicate of the link URL. | |
| WarningAdLinkSameAsLinkValue | String | Provided value that caused the validation issue. | |
| WarningAdditionalImageLinkLengthTooLongName | String | Item has an additional_image_link URL that contains too many characters, so the item will not be published. | |
| WarningAdditionalImageLinkLengthTooLongValue | String | Provided value that caused the validation issue. | |
| WarningAdditionalImageLinkWarningName | String | Item has additional_image_link URLs that are formatted incorrectly and will not be published with your items. | |
| WarningAdditionalImageLinkWarningValue | String | Provided value that caused the validation issue. | |
| WarningAdwordsFormatWarningName | String | Item has an adwords_redirect link that is formatted incorrectly. | |
| WarningAdwordsFormatWarningValue | String | Provided value that caused the validation issue. | |
| WarningAdwordsSameAsLinkName | String | Item has an adwords_redirect URL that is duplicate of the link URL. | |
| WarningAdwordsSameAsLinkValue | String | Provided value that caused the validation issue. | |
| WarningAgeGroupInvalidName | String | Item has an age group value that is formatted incorrectly, which may limit visibility in recommendations, search results and shopping experiences. | |
| WarningAgeGroupInvalidDValue | String | Provided value that caused the validation issue. | |
| WarningSizeSystemInvalidName | String | Some items have size system values which are not one of the supported size systems. | |
| WarningSizeSystemInvalidValue | String | Provided value that caused the validation issue. | |
| WarningAndroidDeepLinkInvalidName | String | Item includes an invalid android_deep_link. | |
| WarningAndroidDeepLinkInvalidValue | String | Provided value that caused the validation issue. | |
| WarningAvailabilityDateInvalidName | String | Item has an availability_date value that is formatted incorrectly, this item will be published without an availability date. | |
| WarningAvailabilityDateInvalidValue | String | Provided value that caused the validation issue. | |
| WarningConutryDoesNotMapToCurrencyName | String | Item includes a currency that doesn't match the usual currency for the location where the product is sold or shipped. | |
| WarningCountryDoesNotMapToCurrencyValue | String | Provided value that caused the validation issue. | |
| WarningCustomLabelLengthTooLongName | String | Item has a custom_label value that is too long, this item will be published without that custom label. | |
| WarningCustomLabelLengthTooLongValue | String | Provided value that caused the validation issue. | |
| WarningDescriptionLengthTooLongName | String | The description for this item was truncated because it contains too many characters. | |
| WarningDescriptionLengthTooLongValue | String | Provided value that caused the validation issue. | |
| WarningExpirationDateInvalidName | String | Item has an expiration_date value that is formatted incorrectly, this item will be published without an expiration date. | |
| WarningExpirationDateInvalidValue | String | Provided value that caused the validation issue. | |
| WarningGenderInvalidName | String | Item has a gender value that is formatted incorrectly, which may limit visibility in recommendations, search results and shopping experiences. | |
| WarningGenderInvalidValue | String | Provided value that caused the validation issue. | |
| WarningGTINInvalidName | String | Item has a GTIN value that is formatted incorrectly. | |
| WarningGTINInvalidValue | String | Provided value that caused the validation issue. | |
| WarningImageLinkWarningName | String | Item has an image_link URL that is formatted incorrectly and will not be published. | |
| WarningImageLinkWarningValue | String | Provided value that caused the validation issue. | |
| WarningIOSDeepLinkInvalidName | String | Item includes an invalid ios_deep_link value. | |
| WarningIOSDeepLinkInvalidValue | String | Provided value that caused the validation issue. | |
| WarningIsBundleInvalidName | String | Item has an is_bundle value that is formatted incorrectly, this item will be published without being bundled with other products. | |
| WarningIsBundleInvalidValue | String | Provided value that caused the validation issue. | |
| WarningItemAdditionalImageDownloadFailureName | String | Item includes additional_image_links that can't be found. | |
| WarningItemAdditionalImageDownloadFailureValue | String | Provided value that caused the validation issue. | |
| WarningLinkFormatWarningName | String | Item has an invalid product link which contains invalid UTM tracking paramaters. | |
| WarningLinkFormatWarningValue | String | Provided value that caused the validation issue. | |
| WarningMinAdPriceInvalidName | String | Item includes a min_ad_price value that is formatted incorrectly. | |
| WarningMinAdPriceInvalidValue | String | Provided value that caused the validation issue. | |
| WarningMPNInvalidName | String | Item has a MPN value that is formatted incorrectly. | |
| WarningMPNInvalidValue | String | Provided value that caused the validation issue.. | |
| WarningMultipackInvalidName | String | Item has an invalid multipack value. | |
| WarningMultipackInvalidValue | String | Provided value that caused the validation issue. | |
| WarningOptionalConditionInvalidName | String | Item includes a condition value that is formatted incorrectly, which may limit visibility in recommendations, search results and shopping experiences. | |
| WarningOptionalConditionInvalidValue | String | Provided value that caused the validation issue. | |
| WarningOptionalConditionMissingName | String | Item is missing condition value, which may limit visibility in recommendations, search results and shopping experiences. | |
| WarningOptionalConditionMissingValue | String | Provided value that caused the validation issue. | |
| WarningOptionalProductCategoryInvalidName | String | Item includes a google_product_category value that is not formatted correctly according to the GPC taxonomy. | |
| WarningOptionalProductCategoryInvalidValue | String | Provided value that caused the validation issue. | |
| WarningOptionalProductCategoryMissingName | String | Item is missing google_product_category. | |
| WarningOptionalProductCategoryMissingValue | String | Provided value that caused the validation issue. | |
| WarningProductCategoryDepthWarningName | String | Item only has 1 or 2 levels of google_product_category value, which may limit visibility in recommendations, search results and shopping experiences. | |
| WarningProductCategoryDepthWarningValue | String | Provided value that caused the validation issue. | |
| WarningProductTypeLengthTooLongName | String | Item has a product_type value that is too long, this item will be published without that product type. | |
| WarningProductTypeLengthTooLongValue | String | Provided value that caused the validation issue. | |
| WarningSalesPriceInvalidName | String | Item has an incorrectly formatted sales price. | |
| WarningSalesPriceInvalidValue | String | Provided value that caused the validation issue. | |
| WarningSalesPriceTooLowName | String | Item has a sale price value that is discounted very low compared to the price. | |
| WarningSalesPriceTooLowValue | String | Provided value that caused the validation issue. | |
| WarningSalesPriceTooHighName | String | Item has a sale price value that is higher than the original price of the item. | |
| WarningSalesPriceTooHighValue | String | Provided value that caused the validation issue. | |
| WarningSaleDateInvalidName | String | Item has a sale_price_effective_date value that is formatted incorrectly, this item will be published without a sale date. | |
| WarningSaleDateInvalidValue | String | Provided value that caused the validation issue. | |
| WarningShippingInvalidName | String | Item has a shipping value that is formatted incorrectly. | |
| WarningShippingInvalidValue | String | Provided value that caused the validation issue. | |
| WarningShippingHeightInvalidName | String | Item has an incorrectly formatted shipping_height value. The value must first contain a numeric value then a valid dimension unit type. | |
| WarningShippingHeightInvalidValue | String | Provided value that caused the validation issue. | |
| WarningShippingWeightInvalidName | String | Item has an invalid shipping_weight value. | |
| WarningShippingWeightInvalidValue | String | Provided value that caused the validation issue. | |
| WarningShippingWidthInvalidName | String | Item has an incorrectly formatted shipping_width value. The value must first contain a numeric value then a valid dimension unit type. | |
| WarningShippingWidthInvalidValue | String | Provided value that caused the validation issue. | |
| WarningSizeTypeInvalidName | String | Item has a size type value that is formatted incorrectly, which may limit visibility in recommendations, search results and shopping experiences. | |
| WarningSizeTypeInvalidValue | String | Provided value that caused the validation issue. | |
| WarningTaxInvalidName | String | Item has a tax value that is formatted incorrectly. | |
| WarningTaxInvalidValue | String | Provided value that caused the validation issue. | |
| WarningTitleLengthTooLongName | String | The title for the item was truncated because it contains too many characters. | |
| WarningTitleLengthTooLongValue | String | Provided value that caused the validation issue. | |
| WarningTooManyAdditionalImageLinksName | String | Item has a additional_image_link value that exceed the limit for additional images, this item will be published without some of your images. | |
| WarningTooManyAdditionalImageLinksValue | String | Provided value that caused the validation issue. | |
| WarningUTMSourceAutoCorrectedName | String | Item includes an utm_source value that is formatted incorrectly and has been automatically corrected. | |
| WarningUTMSourceAutoCorrectedValue | String | Provided value that caused the validation issue. | |
| WarningWeightUnitInvalidName | String | Item has a weight_unit value that is formatted incorrectly, this item will be published without a weight unit. | |
| WarningWeightUnitInvalidValue | String | Provided value that caused the validation issue. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AdAccountId | String | Unique identifier of an ad account. | |
| ItemValidationIssue | String | Filter item validation issues that have a given type of item validation issue. |