-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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).
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
kuroi
No from within Zen Cart. For a mass add you would need to structure and upload the information directly to the database.
ok kuroi - I took the plunge and started messing around with my database, but I'm a little stuck with this.
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:
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
Oakwood
ok kuroi - I took the plunge and started messing around with my database, but I'm a little stuck with this.
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:
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
jsu1972
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 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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
jsu1972
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.
Nope, that doesn't say what the new values will be on an individual product level.
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!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
jsu1972
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?
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
jsu1972
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.
ok - now I see what your saying. :cool:
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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..
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
eclecticbaby
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 your
"home/eclectic/public_html/store/admin" directory??
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Hi,
Yes the "products_with_attributes_stock.php" is located in that directory.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
I've figured it out, thanks for you help DivaVocals
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Hi guys,
Anyone using stock by attributes with the product cost price module?
Does it work together?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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_');
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'),"
);
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??
ME LOST and not a great data baser.... thanks...
:flex:
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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:
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
ldop
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?
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
naturalolive
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.
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
Redcinamn
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?
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
raimond
*Problem solved*
well done. :thumbsup:
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
megadood
Is it possible for customised attributes to be automatically applied to all products in a specific category?
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
jdimaging
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"]
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.
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
bigbadboy
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
Answered a little earlier in this thread.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
thanks kuroi I missed that reply.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
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 quickly
Quote:
site:zen-cart.com products_with_attributes_stock.php:193
-
Re: Stock by Attribute v4.0: Hide Out-of-Stock Items
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:
-
Re: Stock by Attribute v4.0: Hide Out-of-Stock Items
Quote:
Originally Posted by
InternetKev
[*]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.
What settings do you have on your Admin > Configuration > Stock page?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Is this possible with this module, anyone?
If not is there another module better suited? Thanks
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Oops, sorry I must've missed it. Will take another look.
Thanks
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
kuroi
Mod allowing checkout when there's insufficient stock, even when the Admin Settings say not to.
That would be
this bead I think. The problem has been dealt with and is gone.
As Ellie observes, quite a few people have complained about this problem and so I have recently gone behind a few of their sites to look into this. In
every case the issue has proven to be that not all the files needed by the mod had been installed.
The quick test for other people having this problem is to download the includes/classes/order.php file from their site. If line 8 doesn't say something like the line below then there is a problem with the installation.
This is most likely due to a problem with the way in which the files are being FTP'd. Most likely because it involves overwriting some existing Zen Cart files and your FTP client may need you to confirm that you wish to do this. It's even possible that some FTP clients assume that the mod's files with an earlier timestamp than a later Zen Cart installation are less current than the files already there and just ignore the older but vital files.
However, whatever the reason,
anybody else tempted to post on this problem should first check that they have the correct version of the above file installed on their site.
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/store
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!!!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
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!
-
kuroi, you sir, are a legend.
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
kuroi
Mod allowing checkout when there's insufficient stock, even when the Admin Settings say not to.
That would be
this bead I think. The problem has been dealt with and is gone.
As Ellie observes, quite a few people have complained about this problem and so I have recently gone behind a few of their sites to look into this. In
every case the issue has proven to be that not all the files needed by the mod had been installed.
The quick test for other people having this problem is to download the includes/classes/order.php file from their site. If line 8 doesn't say something like the line below then there is a problem with the installation.
This is most likely due to a problem with the way in which the files are being FTP'd. Most likely because it involves overwriting some existing Zen Cart files and your FTP client may need you to confirm that you wish to do this. It's even possible that some FTP clients assume that the mod's files with an earlier timestamp than a later Zen Cart installation are less current than the files already there and just ignore the older but vital files.
However, whatever the reason,
anybody else tempted to post on this problem should first check that they have the correct version of the above file installed on their site.
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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
laurenjj
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?
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
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.
Hmmm... but how is that possible if only one file with the same name is allowed?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
laurenjj
Hmmm... but how is that possible if only one file with the same name is allowed?
:smile:
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.
-
Cannot use overide System?
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!!
-
Re: Cannot use overide System?
Quote:
Originally Posted by
aruleal
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.
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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'.]
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
@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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Hi Kuroi,
As a total coincidence, the solution for my problem has just been posted on the Wishpot Wishlist Management support thread
Quote:
Originally Posted by
amazeme
yes - can confirm this problem. works ok in Firefox but IE prevents ability to add to cart.....BUT only if you have the wishpot code included anywhere BEFORE the attributes module code in tpl_product_info_display.php
I have just relocated the Wishpot code, and all appears to be working fine now.
So, it was nothing to do with Stock by Attributes :-)
Thanks for your help,
Sheila
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
tatebn
how do I go about displaying QTY/In Stock status on the product info page per variant instead of per product?
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.
Thanks!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
tatebn
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
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.
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
chuckienorton
Same q!
Same a!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
kuroi
Same a!
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
Because f**k me, you've spent a lot of time on these forums, amassed an almost unfathomable number of posts.
I agree. Dude, you are AWESOME!
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
I don't believe that I actually said that first met. That would be just too immodest even for me!
Quote:
Originally Posted by
chuckienorton
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.
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.
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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:
Quote:
Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync Quantities
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
:( 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!!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Nevermind!! I overlooked one of the files to be moved over. Thanks!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
raspberryjamcloth
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!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
Jenniferea
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.
Sounds like you're missing the stock_attributes.css file from admin/includes
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
This worked PERFECTLY!!!! Thanks a million Stog!
=0)
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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-
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
stog
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 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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
gregoryhenry
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'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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
swamyg1
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?
I made a while ago an addition
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
hugo13
I made a while ago an addition
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!!!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
cjeb456
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?
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
hugo13
I made a while ago an addition
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
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.
Any idea why this would be happening?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
swamyg1
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.
Any idea why this would be happening?
Quote:
* 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
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-files
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
killertofu
Interesting problem, looking for answer. I love this addon, and thank the developer(s) for their hardwork.
I have been using this for a while, and worked perfectly. However, on one of my new products, I was going in to change the quantities of stock when it duplicated the variant. Now I have two variants for Green/Small. It seems to be only happening with this color, so I tried to delete the color and re-add the value (Luckily its localized to this one product :laugh:), but it still duplicates the variant when I try to go and edit the quantity.
Any thoughts?:wacko:
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Maybe if I reinstall the sql tables it will fix, how do I unistall the sql patch to install it again?
Trying everything.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
swamyg1
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.
Same question, I've been looking for a solution to this very same problem for a very long time.
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 :-)
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
limelites
Same question, I've been looking for a solution to this very same problem for a very long time.
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.
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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
limelites
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:
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.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
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!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
triollc
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
Yes but it involves custom coding. Search for "Grayson"
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+
Quote:
Originally Posted by
lizord
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!
They're in the installation section of the readme file that comes in the add-in package.