Fixing Errant Variations Or Addons

After upgrading to 1.2, you may find that all products with variations and addons have these respective features turned off. Toggling them back on should fix the issue, but doing this product by product can be very painful.

This SQL should allow you to fix the problem rapidly, but you MUST exercise discretion. If you choose a keyword that is too liberal, you’ll enable it for way more products than you intend. So follow these steps.

  • Backup your database. (For reals.)
  • Identify a keyword that identifies the variation or addon you want to fix. For instance, we had a variation named “Colors”.
  • Run this select to verify which products will be effected. If it returns way less or way more products than you expected, please investigate before continuing.
SELECT parent FROM wp_shopp_meta WHERE value LIKE '%YOUR_VARIATION_NAME_SUCH_AS_COLORS_OR_SOMETHING%' AND type = 'meta' AND name = 'options';
  • Once you’re feeling confident, run this:
UPDATE wp_shopp_summary SET variants = 'on' WHERE product in (SELECT parent FROM wp_shopp_meta WHERE value LIKE '%YOUR_VARIATION_NAME_SUCH_AS_COLORS_OR_SOMETHING%' AND type = 'meta' AND name = 'options' ) AND variants = 'off';
  • If you wish to fix an addon, use this instead:
UPDATE wp_shopp_summary SET addons = 'on' WHERE product in (SELECT parent FROM wp_shopp_meta WHERE value LIKE '%YOUR_ADDON_NAME_SUCH_AS_MONOGRAMMING_OR_SOMETHING%' AND type = 'meta' AND name = 'options' ) AND addons = 'off';

That should be it.

Please be careful and always backup before you try solutions that involve manipulating the database directly.

Fixing Errant Variations Or Addons
  • 0.00 / 5 5

You must be logged in to post a comment.

© Ingenesis Limited. Shopp™ is a registered trademark of Ingenesis Limited.

Skip to toolbar