prestashop/pscleaner

This module allows you to check and fix functional integrity constraints and remove default data

PrestaShop Cleaner

This module has been archived, it’s no longer maintained but you still can fork it if you need it for your shop.

About

PrestaShop helps you remove your catalog, orders and customers data in one go.

Multistore compatibility

This module is not compatible with the multistore ❌
It means that its configuration applies for all stores.

Contributing

PrestaShop modules are open-source extensions to the PrestaShop e-commerce solution. Everyone is welcome and even encouraged to contribute with their own improvements.

Requirements

Contributors must follow the following rules:

• Make your Pull Request on the "dev" branch, NOT the "master" branch.
• Do not update the module's version number.
• Follow the coding standards.

Process in details

Contributors wishing to edit a module's files should follow the following process:

1. Create your GitHub account, if you do not have one already.
2. Fork the pscleaner project to your GitHub account.
3. Clone your fork to your local machine in the /modules directory of your PrestaShop installation.
4. Create a branch in your local clone of the module for your changes.
5. Change the files in your branch. Be sure to follow the coding standards!
6. Push your changed branch to your fork in your GitHub account.
7. Create a pull request for your changes on the 'dev' branch of the module's project. Be sure to follow the commit message norm in your pull request. If you need help to make a pull request, read the Github help page about creating pull requests.
8. Wait for one of the core developers either to include your change in the codebase, or to comment on possible improvements you should make to your code.

That's it: you have contributed to this open-source project! Congratulations!

pscleaner's Issues

Product Import does not clean Accessory and Attribute tables, if requested to clean Product data.

Describe the bug
I was importing Products with Accessories, and in the results, have seen, that Products are linked incorrectly(not 100% as I defined). Some part were as I described in my .xlsx, but there were also some random relations. I thought, that the error is is import functionality, or in the source data, but finally found out two reasons:

1. I was importing data to PS several times, and every time used PrestaShop Cleaner v2.0.0 to clean the Product DB. I have found out, that 3 tables, are not cleaned by the Module: a) ps_accessory b) ps_attribute c) ps_tag_count // (I was not able to find out how to register issue for the module, sorry.)
   2) Before importing, I was also setting parameter "Delete all products before import" to YES, but this also does not cleaned data.

Results (Issue):
As a result I receive new data-base of products, but with partially old Accessories. Here is my issue.

Additional observations:
As for ps_attribute and ps_tag_count, I do not know, if old data, that remains in tables can cause the issues for the future clean imports. I think it was worth to mention here. Maybe you can comment on that. Thank you.

Edit by Khouloud: steps to reproduce the issue

1. install PS1.7.6.2

2. Go to the Import page => import products
   Products_1.xlsx
   2.1 Delete all products before import
   2.2 Use product reference as a key

3. check the ps_accessory table => ok
   

4. Go to the Import page => import products
   Products_2.xlsx
   4.1 Delete all products before import
   4.2 Use product reference as a key

5. check the ps_accessory table => NOK
   

To Reproduce
Steps to reproduce the behavior:

1. Import 1st portion of Products with Accessories.
2. Use PS Cleaner to delete all Product Catalog.
3. Import 2nd portion of Products with Accessories with "Delete all products before import" set to YES. As a result you will get mixture of New and Old product relationships.

Additional information
PrestaShop version: 1.7.6.2
PHP version: 7.0.33

Bug in pscleaner free module

Describe the bug
When we click 'repair database' bouton, the module empties the table 'stock_mvt' and delete all existing columns in this table.

To Reproduce
Steps to reproduce the behavior:

1. Add or edit a stock for some products ( to create some stock movments history )
2. Go to pscleaner module
3. Click on 'repair database'
4. go to phpmyadmin and check the table 'stock_mvt'
5. You will see that the table has become empty

Cause of problem:
I think because in prestashop 1.7.5.0 the table stock is always empty , so when the module try to compare id_stock in the both tables , it will delete all columns of the table 'stock_mvt'

Additionnal information
PrestaShop version: 1.7.5.0
PHP version: 7.2

Pscleaner check&fix disabling PayPal currency checkbox

Describe the bug

Every time after making a pscleaner check&fix PayPal payment checkbox was disabled.

Steps to Reproduce

Steps to reproduce the behavior:

1. Go to payments and check PayPal checkbox currency - is enabled.
2. Go to pscleaner and click check&fix
3. Go to payments and check that PayPal checkbox now is disabled

Movie with a problem:
https://bck2233.tinytake.com/tt/NDIwOTk2MF8xMzEyMjEyOQ

Additional information

• PrestaShop version: 1.7.6.4
• PHP version: 7.1 - 7.2
• Pscleaner module: 2.0

Exception by ps_facetedsearch

Describe the bug
ps_facetedsearch throw exception on fresh install (fresh like in clean database by pscleaner module) if category contain products with properties.

To Reproduce
Install PrestaShop 1.7.6.0
Install PS Cleaner -> Delete categories, products etc.
Create a new product with properties.
Go to the category page of that product.
See exception by ps_facetedsearch

Screenshots

Video
https://reker.dk/video.webm

Additional information
PrestaShop version: 1.7.6.0
PHP version: 7.2.19

After a basic installation, the PS Cleaner module already detects that the database is corrupted

Describe the bug
After a basic installation, the PS Cleaner module already detects that the database is corrupted

To Reproduce
Steps to reproduce the behavior:

1. Go to Module Catalog and install pscleaner module
2. Click on Configure
3. Click on check and repair
4. See error

Screenshots

Additionnal information
PrestaShop version: All 1.7
PHP version: N/A

PrestaShop Cleaner only clean catalog datas and order and customers datas

Describe the bug

PS Cleaner didn't clean these data:

• addresses for brands
• stores
• images for stores
• shop contacts
• aliases for search

Expected behavior

All data should be cleaned

Steps to Reproduce

Run PS Cleaner

• PrestaShop version: 1.7.6.5
• PHP version: 7.1.13

Help merchants to deal with over-populated SQL tables

Is your feature request related to a problem?

A shop that has been running for years might accumulate a huge quantity of outdated datas: logs in ps_log table, emails of users who have not shopped for a long time, abandoned carts, cart rules with single usage that have been used a long time ago ...

All of these SQL rows will stay there and make SQL queries being run against the database slower.

Describe the solution you'd like

Ideally ? PrestaShop would be able to identify "useless data" and suppress them. For example "logs that are X months old" (and merchant/webmaster can configure X).

Alternatives you've considered

• a tutorial for merchants about how to identify and clean their old data
• a tutorial for developers about how to identify and clean their old data
• a warning system, able to monitor SQL tables size and properly warn developer/merchant about possible entanglement

Idea coming from @olecorre feedback

PSCleaner module should not clean paypal data

Hello, when I try to "delete orders & customers" with the PayPal (v5.2.1) official module installed and activated I get an exception :

Table 'database.ps_paypal_customer' doesn't exist<br /><br /><pre>TRUNCATE TABLE `ps_paypal_customer`</pre>
at line 769 in file classes/db/Db.php

• PrestaShop version: 1.7.6.7
• PHP version: 7.2
• Pscleaner version: v2.1.0

EDIT

It seems PSCleaner module clean paypal data but it does not work with latest Paypal module release.