Streaming external csv product feed

[buzznights]

Hi all,

 

I want to add a streaming external stock feed to my osCommerce site so I have an accurate display of my suplliers stock levels.

 

I've been looking around but can't seem to find a guide or tutorial with details on how to do this. I'm fairly new to osCommerce so I'm looking for a step by step guide if possible.

 

If anyone can help or point me in the direction of a good tutorial, this would be very much appreciated.

 

Thanks for your time

Stephen

[♥mdtaylorlrim]

Hi all,

 

I want to add a streaming external stock feed to my osCommerce site so I have an accurate display of my suplliers stock levels.

 

I've been looking around but can't seem to find a guide or tutorial with details on how to do this. I'm fairly new to osCommerce so I'm looking for a step by step guide if possible.

 

If anyone can help or point me in the direction of a good tutorial, this would be very much appreciated.

 

Thanks for your time

Stephen

This is going to be a highly customized add on and well beyond the scope of the forum, I would think.

 

You first have to determine if your supplier will push the feed to you, or if you have to pull the feed.

If your supplier pushes the feed then you have to get the format of the feed, determine the common product identifier, parse each line of the feed, then alter your products table for the quantity.

If you have to pull the feed then there are several ways to do it determined by what access is allowed by the supplier. Many times you can simply send an html request for each product and parse the return to find the common product identifier and quantity and then alter your products table for the quantity.

 

If I were doing this I would make it a two step process allowing me to manually verify the data prior to altering the tables.

 

Either way you're looking at a ton of research and months of trial and error unless you are an accomplished php or perl programmer. My suggestion, if you are not a programmer, is to bite the bullet and pay someone to do this for you, if the return exceeds the cost of doing it.