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.
You can organize products on a per-category basis by clicking on the "Filter by category" checkbox. This opens a small interface listing all your categories and sub-categories. Selecting one category automatically filters the list of products to only display products from the selected category. It also adds a "Position" column to the table, with which you can order the product on the category page. This is done either by moving the rows up and down, or by clicking the arrows.
Your product order can then be overridden by the user'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.
Finally, the top of the product list presents five buttons:
- Add new product. Creates a new product.
- Export. Downloads a CSV file of all the products in your catalog.
- Import. Sends you to the CSV Import option page, from where your can import your CSV files.
- Refresh List. Reloads the list of products to display the latest changes.
- Show SQL Query. Provides the SQL statements and parameters query to reproduce your product search or filter in your own 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 list of product was filtered (by name, for instance), then the default SQL statement will take this into account (for instance, "
WHERE 1 AND b.`name` LIKE '%blouse%'").