OMS CSV Upload Errors

Modified on Fri, 16 Dec, 2022 at 3:59 PM

Flow	Error Message	Reason	Resolution
Add Products	Duplicate entry found for client SKUs:	The same SKU is present multiple times in the sheet	Remove the multiple occurrences of Client SKU from the sheet
	Mapping already exists for clientId and client SKUs:	The Client SKU data corresponding to the client is already present in the system	Remove the Client SKU ID entry from the sheet and upload
	Total items should be greater than or equal to 1	At least 1 entry should be present in the sheet	Check the file to being uploaded for data
	Total items should be less than or equal to 50000	Only 50000 SKUs can be uploaded at once	Only upload data with lines <=50000
	Error In Reading File	Some of the fields may be null	Check for the file format or if any field value is null

Update Products	Duplicate entry found for client SKUs :	The same SKU is present multiple times in the sheet	Remove the multiple occurrences of clientSku from the sheet
	Mapping for client Id: and clientSkuIds: not present	The Client SKU corresponding to the client is not present in the system	Check for the client SKU and upload the client SKU first. Client SKU ID must be of a valid format and should not have any decimal values.
	Total items should be greater than or equal to 1	At least 1 entry should be present in the sheet	Check the file to being uploaded for data
	Total items should be less than or equal to 50000	Only 50000 SKUs can be uploaded at once	Only upload data with lines <=50000
	Error In Reading File	Invalid file format or field values	Check for the file format or check for the field value types(integer/string)

Reservation Upload	The file contains duplicate clientSkuIds :	The same SKU is present multiple times in the sheet	Remove the multiple occurrences of Client SKU from the sheet
	Mapping not present for clientSkuIds :	Master data is not uploaded for the Client SKU	Check if the SKU is valid or upload the master data
	Not enough quantity in pool	No inventory exists for the SKU and given From Pool	-
	Error parsing the CSV : exception	Invalid file format/Invalid data	Check for the correct format or if field values are correct
	Record limit exceeded the max size of 5000	Only 5000 entries are allowed in the file	Update the file to consist of only 5000 rows

Inward/Outward PO [Single Order]	Error in reading file : (line number)	Some of the fields are null or invalid data type	Check and update the invalid fields
	Input Validation Failed	- Order Quantity is less than 1 - The selling Price Value is null	Check and update all ordered quantity values less than 1(line item wise) and selling price with a null value
	Record limit should be greater than or equal to 1	Order file should have at least 1 line item	Check if an empty file is being uploaded
	Record limit exceeded the max size of 5000	Only a maximum of 5000 line items can be present for an order	Remove the record lines > 5000, split, and create into multiple orders
	Duplicate entries present for client SKUs :	The same SKU is present multiple times in the sheet	Remove the multiple occurrences of Client SKU from the sheet
	Mapping for client Id: and clientSkuIds: not present	Master data for the Client SKU not present in the system	Check for the valid SKU and upload master data values

Inward/Outward PO [Multiple Order]	Error in reading file : (line number)	Some of the fields are null or invalid data type	Check and update the invalid fields
	Input Validation Failed	- Order Quantity is less than 1 - The selling Price Value is null	Check and update all ordered qty value less than 1(line item wise) and selling price with a null value
	ChannelOrderId can't be empty	Channel Order ID field is empty for a record	Update Channel Order ID field if any record has value as null in this field
	Record limit should be greater than or equal to 1	Order file should have at least 1 line item	Check if an empty file is being uploaded
	Record limit exceeded the max size of 50000	Only a maximum of 50000 records can be present in a file	Update file to consist of only 50000 rows
	Duplicate entries present for channel order: clientSku combination -	For a Channel Order, multiple entries for the same Client SKU ID present	Remove the Channel Order wise duplicate entries for the given Channel SKU
	Order Line Item count exceeded the max size 5000 for channelOrderIds :	The allowed maximum Line item count for each Channel Orders is 5000 , and current file has more than 5000 line items for the given Channel Order	Remove and create a new order for the Channel Orders
	Mapping for client Id: and clientSkuIds: not present	master data not present for given Client SKU	Please check for the given Client SKU and add master data