Stocks by attributes

@creinold Just found a minor text display glitch. One of my products does not have an image. When displaying the product list the image field displayed TEXT_IMAGE_NONEXISTENT instead of an image.
A search using the developers tool kit shows this term appearing in multiple define files.
I figured this means with no common use defined I had to add it specifically to SBA (?)
It worked :)

In file:

admin/includes/languages/english/extra_definitions/products_with_attributes.php

add

define('TEXT_IMAGE_NONEXISTENT', 'No Image Exists');

before php close tag.

Also for consideration for improvement in the how to file:
In the installation section it should read
'There are five core Zen Cart files modified'
because
•admin/includes/stylesheet.css is no longer affected.

hth

Kevin

profitshock:

@creinold Just found a minor text display glitch. One of my products does not have an image. When displaying the product list the image field displayed TEXT_IMAGE_NONEXISTENT instead of an image.
A search using the developers tool kit shows this term appearing in multiple define files.
I figured this means with no common use defined I had to add it specifically to SBA (?)
It worked :)

In file:

admin/includes/languages/english/extra_definitions/products_with_attributes.php

add

define('TEXT_IMAGE_NONEXISTENT', 'No Image Exists');

> before php close tag.
> 
> Also for consideration for improvement in the how to file:
> In the installation section it should read
> 'There are **five** core Zen Cart files modified' 
> because
> •admin/includes/stylesheet.css is no longer affected.
> 
> hth
> 
> Kevin

Thanks for the update Kevin, will add that to the next update I am working on. :clap:

I am having an issue with SBA, I would just like anyone to confirm they have or haven't the same behavior with the database.

When adding SBA to a product, in the database in the 'stock_attributes' field SBA adds by the attributes by csv. If you add manually each attributes I am getting a pattern in the database for example:

13228,14900
4635,13228
4636,13228
4637,13228
4638,13228

As you will see the first value are reversed and then the rest are the same format and SBA works fine.

But if I add using the 'All' option the database is populated like this:

13228,14900
13228,4635
13228,4636
13228,4637
13228,4638

And SBA does not work properly. If I then update stock levels SBA adds a duplicate Stock ID in the reverse order.

I have creinold's installed I have also tried last night Numinix's version and get the same results.

Further to my last post I have found the problem,

SBA adds the 'products_attributes_id' to the 'stock_attributes' field in products_attributes_id 'number order' (etc 1,2,3,4,5 ). So using 'ALL' seems to add in Attribute** 'Sort' **order not the ID order. So SBA will not see this 'stock_attributes' exist.

In my example:

13228,14900 -- 13228 is the colour and 14900 is the size
4635,13228 -- 4635 is the size and 13228 is the colour
4636,13228 -- 4636 is the size and 13228 is the colour
4637,13228 etc
4638,13228

Any help would be appreciated, I am looking for the code for add 'ALL' to edit to sort in attribute order.
Thanks

Hi - I wonder if anyone can help.
I have the latest version of Zen Cart running and have just installed SBA.

Simply pasted the SQL code into the admin panel and copied the admin and includes folders to the server.

Since then, the shop is dead - cant get into the site or the admin panel.

http://shop.essexbikers.co.uk

Clearly this is something I have done wrong or something I have missed out but cannot see why.

Any help appreciated.

Cheers,
Dan.

EDIT - Sorry scrap that - for some reason when I uploaded the admin and includes directories the permissions were set so that no one had rwx access to them. Strange!

Hi

Has anyone considered adding sku by attribute to this contribution? Pardon me for my naivety, but on the surface it looks like the sku could be added to the current data entry page and data table. May not be as elegant as other active (and flawed) contributions, and it would require entering a stock level with the sku, but it would handle the case of multiple attributes (size and color), a requirement for the final solution.

But if Zen Cart 2.0 comes out next week with this promised capability, this argument is moot (should I stop holding my breath?):cool:

creinold, do your files have any changes that make it so out-of-stock combos aren't selectable from the item page?

For example, here is example stock of t-shirts:

Color: Black
Size: XL

Color: Navy
Size: S

Color: Red
Size: L

Color: Red
Size: XL

Color: Red
Size: M

Color: Red
Size: S

Color: Red
Size: XS

We are looking for something where if Black is chosen, XL will be the only size choice, and if Navy is chosen, S will be the only size choice.

I am pretty sure this add-on doesn't yet have this capability, but wanted to check in. Thanks!

That is availabe via dynamic drop down add on. Got to warn you it's pretty buggy for most people. I am slow updating it also along with sba. I am currently on vacation for two weeks fixing my roof. So I am away from the computer. Will continue update the codes when I'm back in the office. =)

Charles
Posted via Mobile Device

creinold:

That is availabe via dynamic drop down add on. Got to warn you it's pretty buggy for most people. I am slow updating it also along with sba. I am currently on vacation for two weeks fixing my roof. So I am away from the computer. Will continue update the codes when I'm back in the office. =)

Charles
Posted via Mobile Device
Take your time.. Your efforts and dedication are appreciated..:smile:

I am having a problem where if an item with a particular attribute is set to 0 and the customer puts said item into the shopping cart then the cart has the warning at the top that they are trying to buy an item that is currently out of stock but no longer indicates which item it not in stock like it use to before I upgraded to 1.3.9d. Any ideas on how to get the item in the cart to display the message that use to be shown again?

Thanks,
Marc

[QUOTE....]but no longer indicates which item it not in stock like it use to before I upgraded to 1.3.9d. Any ideas on how to get the item in the cart to display the message that use to be shown again?....
[/QUOTE]

I have upgraded to 1.3.9a all the way through 1.3.9f and I don't have this problem. I just double checked to make sure. I am using SbyA 1.4.9 in combination with Product Attribute Grid 1.1.1.

Does post number 968 in this thread apply to your situation?

What version did you install? I updated the mod and it's the latest version and fixes that. You can get it in my signature line.
Posted via Mobile Device

I am using "Stock_by_Attributes_ideashop_files". You do not have a signature line.

Where would one put the code clip from post #968 if that is the fix?

Thanks,
Marc

http://www.gotleather.com/Stock_by_Attributes_creinold_files_V4.8.zip
Posted via Mobile Device

hi medeano

di you finally get it to work proper?
i run into the same problems as you and i also cannot find that one vars file....

Hello, I am trying to find what the latest version of Stock by Attributes is?

I see many different postings on the forum here and I am trying to find a version that works with Zen Cart v1.3.9f Will the one above that you made a link to work? If so do I need to uninstall the other version I have? The version I have isnt working as before due that some files were significantly upgraded. (now folks can add products that are out of stock to my shopping cart) I have the version found here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=310

It is v1.4.10 with Ajax

Sorry but it is so confusing as to which version is the latest n greatest :-)

http://www.gotleather.com/Stock_by_Attributes_creinold_files_V4.8.zip

read my reply in the other message you posted
Posted via Mobile Device

Thank you so much creinold. I am so glad that you are updating this add-on! Hopefully something like this will eventually be stock in Zen Cart!

nohart:

Thank you so much creinold. I am so glad that you are updating this add-on! Hopefully something like this will eventually be stock in Zen Cart!
Not to take anything away from creinold.. His work on SBA has been awesome, but there have been in recent months a few folks who have been actively working on keeping this mod updated with the latest versions of Zen Cart.. Don't want to take anything away from their efforts or give the impression that NO ONE has updated this module in a long while..

That said, I hope creinold's anticipated upcoming version is going to include the frequently requested functionality of dynamic attributes:smile: -- the current module which provides functionality (Dynamic Attributes) is NOT fully functional (no offense to the Dynamic Attributes author), and it would be awesome to see this fully functional and a core part of SBA (versus in a separate module).

I think I need the dynamic drop downs working here and Divavocals may have hit on a point. Is it possible to show all drop downs in the first option and then when one is selected to show all the drop downs possible for that option but to have the in stock / out of stock showing as appropriate. At the moment it hides out of stock stuff, but I want to allow back orders , but at least tell the customer there may be a short wait as it is out of stock.

Can this be tweaked to work in this way?