Introduction

This post was a result of a modification of the code of « wayne_f » which can be found here : https://www.prestashop.com/forums/topic/310945-how-to-ordersort-attribute-combination-names-alphabetically/

If you have a lot of attributes (color, style, pattern, size…) in your Prestashop website, you would like to sort them in the layered filter.

We will describe a process to do it automatically with SQL import. Please note you can sort attributes only in one language!

Process

  • Open your database (for example by phpMyAdmin)
  • Create backup of your database for safety (export data and structure)
  • Open SQL tab and perform queries from this file (change ‘ps_’ to your prefix)

Change the string <COLOR> by the « ps_attribute_group_lang.public_name » in the script

Catégories : Prestashop

0 commentaire

Laisser un commentaire

Avatar placeholder

Votre adresse e-mail ne sera pas publiée.