Here is the Opencart mySQL database explained, also some information about importing products from phpmyadmin.
All tables have “oc_” as prefix, which comes from Opencart.
I’ve bolded the imporant SQL tables.
You can use the list below to try to insert products directly from phpmyadmin.
I’ve tried and it worked.
No need to delete any cache or anything.
You just need to insert values in the tables that are bolded in this article.
All the Opencart mySQL database explained
oc_address – contains the registered users.
oc_affiliate – registered affiliates.
oc_affiliate_transaction – I guess it shows orders came trough affiliates.
oc_attribute – ?
oc_attribute_description – ?
oc_attribute_group – ?
oc_attribute_group_description – ?
oc_banner – the default banners from the default theme.
You can also see them from admin, modules, banner.
oc_banner_image – contains the paths to the banner images.
From admin, system > design > banners.
oc_banner_image_description – related to the banners from the default theme.
Check above.
oc_category – some data regarding categories, should not be modified from phpmyadmin.
oc_category_description – displays the description for the categories from your store.
If you remember, when you create a category, besides the name of the category, you can enter a description.
You can modify it from here but there is no point.
oc_category_filter – it’s empty, no idea.
oc_category_path – I think it contains the relation between categories and subcategories.
oc_category_to_layout – empty, no idea.
oc_category_to_store – ?
oc_country – A list with all the countries that are available in the store.
Admin > system > localisation > countries.
oc_coupon – related to discount coupons.
The same thing you will find from admin > sales > coupons.
oc_coupon_category – empty, nothing.
oc_coupon_history – empty, nothing.
oc_coupon_product – empty, nothing.
oc_currency – currency, you can modify from system > localisation > currencies.
oc_customer – all the registered users with passwords, e-mail etc.
oc_customer_ban_ip – ban ips I guess.
oc_customer_field – empty, nothing.
oc_customer_field – related to customers, nothing to see.
oc_customer_group_description – related to customers, nothing to see.
oc_customer_history – empty, nothing.
oc_customer_ip – ips, nothing.
oc_customer_online – empty, nothing.
oc_customer_reward – empty, nothing.
oc_customer_transaction – ?
oc_custom_field – empty, nothing.
oc_custom_field_description – empty, nothing.
oc_custom_field_to_customer_group – empty, nothing.
oc_custom_field_value – empty, nothing.
oc_custom_field_value_description – empty, nothing.
oc_download – empty, nothing.
oc_download_description – empty, nothing.
oc_extension – related to extensions/modules.
oc_filter – empty, nothing.
oc_filter_description – empty, nothing.
oc_filter_group – empty, nothing.
oc_filter_group_description – empty, nothing.
oc_geo_zone – this table is related to VAT.
You can change from admin, system > localisation > geo zones and taxes.
oc_information – some stuff regarding the bottom information from all pages.
oc_information_description – same as above but with full words.
oc_information_to_layout – empty, nothing.
oc_information_to_store – some numbers related to the same bottom information pages.
oc_kbm_article – nothing.
other tables that start to oc_kbm are related to the Ocommerce blog, nothing to see there.
oc_language – related to languages, admin > system > localisation > languages.
oc_layout – displays the layouts.
Admin > system > design > layouts.
oc_layout_route – shows how every page has a layout assigned.
oc_length_class – probably related to a product characteristic like length.
There should be some setting for this in admin.
oc_length_class_description – same as above.
oc_manufacturer – manufacturers.
From admin > catalog > manufacturers.
oc_manufacturer_to_store – same as above, some values that are in relation to manufacturers.
oc_option – some HTML tags, no idea.
oc_option_description – same as above, nothing important.
oc_option_value – same as above, values.
oc_option_value_description – same as above, related.
oc_order – orders from clients.
You can see them also from admin > sales > orders.
oc_order_download – I guess for download sales, if your store has something like that.
oc_order_field – nothing.
oc_order_fraud – nothing.
oc_order_history – values regarding orders.
Nothing.
oc_order_option – empty.
oc_order_product – this option displays the products that have been ordered with names and price.
oc_order_recurring – empty, nothing.
oc_order_recurring_transaction – empty, nothing.
oc_order_status – nothing important.
oc_order_total – nothing important, some values regarding past orders.
oc_order_voucher – empty, nothing.
Opencart mySQL database explained, some of the most important tables
* oc_product – here are the products stored, probably the most important table.
Contains small details like title, price etc.
oc_product_attribute – empty, nothing.
* oc_product_description – the description for the products, are in close relation to the oc_product table.
If you see two items there, it means that there is one for each language.
If you have another language besides English.
oc_product_discount – empty, nothing.
oc_product_filter – empty, nothing.
oc_product_image – empty, nothing.
oc_product_option – empty, nothing.
oc_product_option_value – empty, nothing.
oc_product_profile – empty, nothing.
oc_product_recurring – empty, nothing.
oc_product_related – empty, nothing.
oc_product_reward – related to reward, fidelity points, ignore it.
oc_product_special – empty, nothing.
* oc_product_to_category – important.
Here you need to set the correct id for all the products to their corresponding categories.
You can find the category names in the oc_category_description table.
oc_product_to_download – empty, nothing.
oc_product_to_layout – empty, nothing.
* oc_product_to_store – important.
Every product should have an entry here.
oc_profile – empty, nothing.
oc_profile_description – empty, nothing.
oc_return and all the corespondants – it’s about returning products, nothing important.
oc_review – probably it’s about the reviews and comments to products.
oc_setting – a lot of stuff here, mostly regarding modules and general settings.
You should not modify here anything.
oc_stock_status – some values, nothing important.
oc_store – displays the stores, from admin > system > setting.
You might find here more than one store if you are using custom modules, extensions.
oc_tax_class – taxes and VAT.
oc_tax_rate – same as above, do not modify.
Admin > system > localisation > taxes.
oc_tax_rate_to_customer_group – nothing.
oc_tax_rule – other values, nothing important.
* oc_url_alias – these are the SEO keywords for both products and categories.
Should be managed carefully.
oc_user – admin, the users for the store.
Do not modify here unless you want to change the username or the e-mail address.
oc_user_group – related to the table from above.
oc_voucher and the others – related to vouchers, nothing important.
oc_weight_class – as it’s saying, related to weight, nothing important.
oc_zone – countries, zones and codes, nothing important.