Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help! Searching product in admin


Guest

Recommended Posts

Posted

Hi,

 

I desperately need to search for 'quantity' in admin. Any way to do it?

 

Thanks

Posted

Are you asking of there is a way to search by Product Quantity? :?:

 

Please advise.

 

-R

Posted

Wouldn't that give you a very general search with a large number of responses?

 

Basically, you would have to modify the search function so it could search the Product Quantity field in the MySql DB.

 

If you don't mind my asking, why would you want something like this?

 

-R

Posted

I am using the quantity field as an 'item code' field. When I want to update a price, I enter the code for the item and then edit it. It's easier than searching by product name, as I have 800+ products, many with similar if not identical names (e.g. mineral water 1/2 litre, mineral water 1.5 litres). I set the quantity field not to change when an order is received.

 

Of course I should instead add a new field to product_description table, but before I do that (I'm scared!! :oops: ) I wanted to see if it would have been easier this way.

 

I guess what you're saying is that it's less work to add a field to the db than to modify the search function, correct?

Posted

Something like that.

 

Why not just use the Model Number field that is already provided? You would have an easier time getting it to search the Model field than the quantity field.

 

-R

Posted

you mean Products Model that appears near the bottom of the 'add new product' form in admin (between 'quantity' and 'image')?

 

I just tried that and it doesn't search that field either.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...