Title: Can’t edit size chart !!! Plugin code is shit !
Last modified: June 17, 2022

---

# Can’t edit size chart !!! Plugin code is shit !

 *  Resolved [concerto789](https://wordpress.org/support/users/concerto789/)
 * (@concerto789)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/cant-edit-size-chart-plugin-code-is-shit/)
 * Jesus your plugin is so aweful !!!
 * Too many ‘LIKE’ queries cause the database to crash，the plugin code is shit !!!
 * Tell your developer to optimize it:
 *     ```
       $size_chart_args['meta_query'][] = array(
           'key'     => 'prod-chart',
           'value'   => "{$size_chart_id}",
           'compare' => 'EXISTS',
       );
       $size_chart_args['meta_query'][] = array(
           'key'     => 'prod-chart',
           'value'   => $size_chart_id,
           'compare' => 'LIKE',
       );
       $size_chart_args['meta_query'][] = array(
           'key'     => 'prod-chart',
           'value'   => "[{$size_chart_id},",
           'compare' => 'LIKE',
       );
       $size_chart_args['meta_query'][] = array(
           'key'     => 'prod-chart',
           'value'   => ",{$size_chart_id},",
           'compare' => 'LIKE',
       );
       $size_chart_args['meta_query'][] = array(
           'key'     => 'prod-chart',
           'value'   => ",{$size_chart_id}]",
           'compare' => 'LIKE',
       );
       $size_chart_args['meta_query'][] = array(
           'key'     => 'prod-chart',
           'value'   => "[{$size_chart_id}]",
           'compare' => 'LIKE',
       );
       ```
   

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [Hitendra Chopda](https://wordpress.org/support/users/hitendra-chopda/)
 * (@hitendra-chopda)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/cant-edit-size-chart-plugin-code-is-shit/#post-15751960)
 * Hello Concerto,
 * Thanks for reaching out to us and for your attention.
 * Sure, we will look into this and optimize the query as possible.
 * Can you please share the below details to trouble your crash query?
 * 1. How many products do you have in your store?
 * 2. How many size charts are created?
 * So, we can reproduce the issue from our end.
 * Best Regards,
    Hitendra & Dotstore Team
 *  Thread Starter [concerto789](https://wordpress.org/support/users/concerto789/)
 * (@concerto789)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/cant-edit-size-chart-plugin-code-is-shit/#post-15751998)
 * 1. 4730 products
    2. 3983 size charts
 * Besides，some size charts assigned two or more products.
 * There is a solution for you:
    Step1. Update the different format data in database
   to one same format. Step2. I suggest that use comma “,” to separate ID instead
   of “[” or “]” Step3. Optimize your code, DON’T use such many ‘LIKE’, PLEASE !!!
 *  Plugin Support [Hitendra Chopda](https://wordpress.org/support/users/hitendra-chopda/)
 * (@hitendra-chopda)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/cant-edit-size-chart-plugin-code-is-shit/#post-15764216)
 * Hello Concerto,
 * Thanks for your feedback and for sharing the details.
 * Okay sure, we will look into your feedback and optimize the code.
 * Best Regards,
    Hitendra & Dotstore Team

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Can’t edit size chart !!! Plugin code is shit !’ is closed to new replies.

 * ![](https://ps.w.org/woo-advanced-product-size-chart/assets/icon-256x256.png?
   rev=3011312)
 * [Product Size Charts Plugin for WooCommerce](https://wordpress.org/plugins/woo-advanced-product-size-chart/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-advanced-product-size-chart/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-advanced-product-size-chart/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-advanced-product-size-chart/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-advanced-product-size-chart/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-advanced-product-size-chart/reviews/)

## Tags

 * [code error](https://wordpress.org/support/topic-tag/code-error/)

 * 3 replies
 * 2 participants
 * Last reply from: [Hitendra Chopda](https://wordpress.org/support/users/hitendra-chopda/)
 * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/cant-edit-size-chart-plugin-code-is-shit/#post-15764216)
 * Status: resolved