Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Question from a newbie (a real green newbie).



9:36 pm on Apr 26, 2011 (gmt 0)

5+ Year Member

I can create a site just fine in Dreamweaver and know quite a bit about SEO. My next project is to take a retailers product data feed and create an affiliate site just for that affiliate. I download the product data feed in csv format and I know I can copy and paste the product name, product description, price ect over one product at a time but with 12,000 it's hardly an efficient way of building a site.

I know there is a way to have my site pull info directly from a spreadsheet but I have no idea where to begin.

Can someone point my in the right direction?
( I don't know any PHP, SQL or ASP code but will learn if it's needed).

Thanks in advance,


9:48 pm on Apr 26, 2011 (gmt 0)

WebmasterWorld Senior Member demaestro is a WebmasterWorld Top Contributor of All Time 10+ Year Member


You will likely have to learn a server side scripting language to do this unless you want to do it in an Ajax solution. I can tell you though if you are dealing with 12,000 rows that Ajax may not be the way to go unless you can figure out how to 'page' the data from that feed. Same with if you need this to be index'ble content

If you want to go Ajax you should check out Spry datasets and regions. It is from Adobe and plays nice in Dreamweaver which is why I mention it.


look at datasets and regions

I think your best option tho is to write an import script that inserts/updates a database and then read the data in from that database using PHP/ASP/PYTHON or whatever server language makes sense to use.


9:51 pm on Apr 26, 2011 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month

Depending on your DB, you should have a tool or command to import a CSV file into a table.

If it's an ongoing project (with the retailer frequently updating their product feed), you may want to automate the process. You could do it with a scheduled task in the DB or application server (PHP, ASP, etc.).


9:52 pm on Apr 26, 2011 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member

2 parts.

1). importing the data into your own database.

2). getting the data from your database into your pages.


1) using something like phpMyAdmin you should be able to import a csv format file into a database.

2). extracting the data will require a scripting language, you're going to need to learn the basics of sql (mySQL) and php in order to get started, this is not trivial from a standing start - but go for it, there are thousands of tutorials online.


10:07 pm on Apr 26, 2011 (gmt 0)

5+ Year Member

I've been watching a 200 part tutorial on Youtube and it seems like it's a pretty in depth process. I feel that nothing is "over my head" but it sure is turning out to be an intimidating project.

So far the tutorial has me using xampp and MySQL. Am I correct in guessing that these are 2 of the programs I will need?

Featured Threads

Hot Threads This Week

Hot Threads This Month