products database question

[Don Lundell]

Anyone know if it's possible to download the product item# as a field in the product database?

Or if it's possible through an API to extract product information?

Thanks,

- dc

[jim]

The answer to both questions is no. There is no field that contains the
database record number and there is no API that you can use to extract
product information.

The easiest way to get this information is to go to the main products
screen and list all the products. Then in the html source of the page
the product record number will be listed along with the product name in
a format something like this:
<select name="recs" multiple size=14>
<option selected value="1">dummy product
<option value="0">M&M
<option value="10">My Product
<option value="11">Your product
<option value="12">Our product
<option value="2">Roberts & Manetti
<option value="2442">test product
</select>

To extract just the product name and record number copy the section of
code to a word processor and do a search and replace to delete all the
extraneous wording like <option value-" and ">. You could then sort
the products into record number order or alpabetically.

Jim

Don Lundell wrote:

Anyone know if it's possible to download the product item# as a field in
the product database?

Or if it's possible through an API to extract product information?

Thanks,

- dc

[Webmaster - Dave's Discou]

on the API side, if you have Perl installed, there may be hope

In some very old builds of ShopSite is a handy little script called
list-inums.pl
together with dbapi.pl, this will do exactly what you need. Don't know why
Shopsite stopped including this handy thing.

Place them in the /ss directory of your store, set permissions
appropriately, and call it from your web browser. Presto! You get output
that looks like this:

245 ca200 - G23LH Cylinder ca200
246 fd203 - Muffler Bolt fd203
247 ca211 - G23LH Cylinder Gasket ca211
248 ca212 - G23LH / G43L Cylinder Bolt ca212
249 av406 - G23LH Insulator Gasket av406
250 av405 - G23LH Insulator Manifold av405
251 av401 - G23LH Carburetor Gasket av401
252 av407 - Insulator Screw (M5 x 20) av407

tab-delimited: database product number, product name, sku.

email me at webmaster@davesmotors.com and I will forward you the files you
need.







"jim" <jstavast@xmission.com> wrote in message
news:dfb1q9$1fk$1@eval.shopsite.com...

The answer to both questions is no. There is no field that contains the
database record number and there is no API that you can use to extract
product information.

The easiest way to get this information is to go to the main products
screen and list all the products. Then in the html source of the page the
product record number will be listed along with the product name in a
format something like this:
select name="recs" multiple size=14
option selected value="1">dummy product
option value="0">M&M
option value="10">My Product
option value="11">Your product
option value="12">Our product
option value="2">Roberts & Manetti
option value="2442">test product
/select

To extract just the product name and record number copy the section of
code to a word processor and do a search and replace to delete all the
extraneous wording like <option value-" and ">. You could then sort the
products into record number order or alpabetically.

Jim

Don Lundell wrote:

Anyone know if it's possible to download the product item# as a field in
the product database?

Or if it's possible through an API to extract product information?

Thanks,

- dc

[Don Lundell]

On Mon, 05 Sep 2005 20:03:19 -0700, Webmaster - Dave's Discount Motors <webmaster@davesmotors.com> wrote:

on the API side, if you have Perl installed, there may be hope

In some very old builds of ShopSite is a handy little script called
list-inums.pl
together with dbapi.pl, this will do exactly what you need. Don't know why
Shopsite stopped including this handy thing.

Place them in the /ss directory of your store, set permissions
appropriately, and call it from your web browser. Presto! You get output
that looks like this:

245 ca200 - G23LH Cylinder ca200
246 fd203 - Muffler Bolt fd203
247 ca211 - G23LH Cylinder Gasket ca211
248 ca212 - G23LH / G43L Cylinder Bolt ca212
249 av406 - G23LH Insulator Gasket av406
250 av405 - G23LH Insulator Manifold av405
251 av401 - G23LH Carburetor Gasket av401
252 av407 - Insulator Screw (M5 x 20) av407

tab-delimited: database product number, product name, sku.

email me at webmaster@davesmotors.com and I will forward you the files you
need.

Actually, it turns out I have a copy of list-inums from the Froogle feed add-on.

Thanks for the info. I'll combine this with data some from the product database,
and it should give me with I need.

Thanks again,

- dc

[Webmaster - Dave's Discou]

Fantastic, glad to see that gagglebyte is getting that list-inums.pl out
there. I chased it down for her originally

"Don Lundell" <noone@nowhere.com> wrote in message
news:op.swo7jivhhdeb9o@dc-laptop.logwinxp.resilience.com...
On Mon, 05 Sep 2005 20:03:19 -0700, Webmaster - Dave's Discount Motors
<webmaster@davesmotors.com> wrote:

on the API side, if you have Perl installed, there may be hope

In some very old builds of ShopSite is a handy little script called
list-inums.pl
together with dbapi.pl, this will do exactly what you need. Don't know why
Shopsite stopped including this handy thing.

Place them in the /ss directory of your store, set permissions
appropriately, and call it from your web browser. Presto! You get output
that looks like this:

245 ca200 - G23LH Cylinder ca200
246 fd203 - Muffler Bolt fd203
247 ca211 - G23LH Cylinder Gasket ca211
248 ca212 - G23LH / G43L Cylinder Bolt ca212
249 av406 - G23LH Insulator Gasket av406
250 av405 - G23LH Insulator Manifold av405
251 av401 - G23LH Carburetor Gasket av401
252 av407 - Insulator Screw (M5 x 20) av407

tab-delimited: database product number, product name, sku.

email me at webmaster@davesmotors.com and I will forward you the files you
need.

Actually, it turns out I have a copy of list-inums from the Froogle feed
add-on.

Thanks for the info. I'll combine this with data some from the product
database,
and it should give me with I need.

Thanks again,

- dc

[jim]

Webmaster - Dave's Discount Motors wrote:

Fantastic, glad to see that gagglebyte is getting that list-inums.pl out
there. I chased it down for her originally

"Don Lundell" <noone@nowhere.com> wrote in message
news:op.swo7jivhhdeb9o@dc-laptop.logwinxp.resilience.com...
On Mon, 05 Sep 2005 20:03:19 -0700, Webmaster - Dave's Discount Motors
webmaster@davesmotors.com> wrote:

on the API side, if you have Perl installed, there may be hope

In some very old builds of ShopSite is a handy little script called
list-inums.pl
together with dbapi.pl, this will do exactly what you need. Don't know why
Shopsite stopped including this handy thing.

Place them in the /ss directory of your store, set permissions
appropriately, and call it from your web browser. Presto! You get output
that looks like this:

245 ca200 - G23LH Cylinder ca200
246 fd203 - Muffler Bolt fd203
247 ca211 - G23LH Cylinder Gasket ca211
248 ca212 - G23LH / G43L Cylinder Bolt ca212
249 av406 - G23LH Insulator Gasket av406
250 av405 - G23LH Insulator Manifold av405
251 av401 - G23LH Carburetor Gasket av401
252 av407 - Insulator Screw (M5 x 20) av407

tab-delimited: database product number, product name, sku.

email me at webmaster@davesmotors.com and I will forward you the files you
need.

Actually, it turns out I have a copy of list-inums from the Froogle feed
add-on.

Thanks for the info. I'll combine this with data some from the product
database,
and it should give me with I need.

Thanks again,

- dc


Be aware that the list-inums.pl was dropped because ShopSite no longer

uses any perl. The dbapi.pl is several version out of sync with the
database and code and there is no guarantee that any data that it
provides will be accurate or that it will work with future versions of
ShopSite.

Jim

[Don Lundell]

Be aware that the list-inums.pl was dropped because ShopSite no longer
uses any perl. The dbapi.pl is several version out of sync with the
database and code and there is no guarantee that any data that it
provides will be accurate or that it will work with future versions of
ShopSite.

Jim

Any idea why Shopsite wouldn't just make the item numbers available in the products database?

- dc