Devam Ediyor

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.

Beceriler: PHP

Daha fazlasını görün: oscommerce sync prodct, oscommerce synchronize database, database synchronization, written jobs, statement problem, specific problem statement, side jobs, products manufacturers, problem websites, problem categories, planning problem, payment module escrow, source jobs, nightly jobs, named query, money put escrow, manufacturers products, local manufacturers, jobs target, escrow one time payment, good money jobs, good escrow sites, escrow money send, b escrow, problem statement

İşveren Hakkında:
( 12 değerlendirme ) Portland, United States

Proje NO: #104073

Seçilen:

hautu

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

5 gün içinde 400$ USD
(246 Değerlendirme)
7.6

15 freelancer bu iş için ortalamada 604$ teklif veriyor

cssaglobal1

Plz see the PMB. Thanks & Regards, CSSAGlobal

in 40 gün içinde1500$ USD
(49 Değerlendirme)
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 Daha fazlası

in 12 gün içinde500$ USD
(211 Değerlendirme)
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 Daha fazlası

in 5 gün içinde300$ USD
(172 Değerlendirme)
7.7
netsolve

Glad to work. Regards

in 4 gün içinde425$ USD
(290 Değerlendirme)
7.3
gigapromoters

We can help you..

in 20 gün içinde500$ USD
(20 Değerlendirme)
6.4
MBarb

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

in 10 gün içinde400$ USD
(3 Değerlendirme)
5.6
elfuerte

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

in 0 gün içinde400$ USD
(25 Değerlendirme)
5.0
SWebGuru

Dear Employer, Please see PM for details Thank you

in 3 gün içinde300$ USD
(4 Değerlendirme)
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 Daha fazlası

in 4 gün içinde300$ USD
(4 Değerlendirme)
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.

in 5 gün içinde400$ USD
(0 Değerlendirme)
0.0
fmark

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

in 3 gün içinde400$ USD
(0 Değerlendirme)
0.0
NexxCom

Hi,:) Please, See pm.

in 34 gün içinde1450$ USD
(0 Değerlendirme)
0.0
softtechpegasus

Hi, Please check the PMB. Thanks

in 7 gün içinde500$ USD
(0 Değerlendirme)
0.0
jornkey

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

in 29 gün içinde1288$ USD
(0 Değerlendirme)
0.0