Stocks by attributes

jdhiler:

the only thing is did is reinstall the files, one by one instead of that sketchy way of dropping the entire folder on the install, which doesn't confirm exactly what gets copied where... at least not in Cyberduck.This is a common problem. Some FTP tools appear not to overwrite by default. This usually happens when you have installed your Zen Cart after the date the mod was written. So your Zen Cart has installation date stamps, but the mod has older ones and the FTP client thinks the installed files are more current.

Hopefully they prompt you with an option to overwrite, but this doesn't appear to always happen, especially when the default is not to overwrite "newer" files. In that case, it's important to check the log file. Incomplete uploads are by far the most common reason for Stock by Attributes not working.

jdhiler:

the only thing is did is reinstall the files, one by one instead of that sketchy way of dropping the entire folder on the install, which doesn't confirm exactly what gets copied where... at least not in Cyberduck.Ahhhh good old Cyberduck..:smile: The only (free) FTP app for the Mac I could find that had a decent feature set and GUI.. But you are right it occasionally does not consistently overwrite files correctly.. I found myself switching to my PC to do all of my FTPing because of that..

Sorry, I posted this in wrong thread before.
I am using "Stock by Attributes" v4.7a on ZC 1.3.8.

We have a number of shoes sizes for a particular shoe style and we allow people to pass through the checkout process when a particular size is out of stock, so it goes on back order. This then removes the qty ordered from the stock by attribute number.

If the TOTAL stock level for a particular shoe style goes negative because a large number of sizes are on back order, then ALL sizes that actually are in stock also now show out of stock in the cart.

I need to show when a product is out of stock based only on the stock by attribute and not if total goes 0 or negative. Is this a bug and/or can it be fixed?

I have taken a look at the files but can't find where the problem lies. Also, can't find a thread relating to this specific problem.

Thanks,
Dan

fluxem:

I realized how to adjust this.. I hope..

I went to Admin / Configuration / Stock

then changed Allow Checkout to false.

:)

Maybe this will help you.

Hi, thanks, but I need to allow checkout when there is no stock so items go on back order, i.e. negative stock levels for those sizes indicate how many outstanding shoes of those sizes need to be ordered so orders can be completed. The problem occurs when individual sizes that go -ve accumulate so the total stock for a particular style goes -ve. this then causees even sizes that are in stock to show as out of stock.

Thanks
Dan

I have installed the following module on 1.3.6 (the site just went live a few weeks ago)

Stock by Attributes
Version: 4.7
Zen Cart™ Version: v1.3.8

But when someone makes a purchase it does not deduct from the inventory level for products with attributes stock. It does deduct from the product category stock.

I have tried looking around for an answer to this problem and have not been able to fine one yet.

Has anyone had this same issue?

Thanks in advance for your help.

@edeades

Two possible reasons:

1. The order.php class hasn't been over-written on your web server so you are running the original code Zen Cart code and not the special code that manages stock at attribute level (a common problem with FTP clients that don't by default over-write files already on the server).
2. You are running a version of the plugin designed to be compatible with version Zen Cart 1.3.8a, and not the version 1.3.6 that you are actually running. For that you would need version 4.3.1 of the mod.

Thanks so much for the response kuroi. I had a feeling it had something to do with orders.php. I am a little confused though. I verified I am on Zen Cart 1.3.8. Could it be that I am trying to use the 4.7AJAX mod instead of 4.7MULTIADD? The only orders.php I see in the AJAX mod is in the admin folder. I downloaded and looked at the MULTIADD and see there is orders.php in the includes\classes. Should I be using the MULTIADD mod instead? If so, is there a recommendation for installing the MULTIADD since I already have the AJAX mod installed. Thanks so much!

edeades:

Could it be that I am trying to use the 4.7AJAX mod instead of 4.7MULTIADD?Yes. The AJAX version is missing some files. I believe that's one of them. This isn't something that I've looked at closely myself, but there are posts earlier in this or the other support thread for this mod that discuss this issue.

I downloaded the 4.7MULTIADD mod and used ftp to send the orders.php from the includes\classes folder. The includes\classes was not in the AJAX mod.

It is working perfectly now!

Thanks so much for your help.

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;

hello limelites or anybody who can help me ,i had followed the advice as ontop however after changing the text , i recieved this error message on stocks with 0 qty updated in the products with attributes page.
1146 Table 'beb0917211113392.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:
[SELECT pov.products_options_values_id, pov.products_options_values_name, pa., pwas. FROM zen_products_options_values pov, zen_products_attributes pa LEFT JOIN TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK pwas ON pwas.stock_attributes = pa.products_attributes_id WHERE pa.products_id = '3' and pa.options_id = '1' and (pwas.quantity > 0 or pwas.quantity IS NULL) and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]

Can anybody help me with this???? Thanks alot i am using v 1.38 zen cart along with v4.7 ajax with orders.php updated from multiadd.

My site is https://www.bebemummy.com

I have been looking at the various posts....but cannot see the answer for my problem. I installed the 4.7ajax on my 1.3.8a version, but cannot see the Products by attribute under admin/catalog.

Not sure if I installed it correctly or not. Is there a way to verify it ?? Can someone please help? Website is https://www.ijashun.com

I realised that though I am using Zencart 1.3.8a, I am using lavendar template version 1.3.6. Is this causing problems?

ijashun:

I have been looking at the various posts....but cannot see the answer for my problem. I installed the 4.7ajax on my 1.3.8a version, but cannot see the Products by attribute under admin/catalog.

Not sure if I installed it correctly or not. Is there a way to verify it ?? Can someone please help? Website is www.ijashun.comYou can manually verify if it's installed by looking at the contribution files, and comparing that to what files are in your site folders.. There is no automatic means to verify your install..

anybody knows what does my error message means? Pls thanks!

I checked whether the files are loaded...here is the result

products_with_attributes_stock_4.7.ajax has 3 directories in it

1. Admin ---- got saved in phpuploads
2. Ajax ------ directly to the root
3. Includes----- admin/includes. Here it shows an additional classes folder.

Are the directories in the right place?? Or it would be great to know where each of them should be.

Any help is really appreciated.

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

Thanks

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?

@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.

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"