I do need a simple script which can gather information from one mysql database and transfer it to another one.
This is how I would like things to be.
I have a PoS(point of sale software, used in a retail store) which do use mysql as database. I do add all our products in the PoS software. With stock status, name, product number, category(and sub categories).
I have an oscommerce store, and I would like to automaticly transfer the products with info from the PoS system to the web shop.
This could be done with a simple php script which I can run as a cron job every 6th hour or something.
If you would like to see the database structure, please contact me.
Payment will be done through escrow, when it's done, and tested.
Her is the structure. Please new bidders, have a look at it to understand what to do.
At the top you can see the PoS structure. Please make note of the Z colomn. I only want products witch has G in the WEB_STATUS row to be transfered to oscommerce. So in the example in the base.xls, the product in line 2 should be transfered to the web, but not the product in line 3.(see the Z field)
I ONLY need the fields which you can see in line 4 matched. In other words there are 7 fields to match.
PoS db -> Oscommerce db
VARE_NR -> Model
VARE1 -> products_name
VARE3 -> Image
PRIS -> products_price
KODE -> category ID
LAGER -> Qantity
MEMO -> Description
4 freelanceria on tarjonnut keskimäärin 73 $ tähän työhön
Hi, I am glad to bid on this pos to oscommerse data integration project and i have all idea to make this happen for you. Please check your PM. Regards, Amit