Printable View
Is there an issue using this mod with multiple attributes?
For instance, I have a product with color and size attributes. I have added 100 stock for each attribute and the product display shows 2800 in stock.
But, the dropdown menus for each attribute are empty. (Yes, I did add the attributes in the attribute controller).
Hi there...I have read the forum and only saw one reference to my problem and no resolution. The problem that i'm having is that when I go to the "Products with Attributes Stock" screen under "catalog" and try to "Add Quantity for Product Variat" I get the following error is I select "All" from each attribute:
Warning: Cannot modify header information - headers already sent by (output started at /var/www/dance/zen/zencart/admin/products_with_attributes_stock.php:193) in /var/www/dance/zen/zencart/admin/includes/functions/general.php on line 21
If I add them one by one by selecting the different combinations then i don't get any errors.
If i just click the back button after the error and refresh it looks like it works fine, but there seems to be a problem because it doesn't allow you to see the stock correctly (i'm using the dynamic dropdowns addon also)
I did a small test by adding one manually and then using the add all. then I had a look in the mysql table "products_with_attributes_stock". There is difference in how the attributes are added to the entry in the mysql table for the field "stock_attributes". For the one added manually with no errors and works properly with dynamic dropdowns, the attributes are in the following order: attribute 1, attribute 2, attribute 3, attribute 4. For the ones added by "all" in each attribute the order is: attribute 2, attribute 3, attribute 1, attribute 4. If i manually edit the entry in the table to put attribute 1 first then it works again. So it seems that the function that is adding the attributes for all combinations is putting them in the wrong order. Is there a fix for this?
John
ok kuroi - I took the plunge and started messing around with my database, but I'm a little stuck with this.Quote:
Originally Posted by kuroi
I exported the products_with_attributes_stock table from my database and took a look. I setup a test with two products with the same attribute combinations. Here was the results -
VALUES
(26, 1, '2,5,10', 100),
(27, 4, '20,24,26', 1000);
Each of the attributes are exactly the same (except stock) but there is a completely different combination of numbers to represent the combination.
Now say for product 1, if I add another set of attributes but only change one instance (say style) I would get something like '3,5,10' which makes total sense. But what I dont understand is how the numbers get their values for the other product numbers. Is there some sort of mathematical formula that correlates '2,5,10' equaling '20,24,26'?
If I try to run (through sql) say (28, 5, '2,5,10' 100) it says duplicate entry - making this mass add kinda difficult.
thx:smile:
Quote:
Originally Posted by Oakwood
I'm kinda new to zencart and this addon but i think i know the answer to your question. while the attribute might be the same when you add it to a product it gets another id. you can find these id's in the "products_attributes" table. you'll see that the attribute has an ID and it has a new ID each time it's associated with a product.
Ok so i see from another post the correction to the error I was getting. I removed the line and that works fine now. However I am still having problems with the attribute order while using the multiadd. The values are in the wrong order. I have the dynamic dropdown code also installed and when the values are in a different order the dropdowns don't work. Is there a way to make the multiadd put the attributes in the same order as a single add?Quote:
Originally Posted by jsu1972
Nope, that doesn't say what the new values will be on an individual product level.Quote:
Originally Posted by jsu1972
I'd be really happy if I could even add, for example:
style - men's
size - small
color - green, red, blue, black, tan
like that all at once from the admin or otherwise. This mod is essential but it takes FOREVER if you have say a possible of 300 different combinations of attributes per product!
Again, in my case the actual stock is not important, just how it incorporates with dynamic drop downs to create dependent attributes is vital.
If anybody has any clues on how to speed up the process please post! I even but something in the commercial help but no luck so far. :(
Still...great mod though!
did you open and look at the table called "products_attributes". if you look in the table you will see the attributes for your products...in your post before the last one you asked if there is a mathmatical formula that correlates one set of attributes to another. there is no formula...there is this table. so to "predict" what the values should be, look in this table for the product_id you want...then find the option_id's for the options you want to add...and then you can lookup their product_attributes_id and put it in the stock_attributes column on the products_with_attributes_stock table.Quote:
Originally Posted by jsu1972
ok - now I see what your saying. :cool:Quote:
Originally Posted by jsu1972
Well let me take that back...It just doesn't seem to work for me like it should when I pick the attributes from that table. I can cleary identify them, write them in and wallah, there they are in the admin...but not on the product page. The stock_attributes numbers are different from product to product but not repesented that way on the product_attributes table. It seems when attributes are added to a different product, zen cart picks up where it left off so to speak. So if the largest value of an option was say 40 for my first product, the smallest value of an option would be 41 for my second product. Hope that made sense.
So I've used this contrib before with ABSOLUTELY no issues.. However, I am working on a site that we are using the Super Orders contrib.. I haven't seen much specifically in this thread or the Super Orders support thread which talks about these two contribs together. So my question is this: can these two contribs play nice together? I am assuming they can with some edits to the orders.php and or super_orders.php files.. Some advice/information would be very much appreciated..
I'm hoping someone can help me. I have tried to install v4.7 of this addon and I'm getting an error message when I click on catalog->products with attributes stock It comes up with this message
Warning: main(includes/classes/products_with_attributes_stock.php) [function.main]: failed to open stream: No such file or directory in /home/eclectic/public_html/store/admin/products_with_attributes_stock.php on line 12
Warning: main(includes/classes/products_with_attributes_stock.php) [function.main]: failed to open stream: No such file or directory in /home/eclectic/public_html/store/admin/products_with_attributes_stock.php on line 12
Warning: main(includes/classes/products_with_attributes_stock.php) [function.main]: failed to open stream: No such file or directory in /home/eclectic/public_html/store/admin/products_with_attributes_stock.php on line 12
Fatal error: main() [function.require]: Failed opening required 'includes/classes/products_with_attributes_stock.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eclectic/public_html/store/admin/products_with_attributes_stock.php on line 12
Can someone please help me fix this????
Thanks
Emma
I could be wrong, but the error message seems to indicate a file is missing/damaged from your install of this contrib. Did you check whether or not "products_with_attributes_stock.php" is located in yourQuote:
Originally Posted by eclecticbaby
"home/eclectic/public_html/store/admin" directory??
Hi,
Yes the "products_with_attributes_stock.php" is located in that directory.
I've figured it out, thanks for you help DivaVocals
Hello there,
I too was stuggling to get this modification working, so that customers can see what is in stock for each attribute. I am grateful for any reply or help. I made the changes to includes/modules/attributes.php
JUST FOUND IT!!!!!
Make sure to edit the attributes.php in your override folder. Then change option name to Radio and it works!!!
Hope this helps somebody out there!!!
Quote:
Here's an addition that will display the actual stock amounts for each attribute next to the attribute name. You can see it in action on this product in my store.
Open includes/modules/pages/product_info/main_template_vars_attributes.php and make the following changes:
Replace
Code:
$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;
by
Code:
$sql = "select pov.products_options_values_id,
pov.products_options_values_name,
pwas.quantity,
pa.*
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " pwas
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 pwas.stock_attributes = pa.products_attributes_id
and pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
$order_by;
Next, in that same file replace:
Code:
if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_CHECKBOX or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_RADIO or $products_options->RecordCount() == 1 or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {
$products_options_value_id = $products_options->fields['products_options_values_id'];
if ($products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_TEXT and $products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_FILE) {
$products_options_details = $products_options->fields['products_options_values_name'];
} else {
// don't show option value name on TEXT or filename
$products_options_details = '';
}
if ($products_options_names->fields['products_options_images_style'] >= 3) {
$products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
$products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
} else {
$products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
$products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
}
}
by
Code:
if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_CHECKBOX or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_RADIO or $products_options->RecordCount() == 1 or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {
$products_options_value_id = $products_options->fields['products_options_values_id'];
if ($products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_TEXT and $products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_FILE) {
// $products_options_details = $products_options->fields['products_options_values_name'];
// gbm - replaced original line above to display attribute stock amount beside attribute
$products_options_details = $products_options->fields['products_options_values_name'] . ' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . ']';
} else {
// don't show option value name on TEXT or filename
$products_options_details = '';
}
if ($products_options_names->fields['products_options_images_style'] >= 3) {
$products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
// $products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
// gbm - replaced original line above to display attribute stock amount beside attribute
$products_options_details_noname = ' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . '] ' . $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
} else {
$products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
// $products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
// gbm - replaced original line above to display attribute stock amount beside attribute
$products_options_details_noname = ' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . '] ' . $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
}
}
Then open includes/languages/english/your_template/product_info.php and add the following line:
Code:
define('TEXT_ATTRIBUTES_PIECES','pieces');
Repeat for all languages in your store.
Hi guys,
Anyone using stock by attributes with the product cost price module?
Does it work together?
yes i listed this one in a differn't form - but i though i put it here (yes i know double adding) but this is the right place for it..
Ok just trying to add this mod to my site..
Stock by Attributes v4.7a
And they are telling me if i have a prfix such as "zen_" i have to fix the .sql up.. HOW do i do this as this is my config file...
Code:/ define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
Do I just install the sql update.. or do i have to modify it??? as everyother mod i did i didn't have to add antying to the mod??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` )
);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false',
'When customer places more items in cart than are available, show the available amount on the shopping cart page:',
'9',
'6',
NULL,
now(),
NULL,
"zen_cfg_select_option(array('true', 'false'),"
);
ME LOST and not a great data baser.... thanks...
:flex:
I don't much want to install any add-ons but will if I have to! I have version : 1.3.8a and I want to have different quantities for my attributes on my sunhats anyway of doing this without installing this add-on????
Thanks.
Newbie!:shocking:
Hello.
I have a problem that after installing Stock by Attributes of version 4.7 (also in 4.6) in Zencart version 1.3.7.1 I got an error message during order process. The message is:
Fatal error: Cannot redeclare class order in /home/www/slune.eu/subdomeny/www/includes/classes/order.php on line 1069
Can you give a hint where can be the problem? I guess that the problem can be some conflict with some other contribution. I have the following add-ons installed: Printable Pricelist, Edit Orders, Easy Populate, Image Handler.
Hi there,
I too, am having a problem. I am running 1.3.6 and have just added a product with 6 attribute variables.
http://www.naturalpod.com/shop/index...roducts_id=926
Each attribute has approx 6-7 options. Does someone know a fast way to set the quantity to say 999 for each variable. The amount of combinations/permutations to do it one by one would take forever.
tia.
A.
Here is my question has anyone developed a script that will automatically disable the attribute (such as Size 4) when the item is sold out?
So example: Size 2 (+4)
Size 4 (+2)
Size 6 (sold out) or remove the attribute all together
Size 8 (+2)
~Renee
Ok, I know this has already been covered in this thread somewhere, but I can't read through 50 pages to find it.
I am having trouble installing the mod. I think the problem comes from the renaming files portion or possibly the uploading. So, I will ask about both.
In the instructions is says to rename 2 files. Now, the second one was easy the name of the file was YOUR_CART just like in the instructions. The first was not. It says to rename includes/modules/YOUR_TEMPLATE but the file path is includes/modules/pages. Why would I rename "pages" which is in my directory to the name of my template (which is custom, btw)?
This does not make sense to me.
Second, I am using a net Ftp to make changes. Can anyone do a basic run through of the best way to upload this mod?
Thank you
wonderfull contribution but there is one problem....I cant delete a variant
So when i use multiple options the stock will be count double...
How can i delete a variant?
*Problem solved*
In english the product variant can be deleted. in my default language not...so i will check my default language
Either you, or your FTP program have left a backup copy of the orders class alongside your amended version. There are a number of posts earlier in the thread that explain the problems that this can cause.Quote:
Originally Posted by ldop
I'm puzzled. If you're going to set the stock to a high value for all variants, I can't see any benefit in setting it at all at attribute level. Why not just put a high value on the product and "manage" stock at product level.Quote:
Originally Posted by naturalolive
I doubt it. This would be of limited use beyond the case where every product had just one attribute, and heaps more complicated to generalize to multiple attributes per product. This is the sort of thing that would normally be written for a specific situation where the limitations of what is needed are well-defined and understood.Quote:
Originally Posted by Redcinamn
well done. :thumbsup:Quote:
Originally Posted by raimond
Hiya,
First of all this looks like a great product, thanks for developing and supporting it!
My Query:
Is it possible for customised attributes to be automatically applied to all products in a specific category?
For example
I have a category of hats
within this category every product i create will have a custom attribute of size with a drop down choice from 53 to 60.
I will also have a second attribute setup for hat colour with options red green blue etc...
All hat manufacturers will use this size scheme and colour scheme going forward so I will need to copy these attributes to any product i create in a certain cattegory.
Is there a way to make it so that when you add a new product within the hats category, that the two attributes above are automatically added to them?
I can then go in and ammend stock for each size/colour combination after bulk adding a number of different products under the hat category.
I have found the manual way to copy attributes to already created products via category.. but as I am giving end users a cut down admin interface to add their own products, i didnt want them to have this ability for obvious reasons of them accidentally applying attributes in bulk to all their stock...
Thanks
Martin
You're giving this mod way too much credit. All it does is manage stock for product variants. It has no involvement in creating products and adding attributes to them.Quote:
Originally Posted by megadood
I am trying to do my first custom adon and when I import in the mysql file into phpmyadmin it is naming the table using the database name (c-Panel), not just zen_ and therefore I am getting this error.
1146 Table 'sabrina_zc1.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="7"]
I have no idea how to edit the sql so that it does not use the database name.
This is the table for the database.
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` )
)
;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Show Attributes Stock', 'PRODUCT_STOCK_ATTRIBUTE_SHOW', 'true',
'Show the stock of items that have stock set by attributes?', '1', '500', NULL,
now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
UPDATE configuration SET configuration_value = "false" WHERE configuration_key = "STOCK_ALLOW_CHECKOUT";
Any input would be appreciated, thanks.
Using 1.3.8a and latest SbA and have a small error.
Admin > catalog > products with attributes stock
Click > 'Add quantity for product variant'
Size (only attribute) - 'All'
Quantity - Any number
Hit 'Submit'
I then get this error:
att: 41|42|43|44|45|46
Warning: Cannot modify header information - headers already sent by (output started at /home/path/to/products_with_attributes_stock.php:193) in /home/path/to/admin/includes/functions/general.php on line 21
Line 193 - echo "att: $attributes<bR>\n";
Line 21 - header('Location: ' . $url);
I thought maybe the R in bR was wrong (line break?) but changing it made no difference.
Thing is, although this error occurs hitting back button and accessing 'Admin > catalog > products with attributes stock' again shows the options updated correctly.
Other than that everything works perfect.
Any suggestions to get rid of the error before I show to the client?
Just as an update ...
I think the error might be caused by the fact that I have an attribute:
'Size: Select Size:' <- This attribute is read only but still gets assigned a stock level.
Just a thought.
I just want to say how good i have found this mod but only problem i have is updating the stock levels.
I have seen question about not being able to update than quantity a time.
I am now currently writing my first mod to be able to mass update quantity and stock attributes.
I have not writing a mod before so am asking for best advice how to go about it.
I know that this feature will be incorporated in new version of Zencart but I need this now as I sell stock more that 1 venue and have to update stock regularly.
Any help and advice would appreciated.
Once done I will gladly upload for all to use.
It's absolutely normal for the database name to be used as well as the table name, otherwise your MySQL server would be unable to differentiate between Zen Carts on the same server.Quote:
Originally Posted by jdimaging
The problem would be either than your configure files point to a non-existent database (which seems unlikely) or that you didn't edit your database prefix into the installation SQL before running it as per the installation instructions, so that the table has been created with the wrong name. You will be able to see and correct this via phpMyAdmin.
Answered a little earlier in this thread.Quote:
Originally Posted by bigbadboy
thanks kuroi I missed that reply.
Easy to do given the length of the thread. I find that searching via Google on error messages is a quick way of cutting through the tons of info to finding answers when there are error messages.Quote:
Originally Posted by bigbadboy
The trick is to identify information that is specific to the problem, but not your setup. In this case the following search string would take you there very quicklyQuote:
site:zen-cart.com products_with_attributes_stock.php:193
I was hoping there was a simple solution to what I hope is a simple problem.
- "Stock by Attribute" module is installed and working fine on a Zen-Cart clothing store site.
- We'd like it if a products out-of-stock options were not displayed on the product page -- we'd like the customer to not see a temporarily out of stock option listed.
I believe the option stock check would happen during the option array formation.
Any suggestions would be very appreciated! :smile:
What settings do you have on your Admin > Configuration > Stock page?Quote:
Originally Posted by InternetKev
Thanks for a great mod!
I'm using drop downs for my attributes, in this case 4 options for different coloured card.
If one particular colour of card is out of stock is it possible to display this next to the attribute in the drop down menu, eg:
Please Select Your Colour
Red
Orange (OUT OF STOCK)
Green
Pink
Thanks in advance!
Dunc
Is this possible with this module, anyone?
If not is there another module better suited? Thanks
Not directly with this mod, but it can be extended to do it. It's discussed several times in this thread already and there are pointers to information needed in the mod's FAQ.
Oops, sorry I must've missed it. Will take another look.
Thanks
For historical reasons, two big support threads developed for this mod ... worth looking (make that searching) in both. A good search term for this is "Grayson", though you would need to read on from there, as later posts explain further changes as a result of amendments to Zen Cart's structure in later versions.
I know this has been repeatedly diagnosed as files not being installed properly but I've done everything I can think of and I still can't get this mod to work. This is not my first attempt at installing a mod before and i've never had a problem! I have zen cart vs. 1.3.8a and I installed the Stock by Attribute 4.7MULTIADD (downloaded a week ago from the contrib page) I use DreamWeaver for my uploads but I have also tried transferring the files through windows explorer. I have the site in maintenance mode but this is the address: www.jensonsstore.com/storeQuote:
Originally Posted by kuroi
And my orders.php file says " * @version $Id: order.php 0000 2007-12-02 00:00:00Z kuroi $"
No matter what I do it doesn't control attribute stock only the product stock.
My customer wanted this site up tomorrow so they can get in on some of the christmas shopping that starts this weekend and be able to notify customers before they go on vacation! I've been struggling with this for 4 days!!!
Nevermind. I gave it one more attempt and it is finally working. not sure what i did different from the last 10 times i tried. but TG it's working now!
I've just trawled through 55 pages, 548 messages and lost about 5 hours of my life to this thread (not to mention the previous older thread too) in order to make the changes I wanted to the stock by attributes mod.
From start to end kuroi has provided regular and excellent support for this mod which, through no fault of his own, is far from perfect but nonetheless essential for many of us.
kuroi, I just want to doff my hat in your direction. Because f**k me, you've spent a lot of time on these forums, amassed an almost unfathomable number of posts and have a lot of patience for a lot of forum users who take a lot and give back little.
So seriously, thank you. Lets hope SbA and Zen Cart 1.4 come sooner rather than later because I think you're about ready for retirement.
On another note, anyone know how I can move the [1 in stock] to the end of the menu AFTER the price in the drop down menu...
Example of what I mean here:
http://www.tradersupplies.co.uk/inde...roducts_id=273
It seems a bit odd how the stock number comes before the price. I know Grayson posted a solution to this but his modifications to attributes.php don't seem to work on the latest version of SbA.
Aw shucks :blush:
I've never actually done what you've already suceeded in doing (never had the need) so this is a complete stab in the dark, but is there anything at around about line 31-32 of tpl_modules_attributes.php that might help you?
P.S. Grayson is a lady.
Hi. I'm having the same problem and it's not the order.php file... :( Everything else seems to be working so before I start messing with files, any idea which ones may be the culprit?Quote:
Originally Posted by kuroi
The other problem that has been seen occasionally is the presence of backup files mixed with the live files. Created either by the person doing then installation in case they want to go back, or automatically by an FTP client, these files are sometime inditinguishable by Zen Cart from the original files and both get executed. If the backup gets executed 2nd it can undo the work done by the file installed as part of the mod.Quote:
Originally Posted by laurenjj
Hmmm... but how is that possible if only one file with the same name is allowed?Quote:
Originally Posted by kuroi
:smile:Quote:
Originally Posted by laurenjj
Who said they were named the same? They're usually renamed slightly, but their very presence in certain locations means they get swept up and executed, irrespective of the name.
Hello. I recently installed the stock by attribute following the directions on the readme.
I've noticed that I've added a bunch of php files to the main directory as well as overwrite several core files.
I've read on other posts to always use the overide system but does this not apply to stock by attributes?
My concerns stem primarily from the likelihood of upgrading to a new version of zen cart in the future. Would I have to back up files i uploaded to install stock by attribute and put them back in after I make the upgrade?
hope anybody can help!!
Stock by Atributes can only over-ride over-rideable files and since stock management goes right to the heart of the system in places, not all the files are over-rideable.Quote:
Originally Posted by aruleal
More than that, it is unlikely that the current versiuon of stock by attribute would work with future releases of Zen Cart. It generally needs updating with each new release.
That's the negative. The positive is that from the next major release, you won't have to worry about this at all, since the functionality will be built into the core code, so no add-in will be needed.
Could anyone tell me whether the problems I describe below are caused by Stock by Attribute, or some other ZC config setting?
I'm having the following problems in IE7 only - Firefox is fine:
- The 'Please select colour:' attribute isn't shown as selected by default in IE7.
- If the customer just clicks 'Add to cart' without selecting a colour, ZenCart allows him to checkout without displaying an error.
- Even if the customer DOES select an attribute, it is not passed through to the checkout, and is not displayed on the order.
- Stock levels are not adjusted.
[I am using Stock by Attribute 4.7MULTIADD, I have 'Please select colour:' as the Default attribute, set to 'Display Only'.]
@skybluepunk
This sounds like a problem with how you have set your attributes up rather than a Stock by Attributes problem. I'd take a look at that default value as a I suspect that's your problem.
When you say that you've set it up as "display only" do you mean "read-only"? If so, then Zen Cart wouldn't expect customers to select a value.
First off I must thank for a great mod as this has been most useful for me on my own website.
I have just finished writing stand alone add on to this mod to do bulk update of stock value and will be submitting it soon.
When I was writing is I created a search and sort function in it.
As I was putting more stock on recently I was having to scroll right down to bottom of screen to add more attribute when I thought I might try to add the search and sort function I had just written to file products_with_attributes_stock.php.
I have now done this and seam to be working OK.
My question is where best to submit it as it only a small update would it be best to as full upload or on forum section
Regards
Steve
Hi Kuroi,
No, I don't mean read-only.
I mean that on the Attributes Controller page I have selected the options "Display only" and "Default". I understand that this is the preferred method to force the customer to select an attribute.
Hi Kuroi,
As a total coincidence, the solution for my problem has just been posted on the Wishpot Wishlist Management support thread
I have just relocated the Wishpot code, and all appears to be working fine now.Quote:
Originally Posted by amazeme
So, it was nothing to do with Stock by Attributes :-)
Thanks for your help,
Sheila
I have 2 questions. First off, is it possible to combine attributes, such as color and size, into one dropdown? Secondly how do I go about displaying QTY/In Stock status on the product info page per variant instead of per product?
Thanks,
Brandon
Same q! I just installed on 2 sites, and have it working for an event at JonesCoffeeCompany.com. I'd like it to either change an attribute to (sold out) in the drop down, or make it disappear. This would make this mod a huge addon to zen cart(in my opinion). I know you said not to ask for extra features, but I'm willing to help with this if it's possible.Quote:
Originally Posted by tatebn
Thanks!
I've lost count of how many times this question has been both asked and answered in this forum, and indeed this specific thread. This is part of the reason why the thread has gotten so long.Quote:
Originally Posted by tatebn
However <sighs> one last time, if you have more than one attribute, then there isn't an easy answer. There is a long and complex explanation as to why earlier in this thread. Though this will probably get easier in the future as we start AJAXing more and more.
If you have just one attribute then you're in luck, there is a solution. Just scroll back a few posts and you'll come across some pointers to it.
Same a!Quote:
Originally Posted by chuckienorton
Sorry dude, I'm usually good about not double asking, but did a thread search and didn't see anything like that. Now I've searched for "Grayson" and found some good stuff.Quote:
Originally Posted by kuroi
I agree. Dude, you are AWESOME!Quote:
Originally Posted by kuroi
Thanks!
ps - I know zen is supposed to add this (per your very first post here), but wouldn't your life be easier (since you're already posting all the time) if you just updated the mod with some of the changes. Maybe I can help.
I don't believe that I actually said that first met. That would be just too immodest even for me!
LOL. It would be even easier if I just stopped supporting the mod. However you have a point, and if I'd known how long it would be before the mod was rendered redundant, then I probably would have integrated some of the specific requests that come up over and over again in this thread.Quote:
Originally Posted by chuckienorton
However, the logic that I applied when I originally started the thread is even stronger now than it was then; the mod is almost at the end of its life. And there are two impediments to my integrating this specific change to it: firstly, that I have never actually needed to use the Grayson solution, which is why I only ever point people towards it, and secondly that somebody else has made changes to this mod which means that the version generating most of the questions now differs from that which those of my clients using it have installed.
But this is open source, so if somebody else wishes to continue the development, I was but the last to date in a fairly long line of developers who carried this functionality forward, and they would be most welcome to take up the mantle.
I think I m ay have posted this question in the wrong thread before. Sorry!
I followed all the instructions, all the files seem to be in place. However when I access Admin > Product with Attributes Stock I just get the following unformatted text:
I'm at quite a loss about what's happening. I went through and deleted all the backup files I had left on the server (ie old_orders.php) but all that did was make the spacing between the headings slightly larger.Quote:
Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync Quantities
:( Please help me someone!
I tried installing the Stock by Attribute add-on and when I click on it in the admin area I get a blank screen that says "No input file specified."
I'm not very experienced with databases so I don't know if I did something wrong with the database table or if I screwed up when I copied the files over to the server.
If someone can help me I can give me my login info if you need it.
Thanks!!
Nevermind!! I overlooked one of the files to be moved over. Thanks!
Please help - I ran the SQL patch then moved my files over - I cannot find anywhere in the attributes where I add an amount per attribute. It all still looks the same as before.
Also - how do I remove the database (I can't find it) so I can re-install? If I need to re-install.
DeAnna
www.raspberryjamcloth.com/shop
Never mind, I am so silly - found it!Quote:
Originally Posted by raspberryjamcloth
Sounds like you're missing the stock_attributes.css file from admin/includesQuote:
Originally Posted by Jenniferea
Hello!!
Thank you for the fantastic add-on! I installed it on a website running on version 1.3.8a and it works perfectly!
My question is.....is there anyway to have the products put in order by Product Model number instead of Product name?
Thanks for any help you can give!
hi carilivia
You can change the sort order by edit file
products_with_attributes_stock.php in your admin folder
Please make backup up of this file first before you try to change.
First find the following code that create the sql query as below
// Show a list of the products
$query = 'select distinct
attrib.products_id, description.products_name, products.products_quantity, products.products_model
FROM
'.TABLE_PRODUCTS_ATTRIBUTES.' attrib, '.TABLE_PRODUCTS_DESCRIPTION.' description, '.TABLE_PRODUCTS.' products
WHERE
attrib.products_id = description.products_id and
attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';
$products = $db->Execute($query);
once found change the line
attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';
to
attrib.products_id = products.products_id and description.language_id='.$language_id.' order by products.products_model ';
to have it sort by product model.
You could also pleace it with
attrib.products_id = products.products_id and description.language_id='.$language_id.' order by products.products_id desc ';
this will sort by product id in descending order so it will show newest product added first which is usually the one you want to edit.
Hope this helps
This worked PERFECTLY!!!! Thanks a million Stog!
=0)
I have the initial page in the admin working.
Once I click "Define Variant" i receive this error notice:
1146 Table 'dirtsq5_zc1.products_attributes' doesn't exist
in:
[SELECT pot.products_options_types_name AS name FROM products_attributes pa INNER JOIN (products_options po INNER JOIN products_options_types pot ON po.products_options_type = pot.products_options_types_id) ON pa.options_id = po.products_options_id WHERE pa.products_attributes_id = 195]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I don't understand what to do. Speak slowly when answering I am new with tables, db's, sql, etc.
Hello buddies,
Any way to have the variants sorted on the products_with_attributes_stock.php page in the same order as the attributes in the dropdown menu? For example, on the product page, the T-shirt sizes are ordered from small to x-large. There seems to be complete randomness in the display order on the PWAS page. There's the large variant listed before the small. Medium listed after the large. It looks correct in the dropdown box to the customers but what about the poor sap (me) who has to toil away, entering quantities for hundreds upon hundreds of variants? Alas, my labor is for naught, for my hard work is rife with mistakes because the variants are all unorganized. It's total and complete utter chaos. First, it's just a variant sort, then it escalates. White becomes black. Dark becomes light. What we have is everything we hold sacred in ruins at our feet. Please, help me. We must have order.
Thanks!
G-
I have spent much of yesterday and today trying to find the particular problem in the archived messages and can't find the exact problem addressed.
i am using zen 1/3/7 and I've installed Stock by Attributes v.4.7. I have attributes for color for some of my products. I am testing with one product until I work this out. The product has 3 color choices, clear, pink, purple. In stock are 2 pink,2 clear and 1 purple.
In the attributes controller, I had the flag set to "for display purposes only" as directed in the tutorial.When I select color and quantity and click "add to cart" I get this error message in a yellow box on the product page.
http://www.store.stitchinthyme.com/i...ns/warning.gif Please correct the following:
On the Option for: color You picked an Invalid Selection: Pink
So, I want back to the attributes controller and selected NO on the flag for display only. I did the same and, on got no error on the product page, but on cart page was this message:
http://www.store.stitchinthyme.com/i...ns/warning.gif Please update your order ...
Product Name: Jelly Sandals for American Girl ... Quantity Units errors -
You ordered a total of: 1 Units: 5
I updated the cart, but the message remains.
I know I must be doing some little thing wrong, but I can't figure it out and can't find it in the archives. I have searched several different ways, but I'm at a loss. I have many more shoes to list, but don't want to do it until I can set the color options.
I hope someone can help.
Also, one more request, please. I can't seem to find any link to start a new thread. all I can do is reply to threads already in progress and they don't always fit my situation. :frusty:
If anyone can tell me how to get the "post new thread" link, I would be so grateful. I have seen it in the past, but can't get it now.
Quote:
Originally Posted by stog
Hi Stog,
I'm wondering if you ever got an answer to your question... a bulk update of products would be AWESOME. I'm finding it very tedious editing the quantity for a product, then reverting back to the main listing... just to do it over and over again. I lose my place every time. Where can we find this awesome addition?
I'm also wondering if there is any way to get a listing page with all products and quantity on one single page, regardless of whether they have attributes. Right now you have to go back and forth when looking at products with and without attributes... there is no central location for updating stock... unless I am mistaken. Am I?
Quote:
Originally Posted by gregoryhenry
I'm also wondering this... ordering the attributes by stock ID would be ideal. Especially when dealing with many many products. Is anybody able to provide insight into this?
I made a while ago an additionQuote:
Originally Posted by swamyg1
Amendments from 4.7 to 4.7ajax
added ajax functionality
* search filter: "%ma" filters all produchts with "ma" in products-name or in products-model; the search value will be stored in a cookie
* a click at the "quantity in stock" value adds an input-field & you can enter the new value; the store button saves all changed values
* added files in /ajax folder
* changed products_with_attributes_stock.php
* added products_with_attributes_stock_ajax.php
you can see it in action at :: http://demo.zen-cart.at/index.php?main_page=page&id=26
download the test version at :: http://demo.zen-cart.at/images/produ...k_4.7.ajax.zip
WOW you are a lifesaver! This makes everything a breeze... thanks so much for sharing this!!!Quote:
Originally Posted by hugo13
I do need help with one last thing. I know it's been addressed several times but I cannot find the solution. I would like to show either:
1. on the product info page "out of stock" next to each attribute in the dropdown.
OR
2. Not allowing customer to add item to cart if no quantity for selected attribute. We could give them a message before they reach the cart.
Say I have 5 attributes for my product but 4 are out of stock... does a customer have to go back and forth adding each attribute until they find the one in stock? Sounds like a big guessing game.
Is there a solution for this? I can't seem to find it.
Hi all,
I have just downloaded this mod (not yet installed) and I just wanted to check something
I am using the super orders mod
I see that the attribute stock mod changes the following files
admin/orders.php
includes/classes/order.php
I dont think I am using these files anymore because of super orders
Does anyone know if this mod is compatible with super orders and if so what I would need to change from the default install instructions?
Thanks
Probably not out of the box. I'm not a Super Orders expert so I don't know if there's anything in there that uses stock in a way that's fundamentally incompatible with Stock by Attributes. If not you would need to identify the changes that each mod has made and merge them together to create a composite mod that includes the functionality for both.Quote:
Originally Posted by cjeb456
I actually ran into a problem with this... when clicking the dynamic field to enter the quantity, it's not saving to my database. When "editing quantity" the standard way, the value gets saved.Quote:
Originally Posted by hugo13
Any idea why this would be happening?
Quote:
Originally Posted by swamyg1
is there any error/message when you hit the "store button"; if you use admin-profiles, you must grant permission to 2 products with attributes stock-filesQuote:
* a click at the "quantity in stock" value adds an input-field & you can enter the new value; the store button saves all changed values
Quote:
Originally Posted by killertofu
Hi Hugo (and Kurio)... after much testing, it looks like it ist storing to the DB, but I'm having the same problem killertofu was in post 484. He never responded with more information... it's happening to me with more than one product, but all in the same category.
Here's a screen of what's actually happening in the DB... After editing the quantity of stock ID 126, stock ID 128 was created:
http://dev.perfectlocks.com/images/misc/duplication.jpg
Hello I installed stock by attributes but when I buy products that are out of stock, the cart still lets me buy them.
I've chequed files and the database, and everything seems to be ok...
Please Help.
Maybe if I reinstall the sql tables it will fix, how do I unistall the sql patch to install it again?
Trying everything.
Same question, I've been looking for a solution to this very same problem for a very long time.Quote:
Originally Posted by swamyg1
Does anyone know a way of modifying the code in the php files so that attributes with stock level=0 are automatically hidden or even deleted?
It's a mammoth task to manually disable/delete attributes every time a particular size for a particular item goes out of stock. Similarly, it's a total sale killer if a customer has to click back and forth just to see what's in stock!
Has anyone figured out which part of the code could be manipulated to achieve automation?
There is a setting in the admin>configuration>dynamic drop downs called "Show Out of Stock Attributes". I have tried setting this to False and I have tried setting it to True. Neither option has any effect on out of stock attributes so what is this setting even for?
HELP :-)
I worked on this for a while and found this solution using the Dynamic drop down mod.Quote:
Originally Posted by limelites
I'm using it here in my store.
But I'm having a major problem, my customers are finding it very confusing by not displaying them all options up front. This mod only displays options for quantites that are in stock. Some of my customers don't even see the "first select" "then select" options so they don't know what to do.
I'm thinking of killing this mod and just having customers go to the cart, so it's a total crapshoot as to what might be in stock. NOT IDEAL.
I would really like this mod to work, but not at the expense of the user experience. Has anybody come up with another solution or can anybody suggest what we should do to fix this?
I'm also using the dynamic drop down mod... however it does not seem to work at all.
As I said, there is a setting in the admin>configuration>dynamic drop downs called "Show Out of Stock Attributes". I have tried setting this to False and I have tried setting it to True. Neither option has any effect on out of stock attributes so what is this setting even for?
Can you tell me what your problem with this mod is? I've browsed your site and can't see any out of stock product attributes... isn't it working perfectly for you?
Did you manage to find a way for an attribute with qty=0 to disable automatically?
Well, I think you have it configured correctly. At least this is how I have it configured:Quote:
Originally Posted by limelites
Product Info Single Attribute Display Plugin > Multiple Dropdowns
Product Info Multiple Attribute Display Plugin > sequenced_dropdowns
Show Out of Stock Attributes > True
Mark Out of Stock Attributes > None
Display Out of Stock Message Line > True
Prevent Adding Out of Stock to Cart > True
I'm using the Ajax Stock attributes mod, I have 3 attributes which are not reflecting my stock... it just shows the stock unavailable by not displaying the option. That's my problem, I'm still trying to figure it out. I've tried deleting the attributes and readding them, that doesn't seem to work. I suppose the user experience is fine, I really have no other choice at the moment.
I don't think the dynamic dropdown mod is very complete. It seems to work, but it might have bugs with no support. I might be experiencing one of those bugs, I can send you the files I'm using if you PM me your email addy.
OK, I finally solved this and I've detailed the solution in this thread (post number #641 and #642)
http://www.zen-cart.com/forum/showth...=34977&page=65
Bad URL above... should have been:
http://www.zen-cart.com/forum/showth...756#post697756
is there a way for the individual stock qty to show for the different attributes of the product.
eg; product = tshirt qty 20 total
red tshirt = qty 10
blue tshirt = qty 10
I searced and i can't seem to find a step-by-step install process for stocks by attributes. I'm a new to this and i catch on pretty quick, but i can't seem to figure this out. How do i create a table? Is there a thread that has a step-by-step instruction on how to install? thanks!
Yes but it involves custom coding. Search for "Grayson"Quote:
Originally Posted by triollc
They're in the installation section of the readme file that comes in the add-in package.Quote:
Originally Posted by lizord