Getting at the raw product data in ShopSite Pro 6.3.0

[Shiperton Henethe]

Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[David H]

The ShopSite product database is not directly accessible to third-party
apps. You, of course, can use ShopSite's download feature to export out the
product, page or order data. Since you mention keywords I wonder if you are
refering to the web server logs and/or search terms entered using ShopSite's
search. The product database does not store either of these things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...

Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[Shiperton Henethe]

What we are trying to do is to load individual
sales transactions into our sales database.

The problem is that ShopSite seems to insist in
squirting out the data into "a flat file" format
whereby all units sold in an individual sales
transaction appear on the same row.

Does anyone have a script or something to convert
the individual sales lines into a database in
msExcell or msAccess- so we can have one row per
sales (and total them up etc)

See the problem?


Ship




"David H" <david_hills@yahoo.com> wrote in message
news:bf4hud$8ct$1@support.shopsite.com...

The ShopSite product database is not directly accessible to third-party
apps. You, of course, can use ShopSite's download feature to export out
the
product, page or order data. Since you mention keywords I wonder if you
are
refering to the web server logs and/or search terms entered using
ShopSite's
search. The product database does not store either of these things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...
Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[Keith Petty]

Ship

I have been working on a similar project.
I am writing the code in the Java language.
It takes the flat file that downloads from ShopSite and parses it building a new
file.
If an order has only one item it makes only one row.
If it has more than one item in the order, it duplicates the order number, name,
address, shipping etc. for each item so an order with five items takes five rows
in the file.

It is saved as a "tab" delimited file so that it is easily importable into MS
Excel etc.

Is this a little like what you were looking for?

Keith


Shiperton Henethe wrote:

What we are trying to do is to load individual
sales transactions into our sales database.

The problem is that ShopSite seems to insist in
squirting out the data into "a flat file" format
whereby all units sold in an individual sales
transaction appear on the same row.

Does anyone have a script or something to convert
the individual sales lines into a database in
msExcell or msAccess- so we can have one row per
sales (and total them up etc)

See the problem?

Ship

"David H" <david_hills@yahoo.com> wrote in message
news:bf4hud$8ct$1@support.shopsite.com...
The ShopSite product database is not directly accessible to third-party
apps. You, of course, can use ShopSite's download feature to export out
the
product, page or order data. Since you mention keywords I wonder if you
are
refering to the web server logs and/or search terms entered using
ShopSite's
search. The product database does not store either of these things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...
Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[Shiperton Henethe]

Keith
Yes that would be a good start, I suppose.

Though better yet would be to get direct
access to the relational(?) database within
shopsite.

Would you be able to let us have a copy of your
utility?

(I think ShopSite should seriously
consider making such a thing generally available.
What about two different types of export:
Flat file like now, and also one row per "sales item"
otherwise integration with other databases/systems
is practically impossible, ...unless that is
we are all expected to learn Java and/or Perl!)

With thanks

Ship






"Keith Petty" <support@specialmart.com> wrote in message
news:3F1D50D8.3BD470AB@specialmart.com...

Ship

I have been working on a similar project.
I am writing the code in the Java language.
It takes the flat file that downloads from ShopSite and parses it building
a new
file.
If an order has only one item it makes only one row.
If it has more than one item in the order, it duplicates the order number,
name,
address, shipping etc. for each item so an order with five items takes
five rows
in the file.

It is saved as a "tab" delimited file so that it is easily importable into
MS
Excel etc.

Is this a little like what you were looking for?

Keith


Shiperton Henethe wrote:

What we are trying to do is to load individual
sales transactions into our sales database.

The problem is that ShopSite seems to insist in
squirting out the data into "a flat file" format
whereby all units sold in an individual sales
transaction appear on the same row.

Does anyone have a script or something to convert
the individual sales lines into a database in
msExcell or msAccess- so we can have one row per
sales (and total them up etc)

See the problem?

Ship

"David H" <david_hills@yahoo.com> wrote in message
news:bf4hud$8ct$1@support.shopsite.com...
The ShopSite product database is not directly accessible to
third-party
apps. You, of course, can use ShopSite's download feature to export
out
the
product, page or order data. Since you mention keywords I wonder if
you
are
refering to the web server logs and/or search terms entered using
ShopSite's
search. The product database does not store either of these things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...
Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[comcast]

I have found that the product file can be opened directly in access or excel
by importing as tab delimited. You can then export back as tab or comma
delimited. Sometimes a stray character has to be deleted manually though.

I'm trying to figure how to get at the itemnum field though if anyone has an
idea.



"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bfs87b$hvp$1@support.shopsite.com...

Keith
Yes that would be a good start, I suppose.

Though better yet would be to get direct
access to the relational(?) database within
shopsite.

Would you be able to let us have a copy of your
utility?

(I think ShopSite should seriously
consider making such a thing generally available.
What about two different types of export:
Flat file like now, and also one row per "sales item"
otherwise integration with other databases/systems
is practically impossible, ...unless that is
we are all expected to learn Java and/or Perl!)

With thanks

Ship






"Keith Petty" <support@specialmart.com> wrote in message
news:3F1D50D8.3BD470AB@specialmart.com...
Ship

I have been working on a similar project.
I am writing the code in the Java language.
It takes the flat file that downloads from ShopSite and parses it
building
a new
file.
If an order has only one item it makes only one row.
If it has more than one item in the order, it duplicates the order
number,
name,
address, shipping etc. for each item so an order with five items takes
five rows
in the file.

It is saved as a "tab" delimited file so that it is easily importable
into
MS
Excel etc.

Is this a little like what you were looking for?

Keith


Shiperton Henethe wrote:

What we are trying to do is to load individual
sales transactions into our sales database.

The problem is that ShopSite seems to insist in
squirting out the data into "a flat file" format
whereby all units sold in an individual sales
transaction appear on the same row.

Does anyone have a script or something to convert
the individual sales lines into a database in
msExcell or msAccess- so we can have one row per
sales (and total them up etc)

See the problem?

Ship

"David H" <david_hills@yahoo.com> wrote in message
news:bf4hud$8ct$1@support.shopsite.com...
The ShopSite product database is not directly accessible to
third-party
apps. You, of course, can use ShopSite's download feature to export
out
the
product, page or order data. Since you mention keywords I wonder if
you
are
refering to the web server logs and/or search terms entered using
ShopSite's
search. The product database does not store either of these things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...
Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[Jason]

Hi,

The itemnum value is not a database field that can be controlled in a
product upload as it is dynamically assigned during the database
upload or upon the addition of a product via the back office.

However, if you are uploading to a clean database, you can exercise
some control as the itemnum is assigned sequentially. If the order of your
products does not change you could maintain the order number with
new uploads if the entire product database was being uploaded.

The problem would arise if you deleted products in the middle of the
text database and reuploaded a into Shopsite as a new db, as that
would reassign all the product itemnums on you.

If you have Shopsite Pro, you would be much better off using the order
links based of the SKU's rather than the itemnums as that would probably
not change on you, unless the SKU's themselves were modified by your
company/supplier, etc... If you have Shopsite Manager, this would not
be an option.

Hope this helps.

Jason


<someone@microsoft.com> wrote in message
news:bfsdif$j3u$1@support.shopsite.com...

I have found that the product file can be opened directly in access or
excel
by importing as tab delimited. You can then export back as tab or comma
delimited. Sometimes a stray character has to be deleted manually though.

I'm trying to figure how to get at the itemnum field though if anyone has
an
idea.



"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bfs87b$hvp$1@support.shopsite.com...

Keith
Yes that would be a good start, I suppose.

Though better yet would be to get direct
access to the relational(?) database within
shopsite.

Would you be able to let us have a copy of your
utility?

(I think ShopSite should seriously
consider making such a thing generally available.
What about two different types of export:
Flat file like now, and also one row per "sales item"
otherwise integration with other databases/systems
is practically impossible, ...unless that is
we are all expected to learn Java and/or Perl!)

With thanks

Ship






"Keith Petty" <support@specialmart.com> wrote in message
news:3F1D50D8.3BD470AB@specialmart.com...
Ship

I have been working on a similar project.
I am writing the code in the Java language.
It takes the flat file that downloads from ShopSite and parses it
building
a new
file.
If an order has only one item it makes only one row.
If it has more than one item in the order, it duplicates the order
number,
name,
address, shipping etc. for each item so an order with five items takes
five rows
in the file.

It is saved as a "tab" delimited file so that it is easily importable
into
MS
Excel etc.

Is this a little like what you were looking for?

Keith


Shiperton Henethe wrote:

What we are trying to do is to load individual
sales transactions into our sales database.

The problem is that ShopSite seems to insist in
squirting out the data into "a flat file" format
whereby all units sold in an individual sales
transaction appear on the same row.

Does anyone have a script or something to convert
the individual sales lines into a database in
msExcell or msAccess- so we can have one row per
sales (and total them up etc)

See the problem?

Ship

"David H" <david_hills@yahoo.com> wrote in message
news:bf4hud$8ct$1@support.shopsite.com...
The ShopSite product database is not directly accessible to
third-party
apps. You, of course, can use ShopSite's download feature to
export
out
the
product, page or order data. Since you mention keywords I wonder
if
you
are
refering to the web server logs and/or search terms entered using
ShopSite's
search. The product database does not store either of these
things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...
Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe

[Barney Stone]

Stone Edge Technologies has two ShopSite add-on products that you might find
useful. The Product Manager (http://www.stoneedge.com/productmanager.htm)
can be used to build your products and pages off-line. It includes useful
tools for duplicating similar products and pages, dealing with cross-sell
and product options, etc. The Order Manager
(http://www.stoneedge.com/ordermanager.htm) is a powerful tool for managing
your orders, customers, inventory, purchase orders, CRM, etc. The Order
Manager can import your orders from ShopSite with one button click. It
builds a relational database in Microsoft Access format. It includes many
standard reports (http://www.stoneedge.com/om_reports.htm) and you can also
create your own custom reports.

Both programs have been available for several years now, and are helping
lots of other ShopSite users manage their businesses much more efficiently.

Please give us a call during the week if you would like more information.

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



"Jason" <mcg@cornerm.com> wrote in message
news:bft45k$nsu$1@support.shopsite.com...

Hi,

The itemnum value is not a database field that can be controlled in a
product upload as it is dynamically assigned during the database
upload or upon the addition of a product via the back office.

However, if you are uploading to a clean database, you can exercise
some control as the itemnum is assigned sequentially. If the order of your
products does not change you could maintain the order number with
new uploads if the entire product database was being uploaded.

The problem would arise if you deleted products in the middle of the
text database and reuploaded a into Shopsite as a new db, as that
would reassign all the product itemnums on you.

If you have Shopsite Pro, you would be much better off using the order
links based of the SKU's rather than the itemnums as that would probably
not change on you, unless the SKU's themselves were modified by your
company/supplier, etc... If you have Shopsite Manager, this would not
be an option.

Hope this helps.

Jason


someone@microsoft.com> wrote in message
news:bfsdif$j3u$1@support.shopsite.com...
I have found that the product file can be opened directly in access or
excel
by importing as tab delimited. You can then export back as tab or comma
delimited. Sometimes a stray character has to be deleted manually
though.

I'm trying to figure how to get at the itemnum field though if anyone
has
an
idea.



"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bfs87b$hvp$1@support.shopsite.com...

Keith
Yes that would be a good start, I suppose.

Though better yet would be to get direct
access to the relational(?) database within
shopsite.

Would you be able to let us have a copy of your
utility?

(I think ShopSite should seriously
consider making such a thing generally available.
What about two different types of export:
Flat file like now, and also one row per "sales item"
otherwise integration with other databases/systems
is practically impossible, ...unless that is
we are all expected to learn Java and/or Perl!)

With thanks

Ship






"Keith Petty" <support@specialmart.com> wrote in message
news:3F1D50D8.3BD470AB@specialmart.com...
Ship

I have been working on a similar project.
I am writing the code in the Java language.
It takes the flat file that downloads from ShopSite and parses it
building
a new
file.
If an order has only one item it makes only one row.
If it has more than one item in the order, it duplicates the order
number,
name,
address, shipping etc. for each item so an order with five items
takes
five rows
in the file.

It is saved as a "tab" delimited file so that it is easily
importable
into
MS
Excel etc.

Is this a little like what you were looking for?

Keith


Shiperton Henethe wrote:

What we are trying to do is to load individual
sales transactions into our sales database.

The problem is that ShopSite seems to insist in
squirting out the data into "a flat file" format
whereby all units sold in an individual sales
transaction appear on the same row.

Does anyone have a script or something to convert
the individual sales lines into a database in
msExcell or msAccess- so we can have one row per
sales (and total them up etc)

See the problem?

Ship

"David H" <david_hills@yahoo.com> wrote in message
news:bf4hud$8ct$1@support.shopsite.com...
The ShopSite product database is not directly accessible to
third-party
apps. You, of course, can use ShopSite's download feature to
export
out
the
product, page or order data. Since you mention keywords I
wonder
if
you
are
refering to the web server logs and/or search terms entered
using
ShopSite's
search. The product database does not store either of these
things.

-David H.

"Shiperton Henethe" <shiphen@yahoo.com> wrote in message
news:bemr4i$e8m$1@support.shopsite.com...
Re the product data

1. Is it relational?

2. If so, then can we take copies of the raw data and export
them into some PC readable format so that we can do our own
ad-hoc reporting
(e.g. A report that lists keywords entered against
individual products)

With thanks


Ship
Shiperton Henethe