Jump to content



Latest News: (loading..)

- - - - -

Quickly Update Product Stock


  • Please log in to reply
176 replies to this topic

#101   girolimoni

girolimoni
  • Members
  • 72 posts
  • Real Name:puffi

Posted 25 January 2009 - 10:43 AM

View Postazrin_aris, on Jan 24 2009, 08:02 PM, said:

Hi,

Please try the V3.7 Beta and let me know if it works.

Hi, updated and its working :)

Thanks a lot!!

greetings

p.S we have lots of products per category. it would be nice to have the possibility to enter a keyword and the results would be listed. :)

#102   girolimoni

girolimoni
  • Members
  • 72 posts
  • Real Name:puffi

Posted 25 January 2009 - 10:53 AM

Little Update: Found a bug.

When Add new stok to current stock? is set to false it will update the the stock to 0 for all items where you don't change anything: by default the stock amount field is filled with 0. Should be better if the field has the same number as the field right of it.

:)

#103   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 25 January 2009 - 05:57 PM

View Postazrin_aris, on Jan 23 2009, 05:01 AM, said:

Hey Jim,

Check out the new version (beta). It has what I think you need. Let me know if it works (and if it doesn't too ;) )

Once it is ok, I will make it into a release.

Hey Azrin,

Absolutely AMAZING!!!

Thank you so much... ;)  :D  :wub:
It is exactly what I was looking for and need.

So far with my testing all is working great.
I can sort by Manufacturers or Categories, change the weight, price, qty and status of products quickly.
I can change the status of my products to show "On Backorder" simply by subtracting the QTY (In Stock = 3 / New Stock = -3). I have the function of the show sold out contribution setup so when stock qty reaches zero it shows On Backorder, when I change the status to not-active it removes the product from the catalog view.

The only thing I changed was the sort order from product name to product model.
I don't really have a need for the feature of being able to change the model number or category from the page. But it might come in handy in the future if I need to re-organize my site.

I like how it displays the product ID. Would it be difficult to add the category ID next to it?
I have a PHP file that I could use to make a quick one-shot price change per category. Type in the old price and the category ID, then type in the new price. Call the file in my browser and ta-da, new prices. Right now I have to keep checking through phpmyAdmin for the category ID's. No biggy though. ;)

Thanks again!
This is GREAT
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#104   azrin_aris

azrin_aris
  • Members
  • 34 posts
  • Real Name:Azrin Aris

Posted 26 January 2009 - 01:31 AM

View Postgirolimoni, on Jan 25 2009, 06:53 PM, said:

Little Update: Found a bug.

When Add new stok to current stock? is set to false it will update the the stock to 0 for all items where you don't change anything: by default the stock amount field is filled with 0. Should be better if the field has the same number as the field right of it.

:)


Thanks, I will look in to it

#105   azrin_aris

azrin_aris
  • Members
  • 34 posts
  • Real Name:Azrin Aris

Posted 26 January 2009 - 01:41 AM

View Postjhande, on Jan 26 2009, 01:57 AM, said:

Hey Azrin,

Absolutely AMAZING!!!

Thank you so much... ;)  :D  :wub:
It is exactly what I was looking for and need.

So far with my testing all is working great.
I can sort by Manufacturers or Categories, change the weight, price, qty and status of products quickly.
I can change the status of my products to show "On Backorder" simply by subtracting the QTY (In Stock = 3 / New Stock = -3). I have the function of the show sold out contribution setup so when stock qty reaches zero it shows On Backorder, when I change the status to not-active it removes the product from the catalog view.

The only thing I changed was the sort order from product name to product model.
I don't really have a need for the feature of being able to change the model number or category from the page. But it might come in handy in the future if I need to re-organize my site.

I like how it displays the product ID. Would it be difficult to add the category ID next to it?
I have a PHP file that I could use to make a quick one-shot price change per category. Type in the old price and the category ID, then type in the new price. Call the file in my browser and ta-da, new prices. Right now I have to keep checking through phpmyAdmin for the category ID's. No biggy though. ;)

Thanks again!
This is GREAT

I'll study this new feature... It might be good for me too..... BTW, glad to hear it works

#106   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 06 February 2009 - 05:49 AM

Hi Azrin,

I've been having fun with your contribution. :D

I seem to have a slight glitch and I'm not sure if it was my doing or the way the code is setup.

When the quick_stockupdate.php loads in my browser, the Search by: drop down menu is already preset to - Category with an empty listing of course. In order to actually search by a Category I first have to switch it to Manufacturer, let the page reload, and then back to Category.

What I did to fix it was to add <option>Select 1st</option> as seen below.
<td class="main" align="left" width="50px">
		   <select name="filter_type" id="select" onchange="this.form.submit();">
			   <option>Select 1st</option>
			   <option value="1"<?php if($filter_type==1){echo ' selected="selected"';}?>><?php echo QUICK_CATEGORY  ?></option>
		<option value="2"<?php if($filter_type==2){echo ' selected="selected"';}?>><?php echo QUICK_MANUFACTURER?></option>
	  </select>
		  </td>

If somehow I messed up the original file ignore this. :blush:
If in fact there was a glitch you might want to add that snipet of code in the file. ;)

Thanks again for a very useful contribution!
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#107   supplementler

supplementler
  • Members
  • 19 posts
  • Real Name:sup
  • Gender:Male

Posted 09 February 2009 - 11:35 AM

Is it possible to add the specials price in this contribution also?

#108   azrin_aris

azrin_aris
  • Members
  • 34 posts
  • Real Name:Azrin Aris

Posted 10 February 2009 - 01:04 AM

View Postjhande, on Feb 6 2009, 01:49 PM, said:

Hi Azrin,

I've been having fun with your contribution. :D

I seem to have a slight glitch and I'm not sure if it was my doing or the way the code is setup.

When the quick_stockupdate.php loads in my browser, the Search by: drop down menu is already preset to - Category with an empty listing of course. In order to actually search by a Category I first have to switch it to Manufacturer, let the page reload, and then back to Category.

What I did to fix it was to add <option>Select 1st</option> as seen below.
<td class="main" align="left" width="50px">
		   <select name="filter_type" id="select" onchange="this.form.submit();">
			   <option>Select 1st</option>
			   <option value="1"<?php if($filter_type==1){echo ' selected="selected"';}?>><?php echo QUICK_CATEGORY  ?></option>
		<option value="2"<?php if($filter_type==2){echo ' selected="selected"';}?>><?php echo QUICK_MANUFACTURER?></option>
	  </select>
		  </td>

If somehow I messed up the original file ignore this. :blush:
If in fact there was a glitch you might want to add that snipet of code in the file. ;)

Thanks again for a very useful contribution!

Hey Jim,

Thanks for the update. If it works ok with you, I think it should be fine. As I've mentioned earlier, this is a beta version. I have not gone through the issues thoroughly (yet). Thank you for helping me to test the add-on. I'll add the new code to the release version -  but not so soon :( (Q1 Chaos ;))

Cheers

#109   azrin_aris

azrin_aris
  • Members
  • 34 posts
  • Real Name:Azrin Aris

Posted 10 February 2009 - 01:08 AM

View Postsupplementler, on Feb 9 2009, 07:35 PM, said:

Is it possible to add the specials price in this contribution also?


I'm thinking of doing the same too. But it would take a lot of changing to the original code (it has been rewritten twice ;)) I'm thinking of making it as an additional tag so that the code for the special pricing will be entirely different. But please do not expect this to be added in the next release. It might take some time for me to write the new code.

#110   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 10 February 2009 - 04:58 AM

View Postazrin_aris, on Feb 9 2009, 08:04 PM, said:

Hey Jim,

Thanks for the update. If it works ok with you, I think it should be fine. As I've mentioned earlier, this is a beta version. I have not gone through the issues thoroughly (yet). Thank you for helping me to test the add-on. I'll add the new code to the release version - but not so soon :( (Q1 Chaos ;) )

Cheers

Glad to help test Azrin ;)

Pretty darn good beta release! :D
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#111   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 10 February 2009 - 05:23 AM

View Postazrin_aris, on Feb 9 2009, 08:08 PM, said:

I'm thinking of doing the same too. But it would take a lot of changing to the original code (it has been rewritten twice ;) ) I'm thinking of making it as an additional tag so that the code for the special pricing will be entirely different. But please do not expect this to be added in the next release. It might take some time for me to write the new code.


I was also wondering about - "What if I decide to put items on sale? Wouldn't it be neat having the ability to show or change those prices also in this contrib!" Just the other day I was contemplating adding the "Display MSRP & Savings" contrib, and again thought that would be neat to add in also.

But I also realize it's not nice to keep asking and adding a wish list to someones great contribution. Although I don't know PHP I might play with the code to see if I can add any of my wish list items to it. If not, it's already a great useful feature to have and who knows, Azrin might someday expand it's capabilities. :rolleyes:
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#112   azrin_aris

azrin_aris
  • Members
  • 34 posts
  • Real Name:Azrin Aris

Posted 11 February 2009 - 01:56 AM

View Postjhande, on Feb 10 2009, 01:23 PM, said:

I was also wondering about - "What if I decide to put items on sale? Wouldn't it be neat having the ability to show or change those prices also in this contrib!" Just the other day I was contemplating adding the "Display MSRP & Savings" contrib, and again thought that would be neat to add in also.

But I also realize it's not nice to keep asking and adding a wish list to someones great contribution. Although I don't know PHP I might play with the code to see if I can add any of my wish list items to it. If not, it's already a great useful feature to have and who knows, Azrin might someday expand it's capabilities. :rolleyes:

I've been doing some thinking too to all these new features. I think this is a great opportunity to create a new all-in-one add-on (almost all)- Quick Store Manager or something.... where in it we will have the original QuickStock Update, then we will introduce QuickPrice Update, QuickSale Update etc. This is an ambitious project :) - I hope I have time to do it. But I will try my best.

#113   hanoman77

hanoman77
  • Members
  • 1 posts
  • Real Name:ferdi

Posted 22 February 2009 - 10:03 PM

Found a bug
I'm using this configuration for Currency Localization :
Decimal point : ,
Thousand point : .

When I update the price, the price went wrong. for example original price was 10000 it shows 10,000 in quick updater.
I update the stock, leave the price as it is. when i check the store, the price is 10, back to the updater, yup it's a 10.
I dont know a thing about php. To work this out i set the decimal and thousand point back to default.

Thx for this Azrin, its great.

Edited by hanoman77, 22 February 2009 - 10:04 PM.


#114   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 23 February 2009 - 08:58 AM

View Postazrin_aris, on Feb 10 2009, 08:56 PM, said:

I've been doing some thinking too to all these new features. I think this is a great opportunity to create a new all-in-one add-on (almost all)- Quick Store Manager or something.... where in it we will have the original QuickStock Update, then we will introduce QuickPrice Update, QuickSale Update etc. This is an ambitious project :) - I hope I have time to do it. But I will try my best.

Hey Azrin,

Sounds like an ambitious plan alright.

I will be keeping my eye's open to any updates you might make.
I think this is one of my most favorite and certainly most useful contributions that I have added.

Let me know if you need any more beta testing, I'm game. ;)
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#115   tehsphinx

tehsphinx
  • Members
  • 10 posts
  • Real Name:Michael Duke

Posted 23 February 2009 - 11:56 PM

Hi,

Great Mod firstly :D

Is there any chance of getting a column which has the prices including taxes? or just have a toggle option so we can select which prices we want to see.

Cheers,
Mike

#116   tehsphinx

tehsphinx
  • Members
  • 10 posts
  • Real Name:Michael Duke

Posted 24 February 2009 - 01:28 PM

Hi (agian),

Just been testing it out. It seems to only want to update selective products, some items it refuses to change, but with others. no problems at all.

No clue why.

#117   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 24 February 2009 - 10:10 PM

Hey Mike,

Can you investigate and explain a little about what products refuse to update? That might help Azrin pin-point the problem.

  • What version are you using?
  • Are the problem products in a sub-category? In a sub-sub-category?
  • Does it make a difference if you sort by Manufacturer or Category?
  • What part of the product update doesn't work? Name, Category, Weight, Price, Stock, Status?
  • Is the box on the bottom ticked or not? "Check to set status on each individual product based on items in stock"
I haven't run into any such problems myself, but I have only updated weight, prices and status on a hundred or so products.
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#118   tehsphinx

tehsphinx
  • Members
  • 10 posts
  • Real Name:Michael Duke

Posted 24 February 2009 - 11:29 PM

View Postjhande, on Feb 24 2009, 11:10 PM, said:

Hey Mike,

Can you investigate and explain a little about what products refuse to update? That might help Azrin pin-point the problem.

  • What version are you using?
  • Are the problem products in a sub-category? In a sub-sub-category?
  • Does it make a difference if you sort by Manufacturer or Category?
  • What part of the product update doesn't work? Name, Category, Weight, Price, Stock, Status?
  • Is the box on the bottom ticked or not? "Check to set status on each individual product based on items in stock"
I haven't run into any such problems myself, but I have only updated weight, prices and status on a hundred or so products.

Hi jhande,

1. I put V3.5 on both an 2.2rc2a and 2.2ms2
2.2rc2a just logs me out everytime i try to update
2.2ms2 either tells me that no products have been updated or updates like a minimal amount of them

2. My products are in the 3rd category down so cat-subcat-subsubcat-products
3. I rolled back from 3.7 to 3.5 hoping that might make a difference (apperently not)
4. I've tried updating price, stock & status
5. I've ticked the box at times, the times i've ticked it, it does onthing

So i did some experimenting on my 2.2rc2a install and found that (with v3.7) if a category contained upto 24 products, everything would be fine, if there were 25 or more, then it would log me out everytime i hit the update button.

Hope that helps.

Mike

#119   jhande

jhande
  • Members
  • 2,112 posts
  • Real Name:Jim Hande
  • Gender:Male
  • Location:White Mountains, NH USA

Posted 25 February 2009 - 03:12 AM

Hey Mike,

I'm running 2.2MS2 and v3.5 w/3.7 update works flawlessly with a similar category structure.
Unfortunately I am not proficient in PHP and wouldn't have a clue where to begin.

Hopefully Azrin can figure something out with what you mentioned.

Stay tuned...
- :: Jim :: -
- My Toolbox ~ Adobe Web Bundle & WinMerge | Install ~ osCommerce v2.2 MS2 060817 -
- Not 4 Hire ~ Please DO NOT PM me for help. I really do not have a clue what I am doing! -
- Working on a new 2.3.3 install -

#120   azrin_aris

azrin_aris
  • Members
  • 34 posts
  • Real Name:Azrin Aris

Posted 01 April 2009 - 03:40 AM

View Posthanoman77, on Feb 23 2009, 06:03 AM, said:

Found a bug
I'm using this configuration for Currency Localization :
Decimal point : ,
Thousand point : .

When I update the price, the price went wrong. for example original price was 10000 it shows 10,000 in quick updater.
I update the stock, leave the price as it is. when i check the store, the price is 10, back to the updater, yup it's a 10.
I dont know a thing about php. To work this out i set the decimal and thousand point back to default.

Thx for this Azrin, its great.


Ok I will look into it... but it will not be so soon.... :rolleyes: