Find Relation in Database between Coupon Series and Categores, Products and Users assigned to Coupon Series

English forums
1

Hello everyone,

When new Coupon Serie is created, in OXID Admin there is a possibility to Assign Categories, Products, and Users to the series. So, how to find in database categories, products or users that are assigned to some Coupon Series?

Thank you!

2

You could open PhpMyAdmin overview over all tables, assign something to your coupon code, open another tab with PhpMyAdmin and compare amounts of data rows in each table with the overview you opened before assigning new items to coupons.
This way you can silmply identify tables with added data

1 Like
3

Thank you for the suggestion.
Table is ‘oxobject2discount’, maybe this will help to someone.

Thank you!