Stock Control Grouping Products of the same type

Asked

Viewed 74 times

1

I am producing a stock control system, but the stock needs to have a product grouping system with the same SKU, example, I have a product called "T-shirt A", but there are several types of "T-shirts A", I have different sizes, but grouping by SKU.

How could I do it so as not to compromise control?

Ex: When leaving a product with SKU "sk001" size "M" do not influence the stock control of the products with SKU "sk001" size "G".

php mysql laravel logic e-commerce

  • Why not create a table focused on SKU Stro and one to relate the two? so you’ll get the system working and you’ll get to have the grouping by SKU

  • Just so I understand better, before answering, SKU is a kind of category where the various items have the same SKU, correct ?

  • How? Could you give me an example of this? As if at the time I was going to show the products on the screen, I searched all the SKU giving a Join in the product table (and there with the respective attributes?). But then how would it look in the table of releases? Because I need to register the products that are coming out, right?

  • in fact SKU is a kind of product identification within the stock, is type the ID, example, I have la Shirt A, size P, sku 'aaabr22', ai ai eu teria la shirt A, size M, SKU 'aaabr22' and so on

  • https://uolhost.uol.com.br/faq/v2/loja-virtual/o-que-e-sku-de-um-producto-da-minha-loja-virtual.html#rmcl Here’s what you need to know

  • Yes I read, the SKU is basically a uuid, in its example and divergent, but we can do what I said attach a SKU id to a stock item, when searching for the sku in question via see all the items / drive. this system is just stock control ? has control of notes or something else ?

  • Let’s go continue this discussion in chat.

Show 2 more comments

1 answer

1


Hello, come the solution we discussed in chat, we decided to change the structure of the project a little.

Where we will add the field of sizes if related to the categories of products, so when castrating a drive it will automatically load the possible sizes, so that at the time of registration of some stock movement does not occur problems, and with this change it works as necessary for the control of the stock.

chat For more information I recommend reading the chat

Browser other questions tagged php mysql laravel logic e-commerce

You are not signed in. Login or sign up in order to post.