Product Feed Manager

[andy_cwz]

Hi guys, I'm new to the affiliate world. I'm a web designer/developer by trade.

I started playing a few months back and wanted to do a site which meant using a lot of datafeeds from several different networks.

I came across a few programs that could have helped merge all the product feeds together but none of them really gave me much control and I wanted the output in one database.

So after spending 3/4's of a day uploading and merging products (60,000 products) feeds using excel etc and then finding out the next day most of the products were not working (product feed error) I decided to write a program to do it for me and give me options.

So i've developed a tool which does the following.

IMPORT
Simply FTP your CSV files to your webserver - Import CSV files (option to select seperator pipe comma etc). This merges into a "merchant" mysql table e.g buyat.

CLEAN
This option allows you to clean out data you do not wish to use by selecting a "Merchant" "Category" column and highlighting the unique "Categories" you don't wish to use and removing them. You can also view the selected data before you delete them to ensure you aren't deleting anything you do not wish to have.

MERGE
The merge option allows you customise a mater table to hold all "Merchant" product feeds - thus allowing you to just point to one table which contains every product from all merchants. obviously this is a problem because of the columns/fields being so different. So this tool allows you to save configurations for each "Merchant". e.g. Buyat > productname = mastertable > name | Affiliatewindow > product_name = mastertable > name.

TABLE MANAGER
This option allows you to create new tables (including new Merchants), empty any tables within the database, or delete them.

So the end result has allowed me to do this within 20mins.

- Import 130,000 products within a few mintues,
- Clean out products/data I don't want
- Merge all seperate "Merchant" product feeds into one customised mysql table.

My question to you guys is is this something you would benefit from?

I've finished the script - I just need to create a "Install" page.

PM me if this is something you are interested in - I'm currently working on a demo video so you can get a better idea.

Thanks

[andy_cwz]

My explanation above was pretty poor (rushing around trying to do too many things) so I've thrown together a quick demostration of what it can do.

cwz_autofeed_demo

Thanks

Andy

PS is this the best place to post here about this?