does anybody understand the internal structure of the shopsi

[Andrew G]

here's what I don't understand. when I log into shopsite manager, I have
986 products. when I do a query for all products in the database, I get
894. another thing is that the IDs that I get from accessing the db outside
are different from that shown whenever I publish or edit a product page (the
numbers under store generation page). so if I want to query the record for
a particular product using the ID, I actually get another product's records.
any suggestions? for example, on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497. weired...
thanx for the help guys.

[Jim]

Andrew,
What do you mean by the following:
"on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497."
How are you looking at the "products database itself" and what is the
"shopsite store manager". Also a couple of times you mention "query"
how are you doing that?

It is entirely possible that a product in the database will have a
different id than the order it was entered into the database. When
products are deleted they leave holes in the database that may be filled
with new products as they are added. For example if you add 3 products
and then delete the first one and then add a new one, the new one will
probably be placed where the first one was and will have a record number
of 1 not 4. Products that are deleted aren't actually removed from the
database until after the store is published so that might account for
some difference in record numbers and how many product you actually have.

Jim


Andrew G wrote:

here's what I don't understand. when I log into shopsite manager, I have
986 products. when I do a query for all products in the database, I get
894. another thing is that the IDs that I get from accessing the db outside
are different from that shown whenever I publish or edit a product page (the
numbers under store generation page). so if I want to query the record for
a particular product using the ID, I actually get another product's records.
any suggestions? for example, on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497. weired...
thanx for the help guys.

[Andrew G]

Jim,

We are using shopsite as part of our hosting package from verio. whenever I
manage our store database, I login to the shopsite backend where you can add
products, pages, templates etc. when I "Edit Product Info", and publish the
store, I take note of the numbers that are printed in the screen. it says:

----------------------------------------------------
Indexing Product [108:Rio Nitrus mp3 player] ...
Indexing Page [181:Audio - MP3 Players ] ...

End of Partial Reindex.

Generating Page [181: Audio - ....
----------------------------------------------------

I assume the 108 means product ID as it's recorded in the database, no?
then when I access my store's database through
a mysql client for example and do "SELECT ID, Name, Price from Products
where ID=181" the resulting product is
NOT the Rio Nitrus but something else. What do these numbers mean?

Thanks for any help in advance. It would make my life simpler to be able to
query the db for my own purpose like creating reports
of what we have in stock and what we don't. or what products are priced
above or below a certain treshold or whatever.

- EC


"Jim" <jstavast@xmission.com> wrote in message
news:bunh3h$4hl$1@support.shopsite.com...

Andrew,
What do you mean by the following:
"on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497."
How are you looking at the "products database itself" and what is the
"shopsite store manager". Also a couple of times you mention "query"
how are you doing that?

It is entirely possible that a product in the database will have a
different id than the order it was entered into the database. When
products are deleted they leave holes in the database that may be filled
with new products as they are added. For example if you add 3 products
and then delete the first one and then add a new one, the new one will
probably be placed where the first one was and will have a record number
of 1 not 4. Products that are deleted aren't actually removed from the
database until after the store is published so that might account for
some difference in record numbers and how many product you actually have.

Jim


Andrew G wrote:
here's what I don't understand. when I log into shopsite manager, I
have
986 products. when I do a query for all products in the database, I get
894. another thing is that the IDs that I get from accessing the db
outside
are different from that shown whenever I publish or edit a product page
(the
numbers under store generation page). so if I want to query the record
for
a particular product using the ID, I actually get another product's
records.
any suggestions? for example, on the product database itself, ID for one
of
my products is 441, and on the shopsite store manager, I get 497.
weired...
thanx for the help guys.

[loren_d_c]

Since ShopSite does not use an SQL database for products and the
ShopSite database is not accessible via SQL queries, then you are
getting some other database not related to ShopSite, which would explain
why the record numbers are different.

-Loren



Andrew G wrote:

Jim,

We are using shopsite as part of our hosting package from verio. whenever I
manage our store database, I login to the shopsite backend where you can add
products, pages, templates etc. when I "Edit Product Info", and publish the
store, I take note of the numbers that are printed in the screen. it says:

----------------------------------------------------
Indexing Product [108:Rio Nitrus mp3 player] ...
Indexing Page [181:Audio - MP3 Players ] ...

End of Partial Reindex.

Generating Page [181: Audio - ....
----------------------------------------------------

I assume the 108 means product ID as it's recorded in the database, no?
then when I access my store's database through
a mysql client for example and do "SELECT ID, Name, Price from Products
where ID=181" the resulting product is
NOT the Rio Nitrus but something else. What do these numbers mean?

Thanks for any help in advance. It would make my life simpler to be able to
query the db for my own purpose like creating reports
of what we have in stock and what we don't. or what products are priced
above or below a certain treshold or whatever.

- EC


"Jim" <jstavast@xmission.com> wrote in message
news:bunh3h$4hl$1@support.shopsite.com...

Andrew,
What do you mean by the following:
"on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497."
How are you looking at the "products database itself" and what is the
"shopsite store manager". Also a couple of times you mention "query"
how are you doing that?

It is entirely possible that a product in the database will have a
different id than the order it was entered into the database. When
products are deleted they leave holes in the database that may be filled
with new products as they are added. For example if you add 3 products
and then delete the first one and then add a new one, the new one will
probably be placed where the first one was and will have a record number
of 1 not 4. Products that are deleted aren't actually removed from the
database until after the store is published so that might account for
some difference in record numbers and how many product you actually have.

Jim


Andrew G wrote:

here's what I don't understand. when I log into shopsite manager, I

have

986 products. when I do a query for all products in the database, I get
894. another thing is that the IDs that I get from accessing the db

outside

are different from that shown whenever I publish or edit a product page

(the

numbers under store generation page). so if I want to query the record

for

a particular product using the ID, I actually get another product's

records.

any suggestions? for example, on the product database itself, ID for one

of

my products is 441, and on the shopsite store manager, I get 497.

weired...

thanx for the help guys.

[Andrew G]

my gosh. thanks loren. I've beating my head over this and I wonder why
when I make an update to the shopsite backend, it does not get reflected
into the database records. so my question now is, how do I access the
product db that shopsite is using? my hurdle is that shopsite came as a
package with our hosting server so i didn't install it myself.

thanks so much.
"( '.;.' )" _fernan_


"Loren" <loren_d_c@yahoo.com> wrote in message
news:bupu6e$q9n$1@support.shopsite.com...

Since ShopSite does not use an SQL database for products and the
ShopSite database is not accessible via SQL queries, then you are
getting some other database not related to ShopSite, which would explain
why the record numbers are different.

-Loren



Andrew G wrote:
Jim,

We are using shopsite as part of our hosting package from verio.
whenever I
manage our store database, I login to the shopsite backend where you can
add
products, pages, templates etc. when I "Edit Product Info", and publish
the
store, I take note of the numbers that are printed in the screen. it
says:

----------------------------------------------------
Indexing Product [108:Rio Nitrus mp3 player] ...
Indexing Page [181:Audio - MP3 Players ] ...

End of Partial Reindex.

Generating Page [181: Audio - ....
----------------------------------------------------

I assume the 108 means product ID as it's recorded in the database, no?
then when I access my store's database through
a mysql client for example and do "SELECT ID, Name, Price from Products
where ID=181" the resulting product is
NOT the Rio Nitrus but something else. What do these numbers mean?

Thanks for any help in advance. It would make my life simpler to be
able to
query the db for my own purpose like creating reports
of what we have in stock and what we don't. or what products are priced
above or below a certain treshold or whatever.

- EC


"Jim" <jstavast@xmission.com> wrote in message
news:bunh3h$4hl$1@support.shopsite.com...

Andrew,
What do you mean by the following:
"on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497."
How are you looking at the "products database itself" and what is the
"shopsite store manager". Also a couple of times you mention "query"
how are you doing that?

It is entirely possible that a product in the database will have a
different id than the order it was entered into the database. When
products are deleted they leave holes in the database that may be filled
with new products as they are added. For example if you add 3 products
and then delete the first one and then add a new one, the new one will
probably be placed where the first one was and will have a record number
of 1 not 4. Products that are deleted aren't actually removed from the
database until after the store is published so that might account for
some difference in record numbers and how many product you actually
have.

Jim


Andrew G wrote:

here's what I don't understand. when I log into shopsite manager, I

have

986 products. when I do a query for all products in the database, I
get
894. another thing is that the IDs that I get from accessing the db

outside

are different from that shown whenever I publish or edit a product page

(the

numbers under store generation page). so if I want to query the record

for

a particular product using the ID, I actually get another product's

records.

any suggestions? for example, on the product database itself, ID for
one

of

my products is 441, and on the shopsite store manager, I get 497.

weired...

thanx for the help guys.

[Jim]

There is no programatic way of accessing the ShopSite databases. You
can enter/edit/delete product and page information using the ShopSite
back office Pages or Products screens. If you have a Pro or Manager
version of ShopSite you can upload/download the same information using a
tab delimited file by going to Utilities > Database >Upload/Download.
You can probably output the tab delimited file from your SQL database
and import that into ShopSite to keep the two in sync.
Jim

Andrew G wrote:

my gosh. thanks loren. I've beating my head over this and I wonder why
when I make an update to the shopsite backend, it does not get reflected
into the database records. so my question now is, how do I access the
product db that shopsite is using? my hurdle is that shopsite came as a
package with our hosting server so i didn't install it myself.

thanks so much.
"( '.;.' )" _fernan_


"Loren" <loren_d_c@yahoo.com> wrote in message
news:bupu6e$q9n$1@support.shopsite.com...

Since ShopSite does not use an SQL database for products and the
ShopSite database is not accessible via SQL queries, then you are
getting some other database not related to ShopSite, which would explain
why the record numbers are different.

-Loren



Andrew G wrote:

Jim,

We are using shopsite as part of our hosting package from verio.

whenever I

manage our store database, I login to the shopsite backend where you can

add

products, pages, templates etc. when I "Edit Product Info", and publish

the

store, I take note of the numbers that are printed in the screen. it

says:

----------------------------------------------------
Indexing Product [108:Rio Nitrus mp3 player] ...
Indexing Page [181:Audio - MP3 Players ] ...

End of Partial Reindex.

Generating Page [181: Audio - ....
----------------------------------------------------

I assume the 108 means product ID as it's recorded in the database, no?
then when I access my store's database through
a mysql client for example and do "SELECT ID, Name, Price from Products
where ID=181" the resulting product is
NOT the Rio Nitrus but something else. What do these numbers mean?

Thanks for any help in advance. It would make my life simpler to be

able to

query the db for my own purpose like creating reports
of what we have in stock and what we don't. or what products are priced
above or below a certain treshold or whatever.

- EC


"Jim" <jstavast@xmission.com> wrote in message
news:bunh3h$4hl$1@support.shopsite.com...


Andrew,
What do you mean by the following:
"on the product database itself, ID for one of
my products is 441, and on the shopsite store manager, I get 497."
How are you looking at the "products database itself" and what is the
"shopsite store manager". Also a couple of times you mention "query"
how are you doing that?

It is entirely possible that a product in the database will have a
different id than the order it was entered into the database. When
products are deleted they leave holes in the database that may be filled
with new products as they are added. For example if you add 3 products
and then delete the first one and then add a new one, the new one will
probably be placed where the first one was and will have a record number
of 1 not 4. Products that are deleted aren't actually removed from the
database until after the store is published so that might account for
some difference in record numbers and how many product you actually

have.

Jim


Andrew G wrote:


here's what I don't understand. when I log into shopsite manager, I

have


986 products. when I do a query for all products in the database, I

get

894. another thing is that the IDs that I get from accessing the db

outside


are different from that shown whenever I publish or edit a product page

(the


numbers under store generation page). so if I want to query the record

for


a particular product using the ID, I actually get another product's

records.


any suggestions? for example, on the product database itself, ID for

one

of


my products is 441, and on the shopsite store manager, I get 497.

weired...


thanx for the help guys.

[Eddie Caplan]

It would be really, really, really, really, really nice if we could
access the ShopSite database. As it is, I'm trying to maintain two
halves of the same website: ShopSite, and all the rest of the site that
has nothing to do with shopping. Yet, there is information that is
useful to both: User Names, Addresses, Items bought / sold, Discounts
qualified for, etc.

I'm grateful that ShopSite has added Customer Registration. Now I want
more.

Perhaps ShopSite could provide an API to maintain referential
integrity. I don't HAVE to have direct SQL access... just some way in.

BTW, if that interface could be in PHP.....

Eddie


In article <buq1i1$qvt$1@support.shopsite.com>, Jim
<jstavast@xmission.com> wrote:

> There is no programatic way of accessing the ShopSite databases.

[Andrew G]

Man for a simple report utility. That's all I ask. Shopsite does have
reports page in the back office but it's not customizable so it's useless.
I need to generate a report of how our inventory looks like. Has anybody
ever needed to do such a thing and how if you were able to accomplish it
with shopsite?


"Eddie Caplan" <eddiec_NOSPAM@NOSPAM_stararcher.com> wrote in message
news:230120041133011170%eddiec_NOSPAM@NOSPAM_stararcher.com...

It would be really, really, really, really, really nice if we could
access the ShopSite database. As it is, I'm trying to maintain two
halves of the same website: ShopSite, and all the rest of the site that
has nothing to do with shopping. Yet, there is information that is
useful to both: User Names, Addresses, Items bought / sold, Discounts
qualified for, etc.

I'm grateful that ShopSite has added Customer Registration. Now I want
more.

Perhaps ShopSite could provide an API to maintain referential
integrity. I don't HAVE to have direct SQL access... just some way in.

BTW, if that interface could be in PHP.....

Eddie


In article <buq1i1$qvt$1@support.shopsite.com>, Jim
jstavast@xmission.com> wrote:

There is no programatic way of accessing the ShopSite databases.

[Brandon Eley]

If you want to do that level of reporting you'll have to get a third
party product like Stone Edge. I hate that it's that way... but it is.
Of course, with StonEdge you have the full level of customizeability of
Access... you can write any queries you want on the data in the
database... which is a big plus.

Brandon

Andrew G wrote:

Man for a simple report utility. That's all I ask. Shopsite does have
reports page in the back office but it's not customizable so it's useless.
I need to generate a report of how our inventory looks like. Has anybody
ever needed to do such a thing and how if you were able to accomplish it
with shopsite?


"Eddie Caplan" <eddiec_NOSPAM@NOSPAM_stararcher.com> wrote in message
news:230120041133011170%eddiec_NOSPAM@NOSPAM_stararcher.com...

It would be really, really, really, really, really nice if we could
access the ShopSite database. As it is, I'm trying to maintain two
halves of the same website: ShopSite, and all the rest of the site that
has nothing to do with shopping. Yet, there is information that is
useful to both: User Names, Addresses, Items bought / sold, Discounts
qualified for, etc.

I'm grateful that ShopSite has added Customer Registration. Now I want
more.

Perhaps ShopSite could provide an API to maintain referential
integrity. I don't HAVE to have direct SQL access... just some way in.

BTW, if that interface could be in PHP.....

Eddie


In article <buq1i1$qvt$1@support.shopsite.com>, Jim
jstavast@xmission.com> wrote:


There is no programatic way of accessing the ShopSite databases.