OSCommerce Database Synchronization Module

Imekamilika Ilichapishwa Nov 4, 2006 Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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.

PHP

Kitambulisho cha Mradi: #104073

Kuhusu mradi

14 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

hautu

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

$400 USD kwa siku 5
(Maoni 246)
7.6

14 wafanyakazi huru wanazabuni wastani wa $626 kwa kazi hii

cssaglobal1

Plz see the PMB. Thanks & Regards, CSSAGlobal

$1500 USD kwa siku 40
(Maoni 49)
7.9
netsolve

Glad to work. Regards

$425 USD kwa siku 4
(Maoni 289)
7.3
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 Zaidi

$300 USD kwa siku 5
(Maoni 205)
7.7
gigapromoters

We can help you..

$500 USD kwa siku 20
(Maoni 20)
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 kwa siku 10
(Maoni 3)
5.6
elfuerte

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

$400 USD kwa siku 0
(Maoni 25)
5.0
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 Zaidi

$300 USD kwa siku 4
(Maoni 4)
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 kwa siku 5
(Maoni 0)
0.0
fmark

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

$400 USD kwa siku 3
(Maoni 0)
0.0
NexxCom

Hi,:) Please, See pm.

$1450 USD kwa siku 34
(Maoni 0)
0.0
softtechpegasus

Hi, Please check the PMB. Thanks

$500 USD kwa siku 7
(Maoni 0)
0.0
jornkey

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

$1288 USD kwa siku 29
(Maoni 0)
0.0