Support » Plugin: WP Online Store » WP-Online Store Database Tables

  • Hello,

    I had attack on one of the sites I manage, and I noticed that “Online Store” does not work anymore.

    I do don’t want to restore whole database, because it will affect some other data that was collected in the meantime, so I just want to export tables from the backed up WordPress database that are related to the Store and import them into database that is in use.

    Can you, please, let me know which tables I have to export from backup base. This is older version of the Store, maybe things are changed now, but I cannot install fresh version and do all settings, insert all products all over again… I also have all plugin files (I backed up database and all files at the same time) when this database was used. Any help would be appreciated.

    So here is my backup database, and I placed * in front of tables I am sure that I need to export. Can anyone confirm if I selected all which are related to “WP Online Store”, or I missed something, or maybe I am planing to export table which is not related to the Store:

    – – – – – DATABASE ENTRIES – – – – –
    action_recorder
    address_book
    address_format
    administrators
    am_attributes_to_templates
    am_templates
    banners
    banners_history
    * categories
    * categories_description
    * configuration
    * configuration_group
    counter
    counter_history
    * countries
    * currencies
    * customers
    * customers_basket
    * customers_basket_attributes
    * customers_info
    * customers_to_discount_codes
    * discount_codes
    * extra_field_labels
    * extra_field_values
    * extra_product_fields
    * extra_value_exclude
    * geo_zones
    * information
    * information_group
    * languages
    * manufacturers
    * manufacturers_info
    * newsletters
    * orders
    * orders_products
    * orders_products_attributes
    * orders_products_download
    * orders_status
    * orders_status_history
    * orders_total
    * products
    * products_attributes
    * products_attributes_download
    * products_description
    * products_images
    * products_notifications
    * products_options
    * products_options_values
    * products_options_values_to_products_options
    * products_shipping
    * products_to_categories
    * reviews
    * reviews_description
    * sec_directory_whitelist
    * sessions
    * slideshow
    * specials
    * tax_class
    * tax_rates
    whos_online
    wp_commentmeta
    wp_comments
    wp_hl_twitter_replies
    wp_hl_twitter_tweets
    wp_hl_twitter_users
    wp_links
    wp_ngg_album
    wp_ngg_gallery
    wp_ngg_pictures
    wp_options
    wp_pollsa
    wp_pollsip
    wp_pollsq
    wp_postmeta
    wp_posts
    wp_terms
    wp_term_relationships
    wp_term_taxonomy
    wp_usermeta
    wp_users
    * zones
    * zones_to_geo_zones
    – – – – – END OF THE DATABASE – – – – –

    Thanks in advance
    kele

    https://wordpress.org/plugins/wp-online-store/

Viewing 1 replies (of 1 total)
  • These are my notes taken from an article I wrote for the WPOLS Knowledgebase. I think you may also get to see a more complete list of the DB tables created by looking in the wponlinestore.php file in the WP Online Store folder. I hope this helps:

    If you have a database back up, you can recreate your store (products, customers, orders, et al), by importing DATA ONLY from the store database tables of your back up into a clean (no products) install of the plugin. This requires some mySQL knowledge and it may mean that you install the complete backup of your old database into a secondary database in order to extract the tables you need as DATA ONLY. There are close to 20 tables that the store uses so you will have to figure out which ones you want to keep. Here is a list of most of the tables created. You may not need to move them all – it all depends upon how many changes you have made in your store. Use your eyes and judgment by comparing your old tables to the new ones:

    Categories:

    categories

    categories_description

    Store configuration:
    configuration (probably only the first 30 rows)

    countries (if you have modified any default store data)
    currencies (if you have modified any default store data)

    Customers:
    customers
    customers_basket (I don’t think you will need this one)
    customers_basket_attributes (I don’t think you will need this one)
    customers_info
    customers_to_discount_codes

    discount_codes
    eorder_text

    If you have added Extra Product Fileds:
    extra_field_labels
    extra_field_values
    extra_product_fields
    extra_value_exclude

    files_uploaded
    geo_zones (if you have added/modified zones)

    information
    information_group
    languages (if you have added another language)

    manufacturers
    manufacturers_info

    newsletters (if you have any newsletters)

    Customer Orders:
    orders
    orders_products
    orders_products_attributes
    orders_products_download
    orders_status
    orders_status_history
    orders_total

    Products:
    products
    products_attributes
    products_attributes_download
    products_description
    products_images

    products_notifications
    products_options
    products_options_values
    products_options_values_to_products_options

    products_shipping

    products_to_categories

    reviews (if you have product reviews)
    reviews_description (if you have product reviews)
    sessions (I don’t think you will need this one)
    slideshow (if you homepage slideshows)
    specials (if you have created specials)
    tax_class (if you have modified any default store data)
    tax_rates (if you have modified any default store data)

    The product images will have to uploaded into the image folder, as would any modified files you have backed up (such as CSS files).

Viewing 1 replies (of 1 total)
  • The topic ‘WP-Online Store Database Tables’ is closed to new replies.