OSCommerce, Import products from a datafeed

I have data feed from a supplier that contains product information such as Part#’s, product name, Category, Price/cost, MAP price, weight, quantity on hand, MFG name, Image name, etc. I need this information imported into my OSCommerce site at least once a day. So far I have been manually converting the raw data feed info into a format that can be used by the OSC Easy Populate contribution but I need to have this process automated and completed at least once a day so inventory numbers are correct.

Here is information provided by the datafeed provider.

Product Download Help File

The purpose of this site 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, imgtime

Optional Variables

* invtype

id - A unique string that tied to your account. Your id is: XXXXXXXXX

fields - Fields you want returned followed delimited by a comma

sku 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

imgpath Product's Image Name If There Is One

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 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

imgtime - Unix timestamp; all products that had their main image modified or added 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 /feeds/[url removed, login to view],sku&delim=xml&time=1174276800&id=YOURID

Information on the Easy Popular Contrib.


The Easy Populate contribution can be found here (I'm using [url removed, login to view])

[url removed, login to view]

I also need this done.


Is I'm also going to need one additional MySql field populated in my database that Easy Populate doesn't currently handle. In the raw data feed there is a field called MAP (Map Price) that I will need imported into the Mysql products table as products_map. (Pretty easy, but that need to be done also)

Skills: PHP, Shopping Carts

See more: feed php import product oscommerce, import datafeed oscommerce, oscommerce sku data feed, cwr oscommerce, oscommerce import data feed, oscommerce import products, want a part time account, update oscommerce 2.2 to 2.3.1, supplier manufacturer, product supplier database, populate xml from database, oscommerce addons easy populate, need a manufacturer of my product, m string, mfg mfg, map string, manufacturer supplier, manufacturer's code list, manufacturer products, info fresh com, i have a product i need a manufacturer, height and length, have a product need a manufacturer, example of inventory database, description of products product

About the Employer:
( 17 reviews ) Port Richey, United States

Project ID: #222804

3 freelancers are bidding on average $225 for this job


Hi, I am interested in this project. I have worked on such type of projects. I will make a script to extract data from data feed and place it in your database and this script will run once in the day and automatical More

$250 USD in 5 days
(18 Reviews)

Please check PM.

$200 USD in 7 days
(7 Reviews)

I have read and understood the requirements and I am interested to do this job. I will assure you that you will get 100% satisfaction. Hope to hear from you soon.

$225 USD in 7 days
(1 Review)