easy way to add/change the quantity/product sold?

[99darkgreenGT]

is there an easy way to modify the number of certain items sold? i mean, you know how oscommerce keeps track of the number of times a product has been sold (as seen in the bestsellers menu). is there a way to add or modify the number of products sold manually? we do some sales over the phone and would like for some of these items to reflect in our bestsellers column, i have tried going into the actual item editing are and changing the product quantity number, but that didn't work. is that the way you are suppose to do it, or is there a different way?

 

thanks and hopefully that makes sense :lol:

[Guest]

Look in the products table in the database. For each product it says something like, product ordered and a number. Just change that number to reflect how many times the item has actually been sold.

[99darkgreenGT]

is this somewhere in the admin panel (if so where)? or is it in the file manager area (if so, do you know the file name)? thanks in advance B)

[241]

You could set up an admin controlled customer, whereby if a customer phones in an order, you login as the admin customer and select the product and process it, this would reflect as a sale in your best seller, but, I presume that what you really want is to have an option in the admin panel that allows you to enter a product detail or code and quantity so that this is then reflected as a purchase logged in the database and related back to the store front.

[Guest]

is this somewhere in the admin panel (if so where)? or is it in the file manager area (if so, do you know the file name)? thanks in advance B)

Neither, it's in the actual database itself.

 

You will need to be able to access your database directly if you want to do any substantial modification of the site, or it's just an easier way to alter details than going throgh admin.

 

You need something like php myadmin to access your database directly. Don't ask me how to get it as my host uses cPanel which includes php myadmin as standard.

 

But there will be someone round here who knows.

[Guest]

I had a similar problem. When we take phone orders or orders in store, I needed to deduct the amount of product stock we had.

 

I ended up writing a admin script that allows us to go in and automatically deduct stock from our product quantity. It also lists how many we have in stock and the cart automatically deducts quantity itself.

 

Anyways back to the point:

Your best best would be to write your own admin script that you can use to easily change the number in the database. It'll save you so much time it's rediculous.

 

If you'd like, you can email me and we can maybe work out a deal for a custom script.

B)