how to raise prices by set amount across all products easily

This is an archive of old posting to the User Forum

how to raise prices by set amount across all products easily

Postby Stan Frantz » Fri Dec 10, 2004 12:56 pm

I often need to raise prices a set amount across all products from a
specific supplier. such as if they change a shipping rate.

I have programmed in a db field for my suppliers so I can select all the
products from them, but since all the products have different prices I can't
raise them all by $6.07 using global power edit. I have over 300 different
products to re-price. It takes awhile and is open to typos to do each one
manually, not to mention brain farts affecting my arithemetic. :)

any suggestions? is there anything I'm missing in the documentation?

thanks

Stan Frantz
shopsite.nni.com
Stan Frantz
 

Re: how to raise prices by set amount across all products ea

Postby loren_d_c » Fri Dec 10, 2004 2:48 pm

Download your products in tab-delimited format and load the file into a
spreadsheet. You can do all kinds of math calculations on all of the
numbers in the Price column (add a certain amount, add a certain
percentage, etc), then export from the spreadsheet back to tab-delimited
and upload the file back into ShopSite to update the prices of your
products.

-Loren



Stan Frantz wrote:
I often need to raise prices a set amount across all products from a
specific supplier. such as if they change a shipping rate.

I have programmed in a db field for my suppliers so I can select all the
products from them, but since all the products have different prices I can't
raise them all by $6.07 using global power edit. I have over 300 different
products to re-price. It takes awhile and is open to typos to do each one
manually, not to mention brain farts affecting my arithemetic. :)

any suggestions? is there anything I'm missing in the documentation?

thanks

Stan Frantz
shopsite.nni.com

loren_d_c
 
Posts: 2571
Joined: Fri Aug 04, 2006 12:02 pm
Location: Anywhere

Re: how to raise prices by set amount across all products ea

Postby Nikolaus Gruchot » Fri Dec 10, 2004 2:49 pm

Hi Stan,

how about doing a product download in txt format, opening the download with
excel, do a price change with the batch functionality there and re-uploading
the updated product db?! Would that be the easiest way... ?!

Regards,

Niko

"Stan Frantz" <stan@nni.com> schrieb im Newsbeitrag
news:cpcrgm$gjg$1@eval.shopsite.com...
I often need to raise prices a set amount across all products from a
specific supplier. such as if they change a shipping rate.

I have programmed in a db field for my suppliers so I can select all the
products from them, but since all the products have different prices I
can't raise them all by $6.07 using global power edit. I have over 300
different products to re-price. It takes awhile and is open to typos to do
each one manually, not to mention brain farts affecting my arithemetic.
:)

any suggestions? is there anything I'm missing in the documentation?

thanks

Stan Frantz
shopsite.nni.com

Nikolaus Gruchot
 

Re: how to raise prices by set amount across all products ea

Postby Stan Frantz » Fri Dec 10, 2004 3:31 pm

but I was hoping there was something I could do thru the admin interface
something simple like selecting all the products in question and doing a
power edit on the price with a wildcard and an operator ie.

*+ 6.06

like you do when setting varying prices in an options list.
hopefully it would take whatever value was stored as the price for each item
and alter it accordingly.
hint, hint to shopsite programmers ;-)

If I have to tho, I will probably go the data base route.

thx,

stan

"Stan Frantz" <stan@nni.com> wrote in message
news:cpcrgm$gjg$1@eval.shopsite.com...
I often need to raise prices a set amount across all products from a
specific supplier. such as if they change a shipping rate.

I have programmed in a db field for my suppliers so I can select all the
products from them, but since all the products have different prices I
can't raise them all by $6.07 using global power edit. I have over 300
different products to re-price. It takes awhile and is open to typos to do
each one manually, not to mention brain farts affecting my arithemetic.
:)

any suggestions? is there anything I'm missing in the documentation?

thanks

Stan Frantz
shopsite.nni.com

Stan Frantz
 

Re: how to raise prices by set amount across all products ea

Postby Gary Kennedy » Sat Dec 11, 2004 3:47 am

Tab delimited would be best. Excel add " to some fields causing problems.

Gary Kennedy
gkennedy@martyshoes.com
www.martyshoes.com
Toll-Free 877-362-7897
Fax 201-319-1446

Marty Shoes Inc.
60 Enterprise Ave. N.
Secaucus, NJ 07094
"Stan Frantz" <stan@nni.com> wrote in message
news:cpcrgm$gjg$1@eval.shopsite.com...
I often need to raise prices a set amount across all products from a
specific supplier. such as if they change a shipping rate.

I have programmed in a db field for my suppliers so I can select all the
products from them, but since all the products have different prices I
can't raise them all by $6.07 using global power edit. I have over 300
different products to re-price. It takes awhile and is open to typos to do
each one manually, not to mention brain farts affecting my arithemetic.
:)

any suggestions? is there anything I'm missing in the documentation?

thanks

Stan Frantz
shopsite.nni.com

Gary Kennedy
 


Return to User Forum Archive

Who is online

Users browsing this forum: No registered users and 2 guests