The product list
Clicking on the "Products" option of the "Catalog" menu takes you to the list of your current products, displayed with their main details: ID, image, name, reference, category, etc.
① ID. This is the unique number that identifies the product in your shop. This number is automatically assigned by PrestaShop when the Product is created. This avoids confusion on orders when two products have the same name. This number may be imposed within the context of a catalog import in CSV format.
② Image. This is the visual representation of your product. By default, the image selected as the cover image will appear.
③ Name. This is the name you have given to your product. It is important for the name to be clear for your customer, but it also needs to include keywords to help with your shop's SEO. A product called "Dress" will not give your customer any information, but a product called "Short Flowery Dress" will be much clearer and will introduce keywords for SEO.
④ Reference. This is the reference you have given to your product. It may be an internal reference or your supplier's product reference, and it appears on the Product page of your site and on the order.
⑤ Category. This is the main category to which you have attached the product. As a reminder, a product can be linked to several categories. If you are selling denim jackets, the product can be in both a Jackets category and a Denim category. Shoppers search in different ways, some in the Jacket category, others in the Denim category.
Other information is added to this list.
⑥ Price (tax excl.). The price before taxes is displayed.
⑦ Quantity. This is the remaining quantity for this product and the figure includes the quantities attached to product combinations.
⑧ Status. This tells you if the product is enabled or not.
You can also sort in various ways.
1. Above the product list is a search bar, allowing you to search by:
a. ID. You can therefore display your products by a range you have defined, which is very useful when you have a large catalog.
b. Name. You can use this search zone to list all of the products containing the expression you enter.
c. Reference. This lets you search by the reference of your product.
d. Category. If your catalog has a lot of products and categories or subcategories, you can choose to only display products in the category you are interested in. You have two options:
Search by the category name using the text field in the bar above the products
Select the category you want using the categories filter above the product list. Products can be organized by category by clicking on "Filter by categories". This opens a small interface that lists all of your categories and subcategories. When you select one, the product list is automatically filtered and only shows products in this category. It also adds a "Position" column to the table that allows you to change the order of the products on the category page. To do this, you can either move the rows in the table using the mouse or click on the arrows.
e. Price. You can search for products based on price range by indicating minimum and maximum values. This lets you show products regardless of the categories they are in.
f. Quantity. In the same way as for prices, you can search by quantity. This gives you a quick snapshot of your stock so that you can plan restocking.
g. Status. You can modify the display status of your product to sort by active products that are visible in your shop, or by inactive products that you have chosen to disable for whatever reason, for instance products for which the product page is incomplete.
Besides the product list, this page presents you with various statistics from your store:
- Percentage of in-stock items,
- Percentage of average gross margin,
- Percentage of sales during the last 30 days,
- Number of disabled products.
You cannot reorganize the whole list of products. The products are displayed as is in your store (by increasing ID number), and the customer can choose the product's order using the available sorting algorithms: lowest price first, highest price first, product name A to Z, product name Z to A, in-stock first, lowest reference first, highest reference first.
Your product order can then be overridden by the customer's sorting choice.
Note that when you change the display order in the product list in the back office (by clicking on column name's arrow in order to sort products according to that column), the "Position" column does not display arrows nor can you use it to move rows around anymore. Instead, it displays the position number of the product. In order to be able to position products again, click on the "Reset" button.
The action buttons
The top of the product list presents several buttons:
- Export. Downloads a CSV file of all the products in your catalog.
- Import. Opens the data import page, where you can upload your catalog in CSV format.
- Show SQL query. Show SQL query. Provides the SQL query to reproduce your product search or filter in your own SQL manager.
- Export to SQL Manager. Export to SQL Manager. Opens PrestaShop's SQL Manager Tool (in the "Advanced Parameters" menu), from which you can query PrestaShop's database with SQL statements ("SELECT ... FROM ... WHERE ..."). If your product list is filtered, by name, for instance, then the default SQL query will take this into account (for instance, "WHERE 1 AND b.`name` LIKE '%dress%'").
- New product. Creates a new product. Click on this button to start creating the product pages for your catalog.