Prestashop - Stock levels export : You can not update available stock when it depends on stock

Prestashop - Stock levels export : You can not update available stock when it depends on stock

Overview

When the "Stock levels export" feed runs, it can result in the following error for some products :
"You can not update available stock when it depends on stock"
This is due to the fact Prestashop advanced stock management was (or is still) enabled when those products were created, so Prestashop prevent any stock level update through API.
This article will explain how to solve this error.


Process

In order to solve this problem, follow these steps :

First, you need to disable the "depends_on_stock" tag that has been set on products created while Prestashop advanced stock management system was enabled.
This will let Prestashop know that these products do not relies on advnaced stock management anymore, making stock levels update via Prestashop API work again.

To disable the "depends_on_stock" tag for all products at once, run the following SQL request in your Prestashop database :
UPDATE psstock_available SET depends_on_stock = 0

This will disable the advanced stock management for all products.
    • Related Articles

    • Stock export

      How works stock export Many integrations (Magento, Shopify, Hiboutik, Prestashop etc....) supports the stock export feed. This feed sends the stock available to the external system. The stock sent is calculated using several parameters : First, only ...
    • Stock levels backup

      Stock level backup Boostmyshop myFulfillment is able to process a backup of your warehouse(s) stock levels everyday, saving results in CSV files that will then be available for download from the warehouse screen. Setup All the stock levels backup ...
    • Stock Helper

      Stock Helper The stock helper screen has been designed to help you to optimize your products ideal & warning stock levels depending of procurement and sales history data. To reach the stock helper screen : In the stock helper grid, you will find one ...
    • Low stock alerts (warning and ideal stock levels)

      Overview To manage low stock alerts and optimize replenishemnt, Connect uses 2 stock levels :  Warning stock level : this is the reorder point, when available stock goes below this limit, the alert is raisen in the supply needs Ideal stock level : ...
    • Kit stock management

      Overview This article explains how Boostmyshop can manage stock level for kit products. Boostmyshop calculates the stock available for kits based on the children stock level, using the smallest quantity available among children products. Enable kit ...