Inventory Control

Technologies

PHP 7, CakePHP 4, MySQL, Bootstrap 5, HTML5, jQuery, REST API

Description

Inventory control is an online web application that is used to fetch products and product related information from inventory softwares or websites of famous brands like Sherri Hill, Jovani, Mac Duggal, Roberta Biagi etc. The brand website are built in various platforms i.e. Microsoft .Net, React Js, Magento etc and they are password protected. The Inventory Control bypasses the login, fetches the HTML and extracts data from it. Inventory Control communicates between Databases to update the data. DB to DB makes the updates faster and reliable.

This application successfully updates
  • Collections
  • Products
  • Categories
  • Product Information, stock and price
The application has features
  • Automatic Sync
  • Manual Sync
  • Sync on the fly
  • Handles existing and future stock
Apart from automatic sync from brand’s online software, the application also used to manually manage:
  • Products
  • Categories
  • Collections
  • Images
  • Brands
  • Colours
  • Sizes
  • Managing products with CSV upload. 
Inventory Control has the capability to update various CMS/eCommerce systems
  • WordPress/WooCommerce
  • Shopify
  • Magento 

Apart from the above the system reports all the Error and Warning to the administrator. The system sends notification emails in a frequency to the administrators of the application.

The major notifications are
  • If a brand changes the password of their online software.
  • If the brand’s online software is down or not responding.
  • If any Product is missing Price, Images, Variations, Stock etc.
  • If there is any new colour that needs Hex code to be updated.
  • If a new collection is added by a brand.