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.