Search the Community

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!

I would like to share with you this problem that I've already found in more Prestashop versions, and I hope we can find together a solution. I'm currently using a Prestashop v.1.6.1.11, here is the process: - I have enabled advanced stock management and created Warehouse 1 and Warehouse 2 - Then I switched in product quantity to advanced stock management. One unit was assigned to Warehouse 1 and the other unit assigned to Warehouse 2, so after this we have: Physical Quantity: 2 Usable Quantity: 2 Real Quantity: 2 Warehouse 1: 1 product Warehouse 2: 1 product (Both warehouses have available all carriers.) - Then I add 2 units of this product to cart and finish an order by bankwire. - After the order I have by default status "Awaiting bank wire" now I will give detail of the quantity after updating order status: Awaiting bank wire: Physical Quantity: 2 Usable Quantity: 2 Real Quantity: 2 Then I update first to Payment accepted, Physical Quantity: 2 Usable Quantity: 2 Real Quantity: 0 Next I update to Processing in progress: Physical Quantity: 2 Usable Quantity: 2 Real Quantity: 0 Next I update to Shipped: Physical Quantity: 2 Usable Quantity: 2 Real Quantity: 0 Next I update to Delivered: Physical Quantity: 2 Usable Quantity: 2 Real Quantity: 0 _____ Problem is that since I updated to status "Processing in progress" Physical and Usable quantity should have been decreased like this: Next I update to Processing in progress: Physical Quantity: 0 Usable Quantity: 0 Real Quantity: 0 So problem seems that when the product stock is divided in different warehouses, and we need to get quantities from both warehouses (to send the order), the Physical and the Usable quantity is not updated (quantity is not decreased) after order status is changed. Have you experienced this problem before? how did you solve it? Thanks to all, Rubén

In our store we do not keep any inventory. We only order based on what customers order. So all my product Quantity stock is 0 at this moment. When our customer orders an item, the stock becomes negative. Suppose the customer order with 11 items of product A and 1 item of product B When we create a supply order for that item, if we enter 0 in Automatically Load Products box, then the prestashop picks all items with 0 quantity. However we need only Those Items which are Ordered by the Customers ( i.e. the products with -ve stock) in this case A -11nos and B -1nos and It should order A 11nos and B 1 nos How to do this. can anyone guide Thanks

Hi, Am searching for SQL commands to completelly reset/delete all stock transactions, warehouses and other related records. We have enabled advanced stock before, but are having issues now. Simply disabling a'advanced stock' doesn't solve our issues. So: Besides truncating some tables (which? warehouses?orders?stock statusses?) , are there any fields we can reset on product level ? Goal would be to have all products quantity set to 0 , and all warehouses deleted. It does not matter if we loose orders and/or customers while deleting these. (Though we do not want to lose our products/categroies setup, or our product combinations, neither our multistore config) Thx in advance.

I want to update the stock in advanced stock qty by uploading quantity from supplier. For us who have also a physical shop I use the normal QTY for that, then i set up different warehouses for each supplier I have which I want to import stock qty from. I have not found any solution for this. Store manager supports import qty but not to a specific warehouse. Really weird that no one have come up with this. I have been looking around for this vut can't find it anywhere. There is many shops that would need this. Anyone having some information och knowledge about this?

Hi, I'm facing a "no carrier is available for selection" problem only with this exact setup: product with several combinations advanced stock management and product set to use it the setup that works: product without combinations + advanced stock management product with combinations + simplified stock management (quantity selection on product page) my version is 1.5.6.2 note: all other posts I've seen mention warehouses without carriers, carriers with incorrect countries/zones. this does not apply. as showed above everything works fine except this exact combination. Any help? Thanks, JPinto

Ciao a tutti. Nel mio sito abbiamo scelto di usare la gestione avanzata del magazzino perchè sembrava avere caratteristiche che facevano al caso nostro anche per aggiornare le quantità dei prodotti che vengono riassortiti. In verità non siamo ancora riusciti a usarlo in maniera soddisfacente, anche perchè la documentazione scarseggia. In particolare, acquistando sempre a prezzi diversi (una volta c'è una promo, un'altra c'è un aumento etc,...) ogni volta che arriva un riassortimento dovremmo entrare in ogni prodotto riassortito ed aggiornare il prezzo di acquisto. Questo tuttavia viene bypassato (almeno sulla carta) dalla Gestione avanzata del magazzino, che dovrebbe tenere traccia dei vari prezzi di acquisto dello stesso prodotto, secondo lo schema riportato in questo esempio (http://doc.prestashop.com/display/PS15/Advanced+Stock+Management#AdvancedStockManagement-Stockmanagementrules). Il nostro problema è che TUTTI i moduli di statistiche che abbiamo provato non riescono a rilevare alcun prezzo di acquisto, con la conseguenza che se ricevo un ordine di 100 euro, mi dicono che abbiamo anche GUADAGNATO 100 euro, senza sottrarre il prezzo di acquisto dei prodotti. Eppure il prezzo di acquisto lo inseriamo quando aggiorniamo le quantità, usando la maschera apposita della gestione avanzata del magazzino, di cui allego qui lo screenshot. Questa maschera richiede come OBBLIGATORIO il prezzo di acquisto per ogni prodotto, altrimenti non è possibile effettuare l'upload delle quantità. Quindi i prezzi di acquisto da qualche parte nel database ci sono. Il programmatore (che non sono io) me lo ha confermato. Qualcuno sa dirmi se sbagliamo qualche cosa, oppure se esista un qualche modulo di statistiche che riesca a rilevare i prezzi di acquisto dei prodotti quando è attivata la gestione avanzata del magazzino? Grazie, ciao, Stefano

Hi I enabled advanced stock management on PS 1.5.2.0, created a warehouse and added all carriers. When orders were placed all the carriers that shouldnt apply to that delivery address were all select-able in the cart and worse showing as free. Has anyone experienced this shipping issue?

Hello, I have a problem with my inventory not being correctly updated when I cycle through my process of order status modes. When I update the order status to "Order Sent" - Only the Real Quantity gets updated, the physical and the other one stays. Usually I will change the mode once or twice. For instance: When customer pays, it gets set to "Payment confirmed" Next I choose "Order is being processed" And finally I choose "Order has been sent" The thing is, when I choose the Order Sent status, prestashop puts back the product it had taken from my stock/warehouse. I have fiddled alot with all the various checkmarks, and I can get it to remove one of the "Real" (the calculated) items, but I still have the same amount of "Usable" and "Physical" - after setting the order to sent. Does someone else experience this problem? I have the 1.5.3.1 version running.