Website Inventory Management

[Jignasha22]

SUMMARY:

• Admin can upload CSV file for inventory data from uploader.

• End user can see the information of inventory.

• inventory data can be also update using his inventory API.

• Design screenshot

• Flow Diagram

Inventory Schema:

• sku, attr_color, attr_style, attr_size, qty_on_hand, qty_on_po.

Development Part

• Display Purpose
  • Admin upload CSV file for inventory data and map uploaded CSV data with system schema.
  • Mapped data will be saved in a database then jobqueue will process that mapped data to update product details on elastic search.
  • with the help of pdm API product inventory data can be displayed on our website.
• Client API
  • Admin will configure API and schedule when to update inventory data through his API
  • From client API map JSON/XML data with system schema and store into database then jobqueue will process it to update product details on elastic search

---

Prerequisite:

• Functionality must be working.

User Story Description:

• As a user, I should be able to upload Cloudinary account.
• A user will provide cloudinary access keys in settings
• There should be csv upload feature, which allows to upload files on user's cloudinary account

Environment Applicable:

• Windows desktop OS
• Windows Server OS
• Linux

[Zalasanjay]

• Inventory method is added to the home page.
• inventory CSV file mapping and uploading done.
• CSV validation at client-side and server-side completed.
• normal flow completed with website inventory CSV upload.

[Zalasanjay]

• To update inventory information user needs to upload just one file( no needs to go through whole uploader flow), by using the inventory method.

[emp005169]

Jignasha - get its website corresponding display changes implemented also

[emp005169]

assigning to priyank - implement and move for qa after review.

[priyank26]

• "check inventory" in product detail page
  • click on check inventory
  • put validation for color and quantity
  • check stock with given inventory data