CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Where to find selected premium in database?
Pages: [1]

Author Topic: Where to find selected premium in database?  (Read 428 times)

ehlondon

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 0
Where to find selected premium in database?
January 28, 2013, 08:08:34 am
I am trying to create a module that tracks inventory for Premiums but can't seem to find where a selected Premium for  a contribution is stored or  how to even get to it.

Can anyone point me in the right direction?

Thanks.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Where to find selected premium in database?
January 28, 2013, 08:39:50 am
if you run this in mysql shell:

> show tables like '%premium%';
> show tables like '%product%';

u'll see the premium and product related tables

lobo
« Last Edit: January 28, 2013, 08:42:34 am by Donald Lobo »
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ehlondon

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 0
Re: Where to find selected premium in database?
January 28, 2013, 10:22:38 am
Got it. It's in civicrm_contribution_product (was checking all the others).
Thanks.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Where to find selected premium in database?

This forum was archived on 2017-11-26.