In Progress

oscommerce php file update

Job is to update a php script (and the associated database in mysql for oscommerce if needed (but I don't think it is)).

I need one php file for oscommerce updated correctly to do the following:

Add two custom fields in an array called $cf_array

Then find and change the database mapping for these two fields to map to two fields in oscommerce.

End goal is to allow one web app adapter to update oscommerce with some custom data.


We need to edit the [url removed, login to view] file in (/www/weber/[url removed, login to view]) around line 564 and add custom fields.

['c_Listing Number'] - this should map data to OSC products.products_sort_order

['c_Part Number'] - this should map to OSC products.products_model

After creating the custom fields in the php script, we need to find out how to modify the mapping...

per our support staff's note(he's on vacation otherwise we would get him to do this):

"Currently we don't have Mfr Part No available in our Remote Store API for insertion on OSC side. If you put this Part No. in a custom field, we should be able to modify the OSC adapter and map it to the OSC ProductsModel. By default the adapter maps our Ag product code to OSC product model."

I believe this means we need to also disable Agiliron product code from updating OSC product model. This may be as simple as changing ProductCode to ['c_Part Number'] around line 445 where the OSC products_model is mapped. You will need to figure out where to place the mapping for:

['c_Listing Number'] - this should map data to OSC products.products_sort_order.

Afterwards, test with contacts while they import data and see if it maps correctly.

Skills: PHP

See more: php update file, remote staff, mapping api, job mapping, remote php job, remote job php, php modify php file, php file array, php script insertion, php insertion, mysql import remote file, php mysql model, mysql allow remote, mysql api import, import products api, app field mapping, mysql update field, php model mysql, edit note file, products php script, product insertion, modify mapping, php array file, php web app api, data insertion

About the Employer:
( 8 reviews ) Mount Pleasant, United States

Project ID: #4846800

7 freelancers are bidding on average $128 for this job


Hi, We have a dedicated team with 7 years of experience on PHP/MySQL, Ajax, Jquery, HTML, CSS, Javascript, Java/J2EE. Also having much experience on framework and CMS like 1) CakePHP 2) CodeIgniter 3) Zendframew More

$257 USD in 7 days
(28 Reviews)

Hello, we are ready to provide solution to your Osc site php script update. Regards, Evina.

$155 USD in 2 days
(57 Reviews)

I would like to work on the project.

$105 USD in 6 days
(103 Reviews)

I am ready to start. Please check PM for details.

$93 USD in 3 days
(30 Reviews)

Happy help you again!

$88 USD in 2 days
(27 Reviews)

I'd like to do this job, because I used to do maintenance with oscommerce script.

$30 USD in 2 days
(49 Reviews)

hello sir, we have carefully read your project description, and we can complete this task for you. We are a trustworthy company located in greece,europe and we are looking forward to hearing from you the soonest possib More

$105 USD in 4 days
(3 Reviews)

Greeting from BSP( Build Smarter Planet ) Software Services, we have gone though your project and fulfill your vision of getting the result as your expected. We offer long term reliable and valuable solutions to all ou More

$155 USD in 3 days
(1 Review)