it’s ok an SQL script if you have one to share! 😃

Thank you again!

Hello,

The real quantity is tracked with purchase_items’ quantity balance column.

If you want to get the total then you can use sum like

SELECT SUM(quantity) from sma_products;

Thank you

Thank you for your quick reply!

What i’ll need is a way to recount then quantity showed in sma_products for each single product.

My scenario: Product1 has a quantity of 1300 in sma_products. I want to recount 1300 from the other tables in DB to check its integrity.

so i’ll need to calculate form quanty adjustment and purchases for products and relative variants… i do not use sell product

thank you in advance

add a question: what is Quantity_balance? in my DB i have some row with quantity_balance greater than quantity total or negative in some case…

Example: Productpurchase1 quantity 3600, quantity_balance -320000 or Productpurchase2 quantity 2400, quantity_balance 8312… is it ok?

Thnak you again!

Hello,

I didn’t understand your use case.

We don’t offer support for modifications and modified versions. You are allowed to modify the item as you need as per license at your own risk.

The quantity_balance is the column in the sma_purcahse_items that is used to calculate the product quantity and costing. It could have -ve values if the overselling is enabled but it should not have greater value than quantity in the same table. If it has that might be caused by some bug/errors.

Thank you

Hi, thank you. I’m not working on a modified version… i’m only trying to understand how it works. 😃

Can you explain how the system calculate the quantity on sma_products? and how calculate quantity_balance on sma_purchase_items?

What happen if i insert a purchase with a retro date respect another purchase with same products not completed??

Thank you again!!

Hello,

System set the quantity_balance on sale and others are update accordingly. The add purchase won’t have any effect as the quantity will be consider as quantity_balance and for only completed/partial purchases. If the purchase is not completed the purchase_item won’t be considered as received so it will be just a record without any other action on stock.

Thank you

ok… so quantity_balance is the real amount of pieces in warehouse, right?

Yes, that the real quantity.

ok… so… it is the TOTAL amount of pieces of a product? but if is it true, it could be greater than quantity in the same row… maybe i don’t understand.

or the TOTAL quantity is the sum (+/-) of quantity_balances in other tables (purchases, variations, sales)??

so… quantity_balance is present only in sma_purchase_item?? or there are other columns in other tables in DB with this value?

thank you!