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


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


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.

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

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.


There are no reviews yet.

Be the first to review “[Prestashop] Do you know the level of stock of each product / attribute (size/color/..) ?”

Your email address will not be published.