Can't delete generated product combination

[pasha23]

If I want to delete a generated product combination like a colour blue then nothing wil happen. Sorry for my bad Enlgish

[ViePie]

Same problem here!

[pasha23]

Same problem here!

Hi ViePie,

 

were you able to solve it?

[musicmaster]

Did you empty the cache?

[lbowe7399]

I am having this same problem.  I tried emptying the cache and it didn't help.  I will select an attribute for my product, click on the trash can icon, I confirm to delete in the pop up window, but the combination is still there.  

[selectshop.at]

First of all, please inform which Prestashop version are you using ? Which php-version are you using ?

 

Are you using Varnish on server (ask provider) ? If yes than you should change your hosting package or disable this on server (this can be done only by server admins). Varnish is an external cache, which is not compatible with Prestashop.

[lbowe7399]

I'm using 7.0.18.

[selectshop.at]

I'm using 7.0.18.

This is what ? Prestashop-Version or php-version ? If php-version, change to another.

[pasha23]

I changed to a another php-version and emptied the cache but still doesn't solve the problem.

Edited July 5, 2017 by pasha23 (see edit history)

[selectshop.at]

Which Prestashop Version ?

 

Shop is an upgrade ?

 

How did you added the combinations ? By import ?

 

Any manual manipulations done directly into database ? (for ex. deletion of data, use of module ps cleaner)

[musicmaster]

Did you try a different browser/computer? Sometimes such problems are cookie related.

 

Did you look in your server log file? There might be some error message.

 

I could have a look but for that I would need access to both the backoffice and the database.

[MarlexLadag]

Any solution for this problem?

[Barbarlas]

facing the same problem.... even with 1.7.4.3...

[Sharak]

The same happens on 1.7.5.0. Here's fix for that:

Edited January 31, 2019 by Sharak (see edit history)

[m.rtr]

Given solution does not work.

Still , same problem on same version.

[dolphin]

did you find any solution to the problem still facing the same problem tried everything that found on the forums

[Mian Waqas]

Greetings everyone,

The issue is not from prestashop back office cache - you need to disable the cache on your host/cpanel 

if you are not able to disable it yourself , please ask the support of your host.

 

Thanks in advance

[mican]

On 6/29/2017 at 9:59 AM, selectshop.at said:

First of all, please inform which Prestashop version are you using ? Which php-version are you using ?

 

Are you using Varnish on server (ask provider) ? If yes than you should change your hosting package or disable this on server (this can be done only by server admins). Varnish is an external cache, which is not compatible with Prestashop.

Also want to know about it.

Edited September 19, 2022 by mican (see edit history)

[malaika15]

pasha23 I am facing same problem anyone find solution of this problem? if yes then please help me. Thanks in advance.

Edited September 23, 2022 by malaika15 (see edit history)

[ps8modules]

The problem is caused by low memory_limit and max_input_vars on the server.

[ps8modules]

The problem always arises when there are multiple combinations. When you have several attributes, it can be tens of thousands of records in the database.

[ps8modules]

Hi.

The problem arises when product editing is open and the page is refreshed, or the changes are not saved. As for editing the product, everything is saved in the cache and everything can be loaded back when the page is refreshed.
How to do it ?
Delete the combinations by clicking on the trash can icon, wait for the message that everything is saved and then exit the product editing.
If there are many combinations and you need to delete them all, the fastest way is to delete them from the database either with an SQL query or a script.
The difference is then considerable.

[ps8modules]

E.g:

  

/*uncomment <?php*/
    /* delete product all combinations SAMPLE */
 
    include_once ('./config/config.inc.php');

    $startTime = microtime(true);

    /* change 1 to your id_product */
    $idProduct = 1; 
    
    $getAttributes = Db::getInstance()->executeS('SELECT id_product_attribute FROM '._DB_PREFIX_.'product_attribute WHERE id_product = '.$idProduct);
    $attributesArray = array();
    $cnt = 0;

    if ($getAttributes) {

        foreach ($getAttributes as $attr) {
            $attributesArray[] = $attr['id_product_attribute'];
        }

        $cnt = count($attributesArray);
        $attributesToDelete = implode(',', $attributesArray);

        /* DELETE FROM product_attribute_combination */ 
        Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'product_attribute_combination WHERE id_product_attribute IN ('.$attributesToDelete.')');
        
        /* DELETE FROM product_attribute_image */
        Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'product_attribute_image WHERE id_product_attribute IN ('.$attributesToDelete.')');

        /* DELETE FROM product_attribute */
        Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'product_attribute WHERE id_product_attribute IN ('.$attributesToDelete.')');

        /* DELETE FROM product_attribute_shop */
        Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'product_attribute_shop WHERE id_product_attribute IN ('.$attributesToDelete.')');

        /* DELETE FROM stock_available */
        Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'stock_available WHERE id_product_attribute IN ('.$attributesToDelete.') AND id_product = '.$idProduct);

        /* SET DEFAULT CACHE Attribute */
        Db::getInstance()->execute("UPDATE "._DB_PREFIX_."product SET cache_default_attribute = '0' WHERE id_product = ".$idProduct);
        Db::getInstance()->execute("UPDATE "._DB_PREFIX_."product_shop SET cache_default_attribute = '0' WHERE id_product = ".$idProduct);

        /* CLEAN cache */
        Tools::clearSmartyCache();
        Tools::clearXMLCache();
        Media::clearCache();
        Tools::generateIndex();

        $endTime = microtime(true);
        $totalTime = round(($endTime - $startTime), 2);

        echo 'DONE all combinations are deleted.<br>Combinations count: '.$cnt.'<br>Total in (seconds): '.$totalTime;
    } else {
        $endTime = microtime(true);
        $totalTime = round(($endTime - $startTime), 2);
        echo 'ERROR deleting combinations.<br>Total in (seconds): '.$totalTime;
    }

 

[Eddy Webdelta]

This solved it on our side:

Plesk, PHP settings for host with Prestashop install, Run PHP as on FPM application served by nginx (NL: PHP uitvoeren als op FPM-toepassing bediend door nginx)

if you have access to PHP settings please try that if you are on NGINX. Sorry I don't have explenation for this configuration.

[jamesbuttler]

s Varnish being utilized on your server? If it is, I recommend reaching out to your hosting provider to discuss either upgrading your hosting package or disabling Varnish on the server. Varnish is an external caching system, and it's not compatible with Prestashop. Server administrators are the ones who can perform this task.

[jamesbuttler]

Remember to take caution when deleting product combinations, as this action may impact your inventory or product listings. If you provide more details about the platform or system you're using, I may be able to offer more specific guidance.

Edited December 6, 2023 by jamesbuttler (see edit history)

[jamesbuttler]

Embarking on a business transformation? Navigate the process seamlessly with our guide on IRS Change of Business Name at Lawyers Corner! 🌐✨ Ensure a smooth transition and avoid pitfalls when updating your business name for tax purposes. Empower your journey with expert insights and strategic advice. Ready to redefine your business identity? Visit Lawyers Corner now and let our legal expertise be your guide. Your business evolution starts here