--- schema_version: "1" id: b9087a6e2e5d2a3c19be5622f65bc9b8967ca74e35da93ac8185df2358d74de9 title: Catalog Localization ETL Data Feed collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_pers_etl_catalog_localization_data_feed.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_catalog_localization_data_feed.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 8bcb7ba373154f6196ca0384e3912416ec6a751ba2d294e562b45b07dcb255d2 description: Use the Catalog Localization ETL data feed to localize data for items in your catalog. products: - Marketing - Salesforce Personalization release: "264" --- # Catalog Localization ETL Data Feed Use the Catalog Localization ETL data feed to localize data for items in your catalog. ## About Ingesting Catalog Localization Data Personalization supports the localization of catalog items, which allows unique data for specific fields to be stored based on the language and country codes. The locale-specific data can then be leveraged on site (provided you are tracking users' locale information on your website using the sitemap) to display catalog object information with the locale-specific data for the catalog item. The Catalog Object Locale ETL allows for the ingestion of locale-specific catalog object information for Articles, Blogs, and any user-created catalog object. Promotions do not support localized attributes. The Catalog Object Locale ETL should be used in conjunction with a Catalog Object ETL or another method of populating catalog object items in the catalog. ## Ingestion Considerations - The Catalog object localization setting on the Catalog and Profile Objects settings screen must be turned on for the Catalog Object Locale ETL to function. - Only certain catalog object attributes support localized values (Name, Description, URL). - Localization is not supported for custom attributes or related catalog objects. - If an item is included in the Catalog Object Locale ETL, but does not exist in the Personalization catalog before ingesting the file, an item with the source ID will be created. However, that item will only have the data in locales which are included in the file. For example, if a dataset is in the default configuration (`en_US`) and a new item with only a locale of `fr_FR` is included, the item will only load data to the `fr_FR` locale – there will not be any data in the `en_US` locale. - Multiple catalog object types can be included in a single file. - Datasets have a default language in Personalization - this is configured in the Catalog Object Setup screen (see [Catalog Objects](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_catalog_object.htm&release=264.0.0&type=5 "Catalog objects and their relationships define the structure of your catalog. Personalization uses catalog objects to interpret and understand customer engagement and affinities. Examples of catalog objects include products, articles, blog posts, categories, brands, styles, and features. Personalization includes several built-in catalog objects, and you can create custom ones to meet your specific needs.")). This information is considered the default locale of the catalog and should be updated by the standard Catalog Object ETL. ## Requirements - Each row requires a catalog object item ID and a locale in the format of "2-letter lower-cased language code", "underscore", "2-letter upper-cased country code". Examples: `en_US`, `fr_FR`, `de_DE`, `en_AU`, and so on. - Each catalog object item should have a single locale per row of the file. Every locale instance of a catalog object item should appear consecutively in the file. - The Catalog Object Locale ETL file needs to be sorted by catalog object type so that all catalog objects of the same type appear in consecutive rows. Sorting can be achieved by the client prior to loading the file into the system. - Supported locales are visible in the platform via the locale drop-down on the Catalog and Profile Objects Settings screen (**Settings > Catalog and Profile Objects**). ## Filename Format `locale-catalog-object-YYYY-MM-DD_HH-MM-SS.csv` ## Schema
Field Name Minimum Requirements Example Values Max Length Personalization Data Type
id Required. Catalog Object IDs must exactly match the catalog object IDs provided on site and captured by Personalization site mapping, as well as IDs provided in your Catalog Object ETL. brand123 255 String
catalogObjectType Required. Catalog Object Type must match one of the catalog object types configured on the Catalog and Profile Objects (see Catalogs, User Profile Objects, and Promotions). It should match the name value of the object type, not the label value. Brand    
locale Required. A 5-character representation of the locale associated with the catalog object item information in the row. The structure of which must be "2-letter lowercased language code", "underscore", "2-letter uppercased country code". en_US, fr_FR, de_DE, en_AU 5 String

System Fields
attribute:name Represents the name of a catalog object. Must contain at least one alphanumeric character. Zapatos 1023 String
attribute:url RFC-3986. Complete URLs that represent the display page for this catalog object. https://example.com/categories/zapatos.html 1023 String
attribute:description Represents the description of the product. Must contain at least one alphanumeric character to be set.

zapatos geniales

 250 String
## Sample File
idcatalogObjectTypelocaleattribute:nameattribute:urlattribute:description
Brand001Brandes_ESBrand Name 1http://www.sample.com/brandName1Really nice brand for athletic apparel
Brand002Brandes_ESBrand Name 2http://www.sample.com/brandName2Luxury brand for fancy occasions
Brand003Brandfr_USBrand Name 3http://www.sample.com/brandName3Comfortable work-wear for the toughest jobs
BlogPost001Blogkr_KRBlog Post Name 1http://www.sample.com/BlogPost1Impact of remote work in the work place
Article001Articleen_AUArticle Name 1http://www.sample.com/Article1Go-to guide for what luxury looks like in the modern age
Article002Articleen_AUArticle Name 2http://www.sample.com/Article2How to dress up athletic wear for your work from home meetings.
#### See Also - [ETL File Requirements](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_file_requirements.htm&release=264.0.0&type=5 "ETL files contain entries such as users, products, subscription list members, promotions, transactions, and more. These files must be in a CSV format and can be encrypted or compressed. The file formats must follow the explicit schema requirements for each ETL data feed. Typically, you upload ETL files automatically using the SFTP site, but you can also manually upload a file.") - [Monitor ETL Feed Jobs on the Feeds Dashboard](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_feeds_dashboard.htm&release=264.0.0&type=5 "The Feeds Dashboard provides details about ETL feed jobs.") - [Limits for Marketing Cloud Personalization](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_limits.htm&release=264.0.0&type=5 "Learn about the limits and capabilities in Marketing Cloud Personalization.")