WebSVN – SmartDukaan – Diff – //trunk/Support/src/main/java/in/shop2020/support/controllers/SnapdealListController.java

 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
 		for (int iterator=(sheet.getFirstRowNum()+1);iterator<=sheet.getLastRowNum();iterator++){
 			SnapdealItem snapdealItem =null;
 			Item item = null;
 			Long sku;
+			boolean new_item = false;
 			if (checkEmptyString(sheet.getRow(iterator).getCell(0))){
 				continue;
+			}
 			else {
 				sku=(long) sheet.getRow(iterator).getCell(0).getNumericCellValue();
 				} catch (CatalogServiceException e) {
 					sb.append(sku + " Item not Present"+"\n");
 					continue;
+				}
 				if(snapdealItem.getItem_id()==0){
+					new_item = true;
 					snapdealItem = new SnapdealItem();
 					snapdealItem.setItem_id(sku);
+				}
+			}
+			if (checkEmptyString(sheet.getRow(iterator).getCell(1)) && new_item){
+				sb.append(sku + " New Listing - Warehouse Id not Present"+"\n");
+				continue;
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(1))){
 				long warehouseId = (long) sheet.getRow(iterator).getCell(1).getNumericCellValue();
 				double maxNLC = inventoryClient.getNlcForWarehouse(warehouseId, item.getId());
+				if (maxNLC==0){
+					sb.append(sku + "Max Nlc can't be 0"+"\n");
+					continue;
+				}
 				snapdealItem.setWarehouseId(warehouseId);
 				snapdealItem.setMaxNlc(maxNLC);
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(2))){

Subversion Repositories SmartDukaan