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] Display newest products in ‘New products’ block

Module ‘blocknewproducts’ shows new products by the selected number of days from the addition.

With my modification, the module will display products sorted by date added, despite the time that has passed since the product was added to our store.

Continue reading [Prestashop] Display newest products in ‘New products’ block

[PrestaShop] Module for numeric order references

By default reference code contains only random uppercase letters – like this:
ABCDEFGHI, BCDEFGHIJ, CDEFGHIJK etc.

By my module your new order references will be numeric – like this:
000000001, 000000002, … 000000129 etc.

Just upload my module to your PrestaShop and install it – it’s all 🙂

See on github.com

[PrestaShop] How to override PrestaShop controller, class or main class of the module

In this entry I describe how to override PrestaShop controller, class or main class of the module.

 

How to override PrestaShop controller: /controllers/front/AddressController.php (this is just an example of the file)

Create file: /override/controllers/front/AddressController.php with content:

 

How to override PrestaShop class: /classes/Address.php (this is just an example of the file)

Create file: /override/classes/Address.php with content: Continue reading [PrestaShop] How to override PrestaShop controller, class or main class of the module

[PrestaShop] Copy product translations from one lang to others

This entry shows how to easily copy product translations from one lang to others by PHP script.

Make a backup of the database before running this script! Continue reading [PrestaShop] Copy product translations from one lang to others

[PrestaShop][1.6] Add friendly URL to shop home page

When we turn on Friendly URL in PrestaShop, shop home page url looks like this:
http://example.com/en/
This entry shows trick how to change this url to:
http://example.com/en/shop Continue reading [PrestaShop][1.6] Add friendly URL to shop home page