Welcome to WebmasterWorld Guest from

Forum Moderators: buckworks

Message Too Old, No Replies

What is the fastest way to update prices for an ecommerce website?

ecommerce website, update product prices

6:47 am on Feb 24, 2014 (gmt 0)

New User

joined:Feb 24, 2014
posts: 2
votes: 0


I know that this is not exactly a technical discussion forum but I just waned to get some idea as how people handle the issue that we are facing on our website.

We have recently launched an ecommerce website named <snip> and we have successfully added nearly 700 products to our database by collecting them from different suppliers. And we are now facing issue in updating the prices. Since the prices change frequently and the suppliers send us a new pricing list every 1 or 2 days we have to get back to the list of 700 products and check it entirely to update them. As you may understand its not quite easy to change prices for 700 products each day and we usually end up spending hours in the process.

I just wanted to know if any of you guys have experience in using some technique by which the task of updating prices can be done faster and efficiently. Also if you check the website and have any feedback regarding the design or usability etc please do post it. Your feedback and suggestions are highly appreciated. Thanks.

[edited by: buckworks at 2:06 pm (utc) on Feb 24, 2014]
[edit reason] URL drop snipped [/edit]

11:12 am on Feb 24, 2014 (gmt 0)

Senior Member from GB 

WebmasterWorld Senior Member piatkow is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Apr 5, 2006
votes: 46

Hours to update 700 prices? It sounds to me as if you are using the wrong DBMS.

Seriously if you can't run a script that will update a datebase from a csv file or spreadsheet in a few minutes then you have bought the wrong software.
12:14 pm on Feb 24, 2014 (gmt 0)

New User

joined:Feb 24, 2014
posts: 2
votes: 0

Hello [piatkow],

Thanks for your reply, we are already looking into that option. We actually use the CSV upload technique to update shipping cost to different countries as provided by our shipping service provider. I agree with you, it will save a lot of time while updating prices.

We wanted to know if there is any alternate to using CSV format maybe some software or a really smart technique. Thanks.
1:20 pm on May 22, 2014 (gmt 0)

New User

joined:Mar 12, 2014
votes: 0

CSV knowledge with inventive PHP programming works wonders for a lot of updates.
5:48 pm on June 26, 2014 (gmt 0)

New User

joined:June 26, 2014
votes: 0

If you figure out a percentage that you want to increase, just put two new columns in your spreadsheet. one the percentage, and one for the result, then just drag the formula down the list. Cut and paste "value only" where your old prices were, Takes about 5 minutes.

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members