Ebay plugin flooding the database

  • Resolved sumner250

    (@sumner250)


    8 years, 4 months ago

    Hello,

    I am not sure what I’ve done whilst uploading my products but my database table wp_postmeta has around 254,880 rows of:

    _ebay_category_1_id
_ebay_category_2_id
_ebay_store_category_1_id
_ebay_store_category_2_id
_ebay_gallery_image_url
_ebay_seller_payment_profile_id
_ebay_seller_return_profile_id
_ebay_bestoffer_enabled
_ebay_bo_autoaccept_price
_ebay_bo_minimum_price
_ebay_item_specifics
_ebay_title
_ebay_subtitle
_ebay_global_shipping
_ebay_payment_instructions
_ebay_condition_id
_ebay_condition_description
_ebay_listing_duration
_ebay_auction_type
_ebay_start_price
_ebay_reserve_price
_ebay_buynow_price
_ebay_upc
_ebay_ean
_ebay_isbn
_ebay_mpn
_ebay_brand
_ebay_epid
_ebay_hide_from_unlisted

    Is there a way to reduce the size of my database as it’s currently 785MB and the limit is 500MB.

    Kind regards,

    https://wordpress.org/plugins/wp-lister-for-ebay/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support WP Lab Support

    (@wp-lab-support)

    8 years, 4 months ago

    Hello sumner250.

    I am happy to assist you with this today.

    It depends on the number of products but those meta fields are created by WP-Lister when WooCommerce products are updated / edited, which is nothing special. WooCommerce does the same: It creates empty meta fields like _sale_price, _length, _width and _height, even if those fields are empty / unused.

    But let’s do a little math: Your list of meta fields consists of 29 rows, so if you have 254,880 total rows like this, that would mean you have about 254880 / 29 = 8788 products. With almost 9000 products it’s not much of a surprise that your database has grown beyond 500MB, and even if you would remove all the empty rows starting with _ebay_* from your wp_postmeta table, I doubt that this would actually result in the database shrinking below 500MB. You can contact us via our support form (http://www.wplab.com/request-support/) and the developer can give it a try, but you have to face the fact that with that many products you need a proper hosting plan, without that kind of right limitation on database size. 500MB is not that large if you have that many products and you’re using WP-Lister.

    Kind regards

    Thread Starter sumner250

    (@sumner250)

    8 years, 3 months ago

    Ah okay thank you I wonder why but it was a problem with expired transients. I have it resolved now.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Ebay plugin flooding the database’ is closed to new replies.