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.


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.

Kemahiran: PHP

Lihat lagi: 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

Tentang Majikan:
( 12 ulasan ) Portland, United States

ID Projek: #104073

Dianugerahkan kepada:


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

$400 USD dalam 5 hari
(246 Ulasan)

15 pekerja bebas membida secara purata $604 untuk pekerjaan ini


Plz see the PMB. Thanks & Regards, CSSAGlobal

$1500 USD dalam 40 hari
(49 Ulasan)

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 Lagi

$500 USD dalam 12 hari
(211 Ulasan)

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 Lagi

$300 USD dalam 5 hari
(172 Ulasan)

Glad to work. Regards

$425 USD dalam 4 hari
(290 Ulasan)

We can help you..

$500 USD dalam 20 hari
(20 Ulasan)

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

$400 USD dalam 10 hari
(3 Ulasan)

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

$400 USD dalam 0 hari
(25 Ulasan)

Dear Employer, Please see PM for details Thank you

$300 USD dalam 3 hari
(4 Ulasan)

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 Lagi

$300 USD dalam 4 hari
(4 Ulasan)

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 dalam 5 hari
(0 Ulasan)

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

$400 USD dalam 3 hari
(0 Ulasan)

Hi,:) Please, See pm.

$1450 USD dalam 34 hari
(0 Ulasan)

Hi, Please check the PMB. Thanks

$500 USD dalam 7 hari
(0 Ulasan)

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

$1288 USD dalam 29 hari
(0 Ulasan)