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/[login to view URL],sku&delim=xml&time=1174276800&id=YOURID
Information on the Easy Popular Contrib.
-----------------------------------------------------
The Easy Populate contribution can be found here (I'm using 2.76E)
[login to view URL]
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)
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 automatically gets all the data from that site. But for that you have to give me access permission on your server for making entry in cron. I will also take care to add one field in your database.
Please hire me. So i can start your work.
Kind Regards,
ITGynis
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.