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 sheetRemove 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 systemRemove the Client SKU ID entry from the sheet and upload
Total items should be greater than or equal to 1At least 1 entry should be present in the sheetCheck the file to being uploaded for data
Total items should be less than or equal to 50000Only 50000 SKUs can be uploaded at onceOnly upload data with lines <=50000
Error In Reading FileSome of the fields may be nullCheck 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 sheetRemove the multiple occurrences of clientSku from the sheet
Mapping for client Id: and clientSkuIds: not presentThe Client SKU corresponding to the client is not present in the systemCheck 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 1At least 1 entry should be present in the sheetCheck the file to being uploaded for data
Total items should be less than or equal to 50000Only 50000 SKUs can be uploaded at onceOnly upload data with lines <=50000
Error In Reading FileInvalid file format or field valuesCheck 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 sheetRemove the multiple occurrences of Client SKU from the sheet
Mapping not present for clientSkuIds :Master data is not uploaded for the Client SKUCheck if the SKU is valid or upload the master data
Not enough quantity in poolNo inventory exists for the SKU and given From Pool-
Error parsing the CSV : exceptionInvalid file format/Invalid dataCheck for the correct format or if field values are correct
Record limit exceeded the max size of 5000Only 5000 entries are allowed in the fileUpdate 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 typeCheck 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 1Order file should have at least 1 line itemCheck if an empty file is being uploaded
Record limit exceeded the max size of 5000Only a maximum of 5000 line items can be present for an orderRemove 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 sheetRemove the multiple occurrences of Client SKU from the sheet
Mapping for client Id: and clientSkuIds: not presentMaster data for the Client SKU not present in the systemCheck 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 typeCheck 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 emptyChannel Order ID field is empty for a recordUpdate Channel Order ID field if any record has value as null in this field
Record limit should be greater than or equal to 1Order file should have at least 1 line itemCheck if an empty file is being uploaded
Record limit exceeded the max size of 50000Only a maximum of 50000 records can be present in a fileUpdate 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 presentRemove 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 OrderRemove and create a new order for the Channel Orders
Mapping for client Id: and clientSkuIds: not presentmaster data not present for given Client SKUPlease check for the given Client SKU and add master data

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article