Stocks by attributes

Printable View

Show 100 post(s) from this thread on one page

11 Oct 2006, 09:32 AM
royalgemsnz

Re: Stocks by attributes

In answer to my previous question, here the remedy. Many thanks to my flatmate is is somewhate more php literate than I am.

Instead of changing

PHP Code:

$products_options_array[] = array('id' => $products_options->fields['products_options_values_id'],                       'text' => $products_options->fields['products_options_values_name']);

with

PHP Code:

$products_options_array[] = array('id' => $products_options->fields['products_options_values_id'],                       'text' => $products_options->fields['products_options_values_name'] .' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . ']');

as per http://www.zen-cart.com/forum/showth...=25987&page=19 post 188, change it to this instead.

PHP Code:

                  if ($products_options->fields['quantity'] >0){                     $dropdown_instock = TEXT_ATTRIBUTES_IN_STOCK;                   } else {                     $dropdown_instock = TEXT_ATTRIBUTES_NOT_IN_STOCK;                   }                                      $products_options_array[] = array('id' => $products_options->fields['products_options_values_id'],                                         'text' => $products_options->fields['products_options_values_name'] .' [' . $dropdown_instock . ' '. TEXT_ATTRIBUTES_PIECES . ']');
13 Oct 2006, 09:28 AM
tajul_ashyqin

2 Attachment(s)

Stocks by attributes

hi,

i am having a major problem for these mod. i just do the admin activity reseting this morning and now i cannot set my stocks attributes like before!:cry: see my admin_attributes attachments! this is how it looks from the admin after i try to define the stocks for respective attributes! :cry: when i go to my cpanel to check the entries for the attributes, i am surprised as the entries for the just-new-added attributes (after the reseting session) in stock_attributes fields, only 'A' appears!!! :cry: see the second attachment!

i hope somebody have a fix to it...

4u info, i am using danielcor stocks by attributes mod!
13 Oct 2006, 09:57 AM
kuroi

Re: Stocks by attributes

Quote:

Originally Posted by tajul_ashyqin

i am having a major problem for these mod. i just do the admin activity reseting this morning and now i cannot set my stocks attributes like before!:cry: see my admin_attributes attachments! this is how it looks from the admin after i try to define the stocks for respective attributes! :cry: when i go to my cpanel to check the entries for the attributes, i am surprised as the entries for the just-new-added attributes (after the reseting session) in stock_attributes fields, only 'A' appears!!! :cry: see the second attachment!

Well that's not the way it's supposed to work :no: Firstly to make sure I have understood correctly ... you reset the admin activity log and then entered new attribute stock values? The values entered before the reset are OK, those entered after have this stock_attribute value of "A"? Is this the first time that you have done an activity log reset with stock by attribute installed and in use?

The blank value on your screen is no surprise as the data that would normally be in the field where the As are appearing is obtained via an integer index into another table - obviously As can't do that. So the real issue is how did the As get there.

As an aside this is a direct result of the $*#~@! database structure that this mod has. If integer indexes weren't held as strings in the first place, this simply couldn't happen. Not Danielcor's fault either - like me, he has inherited a structure that goes right back (I suspect) to the original osCommerce mod which spawned this one. Happily Zen Cart does it better and this will be fixed in 1.4.

Hopefully somebody will come up with a solution to this today. But if not, I have time set aside tomorrow to investigate the problem in my later version of this mod reported by SupuS above and mikajlo on another thread, and I will also look at your problem to see if I might have carried it into my version or if it is already dealt with by one of my fixes and can be retrofitted.
13 Oct 2006, 11:41 PM
kuroi

Re: Found a bug?

Quote:

Originally Posted by SupuS

I found a bug I think ..

Supus, I have tried twice (several days apart) but not succeeded in replicating the bug that you describe in the way that you describe it. However, I can replicate it in a different way for which the fix is ...

In includes/classes/order.php find line 696

Quote:

$attribute_search array();

and immediately afterwards insert

Quote:

$attribute_stock_left = STOCK_REORDER_LEVEL + 1; // kuroi: prevent false low stock triggers

I believe that there is a high chance that this will fix your problem also. Please try it and let me know.

If it doesn't work for you, please provide more specific information about the products that you are buting, the attributes that they have (if any) and their attribute stock level. Thanks.
14 Oct 2006, 12:23 AM
kuroi

Re: Stocks by attributes

Quote:

Originally Posted by tajul_ashyqin

hi,

i am having a major problem for these mod. i just do the admin activity reseting this morning and now i cannot set my stocks attributes like before!:cry: see my admin_attributes attachments! this is how it looks from the admin after i try to define the stocks for respective attributes! :cry: when i go to my cpanel to check the entries for the attributes, i am surprised as the entries for the just-new-added attributes (after the reseting session) in stock_attributes fields, only 'A' appears!!! :cry: see the second attachment!

i hope somebody have a fix to it...

4u info, i am using danielcor stocks by attributes mod!

Tajul, Could you backup the following tables (ideally with phpMyAdmin) and email a copy to me at the email address using for Stocky by Attributes 1.3.5 beta testing?

Quote:

products,
product attributes,
products_options,
products_options_types,
products_options_values,
product_options_values_to_products_options,
products_with_stock_attributes

Thanks
14 Oct 2006, 01:04 AM
tajul_ashyqin

Re: Stocks by attributes

yup, that was had happened! it just happened after I reset the admin activity log and entered a new values! before this, I did reset the log but without stock by attributes installed and this was my first time having it after few months of my live site... thanx kuroi for helping me out! I;ll email what ever you need...
15 Oct 2006, 08:47 PM
kuroi

Re: Stocks by attributes

Quote:

Originally Posted by tajul_ashyqin

yup, that was had happened! it just happened after I reset the admin activity log and entered a new values! before this, I did reset the log but without stock by attributes installed and this was my first time having it after few months of my live site... thanx kuroi for helping me out! I;ll email what ever you need...

OK. I've tracked down the bug and have a fix. It applies to both Danielcor's 3.0.1 version and my 4.1 version. A 4.2 version for Zen Cart 1.3.5 users has been submitted to the downloads area containing this, the resolution of Supus's issue a few posts back and some improvements to the alignment of data on the stock page.

If you're running an older version of Zen Cart and are therefore still using Danielcor's version, you will need to apply the first change by hand, but it's fairly straightforward.

All the changes take place in admin/products_with_attributes_stock.php. Make sure you have the right file (there are several with this name).

Find the following line (probably 149) and delete it

Quote:

$s_mack_noconfirm .="attributes[]=" . $attribute_id . "&"; //s_mack:noconfirm

Find the following block (probably 155-163)

Quote:

if(sizeof($attributes) > 1)
{
sort($attributes);
$stock_attributes = implode(',',$attributes);
}
else
{
$stock_attributes = $attributes[0];
}

and immediately afterwards add

Quote:

$s_mack_noconfirm .='attributes=' . $stock_attributes . '&'; //kuroi: to pass string not array

Find the second instance of the block above (around about 202-210) and delete it.

Find the following line (now about 205) and delete the bit marked in red

Quote:

$query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`) values ('.$products_id.',"'.$stock_attributes.'",'.$quantity.')';
15 Oct 2006, 10:17 PM
rkharris

Re: Stocks by attributes - Help on stock levels

Help:::

I have installed the contribution on a 1.3.5. version and it works really good EXCEPT that the variant stock levels are not updated after an order i.e. remain the same when I purchase stock, the main product "Quantity" reduces correctly, and sync brings it back to the original level, Anyone know how to fix this or can anyone point me to the code that should do this so I can try. Thanks for any help.
15 Oct 2006, 10:31 PM
kuroi

Re: Stocks by attributes - Help on stock levels

Quote:

Originally Posted by rkharris

Help:::

I have installed the contribution on a 1.3.5. version and it works really good EXCEPT that the variant stock levels are not updated after an order i.e. remain the same when I purchase stock, the main product "Quantity" reduces correctly, and sync brings it back to the original level, Anyone know how to fix this or can anyone point me to the code that should do this so I can try. Thanks for any help.

Which version of the mod are you running?
16 Oct 2006, 05:19 AM
tajul_ashyqin

Re: Stocks by attributes

Quote:

Originally Posted by kuroi

OK. I've tracked down the bug and have a fix. It applies to both Danielcor's 3.0.1 version and my 4.1 version. A 4.2 version for Zen Cart 1.3.5 users has been submitted to the downloads area containing this, the resolution of Supus's issue a few posts back and some improvements to the alignment of data on the stock page.

If you're running an older version of Zen Cart and are therefore still using Danielcor's version, you will need to apply the first change by hand, but it's fairly straightforward.

All the changes take place in admin/products_with_attributes_stock.php. Make sure you have the right file (there are several with this name).

Find the following line (probably 149) and delete it
Find the following block (probably 155-163)and immediately afterwards addFind the second instance of the block above (around about 202-210) and delete it.

Find the following line (now about 205) and delete the bit marked in red

wow, who are you anyway?! :D superb, Peter! you are really very helpful person... the fixes solved the problems! million thanx to you... :yes: and thank you also for maintaining these mod! :smile:

Show 100 post(s) from this thread on one page