Post by godly75 » Sun Nov 11, 2018 10:28 pm

All these or am I missing others?
  • order
    order_history
    order_option
    order_product
    order_recurring
    order_recurring_transaction
    order_shipment
    order_status
    order_total
    order_voucher
  • customer
    customer_activity
    customer_affiliate
    customer_approval
    customer_group
    customer_group_description
    customer_history
    customer_ip
    customer_login
    customer_online
    customer_reward
    customer_search
    customer_transaction
    customer_wishlist
    custom_field
    custom_field_customer_group
    custom_field_description
    custom_field_value
    custom_field_value_description

Active Member

Posts

Joined
Fri Oct 27, 2017 1:21 am

Post by straightlight » Mon Nov 12, 2018 3:48 am

On GitHub, you could search for the: system/helper/db_schema.php file and lookup for each: order_id database fields. This will also show you the table source name that each orders are associated into despite if a customer has been logged with the order or without.

However, take note that this methodology may exclude the aside extensions you may had installed on your store which may also contain other order_id database fields. Otherwise, you may need to pull in a schema query from PHPMyAdmin (direct) to pull all the order_id database fields which will include all database tables.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by ostechnologies » Mon Nov 12, 2018 5:20 pm

Just take a look at the schema of all the table in your database, if it contains order_id or customer_id then include that file also. In this way, third-party extension tables that use order_id or customer_id will also get included.

Opencart Expert | sales[at]ost.agency
Skype - manish.osuniverse | Gtalk - manishmt

Extensions for Opencart @ https://www.ost.agency/product/product- ... extensions
ost.agency - ecommerce website design, development and digital company


User avatar
Active Member

Posts

Joined
Mon Apr 06, 2015 1:30 pm

Post by Cue4cheap » Sat Sep 24, 2022 6:13 am

I KNOW this is years old post but since I just did this on a test store this is what I got:
TABLE_NAME  1 | COLUMN_NAME
address | customer_id
cart | customer_id
coupon_history | customer_id
customer | customer_id
customer_activity | customer_id
customer_field | customer_id
customer_history | customer_id
customer_ip | customer_id
customer_online | customer_id
customer_reward | customer_id
customer_search | customer_id
customer_transaction | customer_id
customer_wishlist | customer_id
order | customer_id
order_fraud | customer_id
return | customer_id
review | customer_id
affiliate_transaction | order_id
apri | order_id
coupon_history | order_id
customer_reward | order_id
customer_transaction | order_id
order | order_id
order_custom_field | order_id
order_download | order_id
order_fraud | order_id
order_history | order_id
order_option | order_id
order_product | order_id
order_recurring | order_id
order_total | order_id
order_voucher | order_id
return | order_id
voucher | order_id
voucher_history | order_id

Sorry about the formatting but it should be understandable.
Also this doesn't include payment tables so if you use paypal it will also have those tables that use customer_id and/or order_id.

Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am
Who is online

Users browsing this forum: ravikumar22, Semrush [Bot] and 80 guests