Stocks by attributes

[creinold]

Sorry for the noob question but i've just installed stock by attributes, created a product and using stock by attributes defined a quantity for each variant. The quantities are not updating when I make a test purchase....where am i going wrong?

Did you Sync Quantities after adding the stock?

[creinold]

after SBA installed, the original zen cart sales report can not show the actual sales...

I have no problems with my report. It doesn't show attribute sales, just product item sales.

[p1lot]

for some reason the "save" button at the top and the bottom were removed in your newest release, otherwise it is working perfectly fine.

here is the patched version of the file "admin/includes/classes/products_with_attributes_stock.php" to mass-edit quantities:
http://pastie.org/1277159

[janislyn]

Posted in another thread, but this may be correct one...

I'm working with Zen Cart version 1.3.8a, have the stock by attributes add-on installed for that version and have a couple of stock-related issues.

1. I need for the stock level for a particular attribute to show in the shopping cart when a customer selects a quantity more than what's in stock. Despite having the correct configurations under Configuration > Stock, I don't get the quantity showing in the shopping cart. Rather there is this message:

Products marked with * are out of stock or there are not enough in stock to fill your order. Please reduce the quantity of products marked with * below. Thank you.

2. Relatedly, when a customer purchases a product with attribute, the stock for that attribute is not updated automatically. Rather the product stock itself is updated but I have to go under Catalog > Product with Attributes Stock to manually update the attribute quantity.

How do I get the attribute quantity to show in cart when customer selects more than what's in stock? Also, how do I get attribute stock level to update automatically? I've seen both of these questions posted over and over in this forum with no clear answers. If anyone can help, it would be greatly appreciated.

Thanks.

[mvstudio]

Well, after months, I did, or I think I did. I have the latest version (http://www.zen-cart.com/index.php?ma...roducts_id=310) it says is by The Software Guy but the instructions are by Kuroi (so confused now!) and I'm still having the same problem. With multiple attributes I get a load of options on the product page (this particular one http://www.byvalenti.com/index.php?m...r_of_uploads=0), so much that it crashed when I tried to set products with attributes stock. All the options multiply exponentially by the number of attributes each option has. For example, "Cello Bag / 1 Raffia Ribbon" appears numerous times instead of once, and the same happens with each and everyone one of the options as per combinations there are. Has anyone any idea what is happening here?

Thanks!

Hi folks.. Haven't tested the latest SBA version.. Sounds like it too has issues..

So let me say what I have consistently said in this and the other SBA support thread.. I ONLY use the version created by Kuroi.. EVERY SINGLE VERSION released after Kuroi's version is close but no cigar IMHO. If you look through this support thread, you will see that CONSISTENTLY the problems with SBA all relate to versions other than the one created by Kuroi..

My advice?? Rollback to the Kuroi version.. Unless someone (like the author of the latest version) steps in to help..

[finless]

OK new guy to Zen-cart here and have been setting up and having fun for a little over a week. I have found all I need in the FAQ's and fine posts here in this forum. Awesome all!

Now I want to add this add-on and based on reading this thread and it seems for me to at least for now start with Kuroi's 4.7 package. I am running ZC 1.3.9h.

HOWEVER... I am confused about installation?

Does this package not support overrides?
I understand there are NO ADMIN overrides but the INCLUDES install baffles me. To now, I have used overrides for everything I have done so far PER the recommendations here. I again understand for the admin you will be replacing core files.

The instructions that come with the install of this ABS package seem old and or incorrect?

The README.HTML says this:

Prepare the package for upload to your server by renaming the following folders to match your template name: includes/modules/YOUR_TEMPLATE and includes/templates/YOUR_TEMPLATE.

HUH? Modules? Shouldn't this be includes/templates/YOUR_TEMPLATE_NAME/templates/YOUR_TEMPLATE_NAME ???

OK then the other directories in includes with this package. Are you really replacing core files or should they be put in overrides?
For instance the instructions say this:

There are six core Zen Cart files modified by this add-on. If you have installed other add-ons or customized your cart since your Zen Cart installation or upgrade, you will need to check whether they have changed any of the following files:
•admin/includes/stylesheet.css
•admin/orders.php
•includes/classes/order.php
•includes/functions/functions_lookups.php
•includes/modules/pages/checkout_shipping/header_php.php
•includes/modules/pages/shopping_cart/header_php.php

I understand I WILL be replacing the admin files but shouldn't the others be like:
includes/modules/YOUR_TEMPLATE_NAME/ ????
includes/functions/YOUR_TEMPLATE_NAME/
and so on?

So for instance the PAGES directory. Am I support to REPLACE the 2 CORE directories "checkout_shipping" and "shopping cart" or should I be doing this:
includes/modules/YOUR_TEMPLATE_NAME/pages/checkout_shipping etc??

I am good at backing up before making changes, etc. I installed one of the other packages (the filter 1.6 or something like that) and the admin pages worked but checkout did not. Again I read Kuroi's package is most stable so I backed out everything and am planning to try this one BUT, this time I want to make sure to put the files in the proper place. Overrides or not? That is the question ;)

Thanks much!
Bob

[DivaVocals]

HOWEVER... I am confused about installation?

Does this package not support overrides?
I understand there are NO ADMIN overrides but the INCLUDES install baffles me. To now, I have used overrides for everything I have done so far PER the recommendations here. I again understand for the admin you will be replacing core files.

The instructions that come with the install of this ABS package seem old and or incorrect?

These instructions are not old or incorrect at all. Kuroi is one of the most experienced guys around here, and his install instructions for 4.7 version of SBA - Stocks by Attributes (Not ABS) are absolutely spot on and indeed using the Zen Cart overrides system correctly.

The README.HTML says this:

Prepare the package for upload to your server by renaming the following folders to match your template name: includes/modules/YOUR_TEMPLATE and includes/templates/YOUR_TEMPLATE.

HUH? Modules? Shouldn't this be includes/templates/YOUR_TEMPLATE_NAME/templates/YOUR_TEMPLATE_NAME ???

Short answer is no. Follow the instructions and rename all the YOUR_TEMPLATE folders in the SBA install package to match your template's folder name. If you are using ver 4.7, these files are from an older version of Zen Cart. So you will need to make sure they include not only the required SBA code, but all the latest updates for these files (if there are any) from the latest Zen Cart version.

OK then the other directories in includes with this package. Are you really replacing core files or should they be put in overrides?
For instance the instructions say this:

There are six core Zen Cart files modified by this add-on. If you have installed other add-ons or customized your cart since your Zen Cart installation or upgrade, you will need to check whether they have changed any of the following files:
•admin/includes/stylesheet.css
•admin/orders.php
•includes/classes/order.php
•includes/functions/functions_lookups.php
•includes/modules/pages/checkout_shipping/header_php.php
•includes/modules/pages/shopping_cart/header_php.php

I understand I WILL be replacing the admin files but shouldn't the others be like:
includes/modules/YOUR_TEMPLATE_NAME/ ????
includes/functions/YOUR_TEMPLATE_NAME/
and so on?

So for instance the PAGES directory. Am I support to REPLACE the 2 CORE directories "checkout_shipping" and "shopping cart" or should I be doing this:
includes/modules/YOUR_TEMPLATE_NAME/pages/checkout_shipping etc??

Again, the short answer is no.. The instructions are correct.. The files listed here are not part of the Zen Cart override system and as such they must be overwritten by the files in the install package (as indicated in the instructions). Again, if you are using ver 4.7, these files are from an older version of Zen Cart. So you will need to make sure they include not only the required SBA code, but all the latest updates for these files (if there are any) from the latest Zen Cart version.

[finless]

Thanks for the reply. So I have to hand edit the ZC 1.3.9h files and by hand add the code from the SBA 4.7 replacement files? (I meant SBA last time not ABS it was a typo). There is no update to 4.7 you recommend I go with instead?

I follow you on the second part that some files are not part of the ZC overrides. I just assumed that anything in the includes folder could use overrides.

This override structure picture in the FAQ led me to believe that some of these directories like includes/modules/ could use overrides for anything in it?

http://www.zen-cart.com/index.php?ma...98&update_id=2

Thanks,
Bob

[Arpanet]

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:

$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; 

I've got a similar requirement on my site - if an attribute is out of stock it should be removed from the radio button list (radio buttons as opposed to dropdowns per the client's request).

This is somewhat complicated by the fact that each product has 2 attributes, so the attribute would only be removed if it's out of stock in ALL combinations.

A good example is this product:

http://www.vkoonyc.com/accessories-c...oop-scarf-p-20

There's only one size, which makes it easy to test. It's out of stock in Mocha and Lt Grey, and I would like both of those attributes to be removed from the radio button list.

I tried limelite's code in attributes.php but it had no effect.

Using Zen Cart 1.3.9h w/ SBA 4.12.

Thanks in advance!

[magnaromagna]

Hello,
I have a strange problem with this mod. Installed the last version (1.4.12). My zen cart version is 1.3.9h
On the public side, it shows the grid with the options (sizes and colours), but if I select - for example - no.2 size S and green color, no.3 size M red color, etc.), and click on "add to cart", in the cart it shows only 1 item.
Basically, it only add only 1 item (even if I add 2 or more) , and not show the attributes.

Do you think it's a problem on installation or need to edit some admin options?
Thanks