Easy question... how to change product price

[Peter Brunone]

As a new ShopSite developer, I hope this question has been answered before.

I have a client whose prices need to be updated via the app that I have
built. Previously, the app has determined a price based on market
conditions and updated a third-party listing website with the new price
data... but now I need to update the ShopSite back end as well, and I don't
want to have to parse and re-submit that whole "Edit Product Info" page just
to update the price field based on SKU. Any thoughts on a way to do this a
bit more easily?

Regards,

Peter Brunone

[David Clarke]

Hi
This is what happens when you update the products database.
You POST to the products.cgi.
This can be done programatically.
However you need an SSL enabled tool to do it.
We have products that do this.

Let me know if this sends you in the right direction or if you need more
help.

David Clarke

SENT TO SHOPSITE FROM BROWSER:

SSL cipher SSLv3 RC4-MD5 (128 bits)
POST /cgi-bin/store/ss/products.cgi HTTP/1.0
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-excel, application/msword, */*
Referer:
Accept-Language: en-us
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)
Host:
Content-Length: 1135
Cache-Control: no-cache
Cookie: coupon=new:1|; __utm1=224385552.1064097267; __utm2=1064676557;
CP=null*; Apache=24.188.87.98.1064666656408548; __utm3=1064676557
Authorization: Basic
Connection: keep-alive
Accept-encoding: gzip, deflate
Browser reload detected...
Posting 1135 bytes...
473%3A0=3-Zip+Cosmetic+-+Barclay+print
473%3A1=16.00
473%3A2=
473%3A76%3As=4
473%3A76%3Aq0=1
473%3A76%3Ap0=0.00
473%3A76%3As0=
473%3A76%3Aq1=
473%3A76%3Ap1=
473%3A76%3As1=
473%3A76%3Aq2=
473%3A76%3Ap2=
473%3A76%3As2=
473%3A76%3Aq3=
473%3A76%3Ap3=
473%3A76%3As3=
473%3A76%3Ac=
473%3A76%3At1=FFFFFF
473%3A76%3At2=FFFFFF
473%3A76%3At3=FFFFFF
473%3A3=on
473%3A19=7158+-+3372
473%3A20=none
r1%3A473%3A20=1
t%3A473%3A20=none
473%3A21=
473%3A22=
473%3A64=selected
473%3A65=Store
473%3A23=
473%3Aitem_type=%7E
473%3Aitem_accnt=%7E
473%3A7=0
473%3A66=1
473%3A67=
473%3A68=
473%3A69=0.00
473%3A52=Tangible
473%3A62=none
r1%3A473%3A62=1
t%3A473%3A62=
473%3A53=
473%3A54=
473%3A55=
473%3A26=
473%3A27=
473%3A31=
473%3A32=none
r1%3A473%3A32=1
t%3A473%3A32=none
473%3A33=
473%3A70=
473%3A71=
473%3A72=
473%3A73=
473%3A74=
searchstringhid=*
fieldhid=0
queryhid=0
SaveList=on
dbname=products
fields=0%2C1%2C2%2C76%2C3%2C19%2C20%2C21%2C22%2C23%2C75%2C7%2C66%2C63%2C69%2
C52%

2C62%2C53%2C54%2C55%2C26%2C27%2C28%2C29%2C30%2C31%2C32%2C33%2C70%2C71%2C72%2
C73%2C74%2C64%2C65%2C67%2C68
recs=473
function1=datar
Update+Save+Changes.x=121
Update+Save+Changes.y=9

"Peter Brunone" <news@brunone.com> wrote in message
news:bl39aa$ohp$1@support.shopsite.com...

As a new ShopSite developer, I hope this question has been answered
before.

I have a client whose prices need to be updated via the app that I have
built. Previously, the app has determined a price based on market
conditions and updated a third-party listing website with the new price
data... but now I need to update the ShopSite back end as well, and I
don't
want to have to parse and re-submit that whole "Edit Product Info" page
just
to update the price field based on SKU. Any thoughts on a way to do this
a
bit more easily?

Regards,

Peter Brunone

[Peter Brunone]

Hi David,

That sounds like the approach I need. Where can I get a list of
required parameters to post to products.cgi? I found the "Power Edit"
section, and I can choose to update the price specifically, but the
underlying parameters are a bit vague (i.e. the price field is named
"1819.1", and the first part appears to be an internal key in the database)
..
I suppose if I needed to, I could just go through the search process
each time to get the correct record key, but this seems a bit extreme. Is
there an accessible reference document somewhere that would show me how to
update price based on SKU rather than internal record ID? This is kind of a
time-crunch project -- trait of this particular client -- so whatever you
can recommend in the short term would be great.

Cheers,

Peter

"David Clarke" <dc@dcinterconnect.com> wrote in message
news:bl4rvb$7as$1@support.shopsite.com...

Hi
This is what happens when you update the products database.
You POST to the products.cgi.
This can be done programatically.
However you need an SSL enabled tool to do it.
We have products that do this.

Let me know if this sends you in the right direction or if you need more
help.

David Clarke

SENT TO SHOPSITE FROM BROWSER:

SSL cipher SSLv3 RC4-MD5 (128 bits)
POST /cgi-bin/store/ss/products.cgi HTTP/1.0
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-excel, application/msword, */*
Referer:
Accept-Language: en-us
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)
Host:
Content-Length: 1135
Cache-Control: no-cache
Cookie: coupon=new:1|; __utm1=224385552.1064097267; __utm2=1064676557;
CP=null*; Apache=24.188.87.98.1064666656408548; __utm3=1064676557
Authorization: Basic
Connection: keep-alive
Accept-encoding: gzip, deflate
Browser reload detected...
Posting 1135 bytes...
473%3A0=3-Zip+Cosmetic+-+Barclay+print
473%3A1=16.00
473%3A2=
473%3A76%3As=4
473%3A76%3Aq0=1
473%3A76%3Ap0=0.00
473%3A76%3As0=
473%3A76%3Aq1=
473%3A76%3Ap1=
473%3A76%3As1=
473%3A76%3Aq2=
473%3A76%3Ap2=
473%3A76%3As2=
473%3A76%3Aq3=
473%3A76%3Ap3=
473%3A76%3As3=
473%3A76%3Ac=
473%3A76%3At1=FFFFFF
473%3A76%3At2=FFFFFF
473%3A76%3At3=FFFFFF
473%3A3=on
473%3A19=7158+-+3372
473%3A20=none
r1%3A473%3A20=1
t%3A473%3A20=none
473%3A21=
473%3A22=
473%3A64=selected
473%3A65=Store
473%3A23=
473%3Aitem_type=%7E
473%3Aitem_accnt=%7E
473%3A7=0
473%3A66=1
473%3A67=
473%3A68=
473%3A69=0.00
473%3A52=Tangible
473%3A62=none
r1%3A473%3A62=1
t%3A473%3A62=
473%3A53=
473%3A54=
473%3A55=
473%3A26=
473%3A27=
473%3A31=
473%3A32=none
r1%3A473%3A32=1
t%3A473%3A32=none
473%3A33=
473%3A70=
473%3A71=
473%3A72=
473%3A73=
473%3A74=
searchstringhid=*
fieldhid=0
queryhid=0
SaveList=on
dbname=products

fields=0%2C1%2C2%2C76%2C3%2C19%2C20%2C21%2C22%2C23%2C75%2C7%2C66%2C63%2C69%2
C52%


2C62%2C53%2C54%2C55%2C26%2C27%2C28%2C29%2C30%2C31%2C32%2C33%2C70%2C71%2C72%2
C73%2C74%2C64%2C65%2C67%2C68
recs=473
function1=datar
Update+Save+Changes.x=121
Update+Save+Changes.y=9

"Peter Brunone" <news@brunone.com> wrote in message
news:bl39aa$ohp$1@support.shopsite.com...
As a new ShopSite developer, I hope this question has been answered
before.

I have a client whose prices need to be updated via the app that I have
built. Previously, the app has determined a price based on market
conditions and updated a third-party listing website with the new price
data... but now I need to update the ShopSite back end as well, and I
don't
want to have to parse and re-submit that whole "Edit Product Info" page
just
to update the price field based on SKU. Any thoughts on a way to do
this
a
bit more easily?

Regards,

Peter Brunone

[David Clarke]

Welcome to the dance!
ShopSite dosen't make it easy!

Do you upload your products DB?
OR
Are you working with an end user managed site?


As I see it there are 2 ways to gain control over the SSproducts database -
the first is to upload all the info yourself.. in which case internal.record
1 = external.record 1. . the second way is to do a cgi query (like list all
products or something like it ) which forces ShopSite to give you the
individual record numbers so you can track them in some way your self. Not
the most elegant solution but it works. All I can say is thank goodness we
are past the OPENMARKET days! The current ShopSite people are doing a great
job with a very nice product!

I guess we need more XML database interfaces!! I hope the ShopSite people
realize there are some heavy web sites using their proven core
functionality.

David Clarke



"Peter Brunone" <news@brunone.com> wrote in message
news:bl80sl$9bo$1@support.shopsite.com...

Hi David,

That sounds like the approach I need. Where can I get a list of
required parameters to post to products.cgi? I found the "Power Edit"
section, and I can choose to update the price specifically, but the
underlying parameters are a bit vague (i.e. the price field is named
"1819.1", and the first part appears to be an internal key in the
database)
.
I suppose if I needed to, I could just go through the search process
each time to get the correct record key, but this seems a bit extreme. Is
there an accessible reference document somewhere that would show me how to
update price based on SKU rather than internal record ID? This is kind of
a
time-crunch project -- trait of this particular client -- so whatever you
can recommend in the short term would be great.

Cheers,

Peter

"David Clarke" <dc@dcinterconnect.com> wrote in message
news:bl4rvb$7as$1@support.shopsite.com...
Hi
This is what happens when you update the products database.
You POST to the products.cgi.
This can be done programatically.
However you need an SSL enabled tool to do it.
We have products that do this.

Let me know if this sends you in the right direction or if you need more
help.

David Clarke

SENT TO SHOPSITE FROM BROWSER:

SSL cipher SSLv3 RC4-MD5 (128 bits)
POST /cgi-bin/store/ss/products.cgi HTTP/1.0
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-excel, application/msword, */*
Referer:
Accept-Language: en-us
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)
Host:
Content-Length: 1135
Cache-Control: no-cache
Cookie: coupon=new:1|; __utm1=224385552.1064097267; __utm2=1064676557;
CP=null*; Apache=24.188.87.98.1064666656408548; __utm3=1064676557
Authorization: Basic
Connection: keep-alive
Accept-encoding: gzip, deflate
Browser reload detected...
Posting 1135 bytes...
473%3A0=3-Zip+Cosmetic+-+Barclay+print
473%3A1=16.00
473%3A2=
473%3A76%3As=4
473%3A76%3Aq0=1
473%3A76%3Ap0=0.00
473%3A76%3As0=
473%3A76%3Aq1=
473%3A76%3Ap1=
473%3A76%3As1=
473%3A76%3Aq2=
473%3A76%3Ap2=
473%3A76%3As2=
473%3A76%3Aq3=
473%3A76%3Ap3=
473%3A76%3As3=
473%3A76%3Ac=
473%3A76%3At1=FFFFFF
473%3A76%3At2=FFFFFF
473%3A76%3At3=FFFFFF
473%3A3=on
473%3A19=7158+-+3372
473%3A20=none
r1%3A473%3A20=1
t%3A473%3A20=none
473%3A21=
473%3A22=
473%3A64=selected
473%3A65=Store
473%3A23=
473%3Aitem_type=%7E
473%3Aitem_accnt=%7E
473%3A7=0
473%3A66=1
473%3A67=
473%3A68=
473%3A69=0.00
473%3A52=Tangible
473%3A62=none
r1%3A473%3A62=1
t%3A473%3A62=
473%3A53=
473%3A54=
473%3A55=
473%3A26=
473%3A27=
473%3A31=
473%3A32=none
r1%3A473%3A32=1
t%3A473%3A32=none
473%3A33=
473%3A70=
473%3A71=
473%3A72=
473%3A73=
473%3A74=
searchstringhid=*
fieldhid=0
queryhid=0
SaveList=on
dbname=products


fields=0%2C1%2C2%2C76%2C3%2C19%2C20%2C21%2C22%2C23%2C75%2C7%2C66%2C63%2C69%2
C52%



2C62%2C53%2C54%2C55%2C26%2C27%2C28%2C29%2C30%2C31%2C32%2C33%2C70%2C71%2C72%2
C73%2C74%2C64%2C65%2C67%2C68
recs=473
function1=datar
Update+Save+Changes.x=121
Update+Save+Changes.y=9

"Peter Brunone" <news@brunone.com> wrote in message
news:bl39aa$ohp$1@support.shopsite.com...
As a new ShopSite developer, I hope this question has been answered
before.

I have a client whose prices need to be updated via the app that I
have
built. Previously, the app has determined a price based on market
conditions and updated a third-party listing website with the new
price
data... but now I need to update the ShopSite back end as well, and I
don't
want to have to parse and re-submit that whole "Edit Product Info"
page
just
to update the price field based on SKU. Any thoughts on a way to do
this
a
bit more easily?

Regards,

Peter Brunone

[David Clarke]

One more thought..
When you do a database download --> /cgi-bin/store/ss/database.cgi
The products are returned starting with internal.product.number 0.
This would give you a way to synchronize with your customers db.. perhaps.
i.e.

0 = sku..1
1 = sku..2

etc...

When I first started doing this 4 years ago i couldn't believe it either!
But I love a challenge!!

David Clarke




"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl83qs$9vl$1@support.shopsite.com...

Welcome to the dance!
ShopSite dosen't make it easy!

Do you upload your products DB?
OR
Are you working with an end user managed site?


As I see it there are 2 ways to gain control over the SSproducts
database -
the first is to upload all the info yourself.. in which case
internal.record
1 = external.record 1. . the second way is to do a cgi query (like list
all
products or something like it ) which forces ShopSite to give you the
individual record numbers so you can track them in some way your self.
Not
the most elegant solution but it works. All I can say is thank goodness
we
are past the OPENMARKET days! The current ShopSite people are doing a
great
job with a very nice product!

I guess we need more XML database interfaces!! I hope the ShopSite people
realize there are some heavy web sites using their proven core
functionality.

David Clarke



"Peter Brunone" <news@brunone.com> wrote in message
news:bl80sl$9bo$1@support.shopsite.com...
Hi David,

That sounds like the approach I need. Where can I get a list of
required parameters to post to products.cgi? I found the "Power Edit"
section, and I can choose to update the price specifically, but the
underlying parameters are a bit vague (i.e. the price field is named
"1819.1", and the first part appears to be an internal key in the
database)
.
I suppose if I needed to, I could just go through the search process
each time to get the correct record key, but this seems a bit extreme.
Is
there an accessible reference document somewhere that would show me how
to
update price based on SKU rather than internal record ID? This is kind
of
a
time-crunch project -- trait of this particular client -- so whatever
you
can recommend in the short term would be great.

Cheers,

Peter

"David Clarke" <dc@dcinterconnect.com> wrote in message
news:bl4rvb$7as$1@support.shopsite.com...
Hi
This is what happens when you update the products database.
You POST to the products.cgi.
This can be done programatically.
However you need an SSL enabled tool to do it.
We have products that do this.

Let me know if this sends you in the right direction or if you need
more
help.

David Clarke

SENT TO SHOPSITE FROM BROWSER:

SSL cipher SSLv3 RC4-MD5 (128 bits)
POST /cgi-bin/store/ss/products.cgi HTTP/1.0
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-excel, application/msword, */*
Referer:
Accept-Language: en-us
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)
Host:
Content-Length: 1135
Cache-Control: no-cache
Cookie: coupon=new:1|; __utm1=224385552.1064097267; __utm2=1064676557;
CP=null*; Apache=24.188.87.98.1064666656408548; __utm3=1064676557
Authorization: Basic
Connection: keep-alive
Accept-encoding: gzip, deflate
Browser reload detected...
Posting 1135 bytes...
473%3A0=3-Zip+Cosmetic+-+Barclay+print
473%3A1=16.00
473%3A2=
473%3A76%3As=4
473%3A76%3Aq0=1
473%3A76%3Ap0=0.00
473%3A76%3As0=
473%3A76%3Aq1=
473%3A76%3Ap1=
473%3A76%3As1=
473%3A76%3Aq2=
473%3A76%3Ap2=
473%3A76%3As2=
473%3A76%3Aq3=
473%3A76%3Ap3=
473%3A76%3As3=
473%3A76%3Ac=
473%3A76%3At1=FFFFFF
473%3A76%3At2=FFFFFF
473%3A76%3At3=FFFFFF
473%3A3=on
473%3A19=7158+-+3372
473%3A20=none
r1%3A473%3A20=1
t%3A473%3A20=none
473%3A21=
473%3A22=
473%3A64=selected
473%3A65=Store
473%3A23=
473%3Aitem_type=%7E
473%3Aitem_accnt=%7E
473%3A7=0
473%3A66=1
473%3A67=
473%3A68=
473%3A69=0.00
473%3A52=Tangible
473%3A62=none
r1%3A473%3A62=1
t%3A473%3A62=
473%3A53=
473%3A54=
473%3A55=
473%3A26=
473%3A27=
473%3A31=
473%3A32=none
r1%3A473%3A32=1
t%3A473%3A32=none
473%3A33=
473%3A70=
473%3A71=
473%3A72=
473%3A73=
473%3A74=
searchstringhid=*
fieldhid=0
queryhid=0
SaveList=on
dbname=products



fields=0%2C1%2C2%2C76%2C3%2C19%2C20%2C21%2C22%2C23%2C75%2C7%2C66%2C63%2C69%2
C52%




2C62%2C53%2C54%2C55%2C26%2C27%2C28%2C29%2C30%2C31%2C32%2C33%2C70%2C71%2C72%2
C73%2C74%2C64%2C65%2C67%2C68
recs=473
function1=datar
Update+Save+Changes.x=121
Update+Save+Changes.y=9

"Peter Brunone" <news@brunone.com> wrote in message
news:bl39aa$ohp$1@support.shopsite.com...
As a new ShopSite developer, I hope this question has been answered
before.

I have a client whose prices need to be updated via the app that I
have
built. Previously, the app has determined a price based on market
conditions and updated a third-party listing website with the new
price
data... but now I need to update the ShopSite back end as well, and
I
don't
want to have to parse and re-submit that whole "Edit Product Info"
page
just
to update the price field based on SKU. Any thoughts on a way to do
this
a
bit more easily?

Regards,

Peter Brunone

[David Clarke]

Here is the POST from power edit to update 1 price.
wouldnt supprise me if many of the fields could be omited.

Posting 199 bytes...
473%3A1=16.00
searchstringhid=*
fieldhid=0
queryhid=0
SaveList=on
dbname=products
fields=1
recs=473
info_fields=1
multioruni=multi
function1=ersfinal
Update+Save+Changes.x=76
Update+Save+Changes.y=19

[Peter Brunone]

"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl83qs$9vl$1@support.shopsite.com...

Welcome to the dance!
ShopSite dosen't make it easy!

*sigh* I was starting to get that impression.

Do you upload your products DB?
OR
Are you working with an end user managed site?

This client is hosting their own app -- actually several stores with
several sites, each hosting ShopSite -- and I don't think a DB upload would
give the kind of real-time updating they want.

As I see it there are 2 ways to gain control over the SSproducts
database -
the first is to upload all the info yourself.. in which case
internal.record
1 = external.record 1. . the second way is to do a cgi query (like list
all
products or something like it ) which forces ShopSite to give you the
individual record numbers so you can track them in some way your self.
Not
the most elegant solution but it works. All I can say is thank goodness
we
are past the OPENMARKET days! The current ShopSite people are doing a
great
job with a very nice product!

Tell me more about this proposed "return all" cgi query; is there a
wildcard character I can use to return everything in the database (and ONLY
the fields I need)? I could easily keep the results in memory for the
duration of the session, and it would be much easier than searching for SKU
each time and parsing the resulting HTML.

Thanks again for all your help so far.

-Peter

I guess we need more XML database interfaces!! I hope the ShopSite people
realize there are some heavy web sites using their proven core
functionality.

David Clarke


"Peter Brunone" <news@brunone.com> wrote in message
news:bl80sl$9bo$1@support.shopsite.com...
Hi David,

That sounds like the approach I need. Where can I get a list of
required parameters to post to products.cgi? I found the "Power Edit"
section, and I can choose to update the price specifically, but the
underlying parameters are a bit vague (i.e. the price field is named
"1819.1", and the first part appears to be an internal key in the
database)
.
I suppose if I needed to, I could just go through the search process
each time to get the correct record key, but this seems a bit extreme.
Is
there an accessible reference document somewhere that would show me how
to
update price based on SKU rather than internal record ID? This is kind
of
a
time-crunch project -- trait of this particular client -- so whatever
you
can recommend in the short term would be great.

Cheers,

Peter

"David Clarke" <dc@dcinterconnect.com> wrote in message
news:bl4rvb$7as$1@support.shopsite.com...
Hi
This is what happens when you update the products database.
You POST to the products.cgi.
This can be done programatically.
However you need an SSL enabled tool to do it.
We have products that do this.

Let me know if this sends you in the right direction or if you need
more
help.

David Clarke

"Peter Brunone" <news@brunone.com> wrote in message
news:bl39aa$ohp$1@support.shopsite.com...
As a new ShopSite developer, I hope this question has been answered
before.

I have a client whose prices need to be updated via the app that I
have
built. Previously, the app has determined a price based on market
conditions and updated a third-party listing website with the new
price
data... but now I need to update the ShopSite back end as well, and
I
don't
want to have to parse and re-submit that whole "Edit Product Info"
page
just
to update the price field based on SKU. Any thoughts on a way to do
this
a
bit more easily?

Regards,

Peter Brunone

[Peter Brunone]

Yeah, I'm sure the click coordinates on the button don't really
matter... I guess I'll just have to pull out fields as I test-post and see
what happens.


"David Clarke" <DC@dcinterconnect.com> wrote in message
news:bl92jg$kkh$1@support.shopsite.com...

Here is the POST from power edit to update 1 price.
wouldnt supprise me if many of the fields could be omited.

Posting 199 bytes...
473%3A1=16.00
searchstringhid=*
fieldhid=0
queryhid=0
SaveList=on
dbname=products
fields=1
recs=473
info_fields=1
multioruni=multi
function1=ersfinal
Update+Save+Changes.x=76
Update+Save+Changes.y=19