Join Free
+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
  1. #1

    [price_sale] and [percentOff] are empty

    Trying to return specific products that are discounted.. But the results returned have 2 crucial fields that are empty

    [price_sale] and [percentOff] are empty

    Here is the api call

    http://api.prosperent.com/api/search?api_key=mykey&query='.$prosper_query.'&page =1&limit=8&minPrice=300&percentOff=15,&sortBy=perc entOff+desc&relevancyThreshold=1';

    Any help?

  2. #2
    Lower the relevancy threshold. That is a VERY specific query

  3. #3
    I tried lowering the relevancy threshold .7 and .8 This did not help fill the price-sale or percentOff variables, just returned unwanted items.

  4. #4
    What are some sample queries you are using? I'd remove the relevancyThreshold completely, but even with it set to 0.7 and 0.8 I'm getting correct results on some queries I've tested.

  5. #5
    Here is one api call
    Code:
    http://api.prosperent.com/api/search?api_key=mykey&query=myquery&page=1&limit=8&minPrice=300&percentOff=15,&sortBy=percentOff+desc&relevancyThreshold=1
    Last edited by ozzyeye; 09-26-2016 at 10:32 PM.

  6. #6
    Any help with this issue..?

  7. #7
    What are your search queries, because that url is working for me when I put my API Key and a query in.

  8. #8
    I am getting results with my API key as well.

    I simply put "lipstick" in my query.

    This is something that could useful for our site, so I am glad you brought it up.

  9. #9
    Quote Originally Posted by prosperent brandon View Post
    What are your search queries, because that url is working for me when I put my API Key and a query in.
    Quote Originally Posted by BeautyNewsNYC View Post
    I am getting results with my API key as well.

    I simply put "lipstick" in my query.

    This is something that could useful for our site, so I am glad you brought it up.
    His problem isn't getting any data back, his problem is that percentOff and price_sale is empty

    @ozzyeye, in some instances, when the "price_sale" doesn't differ from "price" (or the merchant simply doesn't supply that data), it is impossible to calculate percentage Off as you can't divide by 0 (or nothing), which in turn, brings back the result "null" in "percentOff"

    Take the following for example:

    Code:
    {
       "errors":[
    
       ],
       "warnings":[
    
       ],
       "data":[
          {
             "catalogId":"8db3422aa466a0cdd591214a5e0d5014",
             "productId":"80d55c8c4c592851eef66a104a20343f",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=Herve+Leger+Signature+Essential+Long+Sleeve+Cocktail+Dress+-+Lipstick&m=123936&b=Herve+Leger&p=8db3422aa466a0cdd591214a5e0d5014",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/images-na.ssl-images-amazon.com\/images\/G\/01\/Shopbop\/p\/pcs\/products\/herve\/herve2006310024\/herve2006310024_q1_1-2._QL90_UX336_.jpg",
             "keyword":"Herve Leger Signature Essential Long Sleeve Cocktail Dress - Lipstick",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"This off shoulder, banded formfitting dress features a hidden back zip. Ribbed long sleeves. Fabric: Ribbed mid weight jersey. 90% rayon\/9% nylon\/1% spandex. Dry clean. Imported, China. MEASRUEMENTS Length: 33in \/ 84cm, from shoulder. Available sizes: XS,XXS",
             "category":"clothing & accessories > women > dresses > night out & cocktail",
             "price":"1150.00",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"Shopbop",
             "merchantId":"123936",
             "brand":"Herve Leger",
             "upc":"",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"236b62379ded67ba6a5b5da8f0445644",
             "productId":"8bb902b422e6fa4379ae378f98a597da",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=Sergio+Rossi+-+Matisse+Peep+Toe+%28Lipstick%29+Women%27s+Shoes&m=124147&b=Sergio+Rossi&p=236b62379ded67ba6a5b5da8f0445644",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/www.6pm.com\/images\/z\/3\/0\/5\/4\/0\/0\/3054001-p-2x.jpg",
             "keyword":"Sergio Rossi - Matisse Peep Toe (Lipstick) Women's Shoes",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"Create an unforgettable look with the impressive style of Sergio Rossi. ; Leather upper with tonal stitching. ; Adjustable ankle strap with buckle closure. ; Open toe silhouette. ; Leather lining and insole. ; Genuine leather outsole with wrapped stiletto heel. ; Made in Italy. ; This item may ship with an attached security tag. Merchandise returned without the original security tag attached or a damaged tag may not qualify for a refund. Measurements: ; Heel Height: 4 in ; Weight: 7 oz ; Product measurements were taken using size 38.5 (US Women's 8.5) , width M. Please note that measurements may vary by size.",
             "category":"shoes > women > sandals",
             "price":"358.49",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"6pm.com",
             "merchantId":"124147",
             "brand":"Sergio Rossi",
             "upc":"880644577492",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"fece79d7bdc676ea3111ea666c6b5d6c",
             "productId":"f444ee64506685cd01548b182df76323",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=She+%2B+Lo+-+Breakthrough+Zip+Crossbody+%28Lipstick+Red%29+Cross+Body+Handbags&m=124147&b=She+%2B+Lo&p=fece79d7bdc676ea3111ea666c6b5d6c",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/www.6pm.com\/images\/z\/3\/4\/8\/1\/1\/3\/3481135-p-2x.jpg",
             "keyword":"She + Lo - Breakthrough Zip Crossbody (Lipstick Red) Cross Body Handbags",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"A rocker chic appeal, the She + Lo Breakthrough Zip Crossbody bag gives your look an edge. ; Made of leather with stud detail. ; Dual zipper closure. ; Crossbody strap with chain detail. ; Zipper detail at base. ; Lined interior. ; Interior back-wall zip pocket. ; Interior multifunctional slip pocket. ; Imported. Measurements: ; Bottom Width: 10 in ; Depth: 2 in ; Extended Depth: 2 3 4 in ; Height: 7 in ; Strap Length: 47 1 2 in ; Strap Drop: 22 in ; Weight: 1 lb 1.8 oz ; This product may have a manufacturer's warranty. Please visit the manufacturer's website or contact us at for full manufacturer warranty details.",
             "category":"shoes > handbags > cross-body bags",
             "price":"109.99",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"6pm.com",
             "merchantId":"124147",
             "brand":"She + Lo",
             "upc":"840656106707",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"0f4e24a8ee88af2349a2e9d4745b031c",
             "productId":"78cf5cfdf1bff9fdcd1b22f04e9e601e",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=Liebeskind+-+Edda+%28Lipstick%29+Cross+Body+Handbags&m=124147&b=Liebeskind&p=0f4e24a8ee88af2349a2e9d4745b031c",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/www.6pm.com\/images\/z\/3\/6\/1\/5\/4\/3\/3615430-p-2x.jpg",
             "keyword":"Liebeskind - Edda (Lipstick) Cross Body Handbags",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"Strut your stuff in fun and free fashion with the Edda. ; Made of leather with fringe detail. ; Flap with magnetic snap with zipper closure. ; Exterior back zip pocket. ; Signature logo detail in front. ; Flat bottom. ; Lined interior. ; Interior back-wall zip pocket. ; Two interior multifunctional slip pockets. ; Imported. Measurements: ; Bottom Width: 10 in ; Depth: 3 1 2 in ; Height: 9 in ; Strap Length: 51 in ; Strap Drop: 24 in ; Weight: 1 lb ; This product may have a manufacturer's warranty. Please visit the manufacturer's website or contact us at for full manufacturer warranty details.",
             "category":"shoes > handbags > cross-body bags",
             "price":"119.99",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"6pm.com",
             "merchantId":"124147",
             "brand":"Liebeskind",
             "upc":"4051436824360",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"f4435bdf3319490001d75655454920a0",
             "productId":"9bb60065ea66477398e50598faa116f0",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=Eider+Valdez+Insulated+Hooded+Jacket+-+Women%27s+Grenadine%2FLipstick+Rose%2C+8&m=123472&b=Eider&p=f4435bdf3319490001d75655454920a0",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/www.backcountry.com\/images\/items\/1200\/EID\/EID004O\/GREROS.jpg",
             "keyword":"Eider Valdez Insulated Hooded Jacket - Women's Grenadine\/Lipstick Rose, 8",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"Make the Eider Women's Valdez Insulated Hooded Jacket your go-to midlayer for winter skiing. Primaloft Silver Eco insulation uses partially-recycled materials for warmth, and Thermostretch panels ensure mobility so you can ski like it wasn't there. Eider treated the tough-and-light ripstop shell with DWR to shed moisture and keep you comfortably dry.",
             "category":"clothing & accessories > women > active > track & active jackets",
             "price":"229.95",
             "price_sale":"91.98",
             "percentOff":"60",
             "currency":"USD",
             "merchant":"Backcountry",
             "merchantId":"123472",
             "brand":"Eider",
             "upc":"3600876345501",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"a73dde93bce04a680f4b1d7a0e77b0f1",
             "productId":"12293dba9c3f78719b7c0fe3b9090f0c",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=Maison+Martin+Margiela+%27Replica+-+Lipstick+On%27+Fragrance&m=127294&b=Maison+Martin+Margiela&p=a73dde93bce04a680f4b1d7a0e77b0f1",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/content.nordstrom.com\/imagegallery\/store\/product\/large\/19\/_12053999.jpg",
             "keyword":"Maison Martin Margiela 'Replica - Lipstick On' Fragrance",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"The intimate atmosphere of a boudoir. Girls' garments and makeup all around. The precise gestures of a woman getting ready for a night out. Scents of rice powder and lipstick. A partially opened door inside an intimate apartment. Hidden from view, a woman puts the finishing touches on her makeup. A delicate cloud of rice powder. Crimson red lips. Lipstick On sketches the portrait of a woman getting ready to go out. The silhouette of each Replica bottle is inspired by classic apothecary jars, allowing the collection to be instantly identifiable. Each bottle features a 100% cotton label, which is printed using black ink text and resembles the tags used on clothes and accessories found in the Replica couture collection, in addition to a unique pump wrapped with rope to symbolize the authentic reproduction of the original couture line. The same label concept is carried onto the packaging of each fragrance. Each carton label is associated with a Polaroid photograph-a fleeting moment captured in muted colors and soft light that is a poetic allusion to the story behind each fragrance. Notes:- Top: bergamot oil, heliotrope, neroli oil- Middle: orange flower absolute, iris concrete, galbanum oil- Base: tonka bean absolute, vanilla bourbon extract, patchouli oil. Brand: MAISON MARTIN MARGIELA. Style Name: Maison Martin Margiela 'Replica - Lipstick On' Fragrance. Style Number: 5119117. Available in stores.",
             "category":"health & personal care > makeup > lips > lipstick",
             "price":"125.00",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"Nordstrom",
             "merchantId":"127294",
             "brand":"Maison Martin Margiela",
             "upc":"3614270562099",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"dc397b7353daf84f33e576829472fc36",
             "productId":"2942146db4b4c678825a8780ca3fbb36",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=Charlotte+Tilbury+%27K.i.s.s.i.n.g%27+Luxury+Lipstick+Wardrobe+-&m=127294&b=Charlotte+Tilbury&p=dc397b7353daf84f33e576829472fc36",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/content.nordstrom.com\/imagegallery\/store\/product\/large\/1\/_11453581.jpg",
             "keyword":"Charlotte Tilbury 'K.i.s.s.i.n.g' Luxury Lipstick Wardrobe -",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"What it is: The K.I.S.S.I.N.G Luxury Lipstick Wardrobe gives you perfect lips every day of the year. From the iconic Nude Kate to the deep red beauty of Love Bite, this is Charlotte Tilbury's entire collection of K.I.S.S.I.N.G lipsticks. Whatever mood, whatever style, you'll have a life-changing lipstick for each look. What it does: These lipsticks are enriched with Charlotte's unique, secret formulation derived from the Lipstick Tree, which wraps your lips in protective, UV-shielding coating to help them retain moisture and plumpness all year round. Light-diffusing particles give your lips a full-bodied, youth-boosted, three-dimensional finish. Shades include:- Bitch Perfect- Coachella Coral- Hepburn Honey- Love Bite- Night Crimson- Nude Kate- Penelope Pink- So Marilyn- Stoned Rose- Velvet UndergroundHow to use: Using different techniques, you can get multiple looks from your lipstick. For the day, match your lip liner to your lipstick for natural definition. Apply the lipstick straight from the bullet for a quick, easy lipstick slick or apply with a lip brush for more precision. For a night look, layer a lip lacquer on top. Brand: Charlotte Tilbury. Style Name: Charlotte Tilbury 'K.i.s.s.i.n.g' Luxury Lipstick Wardrobe (Limited Edition) ($320 Value) . Style Number: 5039041. Available in stores.",
             "category":"health & personal care > makeup > lips > lipstick",
             "price":"305.00",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"Nordstrom",
             "merchantId":"127294",
             "brand":"Charlotte Tilbury",
             "upc":"",
             "isbn":"",
             "sales":0
          },
          {
             "catalogId":"2d8ca644fc149291833d1a5210c5da6a",
             "productId":"d91f797b76e9a3a330a0beb3359cdbb3",
             "affiliate_url":"http:\/\/prosperent.com\/store\/product\/214671-40-0\/?k=She+%2B+Lo+-+Next+Chapter+Satchel+%28Lipstick+Red%29+Satchel+Handbags&m=124147&b=She+%2B+Lo&p=2d8ca644fc149291833d1a5210c5da6a",
             "image_url":"http:\/\/images.prosperentcdn.com\/images\/250x250\/www.6pm.com\/images\/z\/3\/4\/8\/1\/1\/2\/3481123-p-2x.jpg",
             "keyword":"She + Lo - Next Chapter Satchel (Lipstick Red) Satchel Handbags",
             "keywords":null,
             "celebrity":[
    
             ],
             "description":"Just enjoy the plush details of this exquisite She + Lo Next Chapter Satchel. ; Made of soft leather. ; Zipper closure. ; Dual rolled carrying handles with detachable, adjustable shoulder strap. ; Three exterior zip pockets. ; Strap detail at base. ; Lined interior. ; Interior back-wall zip pocket. ; Interior multifunctional slip pockets. ; Imported. Measurements: ; Bottom Width: 13 in ; Depth: 5 1 2 in ; Height: 10 in ; Strap Length: 34 in ; Strap Drop: 15 in ; Handle Length: 16 in ; Handle Drop: 6 in ; Weight: 2 lbs 1.2 oz ; This product may have a manufacturer's warranty. Please visit the manufacturer's website or contact us at for full manufacturer warranty details.",
             "category":"shoes > handbags > top-handle bags",
             "price":"159.99",
             "price_sale":"",
             "percentOff":null,
             "currency":"USD",
             "merchant":"6pm.com",
             "merchantId":"124147",
             "brand":"She + Lo",
             "upc":"840656106851",
             "isbn":"",
             "sales":0
          }
       ],
       "coupons":"",
       "facets":"",
       "countryCode":"US",
       "page":1,
       "limit":8,
       "totalRecords":8,
       "totalRecordsAvailable":362,
       "totalRecordsFound":362,
       "extendedQuery":""
    }
    You will notice the ones I highlighted shows nothing, because you can't (price / price_sale) * 100 to get percentOff; You will also notice there are results with price_sale AND percentOff, but they're not as abundant as those without; This means that your query (whatever it may be) is maybe too restrictive, or if it's not, the resulting code displaying "percentOff" might throw away those results because it is null.

    I would suggest to use percentOff IF it is available, but not to base your queries off of it (order by/minimum percent Off etc)

    The API is quite powerful, and you'll be able to whip up a quick shopping comparison (with minimum/maximum price range) and then work out your own % off based on those results, instead of relying solely on that data.

    Remember, the data that Prosperent gives is scrubbed and processed to the nth degree, but is the same shitty data you get from ShareASale and Commission Junction. So if they don't supply it, then it's simply not available here either.

  10. #10
    Though with his request he has percentOff=15, which would return any products with a percentOff of 15% or more, so they shouldn't be empty when they are returned per that request. Which when I ran sample queries pulled back the correct results with percentOff of 15% and greater.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
coupons | coupons and deals