CNV.com Message Forums Forum owned by CNV.com Inc.
Wholesale and Drop Ship Adult Toys at SextoyClub.com
Sex Toys Affiliate program at AdultShopping.com
 

Go Back   CNV.com Message Forums > Wholesale and Drop Ship: SexToyClub.com > Datafeeds

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2015, 01:05 AM
SxcDev SxcDev is offline
Newbie
 
Join Date: Mar 2014
Posts: 15
Default Issue with shipping options returned via API

Hi guys.

If I request a stock check via the API, the response includes the available shipping options and associated cost for each. The issue I'm having at the moment is that several shipping options are returned more than once in the same response, as well as a blank shipping option.

As an example, please have a look at this response to a stock query via the API:

Code:
<?xml version="1.0" encoding="iso-8859-1"?>
<ORDERQUERY>
    <ORDER>
        <REFNUM>ShippingEST</REFNUM>
        <PRODUCTS>
            <ITEM>
                <PNUM>CNVELD-8131-09</PNUM>
                <QTY>1</QTY>
                <STOCK>1</STOCK>
                <VENDORCODE>ELD</VENDORCODE>
                <VENDOR><![CDATA[Eldorado]]></VENDOR>
                <SHIPPING>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS First Class</CARRIER>
                        <PRICE>$5.30</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Priority</CARRIER>
                        <PRICE>$8.80</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Express</CARRIER>
                        <PRICE>$48.80</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER></CARRIER>
                        <PRICE>$6.50</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>Standard Shipping</CARRIER>
                        <PRICE>$7.00</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Priority</CARRIER>
                        <PRICE>$9.00</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>FedEx Express Saver</CARRIER>
                        <PRICE>$17.20</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>UPS Blue</CARRIER>
                        <PRICE>$25.50</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Express</CARRIER>
                        <PRICE>$35.00</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>UPS Ground</CARRIER>
                        <PRICE>$11.60</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>UPS Orange</CARRIER>
                        <PRICE>$23.10</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>UPS Blue</CARRIER>
                        <PRICE>$28.90</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>UPS Red</CARRIER>
                        <PRICE>$68.50</PRICE>
                    </SHIPPINGOPTION>
                </SHIPPING>
            </ITEM>
        </PRODUCTS>
    </ORDER>
</ORDERQUERY>
As you can see above (in bold), there are duplicate entries for USPS Express and UPS Blue, both with completely different prices. There is also a shipping option with a blank 'CARRIER' field, but it has a price listed.

What is going on? If this can't be fixed in the CNV API, then I can just work around it, but I'll have to use the higher price of any duplicated entries in there just to be safe. I would really prefer for this to be fixed in the API.
Reply With Quote
  #2  
Old 04-23-2015, 10:32 AM
CNVAdmin CNVAdmin is offline
Administrator
 
Join Date: Dec 2010
Location: Viva Las Vegas
Posts: 382
Default

Hello SxcDev,

It's not the Order API fault, but multiple listings in the ELD shipping methods:

https://secure2.sextoyclub.com/vendo...lub&vendor=ELD

The Order API is just querying the above data and returning it for you.

I'm bringing this to the programming staff attention, so they can fix this.
__________________
--
Best Regards,
Mike
CNV.com
Reply With Quote
  #3  
Old 04-23-2015, 05:23 PM
SxcDev SxcDev is offline
Newbie
 
Join Date: Mar 2014
Posts: 15
Default

Thank you Mike!

I can see the issue in the table now. So I'm assuming the country code is used to pick the correct entries, but those entries all map to the same Shipping Code, and that Shipping Code maps to the whatever Carrier name they seem to have in their API handler. It would have been better to just return the shipping codes instead of the carrier names (or both carrier name and shipping code).

Also, the blank entry in the response seems to be the "4 to 8 business days B2CBR" entry in that table, going off the "$6.50" figure. I hope they can adjust that as well to have a valid carrier name in it.

RH
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 05:09 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2008-2010 CNV.com