Find Jobs
Hire Freelancers

540899 osCommerce Migration 2

N/A

Dalam Kemajuan
Disiarkan lebih dari 12 tahun yang lalu

N/A

Dibayar semasa penghantaran
Earlier this year, you wrote a datamigration script for oscommerce 2.3 for us. This works very well. But we're looking at extending the functionality. Please allow me to elaborate on this. Several online shops want to use a copy of the main database for the products, categories and manufacturers. We could use your script for this, but unfortunately, the script only works when the tables are truncated and filled again. Some tables (mainly the products table) contain valuable information for some of the reports these shop owners need. We're therefore looking into extending the functionality with update statements for existing products so we can keep the data to report on, and insert statements for new products. Some shop owners need to add products they've created themselves/bought elsewhere. But as osCommerce generates it's products_id's automatically, there is a chance that the products entered manually at one of the daughter shops will be overwritten by the data coming from the main database. This holds for categories and manufacturers as well. I tried to add some categories and products, by creating a category/manufacturer/product with id 999999. Adding subsequent objects in the db automatically generates id's based on the manually entered ID (so 1000000 and so on). This is OK, but what happens when I run the script to update/insert products from the mother DB? So the import script should take into account that products entered manually remain in the database. I will make sure the selected ID of the manually entered products are high enough to not cause conflicts. What would be the effort/cost to rewrite the script to make this possible. Next to that, as an extention of the above, we'd like to be able to select the manufacturers that need to be migrated and enter a price markup for each of the selected manufacturers. We don't want to do this each and every time, so the initial setup and changes thereafter need to be saved somewhere. As 8 websites will be using the main database as a base for their catalogue, the selections of which manufacturers need to be set, need to be saved per website. If should be possible to run the update/insert process through a cron job.
ID Projek: 2286840

Tentang projek

1 cadangan
Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
$425 USD dalam 5 hari
4.9 (304 ulasan)
7.7
7.7

Tentang klien

Bendera NETHERLANDS
Sittard, Netherlands
5.0
15
Kaedah pembayaran disahkan
Ahli sejak Feb 14, 2010

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.