Uninstalling Cart2Quote

How to fully delete Cart2Quote from Magento?

This can also be a required step when updating Cart2Quote when you currently have a Cart2Quote v2 installation.

This task is separated in three parts:

1. Removing Cart2Quote on files level
2. Removing Cart2Quote on database level
3. Clear cache and login again

1. Files level

1.1   Delete layout qquoteadv.xml from backend and frontend ( + crmaddon.xml)

1.1a: file(s): ../app/design/adminhtml/default/default/layout/qquoteadv.xml ( + crmaddon.xml)
1.1b: file: ../app/design/frontend/base/default/layout/qquoteadv.xml
1.2c: file: ../app/design/frontend/rwd/default/layout/qquoteadv.xml

1.2 Delete template folder ‘qquoteadv’  from backend and frontend

1.2a: folder: ../app/design/adminhtml/default/default/template/qquoteadv/
1.2b: folder: ../app/design/frontend/base/default/template/qquoteadv/
1.2c: folder: ../app/design/frontend/rwd/default/template/qquoteadv/

1.3 Delete file(s):  ../app/etc/modules/Ophirah_Qquoteadv.xml (+ Ophirah_Crmaddon.xml)

1.4 Delete folder: ../app/code/community/Ophirah/Qquoteadv

1.5 Delete in ../app/locale/ [de_DE/de_OS/en_US/es_ES/fr_FR/it_IT/nl_NL/pt_BR]: (if available)

1.5a: folder: ../app/locale/[xx_XX]/template/email/crmaddon/
1.5b: folder: ../app/locale/[xx_XX]/template/email/qquoteadv/
1.5c: folder: ../app/locale/[xx_XX]/template/email/cart2quote/
1.5d: file: ../app/locale/[xx_XX]/Ophirah_Crmaddon.csv
1.5e: file: ../app/locale/[xx_XX]/Ophirah_Qquoteadv.csv
1.5f: file: ../app/locale/[xx_XX]/Ophirah_Qquoteadv_AdminHtml.csv

1.6 Delete folder: ../cart2quote-install/  (if available)

1.7 Delete files and folders in the '../skin' directory:

1.7a: folder: ../skin/adminhtml/base/default/css/crmaddon/  (if available)
1.7b: folder: ../skin/adminhtml/base/default/css/qquoteadv/
1.7c: folder: ../skin/adminhtml/base/default/images/crmaddon/  (if available)
1.7d: folder: ../skin/adminhtml/base/default/images/qquoteadv/
1.7e: folder: ../skin/adminhtml/base/default/js/qquoteadv/
1.7f: file: ../skin/adminhtml/default/default/images/minus-icon.png (Warning: This file could be used by other modules and is therefor not advisable to delete)

1.7g: file: ../skin/frontend/base/default/css/qquoteadv_css.css
1.7h: file: ../skin/frontend/base/default/css/qquoteadv.css
1.7i: folder: ../skin/frontend/base/default/images/qquoteadv/
1.7j: file: ../skin/frontend/base/default/images/ajax-loader.gif  (Warning: This file could be used by other modules and is therefor not advisable to delete)
1.7k: file: ../skin/frontend/base/default/images/btn_proceed_to_qquote_DE.gif
1.7l: file: ../skin/frontend/base/default/images/btn_proceed_to_qquote_NL.gif
1.7m: file: ../skin/frontend/base/default/images/btn_proceed_to_qquote.gif
1.7n: file: ../skin/frontend/base/default/images/fill-form-icon.png (Warning: This file could be used by other modules and is therefor not advisable to delete)
1.7o: file: ../skin/frontend/base/default/images/icon_lorry.gif  (Warning: This file could be used by other modules and is therefor not advisable to delete)
1.7p: file: ..skin/frontend/base/default/images/minus-icon.png (Warning: This file could be used by other modules and is therefor not advisable to delete)
1.7q: file: ../skin/frontend/base/default/images/plus-icon.png (Warning: This file could be used by other modules and is therefor not advisable to delete)
1.7r: file: ../skin/frontend/base/default/js/qquoteadv.js
1.7s: file: ../skin/frontend/rwd/default/css/qquoteadv.css
1.7t: file: ../skin/frontend/rwd/default/images/icon_sprite_c2q.png
1.7u: file: ../skin/frontend/rwd/default/images/icon_sprite_c2q2x.png

1.8: Check for any of the files in step 2.7 in you theme folder. (In case of custom theme integration)

2.  Database level

2.1 Delete Cart2Quote information from `core_config_data` and `core_resource` tables

2.1a: Delete Cart2Quote information from `core_config_data`
SELECT * FROM `core_config_data` WHERE `path` LIKE '%quoteadv%'
in case search result is not empty then:
Delete FROM `core_config_data` WHERE `path` LIKE '%quoteadv%';

2.1b: Delete Cart2Quote information from `core_config_data`
SELECT * FROM `core_config_data` WHERE `path` LIKE '%carriers/qquoteshiprate%'
in case search result is not empty then:
DELETE FROM `core_config_data` WHERE `path` LIKE '%carriers/qquoteshiprate%';

2.1c: Delete Cart2Quote information from `core_resource`
SELECT * FROM `core_resource` WHERE `code` LIKE '%quoteadv%' 
in case search result is not empty then:
DELETE FROM `core_resource` WHERE `code` LIKE '%quoteadv%' ;

2.1d: Delete Cart2Quote CRMaddon  information from `core_resource` (not available in all versions)
SELECT * FROM `core_resource` WHERE `code` LIKE '%crmaddon_setup%' 
in case search result is not empty then:
DELETE FROM `core_resource` WHERE `code` LIKE '%crmaddon_setup%' ;

2.1e: Delete Cart2Quote shipping rates  information from `sales_flat_quote_shipping_rate` (not available in all versions)
SELECT * FROM `sales_flat_quote_shipping_rate` WHERE `carrier` LIKE '%qquoteshiprate%' 
in case search result is not empty then:
DELETE FROM `sales_flat_quote_shipping_rate` WHERE `carrier` LIKE '%qquoteshiprate%' ;

2.2 Delete all Cart2Quote tables (You can run all the rules as one script)

 

DROP TABLE IF EXISTS quoteadv_product;
DROP TABLE IF EXISTS quoteadv_request_item;
DROP TABLE IF EXISTS quoteadv_history; #(May show error: Unknown table 'quoteadv_history' on newer versions)
DROP TABLE IF EXISTS quoteadv_customer;
DROP TABLE IF EXISTS quoteadv_crmaddon_messages; #(May show error: Unknown table 'quoteadv_crmaddon_messages on some versions)
DROP TABLE IF EXISTS quoteadv_crmaddon_templates; #(May show error: Unknown table 'quoteadv_crmaddon_templates' on some versions)
DROP TABLE IF EXISTS quoteadv_extraoptions;
DROP TABLE IF EXISTS quoteadv_group_allow;
DROP TABLE IF EXISTS quoteadv_log_admin; #(May show error: Unknown table 'quoteadv_log_admin' on older versions)
DROP TABLE IF EXISTS quoteadv_quote_address;
DROP TABLE IF EXISTS quoteadv_rotation;
DROP TABLE IF EXISTS quoteadv_shipping_rate;

2.3 Delete attributes

2.3a: allowed_to_quote
SELECT * FROM `eav_attribute` WHERE `attribute_code` LIKE '%allowed_to_quote%'
In case search result is not empty then:

DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE '%allowed_to_quote%'

2.3b: group_allow_quote
SELECT * FROM `eav_attribute` WHERE `attribute_code` LIKE '%group_allow_quote%'
In case search result is not empty then:

DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE `%group_allow_quote%`

2.3c: quotemode_conditions
SELECT * FROM `eav_attribute` WHERE `attribute_code` LIKE '%quotemode_conditions%'
In case search result is not empty then:

DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE '%quotemode_conditions%'

 

2.3d: qquoteadv

SELECT * FROM `eav_attribute` WHERE `backend_model` LIKE 'qquoteadv/%';

In case search result is not empty then:

DELETE FROM `eav_attribute` WHERE `backend_model` LIKE 'qquoteadv/%';

 

2.3e: assigned_sales_rep

SELECT * FROM eav_attribute WHERE attribute_code = 'assigned_sales_rep'

In case search result is not empty then:

DELETE FROM eav_attribute WHERE attribute_code = 'assigned_sales_rep'

3. Clear cache and login again

In "System>Cache management" clear:

  • Flush JavaScript/CSS Cache
  • Flush Magento Cache
  • Flush Cache Storage
  • Refresh all the enabled cache types
  • Log out and in again.

Now Cart2Quote is completely removed.

 

Have more questions? Submit a request

3 Comments

  • 0
    Avatar
    About Space

    It generates errors for my site. I have to restore the site.

  • 0
    Avatar
    Myro Stadler

    This all-in-one sql script worked for me:

    SET FOREIGN_KEY_CHECKS = 0;


    DELETE FROM `core_config_data` WHERE `path` LIKE '%quoteadv%';
    DELETE FROM `core_config_data` WHERE `path` LIKE '%carriers/qquoteshiprate%';
    DELETE FROM `core_resource` WHERE `code` LIKE '%quoteadv%' ;
    DELETE FROM `core_resource` WHERE `code` LIKE '%crmaddon_setup%' ;
    DELETE FROM `sales_flat_quote_shipping_rate` WHERE `carrier` LIKE '%qquoteshiprate%' ;

    DROP TABLE IF EXISTS quoteadv_product;
    DROP TABLE IF EXISTS quoteadv_request_item;
    DROP TABLE IF EXISTS quoteadv_history; #(May show error: Unknown table 'quoteadv_history' on newer versions)
    DROP TABLE IF EXISTS quoteadv_customer;
    DROP TABLE IF EXISTS quoteadv_crmaddon_messages; #(May show error: Unknown table 'quoteadv_crmaddon_messages on some versions)
    DROP TABLE IF EXISTS quoteadv_crmaddon_templates; #(May show error: Unknown table 'quoteadv_crmaddon_templates' on some versions)
    DROP TABLE IF EXISTS quoteadv_extraoptions;
    DROP TABLE IF EXISTS quoteadv_group_allow;
    DROP TABLE IF EXISTS quoteadv_log_admin; #(May show error: Unknown table 'quoteadv_log_admin' on older versions)
    DROP TABLE IF EXISTS quoteadv_quote_address;
    DROP TABLE IF EXISTS quoteadv_rotation;
    DROP TABLE IF EXISTS quoteadv_shipping_rate;

    DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE '%allowed_to_quote%';
    DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE '%group_allow_quote%';
    DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE '%quotemode_conditions%';
    DELETE FROM `eav_attribute` WHERE `backend_model` LIKE 'qquoteadv/%';

    -- This was needed bacause of database transfer which wrote nulls.
    UPDATE `core_store` SET store_id = 0 WHERE code='admin';
    UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
    UPDATE `core_website` SET website_id = 0 WHERE code='admin';
    UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';


    SET FOREIGN_KEY_CHECKS = 1;

     

  • 0
    Avatar
    Shyam Krishna

    If you ran the following query will it return any value?
    SELECT * FROM eav_attribute WHERE attribute_code = 'assigned_sales_rep'

    If it returns any value you can run the following,
    DELETE FROM eav_attribute WHERE attribute_code = 'assigned_sales_rep'

     

    Do this as well.

Please sign in to leave a comment.
Powered by Zendesk