http://1-2-3-direct.com/forum_stuff/multi_attribute.gif
Just packaging it up now :)
Printable View
http://1-2-3-direct.com/forum_stuff/multi_attribute.gif
Just packaging it up now :)
Description:
This module allows one to keep track of individual stocks of a product variant. For example, if you have three sizes, large, medium and small, this module will allow you to keep track of all the different quantities. It will work with an unlimited amount of attributes so you could have green, small, cotton shirts.
Download here:
http://1-2-3-direct.com/forum_stuff/produc...butes_stock.zip
dear dafonz
it will be a great module but can you tell me the differece between it and the "Attributes by stock" module by milosh , can they work together or their will be conflicts in that
Can't speak for whether or not they work together (I'm guessing likely not), but this allows you to have finer control over the stock.Quote:
Originally posted by ah_salama@Dec 1 2005, 09:27 AM
dear dafonz
it will be a great module but can you tell me the differece between it and the "Attributes by stock" module by milosh , can they work together or their will be conflicts in that
For example, with milosh's module, you can specify number of each attribute.. so it could be 5 black and 5 blue and 3 medium and 7 small.
Problem is, you don't know what is what. Is it 3 medium blacks or 3 medium blues? You don't know.
With this module, you can specify different stock ids..
so
3 medium blacks
2 small blacks
5 small blues
This is a really dumb question, but where do I go to add attribute stock? I can't figure out where to use this addon.
Catalog > Products with Attributes stockQuote:
Originally posted by cslhypnotech@Dec 1 2005, 10:41 PM
This is a really dumb question, but where do I go to add attribute stock? I can't figure out where to use this addon.
I checked the files for consistency using Winmerge, installed the tables, uploaded the files, and I'm not seeing this option.. I'll check my files again, any ideas?
I'm having the same problem, I uploaded all the files, ran the query etc and it doesn't give me that option under my catalog.
My bad.. I left out a file!
You'll need to edit admin/includes/boxes/catalog_dhtml.php and add this line (whereever you want)
Updated the zip to reflect that. Sorry about that guys!Code:// Edit
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK, 'link' => zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, '', 'NONSSL'));
// end edit
Thanks :) appears to be working perfectly!
Better way -- create file admin/includes/boxes/extra_boxes/products_with_attributes_stock_catalog_dhtml.php with this code:
Code:<?php
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK, 'link' => zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, '', 'NONSSL'));
?>
Hi wonderfullymade (just trying to consolidate everything.. responding to this post)
http://www.zen-cart.com/modules/ipb/index....showtopic=36921
Did you check your boxes? You can either edit this file here
admin/includes/boxes/catalog_dhtml.php and add
or refer to the post by a_berezin with using the overrirdes. I just prefer editing the file directly as I can place the link where I want it to in the menuCode:// Edit
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK, 'link' => zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, '', 'NONSSL'));
// end edit
Yes! I use the digit prefix in filenames for that. ;)Quote:
Originally posted by dafonz@Dec 7 2005, 12:45 PM
I just prefer editing the file directly as I can place the link where I want it to in the menu
Thanks!! That worked! Now I have to figure out how to get molish (I think it was) contrib that wasn't what I needed out of my system (sigh) I didn't back up, but my store isn't live or advertised yet so I have time to work on it.
::tup ::tup
installed it, works fine!
Does this mod correctly decriment stock #'s per attribute when orders are placed?
You betQuote:
Originally posted by afx114@Dec 8 2005, 07:50 AM
Does this mod correctly decriment stock #'s per attribute when orders are placed?
Hi,
Great contribution, Thanks.
I have noticed that when deleting an order the stock is not added back in, should it?
Thanks
I have yet to add any modules to my cart. I am working through things as I come to them, but I have a lot to learn about webspace in general, including Zen Cart.
There are plenty of references throughout the forums to "backup before making major changes" and "test this thoroughly before going live."
How do y'all test something before going live? Once in business your website is live 24/7. So where does the testing happen?
Bet ya weren't expecting such a bare basics kinda question :)
The Newbie,
Audra
Nope.. you'd have to make that yourself I think. I don't like the idea of deleting orders because logging everything is good...Quote:
Originally posted by longstockings@Dec 8 2005, 04:24 PM
Hi,
Great contribution, Thanks.
I have noticed that when deleting an order the stock is not added back in, should it?
Thanks
Have two seperate installs (one on local machine and one on live server)Quote:
Originally posted by audradh@Dec 9 2005, 12:45 PM
I have yet to add any modules to my cart. I am working through things as I come to them, but I have a lot to learn about webspace in general, including Zen Cart.
There are plenty of references throughout the forums to "backup before making major changes" and "test this thoroughly before going live."
How do y'all test something before going live? Once in business your website is live 24/7. So where does the testing happen?
Bet ya weren't expecting such a bare basics kinda question :)
The Newbie,
Audra
My orders doesn't show!!! i got the money but it seems like I don't know what da heck they ordered...
I need some help..
I am using 1.2.5d, and i've installed this module correctly and I set up all my products and all, but it doesn't display what they ordered on the admin page.
Please help me ASAP. Thank you.
This was never tested on 1.2.5d...
Anybody care to walk a newbie through their first module install as well as their first trip into MYSQL?
I have downloaded the module, read the read me file and poked around a bit.
So, the first step is to create the table. I have found my way into the database. The prefix on my tables is zen_, so I am good to go.
I have found the place to add a new table. I have figured out that the first line in the read me file is the table name and the subsequent lines are fields. The last line has me confused.
PRIMARY KEY ( `stock_id` )
)
What is the primary key?
I know, about as basic as it gets! One day I will understand all this :blink:
Audra
OK, I think I figured out the primary key. I have checked the radio button next to stock_id labeled primary. (I even read about primary keys on MYSQL.com although I must admit most of it was lost on me!)
Since I am here rambling I may as well describe the rest of the process as I see it. There must be another newbie out there as lost as I who will benefit!
After creating the table I now need to upload the files provided in the module to the appropriate folders on my server.
Hey, thanks for listening as I talked myself through this!
Audra
Sorry, I guess I do have one sticking point. What is the "Table Type?" I am assuming it is the default, "MyISAM." Is this correct?
Audra
Now I have a question about uploading the files. In
/ admin / includes / languages /
there is a file english.php to upload. Do I overwrite the existing file?
TIA,
Audra
Has anyone tried this? I added the file and no new option showed up under catalog. However, I have no idea what I am doing! I copied the php file, pasted it into notepad, saved it asQuote:
Originally posted by a_berezin@Dec 3 2005, 07:08 AM
Better way -- create file admin/includes/boxes/extra_boxes/products_with_attributes_stock_catalog_dhtml.php
products_with_attributes_stock_catalog_dhtml.php
then uploaded it to the specified place.
What did I do wrong?
Audra
I just tested this contribution and looks good. But when ordering a variation out of stock, the cart never throws an error or warning message for the customer.
A quantity overview for the customer would be awesome as well. ::tup
I am testing it right now. It allows me to place the item in my shopping cart, but displays a message that the item is out of stock or not available in the quantity ordered. I have configured my cart to not allow checkout for out of stocks. This is working as well.
Audra
Check your settings under Configuration->Stock perhaps?Quote:
Originally posted by masterblaster@Dec 11 2005, 06:57 AM
when ordering a variation out of stock, the cart never throws an error or warning message for the customer.
Although I would like to know why the 1st version did not work I did get it working by using da'fonz' edit instead.Quote:
Originally posted by audradh@Dec 11 2005, 06:30 AM
Has anyone tried this? I added the file and no new option showed up under catalog. However, I have no idea what I am doing! I copied the php file, pasted it into notepad, saved it as
products_with_attributes_stock_catalog_dhtml.php
then uploaded it to the specified place.
What did I do wrong?
Audra
Audra
Hello! Thanks for a great contibution! This is something i have been looking for!
I'm very new to zencart, and I don't know a thing about MySQL. I don't know what to do with this code:
[/CODE]
CREATE TABLE `zen_products_with_attributes_stock` (
`stock_id` INT NOT NULL AUTO_INCREMENT ,
`products_id` INT NOT NULL ,
`stock_attributes` VARCHAR( 255 ) NOT NULL ,
`quantity` INT NOT NULL ,
PRIMARY KEY ( `stock_id` )
) [CODE]
Shall i put it in the Admin -> Tools -> Install SQL Patches?
Hope somebody can help me! :blink:
Hey, Taflloyd! The code in the Read Me is what you'll use as a MySQL query. Whatever the website interface you're using, you'll find the section that allows you to administer your site's databases and paste the code into the text field used for MySQL queries. For example, if you use cPanel to administer your website and phpMyAdmin to administer your databases, running the query will add a table to your database with the fields needed to use the module.
How would I do that to put the menu item in position 2 of the Catalog menu instead of the end?Quote:
Originally posted by a_berezin@Dec 7 2005, 01:42 PM
Yes! I use the digit prefix in filenames for that. ;)
Trying to use overrides with this module, per this thread.
Instead of replacing database_tables.php (which would get overwritten in a ZC upgrade), I'm placing the database define
into /includes/extra_datafiles/products_with_attributes_stock_database_tables.php.Code:<?php
define('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK', DB_PREFIX . 'products_with_attributes_stock');
?>
However, I'm getting the error 1146 Table 'cfus_zc1.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist when I use Admin. Any ideas why the /includes/extra_datafiles define isn't being called? When I copied the file to /admin/includes/extra_datafiles it did work.
Rather prolific tonight, I am. What functions from functions_lookups.php do I need to put into an override file (which would go in /includes/functions/extra_functions)?
Hey!Quote:
Originally posted by mrtoner@Dec 13 2005, 04:14 AM
Hey, Taflloyd! The code in the Read Me is what you'll use as a MySQL query. Whatever the website interface you're using, you'll find the section that allows you to administer your site's databases and paste the code into the text field used for MySQL queries. For example, if you use cPanel to administer your website and phpMyAdmin to administer your databases, running the query will add a table to your database with the fields needed to use the module.
Thanks for your answer!
I use phpMyAdmin, and I found the query window, and paste the code. Selected the database and hit "Go". Nothing happened... What am I doing wrong?
If you're using phpMyAdmin, in my experience you need to 1) select the database, 2) click the SQL tab, 3) paste the query into the "Run SQL query/queries on database yyy" field, and 4) click "Go." If I'm reading your post correctly, you did two of those steps out of order. (I'm using phpMyAdmin 2.6.4-pl2.)Quote:
Originally posted by Taflloyd@Dec 13 2005, 02:23 PM
I use phpMyAdmin, and I found the query window, and paste the code. Selected the database and hit "Go". Nothing happened... What am I doing wrong?
Thanks!Quote:
Originally posted by mrtoner@Dec 13 2005, 04:36 PM
If you're using phpMyAdmin, in my experience you need to 1) select the database, 2) click the SQL tab, 3) paste the query into the "Run SQL query/queries on database yyy" field, and 4) click "Go." If I'm reading your post correctly, you did two of those steps out of order. (I'm using phpMyAdmin 2.6.4-pl2.)
I did what you wrote, and it seems i've already created the database, but when i click on the "Products with Attributes Stock" in admin, I don't see the table, only the heading:"Product ID, Product Name, Quantity of all variants, Add Quantity For Product Variant,Sync Quantities". I have products with attributes, but they don't show!
What am i doing wrong?
Thanks
::frust
Taflloyd,
Let me begin by saying that I am an idiot about all of this stuff! I did get this working, however, and know how it feels to be waiting for a response to your query :)
I assume you have uploaded all of the files in the module?
Have you actually gone into MySQL and looked at the table that you created? You can compare the table to the code. When you look at the table it will make sense, what should go where, but yell if you want to double check anything.
Do you have products w/ 2 different attributes per product? I don't know if that matters, but I do know that products w/ no attributes will not show up.
Hope that gives you a place to start,
Audra
?? The database is your Zen Cart database, not one you create. The query adds an additional table to that database (assuming you selected it). I assume you do not have the new table added to your Zen Cart database.Quote:
Originally posted by Taflloyd@Dec 13 2005, 08:11 PM
I did what you wrote, and it seems i've already created the database, but when i click on the "Products with Attributes Stock" in admin, I don't see the table, only the heading:"Product ID, Product Name, Quantity of all variants, Add Quantity For Product Variant,Sync Quantities". I have products with attributes, but they don't show!
What am i doing wrong?
I love this module!!
I have run into a bit of trouble. I am sure that it is user error, but I can't seem to troubleshoot it. I had 2 products that were set to zero quantity. I added in one of each. When I add the items to my cart I get the out of stock message. I check the Products-With-Attributes-Stock in the admin, and it says there is one each of these items. Hmmm. I have tried emptying my cart and starting over, but same thing. I have zeroed out the amount then reentered it. I have refreshed all pages.
Any thoughts?
Best,
Audra
Ya gotta add stocks for each one.. so..click on "Add quantity for product Variant" and go from thereQuote:
Originally posted by Taflloyd@Dec 13 2005, 08:11 PM
Thanks!
I did what you wrote, and it seems i've already created the database, but when i click on the "Products with Attributes Stock" in admin, I don't see the table, only the heading:"Product ID, Product Name, Quantity of all variants, Add Quantity For Product Variant,Sync Quantities". I have products with attributes, but they don't show!
What am i doing wrong?
Thanks
::frust
Can't quite do that as I rewrote a core zen functionQuote:
Originally posted by mrtoner@Dec 13 2005, 06:56 AM
Rather prolific tonight, I am. What functions from functions_lookups.php do I need to put into an override file (which would go in /includes/functions/extra_functions)?
Not quite following...Quote:
Originally posted by audradh@Dec 14 2005, 07:10 AM
I love this module!!
I have run into a bit of trouble. I am sure that it is user error, but I can't seem to troubleshoot it. I had 2 products that were set to zero quantity. I added in one of each. When I add the items to my cart I get the out of stock message. I check the Products-With-Attributes-Stock in the admin, and it says there is one each of these items. Hmmm. I have tried emptying my cart and starting over, but same thing. I have zeroed out the amount then reentered it. I have refreshed all pages.
Any thoughts?
Best,
Audra
So you have a single product that has two variants with quantities of zero? Then you update the two variants to have quantities of one?
OK, morning is here and my brain is a bit clearer. I did a little more testing, and at least found out what the trouble is.Quote:
Originally posted by dafonz@Dec 14 2005, 06:24 AM
So you have a single product that has two variants with quantities of zero? Then you update the two variants to have quantities of one?
I sell clothing, so my standard 2 variants are size and color.
Often I have an item in stock only in one color, but in multiple sizes.
Size is a dropdown w/ multiple variants.
Color shows in the catalog as a radio button (standard default for dropdown if only one variant is given), and the value has been marked as the default in attributes.
In this case, the items are showing as out of stock.
Any thoughts now?
TIA,
Audra
So does this module not prevent someone from ordering something that is out of stock? When one of the items is at 0 stock someone can still select it as it just says X items in stock where X is the total of whatever you have. Then that items inventory goes negative. Is there anyway to correct that?
This can be done in admin area:
Configuration->Stock->Allow Checkout
That works with or without this module.
HTH,
Audra
I don't think you understood what I was asking.
If you have 50 red balls 50 green balls and 50 white balls it's going to say you have 150 of them. Someone orders 50 red balls and now you have 100. The problem with this module is since it shows you still have stock they can order an item that is sold out. So since you have 100 balls left even though there are no red ones they could order 100 of them if they wanted to because it just says you have 100 and not 0 red 50 green 50 white.
That is what happens w/ Zen Cart as is. This module changes it so that it will check the stock based upon the attributes. There is a contribution by Milosh that will do the same based upon only one attribute per product. This module can handle products w/ multiple attributes.
As an aside, it seems to me that if you use this module it makes sense to turn off, in admin, the option of showing how many are in stock because it is misleading to the customer.
HTH,
Audra
Why would one choose to let someone purchase something that is out of stock. In the end it would only serve to frustrate the buyer. If you show the numbers or not it doesn't stop someone from ordering something you don't have.
As I said, that was just an aside.Quote:
Originally posted by greenteagod@Dec 14 2005, 03:04 PM
If you show the numbers or not it doesn't stop someone from ordering something you don't have.
The meat of the issue here is what I said originally:
Customers can be prevented from checking out w/ out of stock items by choosing that option in the admin area:
Configuration->Stock->Allow Checkout
That prevents customers from checking out when the stock quantity is zero with or without this module.
Without this module it will look only at that total number in stock. In your example #150. The setting would be useless as you stated.
With a module that tracks inventory by attribute you would have entered into your inventory 50 red, 50 green, 50 white. When Zen looks to see what the stock level is for red balls it will see 50, not 150. When there are zero red balls left, if you have configured the settings noted above, the customer will not be able to check out if there is a red ball in their cart.
::frust
Audra
After a little more troubleshooting I have determined that this is not the problem.Quote:
Originally posted by audradh@Dec 14 2005, 08:52 AM
I sell clothing, so my standard 2 variants are size and color.
Often I have an item in stock only in one color, but in multiple sizes.
Size is a dropdown w/ multiple variants.
Color shows in the catalog as a radio button (standard default for dropdown if only one variant is given), and the value has been marked as the default in attributes.
In this case, the items are showing as out of stock.
Any thoughts now?
TIA,
Audra
Now I am pretty sure that the problem is thus:
The module is working for all but one manufacturer. When products from this manufacturer are order they show up as out of stock despite having quantitiies entered in the product by attribute stock.
The module was iniitlally working, but now is not.
I have subsequently installed this module:
Column Layout Product Listing for Zen Cart v 1.2
Could this be the trouble?
Audra
Another change:
It is not the manufacturer either. I found a product from a different manufacturer that is not working correctly as well. I can't figure out the difference between the few products that are working correctly and the rest!
They seem to span
categories,
manufacturers,
quantity in stock,
with model# and without model#
2 choosable attributes vs one chooseable and one default
Any ideas about what other differences I might be able to look at?
Audra
OK, I have found the responsible variant and fixed the problem, but I don't know why it happenned.
I had a text only/read only attribute attached to a lot of my products. It was the products w/ this option name that were not being accurately accounted in the inventory.
I think it could have been one of two things: either the text only/read only nature of the attribute option was a problem or the fact that this added a 3rd attribute to the product was the trouble.
I don't have time to test it out right now (getting my inventory back up and running took more time than my kids had allotted me as it is!), but I will try and check it out later if nobody else can shed light on it before then.
I don't remeber da'fonz saying that the module could only handle 2 attributes, but I may be mistaken.
HTH someone,
Audra :)
other problems:
If I set the attributes as Multi-select, and want to order 2 pcs of the items for each attributes (i.e. 3 colors, red, green, blue). Then I input 2 in the quantity box and put in the shopping cart.
I suppose that it will show a quantity with total 6pcs in the shopping cart but it only shows 2 pcs and can't distinguish the quantity among the 3 colors.
Besides, it is better to show the quantity besides the attribute on the product_info page.
I believe it was the text only/read only nature of the attribute. It works just fine with 3 dropdown selects and the code should support an unlimited number of attributes.Quote:
Originally posted by audradh@Dec 15 2005, 02:45 PM
OK, I have found the responsible variant and fixed the problem, but I don't know why it happenned.
I had a text only/read only attribute attached to a lot of my products. It was the products w/ this option name that were not being accurately accounted in the inventory.
I think it could have been one of two things: either the text only/read only nature of the attribute option was a problem or the fact that this added a 3rd attribute to the product was the trouble.
I don't have time to test it out right now (getting my inventory back up and running took more time than my kids had allotted me as it is!), but I will try and check it out later if nobody else can shed light on it before then.
I don't remeber da'fonz saying that the module could only handle 2 attributes, but I may be mistaken.
HTH someone,
Audra :)
That doesn't work...pretend you have this on your pageQuote:
Originally posted by xingxing@Dec 15 2005, 05:05 PM
Besides, it is better to show the quantity besides the attribute on the product_info page.
Size
Big - 40
Light - 20
Color
Green - 30
Blue - 30
So how many of each variant do you have?
Oh! I don't think of the combination of the attributes.
Then a table lists all the combination will be better. But the table may be quite large.
I have to agree with greenteagod's point, though he didn't state it as I believe he meant: with this module, a customer is allowed to add items to the cart when the store is out of stock in that product/attribute combination. Without this module, ZC can be configured to disallow adding of a product when that product is out of stock.Quote:
Originally posted by audradh@Dec 14 2005, 07:30 PM
Customers can be prevented from checking out w/ out of stock items by choosing that option in the admin area:
Configuration->Stock->Allow Checkout
That prevents customers from checking out when the stock quantity is zero with or without this module.
As a customer, I want to be told a product is unavailable before I go to buy it. Don't waste my time by allowing me to add something to my cart that isn't available. Think like a user, make the store user-friendly. (More on user-friendly here.)
Again, that's not possible without extensive modifications of the core scripts.Quote:
Originally posted by mrtoner@Dec 16 2005, 07:14 AM
I have to agree with greenteagod's point, though he didn't state it as I believe he meant: with this module, a customer is allowed to add items to the cart when the store is out of stock in that product/attribute combination. Without this module, ZC can be configured to disallow adding of a product when that product is out of stock.
As a customer, I want to be told a product is unavailable before I go to buy it. Don't waste my time by allowing me to add something to my cart that isn't available. Think like a user, make the store user-friendly. (More on user-friendly here.)
You have to add it to your cart first before knowing it is out of stock.
Example: Size and color.
Let's say you have a matrix like this
Blue big - 0
Blue Small - 5
Green big - 5
Green small - 0
Now... there are two dropdowns. Customer selects Big. How would the system know to disable Green? The only way for that to happen would be either a page refresh (and a db query) or some use of AJAX. That's a pretty big addition.
Agreed and agreed. Landing on the mooon was tough, too. Don't get me wrong: I like your contribution. I just would like to have it all. B)Quote:
Originally posted by dafonz@Dec 16 2005, 07:34 AM
Again, that's not possible without extensive modifications of the core scripts.
...
The only way for that to happen would be either a page refresh (and a db query) or some use of AJAX. That's a pretty big addition.
Perhaps you and milosh (who seems to have solved the issue for individual product/attribute combinations) can work together to get something working for multiple combinations.
Is there a way to call the stock information of the attributes to be displayed on the page? Wether or not you can actually disallow a customer to add it to the cart, there should be a way to access the information about the stock per attribute, no?
Probably the best thing you can do then to make it user frienclly is to have your cart configured so that when an item is added it immediately takes you to the cart. The customer will then have the added key stroke of having to delete the item, but the knowledge is immediate. When the customer hits "Continue" from this page it takes them back to the page they were on, OK 2 extra key strokes. My cart was already set up this way, which is probably why I couldn't get my brain around what was being asked :)Quote:
Originally posted by mrtoner@Dec 16 2005, 03:14 AM
As a customer, I want to be told a product is unavailable before I go to buy it. Don't waste my time by allowing me to add something to my cart that isn't available. Think like a user, make the store user-friendly.
Best,
Audra
Has anyone installed this in a 1.2.5 store or is it only for 1.2.6?
Thanks,
Ryan
I wld like to make a suggestion, is it possible do the followings:Quote:
Let's say you have a matrix like this
Blue big - 0
Blue Small - 5
Green big - 5
Green small - 0
Now... there are two dropdowns. Customer selects Big. How would the system know to disable Green? The only way for that to happen would be either a page refresh (and a db query) or some use of AJAX. That's a pretty big addition.
1. display 1 attribute first (eg. Size attribute)
2. user select a particular size (eg. Big)
3. auto refresh page (and a db query), display the 2nd attribute (Color in this case), which in this instance, the 2nd attribute display only "Green" since "Blue" is out of stock for size "Big".
Just sharing my thought, not sure how challenging programmatically that is.
Great mod. dafonz.
Has anyone used this mod in conjunction w/ the Quick Updates mod?
Audra
stupid question. really stupid.
where on earth do i create this table? in a text file? where do i put it? :blink:
It is a table you need to insert into your database?Quote:
Originally posted by missyenta@Jan 18 2006, 06:39 PM
stupid question. really stupid.
where on earth do i create this table? in a text file? where do i put it? :blink:
Has this mod been updated with the code addition on the first page and any changes mentioned up to now?
I am also curious if this will work with Quick updates/Easy Mod before I install it and break something (old habits die hard...lol)
b
I'm trying to do step #1 in the readme:
Installation
-------------------------------------------
First things first, you will need to make a table. Assuming you have zen_ as a prefix for your tables, the following mysql code will work. Otherwise, modify `zen_products_with_attributes_stock` accordingly.
You do know of course that what you have put together here is what they call the "Holy Grail" of e-commerce? Aka Inventory by attribute multi-tiered. It has been sought after by clothing stores and others for nearly a decade. Which in Internet years is a Millenium.
However I have to put my $0.02 into this one. Especially since it is the Holy Grail for me as well.
First it needs to be modified to use the overrides system. Looks like that can be done with some simple structure changes and I may have that done soon.
Secondly the zen cart attributes/options system does lack and is EXTREMELY confusing. Sorry folks but comparing it to other carts it really is. While this extension is taking place I would suggest adding a attributes wizard to this contribution so that attributes and their options can be created from a single screen or maybe two. This wizard could then post creating the attributes and options and forward the customer to the variants page for editing of the variants if they wish.
Consider that the "Arc of the Covenant" and my $0.02.
Cheers,
BigWil
missyenta -
All that means is if when you installed Zencart, is you installed it with the function of adding the prefix "zen" to your database then you can install the sql as is.
If you installed it without the prefix (like I do), then you need to change:
`zen_products_with_attributes_stock` to `products_with_attributes_stock`
b
I'm also hoping someone out there may be using this in conjunction with Quick Updates.Quote:
Originally posted by bettysue@Jan 18 2006, 04:11 PM
I am also curious if this will work with Quick updates/Easy Mod before I install it and break something (old habits die hard...lol)
b
Anyone?
Best,
Audra :)
hmmm... if I added this mod to my doorknobs site how long would it take to enter all the possible product combinations?
Take one product for example: a simple doorknob set can have:
1 of 4 functions
1 of 2 backsets
1 of 2 door handings
1 of 15 outside finishes
1 of 15 inside finishes
1 of 36 outside knobs/levers
1 of 36 inside knobs/levers
1 of 12 rosettes on outside
1 of 12 rosettes on inside
too many choices to figure out on my fingers, but the trusty old calculator says that's a total of 671,846,400 possible combinations. Damn good thing they're made to order: I wouldn't want to have even one of each possible combination in stock...
whoops - i left part out. this is the code to make the table (follows the text I pasted in the last message):
CREATE TABLE `zen_products_with_attributes_stock` (
`stock_id` INT NOT NULL AUTO_INCREMENT ,
`products_id` INT NOT NULL ,
`stock_attributes` VARCHAR( 255 ) NOT NULL ,
`quantity` INT NOT NULL ,
PRIMARY KEY ( `stock_id` )
)
I know that this table needs to be created, just don't know how or where to do so ;)
thanks for your help so far, i really appreciate it!!
Go to Tools > SQL Patches and drop this into the big field there:
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` INT NOT NULL ,
PRIMARY KEY ( `stock_id` )
);
That should fix you right up. The key is to not use the zen_ in the SQL Patches tool as it will always add the table prefix required per its config file.
Also you were missing the ; at the end.
BigWil
whee, added the prefix that i somehow, for some reason have been using and it works like a charm. this should go into the readme, for folks who are as un-enlightened as myself :)
thanks a bunch bigwil!!
why i dont see nothing....??? :(
http://www.navidadboricua.net/erm.jpg
You have to give some of your products some attributes first.Quote:
Originally posted by danitus@Jan 21 2006, 06:40 AM
why i dont see nothing....??? :(
You have to give some of your products some attributes first. [/b][/quote]Quote:
Originally posted by afx114+Jan 21 2006, 06:44 AM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (afx114 @ Jan 21 2006, 06:44 AM)</td></tr><tr><td id='QUOTE'> <!--QuoteBegin-danitus@Jan 21 2006, 06:40 AM
why i dont see nothing....??? :(
how?
::frust
You have to use Option Names, Option Values and Attribute Controller from 'Catalog' on the top menu of Amdin. Start in that order to set up product attributes.
:)
Hello,
I'm confused by the following in the readme.txt file:
You will need to edit one core file which is the orders.php class otherwise the quantities will not update when a customer has made an order.
Where is the file and what edit do I need to make?
Thanks.
Ok. I will be giving the following modifications a shot. If anyone has any knowledge they can provide to get me over the learning curve it would be greatly appreciated.
A. Include a parameter under Configuration > Stock for "Use product variant system" true/false. Then modify the source so that if this is set to true then the module will go into effect. If it is set to false the old system will be used.
B. The first page of variants should show a list of products. When a product is selected from that list it takes you to the variants for that product. This will help with the lack of "Next/Previous" buttons and the long page that shows ALL of the variants. Which takes me to the next step.
C. On the product list page (see B above) add a drop down filter and/or a search bar to search for the product you want to work with.
These may take some time as I haven't got alot of time in my miserable existance. :( Please be patient. I will start with A above and move on to the rest as time permits.
Cheers,
BigWil
You might want to wait a slight bit before starting on those, I've made some similar enhancements to the system already and will be working with dafonz to release them in a new version.
How about on A being able to enable/disable? Are you working on that one already?
BigWil
Yep, I'm working on adding that right now. Almost done!Quote:
Originally posted by BigWil@Jan 24 2006, 12:30 AM
How about on A being able to enable/disable? Are you working on that one already?
Cool. Will it be an easy drop in replacement or will I have to use winmerge to keep all of my changes?
BigWil
It will be fairly easy because the majority of the changes are directly in the products_with_attributes_stock.php file. There will be some changes to the core files, but there won't be many.Quote:
Originally posted by BigWil@Jan 24 2006, 10:01 PM
Cool. Will it be an easy drop in replacement or will I have to use winmerge to keep all of my changes?
There will also be additional SQL statements to create the configuration keys and such..
Actually I'm finding out that an On/Off switch is pretty useless, because the code already handles everything normally whether or not there are products with attribute stock entered.
BigWil, what were you hoping to accomplish by making this module toggleable?
Update: I've turned this into a "Stock" in general module, meaning that you will also have the option to list/edit stock for products NOT having any attributes. This is handy because it allows your client to maintain all stock for all products in one centralized location. I've also added a couple of configurable options in Configuration > Stock so you'll be able to set up the tool to fit your needs.
I'm doing some testing now, waiting on some feedback from my client as well as dafonz, will hopefully have a new version for downloading soon!
Can't wait for this contribution as I have been looking around for alternative shopping carts today that have this feature.
Found one at www.cs-cart.com which is $125 but it won't display attribute images.
For a clothes shop this is a really big selling point.
Hoping it'll be ready in the next few weeks so that I can have a play with it
Thankyou for working on this contribution
I'll have a ZIP file for testing in the next day or two. If anyone wants a copy please PM me. I want to get some testing/feedback before actually releasing it.
One question I do have about this contrib is:
What happens when a stock attribute is sold out ?
Does it
A. Dissapear from the product attributes completely
B. Show a javascript alert saying out of stock when you try to select an out of stock attribute.
C. Other
If I have a T-shirt available in red or green and I sell out of red T-shirts I still want the option to be visible so that customers are aware that I can get the shirts in that colour. The customer can then contact the store owner to find out when that colour will be restocked.
Depeds on your settings in Configuration > Stock. But by default you can add it to your cart, and the cart will output a message saying that it's out of stock.
As well as the above, if your site is set up to go directly to the shopping cart and show the items that are in it everytime a product is added to the cart then the out of stock knowledge is instantaneous. IMO, this is the best scenario w/ the currently available options if you intend to leave products in the catalog that are out of stock.
If you would like to see this in action try adding the Sheer Halter in size large to your cart on my website. I don't expect it back in stock for at least a month.
Sorry, I don't know off the top of my head where the setting is for this. Perhaps someone else out there in Zen land can help if needed.
Audra
Nice site Audra! Unique, well organized, and pleasing to the eye! In other words....I'm jealous...lol
b