Supplier Database Sync from Excel File on FTP

Project Specifications for FTP Excel/Database Sync

I. Server Settings:

Operating System: Linux [url removed, login to view]

PHP Version: 4.4.7 (Zend: 1.3.0)

Database: MySQL 4.1.22-standard

Shopping Cart: Zen Cart

Website to be completed for: [url removed, login to view]

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.

Kemahiran: PHP

Lihat lagi: example databse supplier product, excel supplier database, project supplier database, supplier database excel, sample supplier database, ftp supplier, sync xls file php, www excel, we excel, supplier manufacturer, standard website pricing, product supplier database, password protected excel, manufacturer supplier, manufacturer prices, manufacturer order, get a supplier, get a manufacturer, format pricing, format prices, expandable list, excel &, correct password, changes to take effect, c# database mysql

Tentang Majikan:
( 2 ulasan ) Tyler, United States

ID Projek: #293286

10 pekerja bebas membida secara purata $454 untuk pekerjaan ini


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

$440 USD dalam 5 hari
(219 Ulasan)

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

$250 USD dalam 4 hari
(24 Ulasan)

Please check a PMB.

$250 USD dalam 4 hari
(69 Ulasan)

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

$400 USD dalam 3 hari
(79 Ulasan)


$250 USD dalam 3 hari
(37 Ulasan)

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!

$750 USD dalam 7 hari
(9 Ulasan)

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

$300 USD dalam 6 hari
(21 Ulasan)

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. S Lagi

$650 USD dalam 12 hari
(2 Ulasan)

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

$500 USD dalam 7 hari
(4 Ulasan)

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.

$750 USD dalam 7 hari
(0 Ulasan)