Käynnissä

PoS System to Oscommerce integration. Simple mysql transfer

Hello.

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.

Regards

Retry

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

Taidot: Komentosarjan asennus, Ostoskärryt

Näytä lisää: retail pos system script, pos simple script, php pos integration script, pos integration oscommerce, oscommerce pos, oscommerce pos integration, use an escrow system to payment, system one, shop-it-to-me, retail job, retail escrow, php escrow payment integration, payment system with escrow, job retail, how to contact escrow, escrow sale, oscommerce php pos integration, oscommerce retail pos, oscommerce pos system, oscommerce integration point sale system, transfer pos system database, retail script pos, pos system retail store mysql, oscommerce integration shop pos, pos script

Tietoa työnantajasta:
( 36 arvostelua ) Hafrsfjord, Norway

Projektin tunnus: #465695

Myönnetty käyttäjälle:

marcinzygmunt

I'm ready to work on that.

45 $ USD 1 päivässä
(11 arvostelua)
3.2

4 freelanceria on tarjonnut keskimäärin 73 $ tähän työhön

dice8up

Hi, php/mySql pros here. We are ready to give you a solution for your database query and auto run query.

250 $ USD 5 päivässä
(16 arvostelua)
5.1
kedeesofttech

Please Check PMB.

45 $ USD 0 päivässä
(6 arvostelua)
3.5
kingyond

can i see the data struct, i can do it well for u. i am skill in [url removed, login to view]

50 $ USD 1 päivässä
(3 arvostelua)
2.4
Thewebweavers

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

150 $ USD 3 päivässä
(1 arvostelu)
0.0