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

Though that may fix the stock mod - there is no question that parts of it are not correct for 1.3.9h. I'm simply not able to fix the whole thing myself right now but there are problems there so beware.

hello delia

i am currently looking at this mod (latest stock by attributes), could you please send me the details of the parts which are not correct for 1.3.9h so that i can analyze them and hopefully fix them.

If I was that sure about it, I would have fixed it myself. There's some tiny things I noticed but there could be more.

I have a question about this mod that i hope can help me wrap my head around things...I have a client who has over 2,000 products more than half have attributes that require stock values....so I was hoping to find a way to upload via CSV, but I am seeing that this is an issue due to the way the attributes are written to the database.

If there is only one attribute for an item, I believe it can be done...but multiple items become comma separated results in the stock_attributes field and I do not believe there is a way to accomodate for this in the CSV file...

Is there a reason it was done this way as opposed as to the code creating a separate line item in the table for each product/attribute value?

How hard would that be to do or is it even possible....

Thanks for any thoughts.....

That is the biggest problem with this mod. But changing it would be a monumental task. Someone needs to completely rewrite this mod.

What I found out was that with a large database, this mod is so inefficient that it's almost not usable in admin. I don't see that it slows down the catalog side that much but editing the stock is very problematic.

I tried to find an alternate solution - and once again turned to Apsona and their free store manager. You can import and export at will with that but he said:

"I'm not sure it will work the way you intend. As far as I know, they're storing the key ID numbers in comma-separated format within the varchar field. This is very non-standard, and is the main reason why ShopAdmin does not support that add-on - it would take a good bit of work to interpret that comma-separated string and integrate it into our UI."

In other words, it would be very pricy to get it done.

I am working with Apsona myself on this right now...and I get the complication.....now I see the issue is a big one for many people.....this is a nightmare for clients with multiple attributes.....and I hate spending money to have someone come up with a solution when we have no insight into when the new Zen version will be released.....

ugh........ what to do what to do......may be time to move on to another cart soon I think.....

Have you got so many products that you have to do an import? That save button is supposed to allow you to make the entries and save all at once. I couldn't get it to work myself but a fix for that would be cheaper.

The site is set to launch next week....she has over 1200 products with attributes that have stock....do not want to do those by hand....most clients are fine - this is an extreme case but we do not want to do it by hand....and she may have multiple updates in the future which of course we were hoping ot give her the upload option for....I have a call today with Apsona...we may be able to do something only because she only has 1 attribute per item.....

I think the problem is when there is more than one option....

I have not tried the save feature yet for multiple attributes in the admin...have to check that out to see if it works.....we tweaked the mod quite a bit though so it may be a bit different...

I am going to talk to a developer though about working on a better mod for this though...if we can find the time this may be a project we will undertake.....

jill8026:

The site is set to launch next week....she has over 1200 products with attributes that have stock....do not want to do those by hand....most clients are fine - this is an extreme case but we do not want to do it by hand....and she may have multiple updates in the future which of course we were hoping ot give her the upload option for....I have a call today with Apsona...we may be able to do something only because she only has 1 attribute per item.....

I think the problem is when there is more than one option....

I have not tried the save feature yet for multiple attributes in the admin...have to check that out to see if it works.....we tweaked the mod quite a bit though so it may be a bit different...

I am going to talk to a developer though about working on a better mod for this though...if we can find the time this may be a project we will undertake.....

We have 6700 products in one of our sites
We have had all kind of problems with this mod to
We finally had it fix for us a few weeks ago
The main thing to resolve this was to make the first page come up into a list if our categories, instead of the full list of every item in our data base.
I know nothing about PHP coding, so I can’t tell you more than that.
This is the guy we paid to fix this. He was wonderful to work with :clap:
http://www.webelity.com/

Hi all I need help with stock by attributes there is any way to set this mod Quantity as 1 for any new product or update product add with attributes. What I m trying to say as soon I add attributes to product and auto quantity add 1 for Quantity for all variants in product with attributes stock? Help Please :frusty:

kuroi:

Depends what you call easy. I do this by either writing SQL scripts to bulk populate the attribute stock, or more frequently by creating spreadsheets for import to the table.

Kuroi can you give an example to the SQL script you have written to bulk populate the attribute stock. I need to set all my stock levels to stay at 1.

Can someone please tell me what the different is between Stock by Attributes and Stock by Attributes Beta?

Not sure if I should post a question here or start a new thread? But here it is:

I am using v1.3.9h and used the stock by attributes module. Copied all the files and the SQL as per the instructions. On testing I realize that it works as expected but when an out of stock item added to cart first and then if an other item, that is in stock, is added to the cart it shows both the items with a red ***.

On the other hand out of stock item is added last it works properly.

I don't know what am I doing wrong. Please help!!

Thanks.

zc_fan:

Not sure if I should post a question here or start a new thread? But here it is:

I am using v1.3.9h and used the stock by attributes module. Copied all the files and the SQL as per the instructions. On testing I realize that it works as expected but when an out of stock item added to cart first and then if an other item, that is in stock, is added to the cart it shows both the items with a red ***.

On the other hand out of stock item is added last it works properly.

I don't know what am I doing wrong. Please help!!

Thanks.

same with my cart. just checked it out.

Yep same here;

https://www.mightcontainnuts.com

I tell you guys...every time you install a module you can not count on all the instructions for making it work properly are there.

I've learned it is no waste of time to read through the support thread first.

This question is posted so often it is driving me CRAZY.....

the solution is here....just search my posts....maybe half of this thread is about this issue.

I also hope this mod will be updated. Maybe with the new zencart release.

Check Athena's post on page 114 of this thread and copy/paste that code to your file.
I had the same problem, but the code in the post fixed everything.

Does anybody know if there's a way to exclude a product from showing up in the products with attributes stock page?

I have a product with 4 options, but I want an unlimited quantity for all the combinations of options for this product, so in the catalog I put 10,000 as the quantity. This is a custom order product.

The problem is that when I go to products_with_attributes_stock.php I see the product with the product ID there. I don't want to populate this product with the options on this page, because it's a bunch of unecessary rows in the DB. I would prefer if this product didn't show up on this page at all.

The problem is, every time I press "Sync quantities" in the upper right corner it lists this product with a quantity of 0. I do not want this.

So I'm looking to exclude the product from this page completely. I looked in the products_with_attributes_stock table but I could not find this product ID on the page at all!

Two things here - If you have attributes set on the product, it will list in the attributes stock table.
The only way it won't show in your products pages where the customer picks it is if stock level is 0.
My guess is that you should go ahead and fill in all the attributes with large quantities and leave the
"Sync Quantities" button alone. I have found that that button produces some very unwanted results.

1.3.9h
Stock By Attributes only
http://www.gandjclothing.com

I'm completely lost. I've added the data base I THINK and now I need to upload the files. all the instructions say is:
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.

I don't have a YOUR_TEMPLATE folder in the stock_by_attributes_1.4.13 folder. Is there any place I can get step by step instructions for beginners on how to install this addon? Actual step by step???? I made changes to fonts, background, layout so I'm assuming I don't replace my current folders with these folder since it would wipe out everything I've done, correct?

This part of the instructions does not help me what so ever:
There are six core Zen Cart files modified by this add-on. If you have installed other add-ons or customised your cart since your Zen Cart installation or upgrade, you will need to check whether they have changed any of the following files:
•admin/orders.php
•admin/includes/functions/general.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

In addition, one file is over-ridden
•includes/templates/template_default/templates/tpl_shopping_cart_default.php

If you, or any mods that you have installed, have changed any of these files (or over-ridden the last one), then you will need to merge the any changes into the relevant file.

What is it telling me to do?

1. Do I find the same files in my current site and replace them with these 6?
2. If so, I don't have an admin file in my current site. Do I just upload the admin folder to my catalog folder? I have a zcadmin. Is that what they mean?

Any help would be GREATLY appreciated
Thanks