Stocks by attributes

Hello,

I am having problems with this contribution and the shopping cart page.

If a product is just priced as is, the stock level check works. On the other hand when I use attribute stock levels it always claims that the item is out of stock no matter what.

I've looked in the database and the levels stored are correct. I have tried backing up the files the contribution uses and then re-installing unedited versions.

I am using the product grid contribution (http://www.zen-cart.com/index.php?ma...roducts_id=876) and have edited it so that it indicates how much stock each attribute had, using traffic light images. When I add something to the basket and the shopping cart loads the correct attributes are listed in there, it is just the stock level that isn't working :(

Quote:

---

Originally Posted by bencart

Hello,
I am having problems with this contribution and the shopping cart page.

---

I've tried using attribute without the product grid and it looks like its a problem with that rather than this contribution :blush:

Quote:

---

Originally Posted by bencart

I've tried using attribute without the product grid and it looks like its a problem with that rather than this contribution :blush:

---

Knowing where that mod came from, I would be surprised if it didn't work. So the problem is most likely in how the two mods interact. But there's a hitch there, since they don't appear to! However, product attribute grid does tweak the shopping cart directly, so it's possible that whatever it does upsets or passes data that isn't available to stock by attribute.

Quote:

---

Originally Posted by Glamorousshoe

Do you guys know of any shopping cart and how do they compare to the Zen-Cart in matter of User Friendliness and Friendly support such as what Iam getting from all the members on this forums.

---

Well, most of us are probably here because we think that Zen Cart offers the best combination of usability, range of features and support. So I doubt many people will suggest you go somewhere else!

It's not the easiest to get into. Nor the lightest code. But when I did my evaluation, it was streets ahead of the other open source options for range of functions and quality of architecture, and it's gotten better since.

But equally important, it seemed to me then, and has proven to be the case in practise since, that not only is this forum one of the most active that I have known, but also that all the developers participate actively in it. This not only improves the quality of the responses given, but also confirms that they remain active in the project, and the project continues to develop.

Quote:

---

Originally Posted by Glamorousshoe

Another Random question.
As I mentioned before I sell shoes and clothes, The way my site is set up now allow the customers to browse by the style.
If I want to add option to browse by Size and have a list of the sizes I carry which would be linked to the stock by attribute, Can anyone Tell me IS that Doable? Can it be done without me paying the developer lots of money??????

---

For a specific situation, that's really not too difficult to do for anybody with a reasonable understanding of databases who gets to grip with the data structure used for stock by attributes. The difficult thing would be building a solution that worked for all cases.

Personally, I wouldn't do it yet though, as the data structure will change when attribute stock is taken into Zen Cart's core code and such changes might have a very limited lifetime.

Hi kuroi,

I'm getting a little closer:-

Looking in the products_with_attributes_stock table I can see where the problem is:

In the column stock_attributes, a standard zen cart checkbox fills it with a number (the attributes id?). This works fine.

Then I add another attribute, which is called quantity and has one option value that is totally blank (as per the attribute grid readme). Looking back in the products_with_attributes_stock table, the stock_attributes column still holds the attribute id number, but now it also has a comma followed by the quantity attributes id appended to it. Should this be happening? That is when the shopping cart stock control breaks.

Thanks for your help :cool:

I have taken the cart back to an update point before the Product Grid contribution was installed and then reinstalled the PG contribution and all is working fine now :clap: I think it was probably a corrupt database.

Thanks for you help kuroi :cool:

Now I start using the stock by attribute function and it works flawless. But iam never satisfied, I uploaded 160 products over the last few days but it takes lots of time to add each product then set the attribute then input the quanity and finally use image handler to upload more images.

The question is: Is there a way where I can input the quanity of more than one product on the same page, or at least the quanity of each different attribute for each item (for example: Input the quanity for different attribute of the same shoe sizes 5-10)?

Any feedback is appreciated!

Quote:

---

Originally Posted by Glamorousshoe

The question is: Is there a way where I can input the quanity of more than one product on the same page, or at least the quanity of each different attribute for each item (for example: Input the quanity for different attribute of the same shoe sizes 5-10)?

---

I don't use the module myself but I looked at the SQL for the table it creates:

Code:

---

CREATE TABLE products_with_attributes_stock (
        stock_id INT NOT NULL AUTO_INCREMENT ,
        products_id INT NOT NULL ,
        stock_attributes VARCHAR( 255 ) NOT NULL ,
        quantity FLOAT NOT NULL ,
        PRIMARY KEY ( `stock_id` )
        );

---

If you don't want to bother writing a real SQL query, just use phpMyAdmin to EXPORT the products_with_attributes_stock table from the database.
0. Open the database in phpMyAdmin and click on the EXPORT tab.
1. Select the products_with_attributes_stock table from the list.
2. Choose CSV as the File Type
3. Under CSV Options set "Fields Terminated by to ',' (comma)
4 Click "Save as File" and then "Go".
5. Save the file to your desktop and open it with Excel as CSV.
6. For each style of shoe you can look up the products id in Admin>Categories/Products, or using phpMyAdmin in the database, by model number in the products table or by name in the products_description table. If I were writng a full SQL query I would 'join' these tables and pull the model number and name from those tables into the CSV file.
7. When you have entered all the inventory numbers, save the edited file AS CSV from Excel.
8. Use phpMyAdmin to IMPORT the table. Under CSV Options be sure to check "Replace table data with file".
Done, you have now added all the quantities to your stock file. I would suggest that you might want to do this when there are no customers on the site so that the inventory doesn't change while you are doing the update. As alway, make a backup of your database before you try this the first time.

Hope this helps.

Quote:

---

Originally Posted by bencart

Hello,

I am having problems with this contribution and the shopping cart page.

If a product is just priced as is, the stock level check works. On the other hand when I use attribute stock levels it always claims that the item is out of stock no matter what.

I am using the product grid contribution (http://www.zen-cart.com/index.php?ma...roducts_id=876) and have edited it so that it indicates how much stock each attribute had, using traffic light images. When I add something to the basket and the shopping cart loads the correct attributes are listed in there, it is just the stock level that isn't working :(

---

I am having the same problem as above again :cry:

The cart owner is adding products and the table products_with_attributes_stock is showing that the stock_attributes column is being loaded with measurementID,quantityID where as the demo ones I put in where only being loaded with measurementID. None of the stock_by_attributes files have been modified from the original files, so I would have thought it should be working?