In Progress

oscommerce inventory pages

We (an independent retail store with a functioning OsCommerce store) have an urgent need for the following coding. The database we’re dealing with is rather large, just under 70,000 products.

A new php inventory page.

Similar to or an exact copy of the standard OsCommerce “Quick Find” entry box. The user would scan the UPC code into this box and one of two things would happen.

1. Item Found. Cursor skips to a text entry box on the same page to enter a quantity. User then hits “enter”, products_quantity field is updated in the database, and page resets to “next scan”.

2. Item Not Found. Go to new page; “Detailed Search Page”. This page would have text entry boxes for each of the following fields in the “products” table.

a. Products_upc

b. Products_model

c. Products_sku

d. Products_description keywords

If entry of some or any of these additional details finds the product, return to the first page and prompt user to update the quantity. If entry & search results in multiple products that might be the one in question, display a list of those possible hits with these details filled in the text boxes. If this search still fails to find the item in the database, prompt user to go to next page.

3. New Product Page. The text box fields will be as follows:

a. Products_upc

b. Products_model

c. Products_sku

d. Products_quantity

e. Products_price

f. Manufacturer

g. Product_description

This page would need a submit button, and upon completing would be written to a text file instead of writing to the database. Hopefully the text file could be in csv or convertible to such, and in batch form named by the date of entry.

This project wil involve some modifications to standard osc files along with additional files. It will involve both standard osc mysql tables & some new ones that are already loaded but not yet written into the php.

These new pages are part of our effort to go live with our oscommerce store & a POS system in the real store sharing the same database. We'll release additional related projects in the near future.

Skills: Shopping Carts

See more: osc inventory, writing standard form, writing batch files, writing batch file, manufacturer search, copy mysql oscommerce, oscommerce product upc, oscommerce extra pages getafreelancer, inventory page oscommerce, scan copy, product inventory, pages, netsolve, inventory database, cursor, pos system php table, update mysql csv php, pos system database, inventory files, upc php, display related products, inventory standard, scan text, database pages, update csv file products

About the Employer:
( 5 reviews ) Detroit, United States

Project ID: #212614

Awarded to:

netsolve

See private message. Regards

$200 USD in 2 days
(75 Reviews)
6.2

6 freelancers are bidding on average $245 for this job

hejian

I am the expert in such things. Let me complete your project quickly with a top quantity. Regards.

$190 USD in 1 day
(17 Reviews)
4.8
leopro

Pls check Pm

$250 USD in 15 days
(9 Reviews)
4.5
gedelstein

Hi! Please check your PM for questions, thanks.

$300 USD in 10 days
(2 Reviews)
3.7
amppost

Hi there, I have intensive knowledge of osCommerce script and will be happy to build the custom inventory updation tool in the admin. Thanks!

$300 USD in 3 days
(1 Review)
1.5
emi87

Please see PM. Thanks!

$230 USD in 3 days
(0 Reviews)
0.0