Do you know the level of stock of each product / attribute (size/color/..) on Prestashop?


Imagine you want to get the detail for each product and for each product attribute (color, size, material,…) the number of products you have in stock. The advantage of being able to retrieve it is, on top of the information provided, the format: You will be able to extract all this information directly into an Excel format.

You will be able to carry out directly your business analysis and understand the stock breakdown as a total but also broken down per attribute and adapt your pricing strategy for instance or change your purchase strategy.


Tested successfully on Prestashop 1.6 and Prestashop 1.7 version

What you will exactly get from it?

Start by looking at the product discovery page to understand who this works. Nothing really complicated, but this is something quite powerful to manage your e-commerce business.

You’ll get a few line to copy-paste in your browser enabling you to extract the data from your Prestashop boutique without having to install any plugin, just by using the SQL Manager feature.

If you want to know directly from Prestashop how this works exactly, you should read this page then.

This means that even if you’re not a technical person, you’ll be able to get access to the data stored in your Prestashop e-commerce website. Yes, this is cool.


You will be able to extract the following information:

  • ID Stock Available
  • ID of the product attribute
  • ID product
  • Name of the product
  • Status available now
  • Product attribute name
  • Shop group name
  • Shop name
  • Quantity in stock
  • out of stock number
  • depends on stock

This SQL query will give it to you this level of information:

Vous êtes un particulier? Découvrez comment publier un article sur reportingbusiness et construisez votre e-reputation. En savoir plus ...

Vous êtes une entreprise? Découvrez comment être référencé sur reportingbusiness et augmenter votre visibilité en ligne. En savoir plus

A lire aussi: