Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 8 of 8

Thread: How to get order-items on DumpOrder request?

  1. 12-29-2009, 07:07 AM #1
    swheeler is offline Junior Member
    Join Date
    Oct 2008
    Posts
    17

    Default How to get order-items on DumpOrder request?

    Hi,

    I have the following XML request string (straight from the user guide)...


    <AspDotNetStorefrontImport Verbose="false">
    <Get Table="Orders" Name="NewOrders">
    <OrderBy>OrderDate asc</OrderBy>
    <Criteria IsNew="1"/>
    </Get>
    </AspDotNetStorefrontImport>

    ...that returns a full record with regard to the order header, but associated order items are missing.

    Can some please indicate how to get the order items included in the DumpOrder XML returned.

    Thanks,

    Scott
  2. 12-29-2009, 07:33 AM #2
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    Can you post the xml that is returned to you?

    That request looks right to me, its what I use and I get full order details.
  3. 12-29-2009, 07:40 AM #3
    swheeler is offline Junior Member
    Join Date
    Oct 2008
    Posts
    17

    Default

    Thanks for looking at this. XML out is:

    <?xml version="1.0" encoding="utf-8"?>
    <AspDotNetStorefrontImportResult Version="" DateTime="12/29/2009 6:50:31 AM">
    <Get Table="Orders" Name="NewOrders" XmlPackage="" IDColumn="OrderNumber" DefaultWhereClause="" OrderBy="OrderDate asc">
    <Criteria IsNew="1" />
    <Orders>
    <OrderNumber>100000</OrderNumber>
    <OrderGUID>807da91d-7b14-428c-8be8-322ec679e44d</OrderGUID>
    <ParentOrderNumber />
    <StoreVersion>AspDotNetStorefront ML 7.1.1.0/7.1.1.0</StoreVersion>
    <QuoteCheckout>0</QuoteCheckout>
    <IsNew>1</IsNew>
    <ShippedOn />
    <CustomerID>58640</CustomerID>
    <CustomerGUID>1a576555-30c6-492e-9d0f-6130a2487fae</CustomerGUID>
    <Referrer>http://www.peachtreeshoppingcart.com/default.aspx</Referrer>
    <SkinID>1</SkinID>
    <LastName>Wheeler</LastName>
    <FirstName>Scott</FirstName>
    <Email>scott.wheeler@cadence-software.com</Email>
    <Notes>
    </Notes>
    <BillingEqualsShipping>0</BillingEqualsShipping>
    <BillingLastName>Wheeler</BillingLastName>
    <BillingFirstName>Scott</BillingFirstName>
    <BillingCompany>Cadence Software</BillingCompany>
    <BillingAddress1>6290 Mernic Drive</BillingAddress1>
    <BillingAddress2>
    </BillingAddress2>
    <BillingSuite>
    </BillingSuite>
    <BillingCity>Cincinnati</BillingCity>
    <BillingState>OH</BillingState>
    <BillingZip>45248</BillingZip>
    <BillingCountry>United States</BillingCountry>
    <BillingPhone>513-708-1317</BillingPhone>
    <ShippingLastName>Wheeler</ShippingLastName>
    <ShippingFirstName>Scott</ShippingFirstName>
    <ShippingCompany>Cadence Software</ShippingCompany>
    <ShippingResidenceType>1</ShippingResidenceType>
    <ShippingAddress1>6290 Mernic Drive</ShippingAddress1>
    <ShippingAddress2>
    </ShippingAddress2>
    <ShippingSuite>
    </ShippingSuite>
    <ShippingCity>Cincinnati</ShippingCity>
    <ShippingState>OH</ShippingState>
    <ShippingZip>45248</ShippingZip>
    <ShippingCountry>United States</ShippingCountry>
    <ShippingMethodID>1</ShippingMethodID>
    <ShippingMethod>Ground</ShippingMethod>
    <ShippingPhone>513-708-1317</ShippingPhone>
    <ShippingCalculationID>2</ShippingCalculationID>
    <Phone>513-708-1317</Phone>
    <RegisterDate>10/4/2008 11:15:34 AM</RegisterDate>
    <AffiliateID>0</AffiliateID>
    <CouponCode />
    <CouponType>0</CouponType>
    <CouponDescription />
    <CouponDiscountAmount>0.0000</CouponDiscountAmount>
    <CouponDiscountPercent>0.0000</CouponDiscountPercent>
    <CouponIncludesFreeShipping>0</CouponIncludesFreeShipping>
    <OkToEmail>1</OkToEmail>
    <Deleted>0</Deleted>
    <CardType>VISA</CardType>
    <CardName>Scott Wheeler</CardName>
    <CardNumber />
    <CardExpirationMonth>04</CardExpirationMonth>
    <CardExpirationYear>2010</CardExpirationYear>
    <CardStartDate>
    </CardStartDate>
    <CardIssueNumber>
    </CardIssueNumber>
    <OrderSubtotal>4.9500</OrderSubtotal>
    <OrderTax>0.0000</OrderTax>
    <OrderShippingCosts>0.0000</OrderShippingCosts>
    <OrderTotal>4.9500</OrderTotal>
    <PaymentGateway>MANUAL</PaymentGateway>
    <AuthorizationCode>0</AuthorizationCode>
    <AuthorizationResult>MANUAL GATEWAY SAID OK</AuthorizationResult>
    <AuthorizationPNREF>AEDB56FF-5931-422B-8551-3515CF436B73</AuthorizationPNREF>
    <TransactionCommand>x_type=AUTH_CAPTURE&amp;x_test _request=TRUE&amp;x_description=AspDotNetStorefron t+Order+100000&amp;x_amount=4.95&amp;x_card_num=** **7890&amp;x_card_code=***&amp;x_exp_date=04/2010&amp;x_phone=513-708-1317&amp;x_fax=&amp;x_customer_tax_id=&amp;x_cust_ id=58640&amp;x_invoice_num=100000&amp;x_email=scot t.wheeler%40cadence-software.com&amp;x_customer_ip=74.83.128.254&amp;x _first_name=Scott&amp;x_last_name=Wheeler&amp;x_co mpany=Cadence+Software&amp;x_address=6290+Mernic+D rive&amp;x_city=Cincinnati&amp;x_state=OH&amp;x_zi p=45248&amp;x_country=United+States&amp;x_ship_to_ first_name=Scott&amp;x_ship_to_last_name=Wheeler&a mp;x_ship_to_company=Cadence+Software&amp;x_ship_t o_address=6290+Mernic+Drive&amp;x_ship_to_city=Cin cinnati&amp;x_ship_to_state=OH&amp;x_ship_to_zip=4 5248&amp;x_ship_to_country=United+States&amp;x_cus tomer_ip=74.83.128.254</TransactionCommand>
    <OrderDate>10/4/2008 11:18:19 AM</OrderDate>
    <LevelID>0</LevelID>
    <LevelName />
    <LevelDiscountPercent />
    <LevelDiscountAmount />
    <LevelHasFreeShipping />
    <LevelAllowsQuantityDiscounts />
    <LevelHasNoTax />
    <LevelAllowsCoupons />
    <LevelDiscountsApplyToExtendedPrices />
    <LastIPAddress>74.83.128.254</LastIPAddress>
    <PaymentMethod>CREDITCARD</PaymentMethod>
    <OrderNotes>
    </OrderNotes>
    <PONumber>
    </PONumber>
    <DownloadEmailSentOn />
    <ReceiptEmailSentOn />
    <DistributorEmailSentOn />
    <ShippingTrackingNumber />
    <ShippedVIA />
    <CustomerServiceNotes>
    </CustomerServiceNotes>
    <RTShipRequest>
    </RTShipRequest>
    <RTShipResponse>
    </RTShipResponse>
    <TransactionState>CAPTURED</TransactionState>
    <AVSResult>OK</AVSResult>
    <CaptureTXCommand />
    <CaptureTXResult />
    <VoidTXCommand />
    <VoidTXResult />
    <RefundTXCommand />
    <RefundTXResult />
    <RefundReason />
    <CardinalLookupResult />
    <CardinalAuthenticateResult />
    <CardinalGatewayParms />
    <AffiliateCommissionRecorded>0</AffiliateCommissionRecorded>
    <OrderOptions>
    </OrderOptions>
    <OrderWeight>1.0000</OrderWeight>
    <eCheckBankABACode>
    </eCheckBankABACode>
    <eCheckBankAccountNumber>
    </eCheckBankAccountNumber>
    <eCheckBankAccountType>
    </eCheckBankAccountType>
    <eCheckBankName>
    </eCheckBankName>
    <eCheckBankAccountName>Scott Wheeler</eCheckBankAccountName>
    <CarrierReportedRate />
    <CarrierReportedWeight />
    <LocaleSetting>en-US</LocaleSetting>
    <FinalizationData>&lt;root&gt;&lt;/root&gt;</FinalizationData>
    <ExtensionData />
    <AlreadyConfirmed>1</AlreadyConfirmed>
    <CartType>0</CartType>
    <THUB_POSTED_TO_ACCOUNTING>N</THUB_POSTED_TO_ACCOUNTING>
    <THUB_POSTED_DATE />
    <THUB_ACCOUNTING_REF />
    <Last4>7890</Last4>
    <ReadyToShip>0</ReadyToShip>
    <IsPrinted>0</IsPrinted>
    <AuthorizedOn>10/4/2008 11:18:19 AM</AuthorizedOn>
    <CapturedOn>10/4/2008 11:18:20 AM</CapturedOn>
    <RefundedOn />
    <VoidedOn />
    <FraudedOn />
    <EditedOn />
    <TrackingURL />
    <ShippedEMailSentOn />
    <InventoryWasReduced>1</InventoryWasReduced>
    <MaxMindFraudScore>-1.00</MaxMindFraudScore>
    <MaxMindDetails>
    </MaxMindDetails>
    <VATRegistrationID>
    </VATRegistrationID>
    <Crypt>1</Crypt>
    <TransactionType>1</TransactionType>
    <RecurringSubscriptionID>
    </RecurringSubscriptionID>
    <RecurringSubscriptionCommand>
    </RecurringSubscriptionCommand>
    <RecurringSubscriptionResult>
    </RecurringSubscriptionResult>
    <RelatedOrderNumber>0</RelatedOrderNumber>
    <BuySafeCommand>
    </BuySafeCommand>
    <BuySafeResult>
    </BuySafeResult>
    </Orders>
    <Orders>
    <OrderNumber>100001</OrderNumber>
    <OrderGUID>7ab03171-0925-4688-b614-c733421a68cd</OrderGUID>
    <ParentOrderNumber />
    <StoreVersion>AspDotNetStorefront ML 7.1.1.0/7.1.1.0</StoreVersion>
    <QuoteCheckout>0</QuoteCheckout>
    <IsNew>1</IsNew>
    <ShippedOn />
    <CustomerID>58675</CustomerID>
    <CustomerGUID>e7bdd477-8b31-4b44-b971-f633033f0356</CustomerGUID>
    <Referrer>http://www.peachtreeshoppingcart.com/</Referrer>
    <SkinID>1</SkinID>
    <LastName>Wheeler</LastName>
    <FirstName>Birgit</FirstName>
    <Email>scottwheeler@fuse.net</Email>
    <Notes>
    </Notes>
    <BillingEqualsShipping>0</BillingEqualsShipping>
    <BillingLastName>Wheeler</BillingLastName>
    <BillingFirstName>Birgit</BillingFirstName>
    <BillingCompany>
    </BillingCompany>
    <BillingAddress1>132 Woodcrest Dr.</BillingAddress1>
    <BillingAddress2>
    </BillingAddress2>
    <BillingSuite>
    </BillingSuite>
    <BillingCity>Loveland</BillingCity>
    <BillingState>OH</BillingState>
    <BillingZip>45140</BillingZip>
    <BillingCountry>United States</BillingCountry>
    <BillingPhone>800-888-8888</BillingPhone>
    <ShippingLastName>Wheeler</ShippingLastName>
    <ShippingFirstName>Birgit</ShippingFirstName>
    <ShippingCompany>
    </ShippingCompany>
    <ShippingResidenceType>1</ShippingResidenceType>
    <ShippingAddress1>132 Woodcrest Dr.</ShippingAddress1>
    <ShippingAddress2>
    </ShippingAddress2>
    <ShippingSuite>
    </ShippingSuite>
    <ShippingCity>Loveland</ShippingCity>
    <ShippingState>OH</ShippingState>
    <ShippingZip>45140</ShippingZip>
    <ShippingCountry>United States</ShippingCountry>
    <ShippingMethodID>1</ShippingMethodID>
    <ShippingMethod>Ground</ShippingMethod>
    <ShippingPhone>800-888-8888</ShippingPhone>
    <ShippingCalculationID>2</ShippingCalculationID>
    <Phone>800-888-8888</Phone>
    <RegisterDate>12/27/2009 4:46:34 AM</RegisterDate>
    <AffiliateID>0</AffiliateID>
    <CouponCode />
    <CouponType>0</CouponType>
    <CouponDescription />
    <CouponDiscountAmount>0.0000</CouponDiscountAmount>
    <CouponDiscountPercent>0.0000</CouponDiscountPercent>
    <CouponIncludesFreeShipping>0</CouponIncludesFreeShipping>
    <OkToEmail>1</OkToEmail>
    <Deleted>0</Deleted>
    <CardType>MasterCard</CardType>
    <CardName>Birgit Wheeler</CardName>
    <CardNumber />
    <CardExpirationMonth>12</CardExpirationMonth>
    <CardExpirationYear>2009</CardExpirationYear>
    <CardStartDate>
    </CardStartDate>
    <CardIssueNumber>
    </CardIssueNumber>
    <OrderSubtotal>4.9500</OrderSubtotal>
    <OrderTax>0.0000</OrderTax>
    <OrderShippingCosts>0.0000</OrderShippingCosts>
    <OrderTotal>4.9500</OrderTotal>
    <PaymentGateway>MANUAL</PaymentGateway>
    <AuthorizationCode>0</AuthorizationCode>
    <AuthorizationResult>MANUAL GATEWAY SAID OK</AuthorizationResult>
    <AuthorizationPNREF>00CC4C2F-B88F-4FCB-87D2-57D900EDB1BE</AuthorizationPNREF>
    <TransactionCommand>x_type=AUTH_CAPTURE&amp;x_test _request=TRUE&amp;x_description=AspDotNetStorefron t+Order+100001&amp;x_amount=4.95&amp;x_card_num=** **2334&amp;x_card_code=***&amp;x_exp_date=12/2009&amp;x_phone=800-888-8888&amp;x_fax=&amp;x_customer_tax_id=&amp;x_cust_ id=58675&amp;x_invoice_num=100001&amp;x_email=scot twheeler%40fuse.net&amp;x_customer_ip=216.196.193. 34&amp;x_first_name=Birgit&amp;x_last_name=Wheeler &amp;x_company=&amp;x_address=132+Woodcrest+Dr.&am p;x_city=Loveland&amp;x_state=OH&amp;x_zip=45140&a mp;x_country=United+States&amp;x_ship_to_first_nam e=Birgit&amp;x_ship_to_last_name=Wheeler&amp;x_shi p_to_company=&amp;x_ship_to_address=132+Woodcrest+ Dr.&amp;x_ship_to_city=Loveland&amp;x_ship_to_stat e=OH&amp;x_ship_to_zip=45140&amp;x_ship_to_country =United+States&amp;x_customer_ip=216.196.193.34</TransactionCommand>
    <OrderDate>12/27/2009 4:49:43 AM</OrderDate>
    <LevelID>0</LevelID>
    <LevelName />
    <LevelDiscountPercent />
    <LevelDiscountAmount />
    <LevelHasFreeShipping />
    <LevelAllowsQuantityDiscounts />
    <LevelHasNoTax />
    <LevelAllowsCoupons />
    <LevelDiscountsApplyToExtendedPrices />
    <LastIPAddress>216.196.193.34</LastIPAddress>
    <PaymentMethod>CREDITCARD</PaymentMethod>
    <OrderNotes>
    </OrderNotes>
    <PONumber>
    </PONumber>
    <DownloadEmailSentOn />
    <ReceiptEmailSentOn />
    <DistributorEmailSentOn />
    <ShippingTrackingNumber />
    <ShippedVIA />
    <CustomerServiceNotes>
    </CustomerServiceNotes>
    <RTShipRequest>
    </RTShipRequest>
    <RTShipResponse>
    </RTShipResponse>
    <TransactionState>CAPTURED</TransactionState>
    <AVSResult>OK</AVSResult>
    <CaptureTXCommand />
    <CaptureTXResult />
    <VoidTXCommand />
    <VoidTXResult />
    <RefundTXCommand />
    <RefundTXResult />
    <RefundReason />
    <CardinalLookupResult />
    <CardinalAuthenticateResult />
    <CardinalGatewayParms />
    <AffiliateCommissionRecorded>0</AffiliateCommissionRecorded>
    <OrderOptions>
    </OrderOptions>
    <OrderWeight>1.0000</OrderWeight>
    <eCheckBankABACode>
    </eCheckBankABACode>
    <eCheckBankAccountNumber>
    </eCheckBankAccountNumber>
    <eCheckBankAccountType>
    </eCheckBankAccountType>
    <eCheckBankName>
    </eCheckBankName>
    <eCheckBankAccountName>Birgit Wheeler</eCheckBankAccountName>
    <CarrierReportedRate />
    <CarrierReportedWeight />
    <LocaleSetting>en-US</LocaleSetting>
    <FinalizationData>&lt;root&gt;&lt;/root&gt;</FinalizationData>
    <ExtensionData />
    <AlreadyConfirmed>1</AlreadyConfirmed>
    <CartType>0</CartType>
    <THUB_POSTED_TO_ACCOUNTING>N</THUB_POSTED_TO_ACCOUNTING>
    <THUB_POSTED_DATE />
    <THUB_ACCOUNTING_REF />
    <Last4>2334</Last4>
    <ReadyToShip>0</ReadyToShip>
    <IsPrinted>0</IsPrinted>
    <AuthorizedOn>12/27/2009 4:49:43 AM</AuthorizedOn>
    <CapturedOn>12/27/2009 4:49:43 AM</CapturedOn>
    <RefundedOn />
    <VoidedOn />
    <FraudedOn />
    <EditedOn />
    <TrackingURL />
    <ShippedEMailSentOn />
    <InventoryWasReduced>1</InventoryWasReduced>
    <MaxMindFraudScore>-1.00</MaxMindFraudScore>
    <MaxMindDetails>
    </MaxMindDetails>
    <VATRegistrationID>
    </VATRegistrationID>
    <Crypt>1</Crypt>
    <TransactionType>1</TransactionType>
    <RecurringSubscriptionID>
    </RecurringSubscriptionID>
    <RecurringSubscriptionCommand>
    </RecurringSubscriptionCommand>
    <RecurringSubscriptionResult>
    </RecurringSubscriptionResult>
    <RelatedOrderNumber>0</RelatedOrderNumber>
    <BuySafeCommand>
    </BuySafeCommand>
    <BuySafeResult>
    </BuySafeResult>
    </Orders>
    </Get>
    </AspDotNetStorefrontImportResult>
  4. 12-29-2009, 08:04 AM #4
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    What would this order contain? Is it a product with variants or just a straight product?

    I see the weight came over

    <OrderOptions>
    </OrderOptions>
    <OrderWeight>1.0000</OrderWeight>
  5. 12-29-2009, 08:15 AM #5
    swheeler is offline Junior Member
    Join Date
    Oct 2008
    Posts
    17

    Default

    ssgumby,

    I just order the 'Simple Item 1' from the default installation. It seems to be a stock item without any variants. Its the phone on the right side of the screen at www.PeachtreeShoppingCart.com. The SKU# 01-0001

    Thanks,

    Scott
    Last edited by swheeler; 12-29-2009 at 01:24 PM. Reason: wrong name
  6. 12-30-2009, 04:42 AM #6
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Use this xml command instead. It should retrieve the line items ordered just fine as it is on my end.
    Code:
    <AspDotNetStorefrontImport Verbose="false">
  <Get Table="Orders" Name="NewOrders">
    <XmlPackage>DumpOrder.xml.config</XmlPackage>
    <OrderBy>OrderDate asc</OrderBy>
    <Criteria IsNew="1"/>
  </Get>
</AspDotNetStorefrontImport>
    You can change the criteria node in order to manipulate what orders you're retrieving, etc.
  7. 12-30-2009, 06:41 AM #7
    swheeler is offline Junior Member
    Join Date
    Oct 2008
    Posts
    17

    Default

    Hi Alfred,

    Thanks for the reply. This is what I get with your XML request:

    <?xml version="1.0" encoding="utf-8"?>
    <AspDotNetStorefrontImportResult Version="" DateTime="12/30/2009 6:38:49 AM">
    <Get Table="Orders" Name="NewOrders" XmlPackage="DumpOrder.xml.config" IDColumn="OrderNumber" DefaultWhereClause="" OrderBy="OrderDate asc">
    <Criteria IsNew="1" />
    <Order OrderNumber="100000" ShowCardNumber="" />
    <Order OrderNumber="100001" ShowCardNumber="" />
    <Order OrderNumber="100002" ShowCardNumber="" />
    </Get>
    </AspDotNetStorefrontImportResult>

    If you like, I can privately email UID/PW creditials to my site.

    Also, I'm using v. 7.1.1 if it makes any difference.

    Thanks,

    Scott
  8. 01-03-2010, 07:23 PM #8
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Please send a ticket to support. thanks