Search the Community
Showing results for tags 'order prep'.
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 18.104.22.168 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!
Hi, I am looking for a module, or an SQL query that will show all orders that can be fulfilled today with the stock we currently have. For example, perhaps we have had a delivery of goods and I want to know which back orders can now be processed. PS must already have this basic functionality, as when an order is placed, it will automatically select Payment Accepted or In Back Order as the order status depending on stock levels. So what I want is to use this functionality at a later date, not just when the order is placed. Surely we are not the only people who would find this useful!