Upload your product catalog manually in YBM Connect, review the validation results and confirm the changes before they are applied.
Before you upload
Manual upload lets you test a file or apply a one-time catalog update. It uses the catalog formats described on the catalog pages and lets you review the result before applying any changes.
- File type:
.csv - Maximum file size: 5 MB
- Encoding:
utf-8orlatin1(ISO 8859-1) - Delimiter: comma
, - Quoting: use
"around values containing commas, quotes or line breaks; escape a quote inside a quoted value as"". - Include one header row. It is skipped by the importer, but values are mapped by their column position, not by the header names.
Use the v5 catalog format for new product catalogs. Existing integrations may continue using their configured v3 or v4 format. Do not reorder columns, insert columns in the middle, or use a spreadsheet export that changes the delimiter or encoding.
Required product data
Every usable v5 product needs a Product ID, Product name and Category name. A Category ID is optional when the category name is provided.
The remaining fields depend on the product. Follow the permitted values and formats in the v5 catalog format, v4 catalog format or v3 catalog format you use.
Multiple bundles for one product
Use multiple consecutive rows with the same Product ID to provide several bundles for one product. Apart from the bundle columns, all values in these rows must be identical. Do not repeat the same Product ID later in the file with different data: the importer cannot safely decide which version is correct. Keep all non-bundle values identical so that additional bundle rows are not ignored.
Analyze, review and confirm
- Upload the CSV file and select the matching encoding.
- Select Analyze. The system checks the data and reports row-level errors where it can.
- Review new products, changes to existing products and any missing products.
- Select Confirm only after reviewing the result. No changes are made before this confirmation.
If the preview reports an issue, correct the source file and analyze it again. Common causes are a changed column order, missing required product data, or repeated product IDs with different product details. Use the matching template and keep multiple bundle rows for one product next to each other.
Some optional values that cannot be converted, such as an invalid country code, year or weight, may be left empty rather than causing a blocking row error. Check the detailed preview for the final values that will be imported.
Delete missing products
The optional Delete missing products setting treats your file as a complete catalog snapshot. Products that currently exist in YBM Connect but are not in the file appear in the preview as missing and are marked deleted when you confirm the import.
Leave this setting off for a partial update.