Closed

Importing new products & product quantity into Openbravopos - repost

This project received 6 bids from talented freelancers with an average bid price of $44 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$10 - $30 USD
Total Bids
6
Project Description

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!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online