Hi, thanks in advance for any help!
I am trying to come up with a SQL query for order prep that will give a list of un-fulfilled orders that we currently have stock for (so for example we've just had a big delivery, will we now be able to ship some orders?).
One thing to note, I am using (the decidedly awful!) Boostmyshop Advanced Stock Management in 1.7.8.2 since multi-warehouse is not available.
As far as I can figure out, I need to Select all order IDs for orders that are not shipped and where all items in order detail for that order are in stock in a particular warehouse.
The warehouse table in Boostmyshop is:
pr_bms_advancedstock_warehouse_product
And has the tables:
- wi_id
- wi_warehouse_id
- wi_product_id
- wi_attribute_id
- wi_physical_quantity
- wi_available_quantity
- wi_reserved_quantity
- wi_shelf_location
- wi_quantity_to_ship
- wi_warning_stock_level
- wi_use_config_warning_stock_level
- wi_ideal_stock_level
- wi_use_config_ideal_stock_level
Again, thanks for any help!