Skip to content

Pawan Kumar / public

Go to a project
Issue #2 opened by

Products Catalogue App

PROBLEM STATEMENT

Given an excel sheet (ES) (in .xlsx format) filled with products for a customer, C.
Parent Code field refers to whether a variant / product has a parent of not. If Parent Code is found then it implies the current product is a child of parent product referred by the code, Parent Code value.
Enable column activates / deactivates a given product. It has Yes / Y value to make the product active else in-active.

You need to write a small web based application with database backend of your own choice (RDBMS/NoSQL any database) answering the below questions,

0) Load the products shown in the below excel using any excel reader library (or your own custom reader) of your choice
1) Given a product name or product code, find the top-most parent of it by its name.
2) Given a product name, display the name of all of its children in sorted order.
3) Display a count of active and in-active products.
4) Display the value of average product price per Category L1 and Category L2

Excel sheet is attached for reference.

items.xlsx

Total time allowed: 2 Hours 30 minutes when doing in the office OR 1 Day when its being attempted at home.

Submission

The solution to be submitted via Github project with README instructions on how to run the program.

Marking Scheme for the solution

a) Correctness of the solution
b) The overall algorithm / program must be optimised
c) Usage of standard coding practices
d) Support the solution by unit tests, if possible

Markdown is supported
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!