Closed

OsCommerce 2.3.1 - inventory update

From OsCommerce version 2.2, we are now testing version OsCommerce 2.3.1 (in a test sub-folder) with a few products. We can migrate all of our current products from 2.2 to version 2.3.1.

"ONLINE INVENTORY UPDATE" - How do we presently do it?

1. Currently on version 2.2, we upload a text file ([url removed, login to view]) that contains the product and product attributes available from our warehouse. This is an exported file FROM another inventory system.

2. We have a file on the same folder where we upload the exported "[url removed, login to view]) - it is called "[url removed, login to view]". We run this file by visiting the url [url removed, login to view]

3. [url removed, login to view] prepares the [url removed, login to view] records to match with the OsCommerce database product ids and updates the available attribute. For example:

[url removed, login to view] has brand as ADIDAS, product style as RUNNERX, and category number as 200

[url removed, login to view] will convert this record into ADID-RUNNERX-200 to match the OsCommerce product model setup as ADID-RUNNERX-200

Once the product model is converted and matched, [url removed, login to view] will update the online product attributes from the inventory.txt.

4. In the [url removed, login to view], the codes to convert should still work with the 2.3.1 because the product models in both version 2.2 and 2.3.1 are the same (ADID-RUNNERX-200).

WHAT WE NEED - to update the attributes

What we basically need is for this [url removed, login to view] to update the products attributes as well so that if it converts a product to ADID-RUNNERX-200, it will update the corresponding online attributes.

Somehow in our test, the attributes are not changing or updating.

Skills: MySQL, PHP

See more: update inventory php, oscommerce convert database, mysql database models, example inventory database, update inventory codes php, warehouse system, warehouse inventory, update products, update mysql, product inventory, migrate mysql, inventory database, update, update url, mysql convert text, converted mysql, mysql attributes, update database mysql, update version, mysql update database, inventory update, database warehouse, migrate products, match records, version update

About the Employer:
( 0 reviews ) Westmount, Canada

Project ID: #1143872

5 freelancers are bidding on average $104 for this job

sscreations

Hello Sir ##############Please Check PMB ################## Thanks

$100 USD in 3 days
(32 Reviews)
6.0
priyaleo

Please check my PM.

$150 USD in 2 days
(0 Reviews)
0.0
firstdevelop

Please see Private Message

$50 USD in 1 day
(0 Reviews)
0.0
arnab4icoe

I have 8+ years of experienced. presently we start a project on like ebay, which is under construction. kindly see www.newegg.com & www.scan.co.uk these two websites full feature are there. I design & developed the who More

$70 USD in 2 days
(1 Review)
0.0
variyasoft

Hello Sir, Hope you are doing fine. We are professional web development and web designing company; operating since 2002. Our innovative and creative ideas with sound practical knowledge of latest design softw More

$150 USD in 3 days
(0 Reviews)
0.0