How to organize the structure of stores?

Question

Django

Good day.
I have such a situation. There are five online stores with a common warehouse. But for different stores, price parameters (sales prices, discounts, etc.) for products may be different. How can I organize a database and connect it with stores so that everything works correctly? Well, that is, if a customer in store A bought 5 units of product X, then in other stores (in which this product is present), the total quantity of this product decreased by 5. For these 5 stores, there should be one back office, or a separate Appendix.
Maybe someone faced a similar issue, or just have an idea. I will be very grateful for your help.
P.S. The site itself is one store on Django-Oscar.
P.P.S. Sorry for the oh bad Russian.

Answer 1

And what's the problem then? Of course, I'm not a great specialist, but let's say there is a table of goods in the warehouse with the fields ID, Name, Count. And for each store there is a plate with the fields ID_product, Price, Sale. When adding goods to the warehouse, we add a line to the store signs with the necessary prices \ discounts \ comments, and take the quantity from the warehouse table.