Stocks by attributes

[ijashun]

I figured it out. I reinstalled the files individually to respective folders.

Thanks

[ijashun]

However, my next problem is that when I click on admin/catalog/Products with Attributes Stock I get this :

Suchen: Store
--------------------------------------------------------------------------------

Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync Quantities


Can anyone help where I can add the product variants and other information?

[kuroi]

@brocolee

Did you run the installation SQL?
Did the admin/includes/extra-Datafiles>products_with attribute_stock_databse_tables.php get uploaded correctly ton your server.

[brocolee]

yes i did regarding the installation sql !

Thanks kuroi for answering the noob question..

Now its finally working! Just that i see naother problem and that is when i was testing and proceed for a check out....

When i delete the order in my back end and tick "restock quantity" the stock nv return back to "SBQ table"

[kuroi]

However, my next problem is that when I click on admin/catalog/Products with Attributes Stock I get this :

Suchen: Store

You're using the AJAX version of this mod which is known to be incomplete. If you search this thread for "ajax" you'll find more information about this.

[kuroi]

yes i did regarding the installation sql !

Thanks kuroi for answering the noob question..

Now its finally working! Just that i see naother problem and that is when i was testing and proceed for a check out....

When i delete the order in my back end and tick "restock quantity" the stock nv return back to "SBQ table"

This mod does not support restocking. I'm afraid that has to be done manually.

[ijashun]

Kuroi,

I removed 4.7ajax and installed multiadd. I am able to add to the product stock by attributes table. However I am not able to display the quantities next to the attributes in the product info page. I tried what you had mentioned in wiki (grayson). I have only one attribute currently..size.

Also when quantity is added to cart, the stock does not reduce (when continue shopping is clicked without checking out).

I have checked for the proper installation, as you suggested.

here is the link.. http://ijashun.com/index.php?main_pa...products_id=25

Can you help, please?

Thanks in advance.

Swathi

[ijashun]

I have another question...can we combine stock by attribute with product attribute grid module... so that we can have the quantity of stock available next to the attribute and also allow the customer to choose the quantity
eg.

size Small available 4. select 2

Thanks in advance for any help.

Swathi

[MelB]

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:

$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 wanted to be able to not have a particular attribute availble if none is stock eg: black medium no stock but all other availble option still visable. I changed the code as above on the attributes.php but it never worked in the store I can still select it an it then goes on backorder

Was there anything else that I should have done first?

[IPC1]

I wanted to be able to not have a particular attribute availble if none is stock eg: black medium no stock but all other availble option still visable. I changed the code as above on the attributes.php but it never worked in the store I can still select it an it then goes on backorder

Was there anything else that I should have done first?

Check your settings in Configuration > Stock > Allow Checkout

This should be set to false.