Importing new products & product quantity into Openbravopos - repost
- Status Closed
- Budget $10 - $30 USD
- Total Bids 6
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!Get free quotes for a project like this
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online