Jump to content

Search the Community

Showing results for tags 'Advanced Stock'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Community Help and Support
    • PrestaShop Download
    • PrestaShop Addons
  • News and Announcements
    • PrestaShop news and releases
    • PrestaShop Beta
    • PrestaShop Blogs
    • PrestaShop Meetups
  • International community (English)
    • General topics
    • PrestaShop Merchants
    • PrestaShop Developers
    • Taxes, Translations & Laws
    • Community Modules and Themes
  • Forum francophone
    • Discussion générale
    • Aide et support communautaire
    • PrestaShop pour les marchands
    • PrestaShop pour les développeurs
    • Adaptation aux lois Québécoises
    • Modules et thèmes gratuits
    • Modules et thèmes payants
  • Foro en Español
    • Discusión general
    • Soporte de la comunidad y ayuda
    • Comerciantes PrestaShop
    • Desarrolladores PrestaShop
    • Módulos y plantillas gratuitas
  • Forum italiano
    • Forum generale
    • Aiuto e supporto della Community
    • Commercianti PrestaShop
    • Sviluppatori PrestaShop
    • Aspetti legali sull'eCommerce
    • Moduli e template gratuiti
  • Deutsches Forum
    • Generelle Fragen
    • Support und Hilfe aus der Community
    • e-Commerce/Versand-Handel mit Prestashop
    • Prestashop-Entwickler
    • Anpassung an deutsches Recht
    • Kostenlose Module und Templates
    • Generelle Fragen Copy
  • Nederlandstalig forum
    • Algemeen
    • Hulp en ondersteuning, van en voor de community
    • PrestaShop-winkeliers
    • PrestaShop-ontwikkelaars
    • Het aanpassen van PrestaShop
    • Gratis modules en templates
  • Fórum em Português
    • Fórum Geral
    • Ajuda e Suporte da Comunidade
    • Lojistas que utilizam o PrestaShop
    • Desenvolvedores PrestaShop
    • Legislação específica
    • Módulos e temas gratuitos
  • Polskie forum
    • Forum ogólne
    • Wsparcie i pomoc użytkowników
    • Oferty twórców PrestaShop
    • Deweloperzy PrestaShop
    • Darmowe Moduły i Szablony
  • Dansk forum
    • Generelt forum
    • Hjælp og support fra fællesskabet
    • PrestaShop for købmænd
    • PrestaShop for udviklere
    • Love og regler
    • Gratis moduler og temaer
  • České fórum
    • Instalasi, Konfigurasi dan upgrade
    • Obecná diskuze
    • Bezplatné moduly a šablony
    • PrestaShop vývojáři
    • PrestaShop obchodníci
  • Bahasa Indonesia
    • Diskusi Umum
    • Podpora a pomoc komunity
    • Laporan Bug
    • Jasa, Promosi & Lowongan Kerja
  • Svenskt forum
    • Allmän diskussion
    • Installation, konfigurering och uppdatering
  • Forumul românesc
    • Discuţii generale
    • Instalare, configurare şi upgrade
  • Pусский язык
    • Обсуждение скрипта
    • Установка, Настройка, Обновление
    • Прием багов
  • Slovenské fórum
    • Všeobecná diskusia
    • Podpora a pomoc komunity
    • PrestaShop obchodníci
    • PrestaShop vývojári
    • Bezplatné moduly a šablóny
  • Türkçe Topluluğu
    • Genel Konular
    • Topluluk desteği ve yardım
    • PrestaShop Tüccarları
    • Prestashop Geliştiricileri
    • Ücretsiz Modül ve Temalar
  • Diễn đàn tiếng Việt
    • Thảo luận chung
    • Hỗ trợ từ cộng đồng
    • Dành cho chủ doanh nghiệp / cửa hàng
    • Dành cho lập trình viên
  • PrestaShop Communities
    • اللغه العربيه [Arabic]
    • Ελληνικά [Greek]
    • עִבְרִית [Hebrew]
    • 中文
    • Magyar [Hungarian]
    • 日本語 [Japanese]
    • Lietuviškai [Lithuanian]
    • انجمن فارسی [Persian]
    • ไทย [Thai]
    • Malaysia [Malaysian]
    • Eesti [Estonian]
    • Slovenščina [Slovenian]
    • Српски [Serbian]
  • IP. Board Forum
    • IP. Board Forum Questions and Issues
  • Archive
    • Zapłać Moduły i Szablony [ARCHIVE]
    • Moduly, upravy a dizajn [ARCHIVE]
    • Phát triển và các mô-đun [ARCHIVE]
    • Yazılım, Modül ve Tema [ARCHIVE]
    • Модули, Шаблоны [ARCHIVE]
    • Module şi teme [ARCHIVE]
    • Pengembangan dan Modul [ARCHIVE]
    • Moduler och teman [ARCHIVE]
    • Ecommerce x PrestaShop [ARCHIVE BOARD]
    • Vývoj a moduly [ARCHIVE]
    • Kostenpflichtige Module, Templates [ARCHIVE]
    • Módulos y temas pagos [ARCHIVE]
    • Módulos e temas pagos [ARCHIVE]
    • Servizi commerciali [ARCHIVE]
    • Forum - Feedback Contributor
    • PrestaShop Cloud

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Found 9 results

  1. 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 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!
  2. 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., 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
  3. 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
  4. 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.
  5. 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?
  6. 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 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
  7. 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
  8. Hi I enabled advanced stock management on PS, 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?
  9. 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 version running.
  • Create New...