Hello,

Please let me know your installation link with owner account details in private reply. I will need to check the site before suggesting solution.

_You can post private reply by enabling the `PRIVATE for Staff only` at top right of reply section._

Thank you

**[Rafiqul Hasan](/u/mdrafiqulhasan110)** If you are using an older version, try to update to a recent version. Product sync quantity has been improved on, in recent version of SMA.

Hello,

The issue is due to variants. The quantity is assign to variant and the variant is delete. So all the quantity for product code `75795825` is still assign to variant_id 2294 and as it's delete so system can't select the variants. That causing the issue.

Please keep in mind that SMA has limitation with variants. You can't add and later delete the variants for item. This will cause the issue as now.

You can run the following query after selecting your database

```
UPDATE `sma_purchase_items` SET `option_id` = NULL WHERE `product_id` = '234';
```

> Please keep in mind in future that you can only assign/delete variants at the beginning. Once you have purchased/sold variants there is no way to assign/delete variants to the current quantity. The current quantity will stuck in database as it is now for the warehouse 8 and products 75795825

Thank you

Thank you very much. now i have understood the problem. I will keep it in mind in future.

And i am waiting for a big update with multiple variants selection. I think this limitation should be solved as soon as possible. And i am also keep watching on your MPS . Hope it will be best solution for my business.

Hello,

SMA will need a rewrite for multiple variants so it will take quite long.

MPS has multiple variants feature but that is different item that will be available in Jan 2021.

Thank you