Quote Originally Posted by balihr View Post
IMO, you'll need to get your hands dirty and get the coding done. A simple approach would be to add 2 more fields (let's say qty1 and qty2) in the database and add logic to update products_quantity based on the values in those fields. Javascript can do it in admin product page.
As for frontend, you'd need a new function that would be called during checkout_process - you could for example use NOTIFY_CHECKOUT_PROCESS_AFTER_SEND_ORDER_EMAIL notifier to get this part done. This would be a bit more fun because you need to run through all products and be careful not to go into negative values (for example, qty1 is 2, qty2 is 5, ordered 4).
Using these fields for Google will require your GPSF module to be modified, just like you'll need custom code for delivery dates per location.

Don't forget to handle cases in admin when order is cancelled or deleted and you need to restock.
Thank you for your suggestions.
Qty1 and Qty2 are in DB and IMS update data in these fields from each location. That's done.

GPSF will take data from these DB columns for qty1 and qty 2 for each location. That's done.

I have qty1 and qty 2 fields on edit product page and it's inserting/updating values fine. That's done.

What I am trying to achieve now is :

When customer complete checkout it should substract from qty1 field by default unless it is 0 than from qty 2 but for available stock check it should take qty1 + qty 2 = total quantity instead of just qty1 field. I am thinking to mark zc default qty as qty1 to simplify as zc by default subtract from it. So just need to add/update code to include qty from qty2 field and apply check to subtract qty from qty 2 when qty1 is <1.

So I think somewhere on front end where Available quantity check is that's what need to be customized to achieve. Site is using One page checkout. Any idea which files/code need to be customize in there.