Orders Download XML DTD

This is an archive of old posting to the User Forum

Orders Download XML DTD

Postby David Clarke » Sun Sep 28, 2003 7:12 am

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
David Clarke
 

Re: Orders Download XML DTD

Postby Barney Stone » Mon Sep 29, 2003 5:25 am

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


Barney Stone
 

Re: Orders Download XML DTD

Postby David Clarke » Mon Sep 29, 2003 8:21 am

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




David Clarke
 

Re: Orders Download XML DTD

Postby Barney Stone » Mon Sep 29, 2003 2:51 pm

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






Barney Stone
 


Return to User Forum Archive

Who is online

Users browsing this forum: No registered users and 68 guests