Product upload question

This is an archive of old posting to the User Forum

Product upload question

Postby JSutton » Fri Jul 25, 2003 7:33 am

Loren,
We are using shopsite 6.3 and have 5000+ products on our site. We have
picked up a new supplier and want to add their products to the site as well.
Can we upload the products (already in the proper format) to the site
without bothering the existing products? It is not important to us that all
shopsite fields are completed before the upload takes place. We are more or
less looking to get the bulk of the information into the system so that it
can be assigned pictures etc. We have had some experience with product
uploads in the past, but we have not tried it where we didn't delete the
database prior to the upload. We appreciate your help.

Justin
JSutton
 

Re: Product upload question

Postby Brandon Eley » Sat Jul 26, 2003 9:56 am

We rarely delete our database. We use the product upload and upload
tab/comma delimeted files with our new products all the time. Never had
a problem.

Brandon
2BigFeet.com

JSutton wrote:

Loren,
We are using shopsite 6.3 and have 5000+ products on our site. We have
picked up a new supplier and want to add their products to the site as well.
Can we upload the products (already in the proper format) to the site
without bothering the existing products? It is not important to us that all
shopsite fields are completed before the upload takes place. We are more or
less looking to get the bulk of the information into the system so that it
can be assigned pictures etc. We have had some experience with product
uploads in the past, but we have not tried it where we didn't delete the
database prior to the upload. We appreciate your help.

Justin

Brandon Eley
 

Re: Product upload question

Postby Larry Bohen » Mon Jul 28, 2003 6:47 am

I upload changes/additions to our 7700+ MS Access products db daily to our
ShopSite Pro store. Each Access product record has a "Status" field into
which I enter a date in (the date I added or changed the record). I created
a query which selects records for upload based on the "Status" field
criteria. Today's upload criteria is Between "20030727" And "20030728" -
This criteria selects only records with a "Status" field between 7/27/2003
and 7/28/2003. I simply edit this "Status" field criteria depending upon the
dates I want included in the upload.

Each of our 7700+ audiobook products has a unique SKU. It is important when
you are uploading to ShopSite, that you make sure that each product has a
"unique product identifier" (SKU or NAME) otherwise you may add duplicates
of items you already have at your Web site.


"Brandon Eley" <brandon@2bigfeet.com> wrote in message
news:bfubtu$4h7$2@support.shopsite.com...
We rarely delete our database. We use the product upload and upload
tab/comma delimeted files with our new products all the time. Never had
a problem.

Brandon
2BigFeet.com

JSutton wrote:

Loren,
We are using shopsite 6.3 and have 5000+ products on our site. We have
picked up a new supplier and want to add their products to the site as
well.
Can we upload the products (already in the proper format) to the site
without bothering the existing products? It is not important to us that
all
shopsite fields are completed before the upload takes place. We are more
or
less looking to get the bulk of the information into the system so that
it
can be assigned pictures etc. We have had some experience with product
uploads in the past, but we have not tried it where we didn't delete the
database prior to the upload. We appreciate your help.

Justin


Larry Bohen
 

Re: Product upload question

Postby JSutton » Mon Jul 28, 2003 1:16 pm

Thank you to the both of you for sharing your experience with us. We look
forward to making the addition of our new supplier quick and easy. Have a
great day.

Justin



"Larry Bohen" <lbohen@audiobooksonline.com> wrote in message
news:bg39gd$npd$1@support.shopsite.com...
I upload changes/additions to our 7700+ MS Access products db daily to our
ShopSite Pro store. Each Access product record has a "Status" field into
which I enter a date in (the date I added or changed the record). I
created
a query which selects records for upload based on the "Status" field
criteria. Today's upload criteria is Between "20030727" And "20030728" -
This criteria selects only records with a "Status" field between 7/27/2003
and 7/28/2003. I simply edit this "Status" field criteria depending upon
the
dates I want included in the upload.

Each of our 7700+ audiobook products has a unique SKU. It is important
when
you are uploading to ShopSite, that you make sure that each product has a
"unique product identifier" (SKU or NAME) otherwise you may add duplicates
of items you already have at your Web site.


"Brandon Eley" <brandon@2bigfeet.com> wrote in message
news:bfubtu$4h7$2@support.shopsite.com...
We rarely delete our database. We use the product upload and upload
tab/comma delimeted files with our new products all the time. Never had
a problem.

Brandon
2BigFeet.com

JSutton wrote:

Loren,
We are using shopsite 6.3 and have 5000+ products on our site. We have
picked up a new supplier and want to add their products to the site as
well.
Can we upload the products (already in the proper format) to the site
without bothering the existing products? It is not important to us
that
all
shopsite fields are completed before the upload takes place. We are
more
or
less looking to get the bulk of the information into the system so
that
it
can be assigned pictures etc. We have had some experience with product
uploads in the past, but we have not tried it where we didn't delete
the
database prior to the upload. We appreciate your help.

Justin




JSutton
 

Re: Product upload question

Postby Larry Bohen » Tue Jul 29, 2003 4:41 am

Before you do anything like this, especially for the first time, BACKUP your
ShopSite store and your Access db.

"JSutton" <jsutton@petluvers.com> wrote in message
news:bg40b4$sns$1@support.shopsite.com...
Thank you to the both of you for sharing your experience with us. We look
forward to making the addition of our new supplier quick and easy. Have a
great day.

Justin



"Larry Bohen" <lbohen@audiobooksonline.com> wrote in message
news:bg39gd$npd$1@support.shopsite.com...
I upload changes/additions to our 7700+ MS Access products db daily to
our
ShopSite Pro store. Each Access product record has a "Status" field into
which I enter a date in (the date I added or changed the record). I
created
a query which selects records for upload based on the "Status" field
criteria. Today's upload criteria is Between "20030727" And "20030728" -
This criteria selects only records with a "Status" field between
7/27/2003
and 7/28/2003. I simply edit this "Status" field criteria depending upon
the
dates I want included in the upload.

Each of our 7700+ audiobook products has a unique SKU. It is important
when
you are uploading to ShopSite, that you make sure that each product has
a
"unique product identifier" (SKU or NAME) otherwise you may add
duplicates
of items you already have at your Web site.


"Brandon Eley" <brandon@2bigfeet.com> wrote in message
news:bfubtu$4h7$2@support.shopsite.com...
We rarely delete our database. We use the product upload and upload
tab/comma delimeted files with our new products all the time. Never
had
a problem.

Brandon
2BigFeet.com

JSutton wrote:

Loren,
We are using shopsite 6.3 and have 5000+ products on our site. We
have
picked up a new supplier and want to add their products to the site
as
well.
Can we upload the products (already in the proper format) to the
site
without bothering the existing products? It is not important to us
that
all
shopsite fields are completed before the upload takes place. We are
more
or
less looking to get the bulk of the information into the system so
that
it
can be assigned pictures etc. We have had some experience with
product
uploads in the past, but we have not tried it where we didn't delete
the
database prior to the upload. We appreciate your help.

Justin






Larry Bohen
 


Return to User Forum Archive

Who is online

Users browsing this forum: No registered users and 64 guests