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 02-26-2019, 08:05 AM
SxcDev SxcDev is offline
Newbie
 
Join Date: Mar 2014
Posts: 16
Default Invalid shipping data returned by API

Hi,

If an order query is posted to the API, it is returning invalid data. The query would be this as an example:
Code:
<?xml version="1.0" encoding="iso-8859-1"?>
<orderquery>
	<username>[username]</username>
	<password>[password]</password>
  	<order>
    	<REFNUM>112233</REFNUM>
  		<shiptozip>90017</shiptozip>
		<country>US</country>
    	<products>
      		<item>
        		<pnum>CNVELD-8604-620</pnum>
        		<qty>1</qty>
      		</item>
    	</products>
  	</order>
</orderquery>
The response is this:

Code:
<?xml version="1.0" encoding="iso-8859-1"?>
<ORDERQUERY>
    <ORDER>
        <REFNUM>112233</REFNUM>
        <PRODUCTS>
            <ITEM>
                <PNUM>CNVELD-8604-620</PNUM>
                <QTY>1</QTY>
                <STOCK>1</STOCK>
                <VENDORCODE>ELD</VENDORCODE>
                <VENDOR>
                    <![CDATA[Eldorado]]>
                </VENDOR>
                <SHIPPING>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS First Class</CARRIER>
                        <PRICE>$4.99</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Priority</CARRIER>
                        <PRICE>$9.99</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER></CARRIER>
                        <PRICE>$48.80</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>Standard Shipping</CARRIER>
                        <PRICE>$5.99</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER></CARRIER>
                        <PRICE>$5.99</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Priority</CARRIER>
                        <PRICE>$13.99</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>FedEx Express Saver</CARRIER>
                        <PRICE>$17.20</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>UPS Blue</CARRIER>
                        <PRICE>$24.99</PRICE>
                    </SHIPPINGOPTION>
                    <SHIPPINGOPTION>
                        <CARRIER>USPS Express</CARRIER>
                        <PRICE>$41.99</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>
Now, what you can see there are several issues:

1 - Shipping options with empty "CARRIER" fields.
2 - Duplicate shipping options with different prices:
USPS Priority $5.99
USPS Priority $13.99

Now, when a customer orders an item, and selects USPS Priority ($5.99), the code M02 is sent as part of that order. Once the order is forwarded to the order API, CNV is treating it as $13.99, so it means the customer has underpaid, and the store owner has to cover the difference in price.

How should we deal with these issues?

I'm assuming that we should just ignore the options with empty "CARRIER" fields, as for the duplicate items, do we always select the higher priced entry to display to the customer? Is this correct, or is there something else we need to do?

Last edited by SxcDev; 02-26-2019 at 08:08 AM.
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 04:35 PM.


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