Announcement

Collapse
No announcement yet.

Querying for Gift Certificates

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Querying for Gift Certificates

    is there a way to query for gift certificates? we would like to validate gift certificates existence and value.
    thanks

  • #2
    Go to: Settings>Payment>Gift Certificates, there is a search bar

    Comment


    • #3
      Using the advanced api you can query the [promotions] table. This is a sample row.

      Code:
      {
          "id":[removed],
          "promotion_name":[removed],
          "promotion_description":[removed],
          "promotion_start":"2/3/2007",
          "promotion_end":"2/9/2020",
          "promotion_enabled":"1",
          "by_amount":"0",
          "chk_byamount":"0",
          "by_quantity":"0",
          "chk_byquantity":"0",
          "by_product":"0",
          "by_category":{},
          "promotion_amount":"5",
          "promotion_percentage":"1",
          "promotion_peritem":"0",
          "promotion_category":{},
          "promotion_product":{},
          "promotion_freeshipping":"0",
          "promotion_freeproduct":{},
          "prod1_id":"0",
          "prod1_qty":"0",
          "prod2_id":"0",
          "prod2_qty":"0",
          "prod3_id":"0",
          "prod3_qty":"0",
          "prod4_id":"0",
          "prod4_qty":"0",
          "coupon":[removed],
          "promotion_uses":"1193",
          "promotion_maxuses":"9999",
          "promotion_usespercust":"10",
          "coupon_group":"-1",
          "userid":[removed],
          "last_update":"3/13/2015 12:25:35 PM", 
          "by_amount2":"9999",
          "by_quantity2":"9999",
          "nonstackable":"0",
          "promotion_country":"All",
          "promotion_state":"All",
          "rules_retailprice":"0",
          "exc_manufacturer":{},
          "promotion_freeproduct_price":"0",
          "exc_preorder":"0",
          "shipping_discount":"0",
          "shipping_options":{},
          "recurringorders":"0",
          "bonus_reward_points":"0"
      }
      This is a JSON stringified result of a row I pulled from my test store. Should give you a good idea with what you're working with.

      Comment


      • #4
        Originally posted by jleclair View Post
        Using the advanced api you can query the [promotions] table. This is a sample row.

        Code:
        {
        "id":[removed],
        "promotion_name":[removed],
        .
        .
        .
        "bonus_reward_points":"0"
        }
        This is a JSON stringified result of a row I pulled from my test store. Should give you a good idea with what you're working with.
        This is perfect, exactly what I needed. Where can I find some documentation on the advanced API or the endpoint you used to get this result?

        thanks again!

        Comment


        • #5
          https://support.3dcart.com/knowledge...ical-reference

          download the zip

          Comment


          • #6
            thanks! this worked perfectly

            Comment


            • #7
              Maybe I'm missing something, but the original question was about Gift Certificates and the answer is about Promotions.

              Are gift certificates available on Promotions? I haven't been able to see mine on my 3D Cart store. I can see coupon codes, but not Gift Certificates.

              Comment

              Working...
              X