test

public class FileCSVReader {


    List<Category> listCategory = new ArrayList<>();
    List<Brand> listBrand = new ArrayList<>();
    private Category category;
    private Brand brand;
    private Product product;


    public static void main(String[] args) throws IOException {

        FileCSVReader fileCSVReader = new FileCSVReader();
        fileCSVReader.readCSVFile("sample.csv");

    }

    public void readCSVFile(String fileName) throws IOException {

        try (
                Reader reader = Files.newBufferedReader(Paths.get(fileName));
                CSVParser csvParser = new CSVParser(reader, CSVFormat.DEFAULT);

        ) {

            int rowNumber = 0;
            for (CSVRecord csvRecord : csvParser) {
                rowNumber++;

                if (rowNumber >= 7) {
                    listCategory.add(createCategory(csvRecord));
                    createBrand(csvRecord);
                    createProduct(csvRecord);

                }


            }
            System.out.println(listCategory);
        }

    }

    public Category createCategory(CSVRecord csvRecord) {

        category.setName(csvRecord.get(3));
        category.setNameLocaleUA(csvRecord.get(3));
        category.setNameLocaleRU(csvRecord.get(3));
        category.setCategoryPageUrl(csvRecord.get(52));
        category.setCategoryPageUrlLocaleUA(csvRecord.get(54));
        category.setCategoryPageUrlLocaleRU(csvRecord.get(55));
        category.setExternalId(csvRecord.get(53));

        return category;

    }

    public Brand createBrand(CSVRecord csvRecord) {
        brand.setExternalId(csvRecord.get(48));
        brand.setName(csvRecord.get(49));

        return brand;

    }

    public Product createProduct(CSVRecord csvRecord) {

        product.setBrandExternalId(csvRecord.get(48));
        product.setCategoryExternalId(csvRecord.get(53));
        product.setEAN(csvRecord.get(10));
        product.setImageUrl(csvRecord.get(51));
        product.setName(csvRecord.get(50));
        product.setProductPageUrl(csvRecord.get(25));
        product.setExternalId(csvRecord.get(9));

        return product;

    }


}