Stocks by attributes

mauryg:

If Kuroi posts an answer it will be more definitiveThat's an excellent response - comprehensive and accurate. Great job :thumbsup:

Thanx for both of you" kuroi, and mauryg" I believe I have the latest version from the stock atribute.

Saddly I can't generalize the size chart since I sell in my store as well as the web so certain styles are not available in all the sizes so I have to add those manually.

I guess Iam finding it time consuming since I have to upload 100s of item all at once which seems alot. " I had the same feeling when I have to add everything to my POS"

Lets just hope they will come up with zen 1.4 soon, I start to fall in love with this shopping cart because of guys like you that offer quick replies for free.

Thanx again.

Sami

Glamorousshoe,
I had forgotten I had answered the same question before for another shoe site. Look at posts #302 thru #305 in this thread. The problem with Easy Populate is that it uses 5 columns for EACH attribute you have and the spreadsheet, in my site, overran the Excel limit of 256 columns. Even Open Office couldn't handle it. But if the only attributes you have are the sizes, then this mod could be helpful to you.

Kuroi,
Thank you. It's always nice to get a kind word from the Zen master. :smile:

A random thought for Sami,
If you made each shoe a separate category and each size a separate product with it's own model number, e.g SHOE-Size, then you could use the CATEGORY description for the description of the shoe and had NO PRODUCT description page, then each size would have a BUY NOW button in the Category product listing and you could easily use the regular Easy Populate mod for adding the stock, price etc.

Thanks for the follow up
I already "master" the stock by attribute and The site is operating exactly as I wanted to do, So I will stick with what I know best.

I will wait to see how good the site would do before I start expanding in my studies for the Zen Cart, (Note: I only got the password for the admin panel from the developer yesterday) So Iam literally Fresh to this but so far so good, didn't break anything yet "knock on wood"

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.

Just a random question.

kuroi:

No. But my version of the mod does come with a readme file that lists the files that have been over-ridden. Remove the over-ride and replace the over-ridden files with originals from the release package for the version of Zen Cart that you are using, and the mod will cease to function.

Thanks for the idea. I don't know why I didn't think of that.

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??????

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?main_page=product_contrib_info&products_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 :(

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:

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.

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.

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!

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:

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".
4. Save the file to your desktop and open it with Excel as CSV.
5. 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.
6. When you have entered all the inventory numbers, save the edited file AS CSV from Excel.
7. 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.

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?main_page=product_contrib_info&products_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?

Glamorousshoe:

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

I don't know of any way, but there are a couple of small time savers you can use. I seem to remember that there was an extra confirmation step in the original mod long ago. I think it is in the old thread that there were instructions to omit that step...sorry I can't be more specific, it's been a long time.

The other thing is that after you add the quantity for the 1st attribute combination to product A, hit your browser back button (you don't even need to wait for the page to fully load) in order to add the next attribute combo to that same product A. That at least eliminates having to scroll down to the same product X times in a row. It's not much, but definitely saves a bit of time...
:bigups:
Audra

Thank you, I never thought about using the back button, that is a smart move and it does save the headache of searching for the product in the list.

Forward thinking A+

bencart:

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?

I have now fixed this so that Product Attribute Grid and Stock by Attributes work when the attribute grid is setup to use single attributes.

The file admin/products_with_attributes_stock.php needs this modification:

Original Code:

            foreach($product_attributes as $option_name => $options)
            {
                echo '<p><strong>'.$option_name.': </strong>';
                echo zen_draw_pull_down_menu('attributes[]',$options).'</p>'."\n";
            }
```Fixed Code:
```php
            foreach($product_attributes as $option_name => $options)
            {
                // if the option isn't the attribute grids dummy quantity attribute
                if($option_name != 'Quantity')
                {
                    echo '<p><strong>'.$option_name.': </strong>';
                    echo zen_draw_pull_down_menu('attributes[]',$options).'</p>'."\n";
                }

            }

Hi all
I need a little help to install SBA 4.7. I'm reading installation instructions and I'm using ZC 1.3.8(a).

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

In SBA 4.7 package I can find and rename includes/templates/YOUR_TEMPLATE but there isn't includes/modules/YOUR_TEMPLATE

Incorrect instruction, or... ?