Prestashop 1.7 Common procedures

[sistemascesumin]

Database configuration​

Change the database access configuration in the app / config / parameters.php file

Change store URL​

Go to Store parameters -> Traffic & SEO and go down a bit to the section Set store URL and:

• We put the domain in Domain Store and Domain SSL
• We put the folder path (if the store is in a directory) in Base URI (always ending in /).

… If it cannot be accessed, this change can be made directly in the database

• Ps_shop_url table , domain and domain_ssl fields
• Tabla ps_configuration campos PS_SHOP_DOMAIN y PS_SHOP_DOMAIN_SSL

Change URL in other records

With a program like SQLYog or similar, search the new database for records that have the old domain and change them to the new domain if necessary (urls, emails, etc.).

Empty cache

Empty the store cache (files)

Empty browser cache and DNS cache

Switch to friendly URLs​

Go to Store parameters -> Traffic and SEO -> URL settings and activate the friendly URL option

Database cleanup​

To clean a Prestashop database empty the following tables (apply the query):

TRUNCATE ps_connections; - Stores data about the ip of the visitors and data about the pages that visit
TRUNCATE ps_connections_page; - Data on connection times to
TRUNCATE pages ps_connections_source; - Keywords of the connections, source ...
TRUNCATE ps_cart; -
TRUNCATE customer carts ps_cart_product; - Data on products in customer carts
TRUNCATE ps_guest; - Data on connections without login
TRUNCATE ps_page_viewed; - Pages displayed
TRUNCATE ps_pagenotfound; - Log of pages not found
TRUNCATE ps_statssearch; - Search engine statistics