Scroll menu in PrestaShop 1.7 back-office

When you have many modules which adds buttons to the menu you are not able to see/click button from bottom of the menu because it’s not visible.

Very simple solution to allow scrolling the menu

Open file: /admin/themes/default/css/overrides.css and append this:

Open file: /admin/themes/default/js/admin-theme.js and append this:

 

 

 

Create friendly URL based on product name in Prestashop using SQL query

Below you will find simple SQL queries which creates product friendly url from product’s name and saves them in the database SEO section.

You can run this i.e. in phpmyadmin or MySQL Workbench.

Example of action

From product name $ My super product 1 !!! it will create friendly url my-super-product-1

Queries

Continue reading Create friendly URL based on product name in Prestashop using SQL query

Automatic product status and visibility – Prestashop module

Module allows to automatically update product status and visibility  based on stock available with multistore and attribute combinations support included.

  • You will save a lot of time. Products will be automatically turned on and off when manually updating product quantities and sales
  • The module automatically turns on or off newly imported or updated products
  • Multistore support. You can configure the module individually for each store
  • Product attribute combinations support
  • Since version 1.1 you can choose what you want to do:
    • change product visibility (show/hide)
    • change product status (enable/disable)
For More details and download go to:

https://addons.prestashop.com/en/order-management/26968-automatic-product-status-and-visibility.html

 

 

[Prestashop] Set the deepest category assigned to the product as the default

To set the deepest category assigned to the product as the default you need to do:

  1.  Open your database (for example by phpMyAdmin)
  2.  I suggest you create backup of your database for safety (export data and structure)
  3. Open SQL tab and perform these queries Continue reading [Prestashop] Set the deepest category assigned to the product as the default

[Prestashop] First product image as cover

If you want to mark first image of product as cover you need to do:

  1.  Open your database (for example by phpMyAdmin)
  2. I suggest you create backup of your database for safety (export data and structure)
  3.  Open SQL tab and perform queries from this file (change ‘ps_’ to your prefix):
    prestashop-first_image_as_cover.sql
  4.  Done! 🙂

[Prestashop] Send invoices only for non-free orders

If you want to send invoice file only when order in non-free – you need to do this:

  1. Create file /override/classes/order/Order.php with this contents:
  2.  Remove file /cache/class_index.php
  3.  Done!

Fast PrestaShop installation using shell command line

I wrote small script which in 7 steps provide fast PrestaShop installation using shell command line: script downloads latest PrestaShop, extracts files, creates database, sets correct permissions for PrestaShop files, installs PrestaShop and clean up installation.

You can find my script on: https://github.com/evox95/prestainstall

Just run it using root account or using sudo:

Zaznaczenie_004 Zaznaczenie_002