ShopSite Forums

Your source for ShopSite user collaboration
https://forum.shopsite.com/

Orders Download XML DTD

https://forum.shopsite.com/viewtopic.php?f=10&t=4899

Page 1 of 1

Orders Download XML DTD

PostPosted: Sun Sep 28, 2003 7:12 am
by David Clarke
Can anyone comment on this:

The order data is essentially a master detail (one to many) data structure.
So, why is the product detail stuck in the middle of the 'shipping' element?
This requires the parser to deal with one to one AND one to many inside of
the same element.

I wish it was more like this:

<ssdownload>
<response></response>
<ssorder>
<master></master>
<detail></detail>
<ssorder>
<ssorder>
<master></master>
<detail></detail>
<ssorder>
</ssdownload>

At the very least, why not close the 'Shipping' element before opening the
'Product' element. And the 'product' element children value should tell the
parser how many Products are on the sale, followed by a 'ProductDetail'
element which should give 11 as the children value.

/ShopSiteOrders/[2]/[4] Shipping 5
/ShopSiteOrders/[2]/[4]/[1] FullName 0
/ShopSiteOrders/[2]/[4]/[2] Company 0
/ShopSiteOrders/[2]/[4]/[3] Phone 0
/ShopSiteOrders/[2]/[4]/[4] Address 6
/ShopSiteOrders/[2]/[4]/[4]/[1] Street1 0
/ShopSiteOrders/[2]/[4]/[4]/[2] Street2 -1
/ShopSiteOrders/[2]/[4]/[4]/[3] City 0
/ShopSiteOrders/[2]/[4]/[4]/[4] State 0
/ShopSiteOrders/[2]/[4]/[4]/[5] Code 0
/ShopSiteOrders/[2]/[4]/[4]/[6] Country 0
/ShopSiteOrders/[2]/[4]/[5] Product 11 0
/ShopSiteOrders/[2]/[4]/[5]/[1] ProdType 0
/ShopSiteOrders/[2]/[4]/[5]/[2] Name 0
/ShopSiteOrders/[2]/[4]/[5]/[3] SKU 0
/ShopSiteOrders/[2]/[4]/[5]/[4] Taxable 0
/ShopSiteOrders/[2]/[4]/[5]/[5] Quantity 0
/ShopSiteOrders/[2]/[4]/[5]/[6] ItemPrice 0
/ShopSiteOrders/[2]/[4]/[5]/[7] Total 0
/ShopSiteOrders/[2]/[4]/[5]/[8] Weight -1
/ShopSiteOrders/[2]/[4]/[5]/[9] Dimension -1
/ShopSiteOrders/[2]/[4]/[5]/[10] OrderOption -1
/ShopSiteOrders/[2]/[4]/[5]/[11] CustomerText -1


Any thoughts?

David Clarke

Re: Orders Download XML DTD

PostPosted: Mon Sep 29, 2003 5:25 am
by Barney Stone
David -

We had the same question when ShopSite presented the DTD to us. The answer
is that they want to leave open the possibility of supporting multiple
shipping addresses per order. With the products inside the shipping data, it
becomes obvious which products go to each ship-to address.

The XML order download method is fully supported by our Stone Edge Order
Manager for ShopSite. If you are not already familiar with the Order
Manager, you might want to check it out
(www.stoneedge.com/ordermanager.htm). If you are trying to develop a
back-end management system, the Order Manager might save you a lot of time
and money.

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com



"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl6q94$1q2$1@support.shopsite.com...
Can anyone comment on this:

The order data is essentially a master detail (one to many) data
structure.
So, why is the product detail stuck in the middle of the 'shipping'
element?
This requires the parser to deal with one to one AND one to many inside of
the same element.

I wish it was more like this:

ssdownload
response></response
ssorder
master></master
detail></detail
ssorder
ssorder
master></master
detail></detail
ssorder
/ssdownload

At the very least, why not close the 'Shipping' element before opening the
'Product' element. And the 'product' element children value should tell
the
parser how many Products are on the sale, followed by a 'ProductDetail'
element which should give 11 as the children value.

/ShopSiteOrders/[2]/[4] Shipping 5
/ShopSiteOrders/[2]/[4]/[1] FullName 0
/ShopSiteOrders/[2]/[4]/[2] Company 0
/ShopSiteOrders/[2]/[4]/[3] Phone 0
/ShopSiteOrders/[2]/[4]/[4] Address 6
/ShopSiteOrders/[2]/[4]/[4]/[1] Street1 0
/ShopSiteOrders/[2]/[4]/[4]/[2] Street2 -1
/ShopSiteOrders/[2]/[4]/[4]/[3] City 0
/ShopSiteOrders/[2]/[4]/[4]/[4] State 0
/ShopSiteOrders/[2]/[4]/[4]/[5] Code 0
/ShopSiteOrders/[2]/[4]/[4]/[6] Country 0
/ShopSiteOrders/[2]/[4]/[5] Product 11 0
/ShopSiteOrders/[2]/[4]/[5]/[1] ProdType 0
/ShopSiteOrders/[2]/[4]/[5]/[2] Name 0
/ShopSiteOrders/[2]/[4]/[5]/[3] SKU 0
/ShopSiteOrders/[2]/[4]/[5]/[4] Taxable 0
/ShopSiteOrders/[2]/[4]/[5]/[5] Quantity 0
/ShopSiteOrders/[2]/[4]/[5]/[6] ItemPrice 0
/ShopSiteOrders/[2]/[4]/[5]/[7] Total 0
/ShopSiteOrders/[2]/[4]/[5]/[8] Weight -1
/ShopSiteOrders/[2]/[4]/[5]/[9] Dimension -1
/ShopSiteOrders/[2]/[4]/[5]/[10] OrderOption -1
/ShopSiteOrders/[2]/[4]/[5]/[11] CustomerText -1


Any thoughts?

David Clarke


Re: Orders Download XML DTD

PostPosted: Mon Sep 29, 2003 8:21 am
by David Clarke
How do you deal with the https issue?
David Clarke


"Barney Stone" <barney@StoneEdge.com> wrote in message
news:bl98d3$lph$1@support.shopsite.com...
David -

We had the same question when ShopSite presented the DTD to us. The answer
is that they want to leave open the possibility of supporting multiple
shipping addresses per order. With the products inside the shipping data,
it
becomes obvious which products go to each ship-to address.

The XML order download method is fully supported by our Stone Edge Order
Manager for ShopSite. If you are not already familiar with the Order
Manager, you might want to check it out
(www.stoneedge.com/ordermanager.htm). If you are trying to develop a
back-end management system, the Order Manager might save you a lot of time
and money.

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com



"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl6q94$1q2$1@support.shopsite.com...
Can anyone comment on this:

The order data is essentially a master detail (one to many) data
structure.
So, why is the product detail stuck in the middle of the 'shipping'
element?
This requires the parser to deal with one to one AND one to many inside
of
the same element.

I wish it was more like this:

ssdownload
response></response
ssorder
master></master
detail></detail
ssorder
ssorder
master></master
detail></detail
ssorder
/ssdownload

At the very least, why not close the 'Shipping' element before opening
the
'Product' element. And the 'product' element children value should tell
the
parser how many Products are on the sale, followed by a 'ProductDetail'
element which should give 11 as the children value.

/ShopSiteOrders/[2]/[4] Shipping 5
/ShopSiteOrders/[2]/[4]/[1] FullName 0
/ShopSiteOrders/[2]/[4]/[2] Company 0
/ShopSiteOrders/[2]/[4]/[3] Phone 0
/ShopSiteOrders/[2]/[4]/[4] Address 6
/ShopSiteOrders/[2]/[4]/[4]/[1] Street1 0
/ShopSiteOrders/[2]/[4]/[4]/[2] Street2 -1
/ShopSiteOrders/[2]/[4]/[4]/[3] City 0
/ShopSiteOrders/[2]/[4]/[4]/[4] State 0
/ShopSiteOrders/[2]/[4]/[4]/[5] Code 0
/ShopSiteOrders/[2]/[4]/[4]/[6] Country 0
/ShopSiteOrders/[2]/[4]/[5] Product 11 0
/ShopSiteOrders/[2]/[4]/[5]/[1] ProdType 0
/ShopSiteOrders/[2]/[4]/[5]/[2] Name 0
/ShopSiteOrders/[2]/[4]/[5]/[3] SKU 0
/ShopSiteOrders/[2]/[4]/[5]/[4] Taxable 0
/ShopSiteOrders/[2]/[4]/[5]/[5] Quantity 0
/ShopSiteOrders/[2]/[4]/[5]/[6] ItemPrice 0
/ShopSiteOrders/[2]/[4]/[5]/[7] Total 0
/ShopSiteOrders/[2]/[4]/[5]/[8] Weight -1
/ShopSiteOrders/[2]/[4]/[5]/[9] Dimension -1
/ShopSiteOrders/[2]/[4]/[5]/[10] OrderOption -1
/ShopSiteOrders/[2]/[4]/[5]/[11] CustomerText -1


Any thoughts?

David Clarke




Re: Orders Download XML DTD

PostPosted: Mon Sep 29, 2003 2:51 pm
by Barney Stone
We have VBA code that can post to an HTTPS address. We use that for all
communication with secure servers.

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com


"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl9in8$nsp$1@support.shopsite.com...
How do you deal with the https issue?
David Clarke


"Barney Stone" <barney@StoneEdge.com> wrote in message
news:bl98d3$lph$1@support.shopsite.com...
David -

We had the same question when ShopSite presented the DTD to us. The
answer
is that they want to leave open the possibility of supporting multiple
shipping addresses per order. With the products inside the shipping
data,
it
becomes obvious which products go to each ship-to address.

The XML order download method is fully supported by our Stone Edge Order
Manager for ShopSite. If you are not already familiar with the Order
Manager, you might want to check it out
(www.stoneedge.com/ordermanager.htm). If you are trying to develop a
back-end management system, the Order Manager might save you a lot of
time
and money.

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com



"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl6q94$1q2$1@support.shopsite.com...
Can anyone comment on this:

The order data is essentially a master detail (one to many) data
structure.
So, why is the product detail stuck in the middle of the 'shipping'
element?
This requires the parser to deal with one to one AND one to many
inside
of
the same element.

I wish it was more like this:

ssdownload
response></response
ssorder
master></master
detail></detail
ssorder
ssorder
master></master
detail></detail
ssorder
/ssdownload

At the very least, why not close the 'Shipping' element before opening
the
'Product' element. And the 'product' element children value should
tell
the
parser how many Products are on the sale, followed by a
'ProductDetail'
element which should give 11 as the children value.

/ShopSiteOrders/[2]/[4] Shipping 5
/ShopSiteOrders/[2]/[4]/[1] FullName 0
/ShopSiteOrders/[2]/[4]/[2] Company 0
/ShopSiteOrders/[2]/[4]/[3] Phone 0
/ShopSiteOrders/[2]/[4]/[4] Address 6
/ShopSiteOrders/[2]/[4]/[4]/[1] Street1 0
/ShopSiteOrders/[2]/[4]/[4]/[2] Street2 -1
/ShopSiteOrders/[2]/[4]/[4]/[3] City 0
/ShopSiteOrders/[2]/[4]/[4]/[4] State 0
/ShopSiteOrders/[2]/[4]/[4]/[5] Code 0
/ShopSiteOrders/[2]/[4]/[4]/[6] Country 0
/ShopSiteOrders/[2]/[4]/[5] Product 11 0
/ShopSiteOrders/[2]/[4]/[5]/[1] ProdType 0
/ShopSiteOrders/[2]/[4]/[5]/[2] Name 0
/ShopSiteOrders/[2]/[4]/[5]/[3] SKU 0
/ShopSiteOrders/[2]/[4]/[5]/[4] Taxable 0
/ShopSiteOrders/[2]/[4]/[5]/[5] Quantity 0
/ShopSiteOrders/[2]/[4]/[5]/[6] ItemPrice 0
/ShopSiteOrders/[2]/[4]/[5]/[7] Total 0
/ShopSiteOrders/[2]/[4]/[5]/[8] Weight -1
/ShopSiteOrders/[2]/[4]/[5]/[9] Dimension -1
/ShopSiteOrders/[2]/[4]/[5]/[10] OrderOption -1
/ShopSiteOrders/[2]/[4]/[5]/[11] CustomerText -1


Any thoughts?

David Clarke






All times are UTC - 7 hours
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/