Stocks by attributes

Printable View

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

2 Nov 2010, 09:59 PM
creinold

Re: Stocks by attributes

Quote:

Originally Posted by dirntknow

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?
2 Nov 2010, 10:01 PM
creinold

Re: Stocks by attributes

Quote:

Originally Posted by weber

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.
6 Nov 2010, 03:33 PM
p1lot

Re: Stocks by attributes

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
19 Nov 2010, 06:50 PM
janislyn

Re: Stocks by attributes

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.
20 Nov 2010, 02:28 AM
mvstudio

Re: Stocks by attributes

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!

Quote:

Originally Posted by DivaVocals

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..
22 Nov 2010, 11:28 PM
finless

Re: Stocks by attributes

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:

Quote:

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:

Quote:

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
23 Nov 2010, 01:09 AM
DivaVocals

Re: Stocks by attributes

Quote:

Originally Posted by finless

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.

Quote:

Originally Posted by finless

The README.HTML says this:

Quote:

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.

Quote:

Originally Posted by finless

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:

Quote:

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.
23 Nov 2010, 07:39 PM
finless

Re: Stocks by attributes

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
7 Feb 2011, 11:51 PM
Arpanet

Re: Stocks by attributes

Quote:

Originally Posted by limelites

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:

PHP Code:

$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 Code:

$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!
13 Feb 2011, 03:38 PM
magnaromagna

Re: Stocks by attributes

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

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