Formular / Script for google sheet for inventory management
Budget: $30 – $250 SGD
i have 2 googlesheet
1 inventory
1 product list
i download it in excel for your understanding.
so in the inventory, we have the datacode, everytime we create a new product, we will increase the number.
the datacode will tagged to the respective product.
when we update the inventory, it should automatic fill in the product list Quantity at column E for (master standard & master special)
the data will be from inventory (balance stock) column K
1 inventory
1 product list
i download it in excel for your understanding.
so in the inventory, we have the datacode, everytime we create a new product, we will increase the number.
the datacode will tagged to the respective product.
when we update the inventory, it should automatic fill in the product list Quantity at column E for (master standard & master special)
the data will be from inventory (balance stock) column K