Stock by Attribute v4.0 addon for v1.3.5-1.3.9

Hello,

I'm using zen 1.3.9h now.
Is your v1.4.14 good for zen v1.5 ?

How to merge files while FTP, since I have many add-on mods installed?

Thank you!

drolex:

Update: I tried removing Stock by Attributes and the cart still doesn't work. Therefore, Stock by Attributes might work in Zen Cart v1.5 and my problem is something else. Maybe it's my template.

Thanks for the info :) I'm rebuilding fresh from a new install in a test directory on my server but it will be awhile before I get that far with it.

It sure would be nice if someone could point me in the right direction. Trying to load the page with 1000's of products with all the attributes on one page is too time consuming. Ideally I would like to set it up sorta like the admin area product listing page such as 20 per page with the next and previous buttons

thefather:

I have this installed and it seems to be working as I need. My only complaint is the fact that all of the products that have defined attributes loads on 1 single page. I have several thousand products so the load time basically sucks.

I would like to be able to break it down into several pages.

Any suggestions on how I may accomplish this?

rhuseby:

I am currently modifying this add-on to include a unique part number for each stock variant. I think I have seen other people asking for this feature. This will allow me to sync the Zen product quantities with my internal inventory control system quantities via SQL command line tools and a scheduled task. I'm not a PHP programmer, but I'm pretty good at hacking up existing code to make it do what I want. I have the bulk of it done but have hit a wall. If anyone wants to jump in and help finish it up, I'll be glad to share what I've done. The unique part number exists, I can add the part number in the Admin, the number displays in the admin and cart. I can't figure out how to carry the part number through the rest of the checkout process and put it on the invoice...

This MOD is finished, I have submitted it for approval...

cricri:

Hi all,

I just downloaded and tried to install SBA to my Zen Cart.

Zen Cart ver 1.3.9h
SBA ver 1.4.14

I am using a norwegian translation of Zen Cart.

I followed the instructions in the included readme file, inserted the extra rows in the SQL database and renamed the MY_TEMPLATE folder to my template name. I also made norwegian versions of the SBA language files.

Then I uploaded everything to the server.

The problem is that SBA does not work at all. Nothings shows, no changes made. No menu item in "Catalog", no nothing.

I just simply can't figure out why this is not working.

Any suggestions?

Thanks in advance,

Kristian W.
Norway

I am having the same issue except my installation is english only.

Any help would be appreciated.

Brent

I noticed an error within stock_by_attributes_1-4-13 which is what I used to create this new MOD. If you add a product that is out of stock, it will display out of stock as it should. But it will also show out of stock on any additional items you add after that, even items that have plenty of stock available. I found a piece of code in an older version that appears to be missing and fixes this issue. It is in includes/modules/pages/shopping_cart/header_php.php, need to put back in at line 85...

if (STOCK_CHECK == 'true') {
$flagStockCheck = zen_check_stock($products[$i]['id'], $products[$i]['quantity']);
if ($flagStockCheck == true) {
$flagAnyOutOfStock = true;
}
$stockAvailable = zen_get_products_stock($products[$i]['id']);
}

thefather:

It sure would be nice if someone could point me in the right direction. Trying to load the page with 1000's of products with all the attributes on one page is too time consuming. Ideally I would like to set it up sorta like the admin area product listing page such as 20 per page with the next and previous buttons

I have modified the admin to include buttons at the top to take you straight to the product you want to work with. This won't help the load time but it makes it much easier to work with...

That does not look bad but that would still be cumbersome and bulky for anyone with lots of products.

I would just like to have a way to load lesser amount of products. Such as by brand, or by starting letter or even 25 per page with simple ways to navigate it.

Guess I need to keep looking for my answers

rhuseby:

I have modified the admin to include buttons at the top to take you straight to the product you want to work with. This won't help the load time but it makes it much easier to work with...

Does anyone know if it is possible to assign a quantity to ALL products that have attributes set in one go?

The reason for this is that I upload hundreds of products at a time and having to individually go in a add a quantity for each attribute for each product is painful!

So essentially once I have a category's full of say 100 products, all with say small medium and large set to them, I would really like a script I could run that could set every option to say qty 10 in one go?

If anyone can give me some direction on this I'd be very grateful.

Thanks.

Using :
Zen Cart 1.3.9h

Database Patch Level: 1.3.9h

v1.3.9h [2011-11-20 22:01:01] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-08-16 10:59:26] (Fresh Installation)

PHP Version 5.2.11

And getting this error when trying to go to the Catalog>products with attributes stock.

1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="107" order by sort ASC;]
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.


Any help is greatly appreciated, we need to update our inventory.

SBA 1.4.14
1.3.9h

PROBLEM #1: I installed SBA, everything looked good but when I add a product to the cart it shows it as out of stock even if there is a qty of 100 in the size.

PROBLEM #2: I have Fast and Easy Checkout installed. Now when I try to checkout it gets to the 'confirm order' page and I get this:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.product_attribute_is_free, pa.attributes_discounted ' at line 11
in:
[select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.product_attribute_is_free, pa.products_attributes_weight, pa.products_attributes_weight_prefix, pa.attributes_discounted, pa.attributes_price_base_included, pa.attributes_price_onetime, pa.attributes_price_factor, pa.attributes_price_factor_offset, pa.attributes_price_factor_onetime, pa.attributes_price_factor_onetime_offset, pa.attributes_qty_prices, pa.attributes_qty_prices_onetime, pa.attributes_price_words, pa.attributes_price_words_free, pa.attributes_price_letters, pa.attributes_price_letters_free, pa.products_attributes_maxdays, pa.products_attributes_maxcount, pa.products_attributes_filename pa.product_attribute_is_free, pa.attributes_discounted from products_options popt, products_options_values poval, products_attributes pa left join products_attributes_download pad on pa.products_attributes_id=pad.products_attributes_id where pa.products_id = '150:d589ee96db65a5fd30e81707a211f4a4' and pa.options_id = '1' and pa.options_id = popt.products_options_id and pa.options_values_id = '6' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1']

I have turned off FEC and the problem still happens.

Any ideas what I did wrong or what needs to be fixed? Desperate - site is basically useless at this point. :(

athena:

Here is a link to a post in a thread called only: "Stock By Attributes" rather than this thread called: "Stock by Attribute v4.0 for Zen Cart 1.3.5+"

I think some of us have gotten lost in there but this post is significant - I just haven't had time to try it yet:

limelites:

Ahaaaaaaa, figured this one out guys!!

For anyone else having a problem with this issue, just look at re-installing the files that shipped with the stock_by_attributes mod.

I've just cured my problems by overwriting /includes/classes/order.php with the order.php from "stock_by_attributes_4-7MULTIADD mod"

Somehow some other mod had corrupted the data that updates the "Quantity in Stock" in ADMIN>CATALOG>PRODUCTS WITH ATTRIBUTES".

It is now updating the Quantity in Stock Column with each sale. All working perfectly now.

Additionally, if you want the attribute in the drop down menu to automatically disable when the attribute quantity = zero, then you have to open /includes/modules/attributes.php and replace this:

$sql = "select pov.products_options_values_id,
pov.products_options_values_name,
pa.*
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
where pa.products_id = '" . (int)$_GET['products_id'] . "'
and pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
and pa.options_values_id = pov.products_options_values_id
and pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
$order_by;

> > with this:
> > ```php
$sql=	"SELECT  pov.products_options_values_id,
       					 pov.products_options_values_name,
       					 pa.*,
       					 pwas.*
        	    FROM   " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " pwas ON pwas.stock_attributes = pa.products_attributes_id
                WHERE   pa.products_id = '" . (int)$_GET['products_id'] . "'
       			and    pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
				and    (pwas.quantity > 0 or pwas.quantity IS NULL)
      			and    pa.options_values_id = pov.products_options_values_id
             	and       pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
				$order_by;

My attributes with stock are radio buttons and/or drop-down lists. I would like to use code similar to the one above, but instead of making the attributes disappear I would like to cause them to be grayed out (unselectable) and (ideally) apply a new style to them so that I can customize the "out of stock" options with a little CSS (which I suppose would be more applicable to radio buttons than it would be to drop-down lists).

Thanks!

Also, is it possible to display the quantity remaining for each attribute? For instance "(3 in stock)" or soemthing like that next to the radio button for the "Blue Shirt" option.

hockey2112:

Also, is it possible to display the quantity remaining for each attribute? For instance "(3 in stock)" or soemthing like that next to the radio button for the "Blue Shirt" option.
It is possible.
part of the answer is in this thread. start looking at post #517
There may be a few modifications to that code. look at the posts before page 55 or something. messy info i know. its in here somewhere. look before 2008 posts maybe...

hi, please please can someone help..
currently using zencart 1.3.9 and stock by attribute 1.4.14. everything seems to be working fine until we try to add the quantity to a product variant. once we enter in the quantity and click submit we are given this error message

1364 Field 'sort' doesn't have a default value
in:
[insert into products_with_attributes_stock (products_id,stock_attributes,quantity) values (486,"1577",2) ON DUPLICATE KEY UPDATE stock_attributes = "1577", quantity = 2]
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.

another error message for when we select to sync all quantities.

1265 Data truncated for column 'products_quantity' at row 1
in:
[update products set products_quantity="" where products_id="71"]
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.

any help would be much appreciated as we are currently unable to update our stock count. :no:

ArtRat:

It is possible.
part of the answer is in this thread. start looking at post #517
There may be a few modifications to that code. look at the posts before page 55 or something. messy info i know. its in here somewhere. look before 2008 posts maybe...

Awesome, I will check it out ASAP.

Another question... is it possible to have the stock auto-reset to a certain number at midnight each night? I will be using the stock to set up available local deliveries each day (30 per day). Once there have been 30 deliveries ordered that attribute option will be disabled, but I would like for it to automatically become available again that night at midnight so that people can "order" it the next day.

Possible?

hara:

Hello,

I'm using zen 1.3.9h now.
Is your v1.4.14 good for zen v1.5 ?

How to merge files while FTP, since I have many add-on mods installed?

Thank you!

It doesn't work for v1.5:(

Is anybody working on making this module compatible with zen cart 1.5?
in my view this is one of the most important modules because who is using it can't simply stop using it..:unsure:

I agree, I am stuck without this! :smile: Looking for a new shopping cart unless it gets updated fast.> tesefoti:

Is anybody working on making this module compatible with zen cart 1.5?
in my view this is one of the most important modules because who is using it can't simply stop using it..:unsure:

storminyte:

I agree, I am stuck without this! :smile: Looking for a new shopping cart unless it gets updated fast.

I would suggest approaching someone like Numinix to upgrade teh module. If need be you might be able to get some others such as myself to pool funds to pay for the upgrade.

-lindasdd