Stocks by attributes

[janellez]

Once again, here I am, asking for help !

I keep searching the forums but can't seem to find the answer with your mod, kuroi. I would like to put stock numbers next to my attributes in drop down menus. If I have to use radio buttons, that's fine too.

The code I'm finding through searching seems to be referring to other or older mods.

Thanks in advance!

Janelle

[high2K]

The most common cause of this problem is leaving a backup files littered across the site resulting in the wrong getting executed in some places, and errors about trying to do the same thing twice where that's not allowed.

If this is the case, how do I sort it? I'm not sure what you mean about having backup files littered across the site. I have several backups sitting within the relevant folder - do mean that I should empty this before installing the contribution?

[jcgkiwi]

I have tried searching, but not sure how to word search to get relevant answer... if it's there!

I have recently had a clean install of 1.3.7.1, then upgraded to 1.3.8a.
Then installed SBA 4.7

I'm still getting used to it, but one thing I have noted is that if an item has a total of 10, but a particular attribute is out of stock, it still reduces the total when the out of stock attribute is checked out... even going so far as to make it a minus value.

Is this normal? I would have thought that it wouldn't reduce the quantity, when an out of stock item is checked out...?

I am currently downloading the site to do a file compare and see if I missed something, but I was fairly thorough... I think.

[philip24]

Hi.

I have just tried installing the SOL patch and received the following error.

1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false')," );]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields

The original SQL patch as I have entered it is as follows:-

CREATE TABLE products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity FLOAT NOT NULL ,
PRIMARY KEY ( `stock_id` )
);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false',
'When customer places more items in cart than are available, show the available amount on the shopping cart page:',
'9',
'6',
NULL,
now(),
NULL,
"zen_cfg_select_option(array('true', 'false'),"
);

Can any spot where I am going wrong please? Having stock attributes is critical to my site - if I can't get this to work I shall have to look for another package.

Philip

[MB1]

i added about 15 new products the other day and because the way SBA organizes everything alphabetically it was a pain in the but to work with is zencart 1.4 is it going to be easier to work on the attribute inventory numbers, or is it going to be the same, at least separating the stock by categories would make a huge difference i couldn't imagine having a large store with 100s of items

[marcelo63]

Hello
My info
www.ysandals.com
PHP 5.1
MySWL 5.0
Zen 1.3.8
Modified template Cherry-Zen
Linux Apache godaddy servers
Stocks by Attributes by Kurai Ver. 4.7

installed without any inconvenience and works perfect until I reached Item Number 50 (currently 476 and need to get over a 1,000).
which makes a pain in the the data entry, JUST the data entry is the inconvenience for me/us, so here I go:

Questions:
Is is possible to do the following
remember we sell mostly shoes (later we will add clothing but no so many variants)
Shoes comes average 8 different sizes and 3 different colors, so:

1) Is it another way to complete/fill stocks once the variants/atrributes are created like a matrix or table, where in one page for such item you can fill all stock in one page and NOT one by one.
2) Have a page break, currently all items are displayed with all atrributes and stock and variants in only one. Say cut off page 10, 15, 20 or 50 items
3)A search button to find items. currently CRTL F is the only way.

Other than That Thanks Kurai!

Marcelo
www.ysandals.com

[kuroi]

one thing I have noted is that if an item has a total of 10, but a particular attribute is out of stock, it still reduces the total when the out of stock attribute is checked out... even going so far as to make it a minus value.

This is Zen Cart's back ordering feature. If you look under Admin > Configuration > Stock there are switches for controlling whether or not Zen Cart allows this.

[kuroi]

I have just tried installing the SOL patch and received the following error.

You already have the patch installed. The error message is simply telling you that it can't add the same switch a second time.

[kuroi]

i added about 15 new products the other day and because the way SBA organizes everything alphabetically it was a pain in the but to work with is zencart 1.4 is it going to be easier to work on the attribute inventory numbers, or is it going to be the same, at least separating the stock by categories would make a huge difference i couldn't imagine having a large store with 100s of items

I agree.

Stock by Attributes has its origins not in Zen Cart, but another package. It's even possible that it's older than Zen Cart itself. It is well past the natural end of its life and I have been doing no more than keep it on the life support machine until Zen Cart 1.4 is born.

I can't comment specifically on how this will work in Zen Cart 1.4, but the Zen Cart team have had the advantage of seeing how the existing mod works (and where it doesn't) and I'm confident that they will produce a more usable attribute stock facility, and provide an enhanced foundation for future mods in the this area.

[kuroi]

Stocks by Attributes by Kurai Ver. 4.7

1) Is it another way to complete/fill stocks once the variants/atrributes are created like a matrix or table, where in one page for such item you can fill all stock in one page and NOT one by one.
2) Have a page break, currently all items are displayed with all atrributes and stock and variants in only one. Say cut off page 10, 15, 20 or 50 items
3)A search button to find items. currently CRTL F is the only way.

Other than That Thanks Kurai!

Hmmm. Who's this Kurai dude? Somebody been taking credit for my work?

The answer to your questions are: yes, yes and yes, or no, no and no depending upon how one looks at it.

This is open source software and none of the things that you have asked would be difficult to do for somebody with say intermediate PHP and MySQL skills and a good knowledge of this area of Zen Cart.

However, you can't do them in the current version, and because this mod is at the end of its life, it's unlikely that anybody will be making them available unless they disparately need the changes themselves.

Hint: If I were in your position, I would look instead at how you might be able to use MySQL to do a bulk upload of data from a CSV file exported from Excel.