Catalog Feed Upload Debug Guide

When uploading a CSV for your DPA catalog, you may encounter failures due to formatting or logical issues in your file. Below are common causes and how to resolve them:

CSV Upload Rejection FAQ

When uploading a CSV for your DPA catalog, you may encounter failures due to formatting or logical issues in your file. Below are common causes and how to resolve them.

    Price Is Zero
  • Issue: price must be a positive value. A zero price is not allowed.
  • Resolution: Ensure all price values are greater than zero.

    Sale Price Is Greater Than or Equal to Price
  • Issue: salePrice must be less than price.
  • Resolution: Adjust your salePrice so it is strictly lower than price.

    Sale Dates Present Without Sale Price
  • Issue: If salePrice is null, then salePriceStartDate and salePriceEndDate must also be null.
  • Resolution: Either provide a valid salePrice or remove the sale dates.

    Using the Wrong Delimiter
  • Issue: Delimiter in the CSV doesn’t match the one selected in Catalog.
  • Resolution: Ensure the delimiter (e.g., comma, tab) matches the configuration in the Catalog UI.

    Duplicating Columns
  • Issue: Column names are duplicated.
  • Resolution: Each field should be unique and not repeated. Do not introduce any new field names.

    Mixing Up Item ID and Variant ID
  • Issue: itemId and id fields are swapped or misused.
  • Resolution:
  • itemId refers to the product (e.g., a t-shirt).
  • id refers to the variant (e.g., size or color).
  • You can have one itemId with multiple id values.

    Case Sensitivity Issues
  • Issue: Input is case sensitive.
  • Resolution: Follow exact casing as required. Field values (e.g., ADULTS, FEMALE) must be in all caps where specified.

Use cgbot in slack to help verify your feed before upload!
cgbot, please verify this feed 
id	name	itemId	price	salePrice	salePriceStartDate	salePriceEndDate	isAvailable	webUrl	description	brand	categoryId	primaryImageUrl	additionalImageUrls	primaryVideoUrl	additionalVideoUrls	ageGroup	gender	multipackQuantity	isBundle	rating	numberOfReviews	rewardPercent	rewardStartDate	rewardEndDate	labels
variantId1	variantName	itemId1	100	90	2024-11-10T15:30:00		TRUE	https://webUrl.com?a=1	description	brand	1	https://imageUrl.jpg?a=1	https://imageUrl2.jpg?a=1;https://imageUrl3.jpg?a=1	https://videoUrl.mp4?a=1	https://videoUrl2.mp4	KIDS	UNISEX	2	FALSE	4.73	100	10			label1;label2
variantId2	variantName	itemId1	100	90	2024-11-10T15:30:00		TRUE	https://webUrl.com?a=1	description	brand	1	https://imageUrl.jpg	https://imageUrl2.jpg?a=1;https://imageUrl3.jpg?a=1	https://videoUrl.mp4?a=1	https://videoUrl2.mp4	KIDS	UNISEX	2	FALSE	4.73	100	10			label1;label2
variantId3	variantName	itemId2	100	90	2024-11-10T15:30:00		TRUE	https://webUrl.com?a=1	description	brand	1	https://imageUrl.jpg	https://imageUrl2.jpg;https://imageUrl3.jpg	https://videoUrl.mp4?a=1	https://videoUrl2.mp4	ADULTS	UNISEX	2	FALSE	4.73	100	10			label1;label2