Find Jobs
Hire Freelancers

OSCommerce, Import products from a datafeed

$30-250 USD

Cancelled
Posted about 16 years ago

$30-250 USD

Paid on delivery
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)
Project ID: 222804

About the project

3 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $225 USD for this job
User Avatar
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
$250 USD in 5 days
5.0 (18 reviews)
5.7
5.7
User Avatar
Please check PM.
$200 USD in 7 days
4.9 (7 reviews)
2.9
2.9
User Avatar
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
4.5 (1 review)
2.6
2.6

About the client

Flag of UNITED STATES
Port Richey, United States
5.0
17
Member since Feb 7, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.