PHP/SQL application with AJAX/jQuery/ZPL


We operate an online shop and a physical store. Stock levels of both are managed by a Gambio (os-commerce) online shop. The tool should allow to move products from one online shop to the other online shop (products should be reserved either for online sales or offline sales).

Primary functionality: tool should list all (several thousands of) products (extracted from 3-5 MySQL-Tables) in rows.

Colums should contain filters.

On the left, there is the "Online Shop", on the right there is the data from the "Offline Shop". In the middle, there are arrows and a text field to allow movement of 1 or more products from one shop to the other one.

Application should react "real-time" on modern Macs and quick internet connection. We don't have patience to wait more than 0.05 seconds after a click. Clicking many times and then having to wait after clicking "Save" is OK.

All Movements should be tracked, so a "physical relocation overview" can be made for a "session".

Both shops have the same Database structure.


Previous description is core functionality. In order to have full flexibility on our side, we will need several tools around this core function. Examples:

- We will need to transfer newly added products, updated prices, discounts etc. from Shop1 (master) to Shop2 (slave).

- We will need to manage batches of moved products. Edit a couple of times. Finalise the "batch". Print labels (using ZPL and/or generate PDF for A4 labels) for all moved products. Print an overview of all products that were moved in one batch.

- We need to be able to add products to both shops that came from "nowhere" (from a supplier) instead of coming from one of the two shops.

- etc.


We wish to find a person, that is able to quickly understand basic concepts (in addition to PHP, SQL and ZPL) and efficiently executing, but willing to stay within specification.

We wish an application, that allows improvements in the future (well and flexibly structured, well commented code).

We wish to find a person that will stay with us for additional future improvements.

We would like to see a working version of the "core functionality". If both parties are happy, there will follow many more project

Skills: AJAX, jQuery / Prototype, MySQL, PHP, Software Architecture

See more: php ajax jquery chat application, php web application using jquery, jquery ajax php sql, how to fetch data from database in php using ajax, ajax php mysql, using jquery ajax and php to fetch data from a mysql database, javascript php mysql, simple ajax example in php, php ajax example, jquery ajax php, php and ajax mysql database example, php, mysql, php sql form ajax, application form jquery ajax php mysql, php sql application facebook, php quiz application ajax, ajax grid php sql jquery, php sql application, ajax jquery php pagination examples

About the Employer:
( 3 reviews ) Eschenbach SG, Switzerland

Project ID: #15698453

10 freelancers are bidding on average $201 for this job


Hello! We are A2 Design, a Russian-Canadian web development company. We specialise in: PHP & PHP frameworks, WordPress & Woocommerce, Opencart, Magento, API development, HTML5, CSS, JavaScript, Bootstrap, MySQL, etc. More

$350 USD in 3 days
(109 Reviews)

Since you have all products for online and offline in a same database then a checkbox of ONline/offline will do with a textfield to add some notes for each. it will save once u click checkbox . Relevant Skills and Exp More

$111 USD in 1 day
(349 Reviews)

will discuss more if you like. bid doesn't include zpl only pdf . Relevant Skills and Experience well experienced in php mysql Proposed Milestones $250 USD - milestone 1

$250 USD in 3 days
(153 Reviews)

Hi, I have seen your requirements for an application of your existing OS-commerce website. I can surely help you in this. Relevant Skills and Experience Magento, Woo-Commerce, Presta shop, E-Commerce portals HTML, HT More

$200 USD in 3 days
(119 Reviews)

Hello Sir, I am working from 2007 within the same technology and having great experience to successfully deliver your project with quality. Please check my portfolio: [login to view URL] Please let me know if we can discus More

$333 USD in 15 days
(30 Reviews)

Hello, I have good experiences in php, ajax, jQuery, mysql. I'd like to have a discussion to make clear. Thanks, Kind Regards Relevant Skills and Experience php, mysql, jquery, ajax Proposed Milestones $200 USD - c More

$200 USD in 7 days
(37 Reviews)

Hello , My Name is Sam , I am Full Stack web and app developer . I'd read the Project details extremely carefully and I am absolutely sure that I can do the It very well . Relevant Skills and Experience To Know idea a More

$155 USD in 3 days
(37 Reviews)
$30 USD in 1 day
(58 Reviews)
$155 USD in 3 days
(9 Reviews)

I have experienced in PHP, html, css, wordpress, drupal , magento , joomla and available to work on updates mentioned in Magento 2 project. send me message for further discussion. Ady Relevant Skills and Experience ht More

$222 USD in 3 days
(4 Reviews)