Jump to content

Edit History

madpugger

madpugger


update table entries

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!

madpugger

madpugger

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_idwi_warehouse_idint(11)Add attribute to SQL querywi_product_idint(11)Add attribute to SQL querywi_attribute_idint(11)Add attribute to SQL querywi_physical_quantityint(11)Add attribute to SQL querywi_available_quantityint(11)Add attribute to SQL querywi_reserved_quantityint(11)Add attribute to SQL querywi_shelf_locationvarchar(20)Add attribute to SQL querywi_quantity_to_shipint(11)Add attribute to SQL querywi_warning_stock_levelint(11)Add attribute to SQL querywi_use_config_warning_stock_levelint(11)Add attribute to SQL querywi_ideal_stock_levelint(11)Add attribute to SQL querywi_use_config_ideal_stock_levelint(11)Add attribute to SQL query

×
×
  • Create New...