How to design an online warehouse?

Question

PHP

I am making an accounting system for a company. Now I am engaged in a warehouse, sales, purchases and expenses about a warehouse. I am looking for the best solution for calculating the actual quantity of goods. The system is connected to the online store.
Suppose a company sells T-shirts and sometimes prints pictures on them. In addition to T-shirts, there are company consumables in the warehouse, which are sometimes sold - for example, cartridges.
The system keeps records of all purchases, sales, movements and other actions with the warehouse. There are several "warehouses" in the system, i.e. product locations.

1. The product has mandatory parameters that must be selected when selling or purchasing.
   For T-shirts, this is the size and color. Cartridges have a parameter "amount of ink" (can be "empty" or "full"). Even empty ones must be taken into account, but full ones can be used or sold.
   
2. The set of parameters depends on the category in which the product is located. In this example, there are only 2 categories - T-shirts and cartridges.
   
3. The product may have a limited range of colors. For example, Metallica No. 3 jerseys are only available in black and cannot be sold or accidentally bought in, say, pink.
   
4. In addition, the product (name, to be more precise) has a set of properties by which the user finds them through a filter on the store's website: brand, print type.
   

Actions:

1. Sales, purchases, transfers between warehouses
   
2. Refilling cartridges - was "empty", became "full"
   

What to count:

1. Need to know how many green "Hello Kitty" XXL T-shirts are currently in stock #1.
   
2. You need to know how many Metallica T-shirts of all sizes have been sold in the last 16 days (since the date of the last purchase). Or last month. Or from December 30th to January 1st. In general, you understand :)
   
3. It is desirable to show the current quantity immediately in the list of goods (if the warehouse is not selected, then the sum for all warehouses) (yes, each line will have its own set of parameters (this is just a matter of the speed of the database selection algorithm)
   For example: Green, XL = 3pcs | Green , L = 4pcs | Red, L = 5pcs
   
4. For each item, you need to have a history of events - when, how much and what type of units of goods were sold-bought-moved. You need to know the event type and id.
   

Interested in exactly how to count the quantity of goods with a bunch of parameters, having information about purchases and so on.
I would be glad if you can suggest a good example of the implementation of such a system, which describes in detail what is here and why.
PS. DB - MySql, PHP-engine - Laravel 4.2
PSS. 1C do not offer! Thanks :)

Answer 1

Store current balances for each commodity item + history of "arrival/departure" operations
From the point of view of warehouse balances, it is logical to consider MetallicaGreenXL, MetallicaGreenL, MetallicaRedL as 3 different goods.
For convenience, you can store an additional data structure that combines 3 of these products into a single Metallica group.
In general, honestly, I do not advise to fence the bike in this case. Take some kind of 1C, it has been done conveniently and understandably for a long time. It costs a penny, api outside is also not a problem.

Answer 2

TOR for the detected project. Well, then you know where to go with him?)

Answer 3

Make integration with 1C-Sklad, it will be much easier and faster

Answer 4

Why invent a lisaped when there is already 1C Warehouse and others ...

Answer 5

In 1Ske, the problem with "Hello Kitty" T-shirts in "XHL" size is solved through the properties of the nomenclature.
Those. in the reference book there is Mike's nomenclature, it has all sorts of possible characteristics.
But at the time of arrival of the goods, or sale, it is necessary to put down a characteristic.
Now further: if an ordinary T-shirt initially came, and then you need to print on it, then you need to make a "Production" document, which will consume ink and the work of the master, but the output will be a "Hello Kitty" T-shirt
Look, there seems to be a service "My warehouse "or something like that, he has to solve these problems.
Also, these tasks can be solved through 1Sku.