Automate Product Price and Stock Update

I'd like to be able to get my product price and stock updates to run as automatically as possible (I don't want to do a whole lot of work every time I update). I can download a csv, or tab delimited file from our supplier or they have a .php feed that is described below:

Product Download Help File
The purpose of https://shop.cwrelectronics.com/feeds/productdownload.php is to help you quickly update your database with fresh data from the cwr back-end server. Below is a list of required fields and a description of each one.
Required Variables

    * id
    * fields
    * delim
    * One of the following: time, sku, mfgn, ohtime

Optional Variables

    * invtype

id - A unique string that tied to your account. Your id is: MPB_MzUzNTkwMzUzNTkwNTMw
fields - Fields you want returned followed delimited by a comma
sku	CWR's Part Number
sdesc	Short Description
qty	Quantity Available to Ship
price	Your Cost
list	List Price
map	M.A.P. Price
mrp	M.R.P. Price
mfgn	Manufacturer Part Number
mfg	Manufacturer Name
upc	UPC Code
cat	Category Name
eta	Next Shipment Date
wt	Product's Shipping Weight
bh	Product's Box Height
bl	Product's Box Length
bw	Products's Box Width
fdesc	Full Description
acc	List of Accessories
st	Product Status (1 = Stock; 2 = Non-Stock)
pi	Accessories Included
wa	Product's Warranty
re	Product is a Remanufactured (1 = Yes; 2 = No)
ti	Title
delim - Format to be returned: xml, csv, tab, comma
time - Unix timestamp; all products that have changed after the time sent will be displayed
sku - Enter a CWR sku and have only that item returned
mfgn - Enter a Manufacturer Part Number and have only that item returned
ohtime - Unix timestamp; all products that had quantity on hand changed after the time sent will be displayed
invtype - Choose which kind of inventory to display (stock, nonstock, both)
disc - Will return discontinued items in the results. Fields EXCEPT SKU, MFG# with have the data replaced with NLA; if set to 1 example disc=1
Example [B]https://shop.cwrelectronics.com/feeds/productdownload.php?fields=price,sku&delim=xml&time=1174276800&id=YOURID[/B]

We want to update our store on a (bi-) weekly basis using the Excel command vlookup to import info from the table we download from our supplier and we're able to do that manually with no problems. However, if anyone could help us come up with a macro that will import the new data using vlookup automatically that would be awesome. If the macro could even do the .php query to CWR so we didn't even have to download the initial Excel file from our supplier that would be even better.

I know this is kind of a odd question, but it has to potential to be a big time saver.

Thanks in advance for any help:D

This may or may not be useful to you, but whenever I need to update a whole category of products and I don't want to update each one individually, I run a Query on my products database table. My query looks like this:

UPDATE ifw_products
SET products_price=19.50
WHERE master_categories_id=9

Works for me. Hope this helps

www.infaithwear.com
Inspire Change...

Thanks for the response. Could you explain a little more? I'm assuming this is SQL, which I am not very familiar with.

I HAVE A GREAT FIX TO THIS AND IT UPDATES AUTOMATICALLY!
I found a guy who scripts and he did a great job for me! My site updates products, inventory, and pictures... ALL AUTOMATICALLY! I'm using an .XML feed for my inventory updates... AUTOMATICALLY! I only have to load ONE .csv file to a folder when my supplier updates their products... I don't have to use Easy Populate Advanced... the script DOES IT FOR ME! Loading pictures? IT DOES IT FOR ME! We're talking in seconds! My picture all show up and my inventory stays current!

You will have to pay a little money, but his theory is all the time you spend fudging with your cart, is the time you could be managing sales!

Email me for the hook up!