Freelancer

Supplier Database Sync from Excel File on FTP  

Supplier Database Sync from Excel File on FTP is project number 293286
posted at Freelancer.com. Click here to post your own project.


| More Free Trial For New Buyers
 

Status: Cancelled

Selected Providers: -

Budget: $250-750

Created: 07/29/2008 at 6:12 EDT

Bid Count: 10

Average Bid:
$ 454

08/13/2008 at 6:12 EDT

Project Creator: feelitnutrition
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (2 reviews)

Bid On This Project
 

Description

Project Specifications for FTP Excel/Database Sync



I. Server Settings:

Operating System: Linux 2.6.9-42.ELsmp
PHP Version: 4.4.7 (Zend: 1.3.0)
Database: MySQL 4.1.22-standard
Shopping Cart: Zen Cart 1.3.7.1
Website to be completed for: www.FeelItNutrition.com

II. Details:

Our supplier keeps a file in .xls format in a password protected directory that is updated every two weeks and is assigned a new password to access it. The products in the list and in our product database need to be synchronized every two weeks to disable discontinued products and adjust price changes that take effect from the .xls file. We also will have a margin table lookup file that will have to be cross referenced in order to determine the correct pricing. Below is an example of the process:
Get file from supplier directory -> Apply prices based on margins set in lookup file -> Set prices accordingly and disable discontinued items in Zen Cart

Example 1: After automatically logging in and moving the .xls file to our server, the synch process should begin. A product is listed in the .xls file, and has a base price set at $19.99. It has a product number of ‘123456’. The product has a manufacturer code of ‘123’. During the synchronization, the script should analyze the manufacturer, then cross reference with our margin table by manufacturer code, (for this example manufacturer code ‘123’ has a markup of 15%.) It would then apply the markup to the base price and set the price of the product on Zen Cart at $22.99 (rounding up to the nearest $0.99). It would then move to the next product.

Example 2: The script comes across a product in the .xls file with a note that says ‘DISC’. It would automatically disable the product in Zen Cart.


III. Important Fields:

Supplier .xls file –
SUPPLIER_NUMBER = the identifier for a specific manufacturer, which will be used to apply margins
STOCK_CODE = this identifies the product within the Zen Cart product database
SELLING_PRICE = this is the base price that will be adjusted by the margin lookup file
DISCONTINUED = if blank, this product is still current. If it contains the value ‘DISC’, it should be taken off of the site
NOTE: If there are any products that are on the .xls sheet, but not in the Zen Cart already, it should output them into a single .xls file

Margin Table Lookup File -
SUPPLIER_NUMBER = the identifier for a specific manufacturer, which will be used to apply margins
MARGIN = This will be a number between 0-100 that will determine what needs to be added to a product.
(equation: roundtonearest99cents(baseprice x 1.(MARGIN)) = newprice)
NOTE: The Margin Table Lookup File only contains Suppliers and their margins. Individual products will not be included in this file.



IV. Multiple Site Integration:

This project also needs to be expandable to other websites that we have, so any changes that are made to files or settings in the Zen Cart admin must be able to be duplicated into another Zen Cart site.


Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

400

3 days

07-29-2008 22:51 EDT

i just read this description carefully, all can be done. im very good at programming on zencart, mysql, php and excel.

help

 

250

4 days

07-29-2008 15:15 EDT

Please check a PMB.

help

 

250

3 days

07-29-2008 15:03 EDT

A VERY IMPORTANT OFFER IS WAITING FOR YOU IN YOUR PM!

help

 

440

5 days

07-29-2008 07:50 EDT

Hello, Greetings from O2i. We are a well established firm, to enable foreign company Outsourcing 2 India. I am confident in completing the job smoothly and sucessfully. Kindly get in touch with me. Best Regards O2I

help

 

250

4 days

07-29-2008 13:57 EDT

US based developer ready to take this project. Understood the requirements

help

 

750

7 days

07-29-2008 14:53 EDT

Hello, we are web applicaiton experts, we have strong experience on this kind of projects, i have read your requirements carefully, let's do it for you. Thanks!

help

 

300

6 days

08-03-2008 22:14 EDT

Dear Customer, Please manage some time from your busy schedule to look into the PM from me. Thanks in advance. With regards, Crispy

help

 

500

7 days

07-29-2008 10:03 EDT

I have more than 6 yrs experience having worked for multinational corporations. I can show you samples of my previous work if you want.

help

 

650

12 days

07-29-2008 12:12 EDT

We are fast growing IT Company with head counts of 47, mainly located in India, Greece & U.S.A. Right now we are providing services in more than 30 countries. We want to increase our business relationship boundaries. So we are interested to give service for your proposal. In case, if you are interested to talk for further. Please feel free to contact us. Thank you and regards , Prabhat Ranjan, Delhi,India.

help

 

750

7 days

07-29-2008 23:47 EDT

(No Feedback Yet)

We have similar project and we can offer you the professional services, the team with over 10+ years working experiences, established in Jul, 2004. please kindly check PMB for details, thank you.

help


    Bid on this Project