I am wondering if there is a way within the Standard software or an Add-On that would give the ability to automatically change a Products Status (Active, Disabled, Hidden) based upon an X variable?
e.g.
Condition 1
If a defined individual product (Product Listing 1) becomes out of stock due to a completed sale then make that product listing “Disabled” and make another individual product (Product Listing 2) “Active”.
Condition 2
Then when new inventory is added to the (Product Listing 1) it automatically becomes “Active” and (Product Listing 2) becomes “Disabled”.
This would be useful because it means the store can have an “In Stock” listing and a “Pre-Order” listing with different details in the description regarding delivery times etc and the two listing automatically alternate based on the amount of available inventory in the In-Stock listing.
If you combine the DBS, FBOs and ABS schemes - With a single fence from the supplier and shipment from your warehouse and show customers in the product card as available and remote warehouse.
The buyer, when placing an order from one warehouse, is shown one delivery method, and if from both warehouses, then one delivery service can be set up for both warehouses and set the time to move the goods to the goods sorting warehouse.
In this case, when the balances are synchronized and the quantity is zero, the product itself will disappear from the showcase
The module is able to hide goods from the showcase for buyers if delivery is not available for the buyer’s city
I’m witRe-read your request and suggested that maybe you need to study this addon.
If we understand you correctly, then you sell several products as one and you will need to make one e from two parts if one is finished then turn off, and when you reappear in the warehouse turn it on. Faithfully?
The fn_change_order_status function (app/functions/fn.cart.php) is used to change product inventory after sale. You can use hooks in this function to check new inventory amount and make necessary actions
Thanks for all the replies everyone, I have been working my way through the different suggestions, I like the database triggers suggestion from harmsmitsdev that might do the trick, something new to learn.