I gang

OSCommerce Database Synchronization Module

OSCommerce Database Synchronization Module

I have two separate OSCommerce websites that share a large number of products between them. I want a utility that will synchronize products, categories, and manufacturers from one site to the other (only a one way synch is required). I was planning to do this myself, but I'm too swamped to get to it.

I will put the money into GAF escrow and will pay it out when the following requirements have been demonstrated. You will need to do the development on your own local sites as I will not provide the login to my sites or access to my databases. Since this is a generic module that should not be a problem. I'll send 50% of the payment when you deliver code that appears to address the requirements. I'll send the remainder of the funds once it is installed and works on my site. This should be a pretty quick job for someone who knows what they're doing in OSC.

If you do a good job on this, there are more jobs I can send your way.

Requirements

1. The module should be callable from a cron script nightly and should work automatically without user intervention

2. The module should also be callable from the OSC admin side

3. The module should reside on the 2nd website that is the target of the synchronization.

4. The module should synchronize specific records in the following tables

a. Products

b. Products_description

c. Manufacturers

d. Manufacturers_info

e. Categories

f. Categories_description

g. Products_to_categories

h. Specials

5. The products, manufacturers, and categories tables of the DB to be synched have a new field named "updated". That field should be used to determine which records get synchronized.

a. If updated = 1, then the record needs to be synched

b. If updated= 0, then the record is already synched.

6. The module should query all records with 'updated' set to 1 and then synchronize them one at a time.

7. Once a record has been updated you must set the 'updated' field to 0 in the source DB to indicate that it has been successfully synchronized. That way an internal server error won't leave it in an unknown state…

8. The module should only synchronize products, manufacturers, and categories where the 'updated' field is 1.

9. The module should synchronize the tables in the following order:

a. Manufacturers

b. Categories

c. Products

10. If the module is synchronizing manufacturers, it should also synchronize the manufacturers_info record for that manufacturers_id.

11. If the module is synchronizing categories, it should also synchronize the categories_description record for that categories_id.

12. If the module is synchronizing products, it should also synchronize the products_description, products_to_categories, and specials records for that products_id.

13. If the product_id, manufacturers_id, or categories_id already exists in the 2nd DB, then you should use a mysql Update statement. If it doesn't exist, you should use a mysql Insert statement.

14. When synchronizing the databases, the manufacturers_id, products_id, and categories_id should be the same on both databases.

15. The module should be written in PHP and should conform to the basic conventions of OSCommerce.

Færdigheder: PHP

Se mere: oscommerce sync prodct, oscommerce synchronize database, database synchronization, written jobs, where is escrow, what jobs can you do, what is the problem statement, what is problem statement, what is a problem statement, what are databases and what are they used for, update oscommerce 2.2 to 2.3.1, target jobs, state of n.h. jobs, state of n.c. jobs, statement problem, statement of a problem, state jobs, specific problem statement, side jobs, products manufacturers, problem websites, problem categories, planning problem, payment module escrow, out source jobs

Om arbejdsgiveren:
( 12 bedømmelser ) Portland, United States

Projekt-ID: #104073

Tildelt til:

hautu

I'm be able to do it for you. regards.

$400 USD in 5 dage
(246 bedømmelser)
7.6

15 freelancere byder i gennemsnit $604 for dette job

cssaglobal1

Plz see the PMB. Thanks & Regards, CSSAGlobal

$1500 USD in 40 dage
(49 bedømmelser)
7.9
VALUEONWEB

Valueonweb is a customer-specific service oriented company has got an Professional and creative team. We are the Professional Web Development Company having 3 years experience in Web design and development. We have exp Mere

$500 USD in 12 dage
(211 bedømmelser)
7.9
omtechnologies

Dear Sir/ Madam, Our team has taken a close look at your requirements and has come up with a solution with most competitive bidding rates. This bid is for a highly professional and quality work/service that we render t Mere

$300 USD in 5 dage
(172 bedømmelser)
7.7
netsolve

Glad to work. Regards

$425 USD in 4 dage
(290 bedømmelser)
7.3
gigapromoters

We can help you..

$500 USD in 20 dage
(20 bedømmelser)
6.4
MBarb

Hello, We have over 4 years of experience in PHP, OSCommerce and are willing to start the project immediately. Thanks

$400 USD in 10 dage
(3 bedømmelser)
5.6
elfuerte

Can start immediately. Payment by paypal. Same conditions just without escrow.

$400 USD in 0 dage
(25 bedømmelser)
5.0
SWebGuru

Dear Employer, Please see PM for details Thank you

$300 USD in 3 dage
(4 bedømmelser)
3.2
DyaDya

Thanks for detail information about the job!!! I will do this for you. My price is low, about 8-10$ per hour! But operational experience with php and mysql is hight (more than 5 years). If you choose me, i'm create an Mere

$300 USD in 4 dage
(4 bedømmelser)
3.3
murugan050171

Let me be given with the opportunity to work on this project, I assure you that it will be completed in the time given and for your complete satisfaction.

$400 USD in 5 dage
(0 bedømmelser)
0.0
fmark

Hi I have just implemented this a few days back I can do it for you in real notime.

$400 USD in 3 dage
(0 bedømmelser)
0.0
NexxCom

Hi,:) Please, See pm.

$1450 USD in 34 dage
(0 bedømmelser)
0.0
softtechpegasus

Hi, Please check the PMB. Thanks

$500 USD in 7 dage
(0 bedømmelser)
0.0
jornkey

Jarun :Owned and Operated by karun as of February 2005. Designers and Programmers highly skilled

$1288 USD in 29 dage
(0 bedømmelser)
0.0