In Progress

310937 PHP developer + mySQL

Import inventory from mysql into Channel Advisor using PHP

Goal is to develop PHP two ways interface between Channel Advisor ([url removed, login to view]) database and mySQL database



• mySQL

• eBay principles (preferred)

Project Overview:

We are a retail company that has mySQL database as inventory for its products. This information from this mySQL database must be imported in Channel Advisor database via PHP two ways interface. Channel Advisor database has its own PHP API.

Project Details:

API info - channel advisor developer network:

Php examples:

Needed results:

1) function that creates/ updates one inventory item

updates all product variation of this product id in Channel Advisor system

- input: product_id

- output: true/false

- process:

--- load all product variations of the product (table: product_variation, col: product_variation_id)

--- cycle through all product variations

--- if doesn't exist: create new, if exists, update

--- update all attributes which can be set via API, get data from product or product_variation table, any data that is not available populate with test data for now

--- database: eos (end of service)

2) function that cycles through all products and creates/ updates all inventory in Channel Advisor database

3) function that retrieves stock levels for one product item

- input: product_id

- output: array containing product_variation_ids containing array of all stock levels

- process: retrieve stock level info via API based on a given product id

4) simple test web application to test all the functions and to run import and see the results

The codes must have commentaries and be easy to understand and efficient.

Project Deliverables/ Success Criteria:

All the functions work and test application work without errors and unhandled exceptions. Import of database is completed.

Response Requirements for Providers: (please provide the following to be considered):

• your fixed rate for the entire project

• your estimated timeline.

• your general hours of availability during the week.

• your availability for ongoing work after completion of the project

• brief summary of applicable experience with proof

Skills: Anything Goes, PHP, SQL

See more: week end update, web php developer, web develop php, web developer with codes, web developer update, web developer test, web developer rate, web developer providers, web developer overview, web developer channel, true results, test your php skills, test for php developer, table in web developer, summary of web developer, summary of a web developer, summary for web developer, sql inventory system, simple web application examples, service channel

About the Employer:
( 0 reviews )

Project ID: #2056734