Mysql one way update oPOS to Prestashop

Closed

Mysql one way update stock volume and pricing between Unicenta oPOS and Prestashop.

Unicenta opos is open point-of-sale using Mysql, same as prestashop.

Update of stock volume POS to Presta every time there is order payment confirmed in POS.

Update of pricing(price buy, price sell, price + tax) POS to Presta every time price is changed in POS, or every 5min.

Add two extra fields to POS product table eg SK1 and SK2 for future use, eg product description. Modify Unicenta opos to alow data input to these new fields in front software, just next to "product name".

Scenario example:

Online order payment is confirmed, invoice printed(not included), shop assistant prepares that order and scan all available products in to POS. That way our POS system consist our total sales, orders and so on. Please mind that these products were already taken off the online stock during online shopping.

Due to out of stock situations (eg somebody is walking around the shop with 10 mars bars in his basket) POS system should automatically adjust online order in Presta after it's preparation is completed, to reflect any shortages in products. Correction note should be then generated and emailed to the customer as usual. If this step is to complicated/expensive to get POS to identify online order and adjust accordingly to what was scanned in during order preparation, then it will need to be done usual way, manually in the back office. Please state in your biding if this step 'back order adjustment' is included in your bid.

Prestashop database is located on remote hosting server.

Unicenta database will be located on local server in the shop.

Test web will be set for development.

I am looking for simple budget project, to avoid online overselling to my customers.

Thanks

Seb

Skills: MySQL, PHP

See more: prestashop price update mysql, prestashop update stock, prestashop mysql update, prestashop pos, unicenta opos mysql prestashop, your remote assistant, what to buy and sell on the web, what is test scenario, test scenario, tax preparation software, software development project description example, shop assistant online, remote tax preparation, pricing of web development project, php remote development, online sale assistant, mysql database buy, mysql customer database, my office products, eg web development, buy tax online, unicenta prestashop, opos, online tax preparation, what to buy and sell online

Project ID: #1590809

7 freelancers are bidding on average $682 for this job

toinnisfree

pls chk pmb

$875 CAD in 7 days
(520 Reviews)
7.8
epark

prestashop expert.please check pm.

$750 CAD in 14 days
(107 Reviews)
6.7
gopalvora

Hi Ready to start Thanks..

$700 CAD in 30 days
(133 Reviews)
6.7
crmexpert27

Hello. I am an expert customizing Prestashop + POS systems. Please see my profile and past reviews !

$648 CAD in 15 days
(1 Review)
2.3
deeps1984

Hi, Ready to work..

$400 CAD in 5 days
(0 Reviews)
0.0
bctechnosys

Hi , we appreciate and thank you for sharing your requirements. We are a team that knows the integrity of design and develop a website and with the following links you can have the idea. PHP projects http://ww More

$800 CAD in 15 days
(1 Review)
0.0
Juliantechno

PLEASE CHECK PMB

$600 CAD in 6 days
(0 Reviews)
0.0