Closed

Importing new products & product quantity into Openbravopos - repost

I am using Openbravopos and would like to keep track of current inventory.

So, I need a way to easily update the quantity of each product by running an import of a list of products using [url removed, login to view] as the unique identifier.

I am using MySQL database.

So I need an import script that will do this:

For each product in the list, check if product exists in PRODUCT table by matching on CODE.

If product does not exist:

a) add product into PRODUCT table

b) update STOCKCURRENT and STOCKDIARY with Qty of product

If product exists:

a) update [url removed, login to view] with new selling price

b) update STOCKCURRENT and STOCKDIARY with additional Qty of product

Please bid only if you have experience with Openbravo POS.

When you bid, please explain whether you recommend to use SQL or PHP to write this script.

Thanks!

Skills: MySQL, PHP, SQL

See more: pos sql, sql pos, product table, import sql database mysql, using product, add product php code, selling pos, sql inventory, table inventory php script, mysql product database products, add table openbravo pos, openbravo pos products, script selling product, openbravo pos mysql database, selling product script, mysql product database script, sql pos database, inventory products, pos inventory code, pos mysql php, mysql pos, openbravo php mysql, php inventory pos, php openbravo pos, sql inventory database

About the Employer:
( 2 reviews ) Singapore, Singapore

Project ID: #4863124

6 freelancers are bidding on average $44 for this job

pixarsolution

OpenBravo POS expert is here. I can deliver you 100% solution.

$111 USD in 2 days
(11 Reviews)
5.6
programac

Please check your private message box

$31 USD in 2 days
(32 Reviews)
5.3
zhongxian929

Hi! Ready to start!!! Correctly, I can do it. Please check my pm

$30 USD in 2 days
(3 Reviews)
0.0
ranesh26

Hi sir, I did work a same type of open pos system. So I can do it easily. If you interested please contact me.

$30 USD in 1 day
(5 Reviews)
0.0
sumanling

Hi sir, I did work a same type of open pos system. So I can do it easily. If you interested please contact me.

$30 USD in 1 day
(0 Reviews)
0.0
skynyxghy

Ready to start right now ....

$30 USD in 1 day
(1 Review)
0.0