Convert CSV to XML Product Feed
How to convert data from a CSV to XML?
- Prepare your CSV file:
Create a CSV spreadsheet, following the proposed ñolumn mapping. - Enable the “Import from a CSV” option on the Data Source settings tab:
Once you enable this option you can specify the file URL or upload it from your device (direct upload only applies to Public Free and Static Pro plans). - Setup other necessary and/or related file generation settings and defaults (optional).
- Start your service.
Column Mapping of CSV File for Product Feed Generator
Required fields & explanations of spreadsheet columns:
| Element name | Description | Is this required |
| URL | Valid column names: url, product_url, link Recommended content type: String Description: Product page URL | Required It is allowed to use a URI relative to the website domain |
| Name | Valid column names: name, title Recommended content type: String Description: Product Name | Required |
| Id | Valid column names: id, sku Recommended content type: String Description: Unique Product Identifier | Not required Google XML: Yandex YML: |
| Brand | Valid column names: brand, vendor Recommended content type: String Description: Brand Name | Not required |
| Barcode | Valid column names: barcode, gtin, isbn, ean, upc, jan Recommended content type: Integer Description: Product Global Trade Item Number | Not required |
| Price | Valid column names: price, regular_price, prc Recommended content type: Integer Description: Product price | Required |
| Discounted price | Valid column names: sale_price, saleprice Recommended content type: Integer Description: Product reduced price | Not required |
| Currency | Valid column names: currency, pricecurrency, cur Recommended content type: String Description: Currency code – USD, EUR, RUR, RUB, UAH, BYN, KZT | Not required If there is no - the value of the main currency specified in the settings is assigned |
| Description | Valid column names: description, desc Recommended content type: String Description: Product description | Not required Used when enabling the corresponding option in the settings You can use line breaks and HTML markup |
| Image | Valid column names: picture, image, image_link Recommended content type: String Description: Image file URL | Not required Used when enabling the corresponding option in the settings It is allowed to use a URI relative to the website domain |
| Category | Valid column names: category, cat, cat_name Recommended content type: String Description: Product category name | Not required If not present – the value of the main currency specified in the settings is assigned. |
| Color | Valid column names: color Recommended content type: String Description: Product color name | Not required |
| Size | Valid column names: size Recommended content type: String Description: Size for products of clothing and footwear categories | Not required |
