Printable View
Thank you very much for that. I actually already use the Improved Attributes Controller (i should have noted that, sorry) and it is indeed a big time saver. I guess i was looking for more of a multiple product at once tool. But i'll take what i can get and that does help. Thank you again for the suggestion.
Computer Candy
Now as I think about your question, there is another possibility. If you "Price by attribute", you could use Easy Populate to add the attributes to a whole category in one pass. Set up the attributes and then download an "Attributes" file. Open it in Excel, add all the product numbers in the first column and then copy ALL the attribute columns down for your newly added products. Put a price in the attributes you want to add, save the file (in text format) and upload it with Easy Populate to the database. All the attributes will be added to each product. If all of the attributes have the same price, the base price is set to zero and the product is marked "Price by attributes" = YES, then the total price will be the price of the attribute. OR you might be able to just set the base price to what you want, leave the product marked "Price by attribute"=NO, and set the attribute price to zero (haven't tried this yet).
Candy,
Am I incorrect in saying that all you are trying to do is add
4, 4.5, 5 ...through... 11 on every item in your store?
Then you would go into the Products with attributes stock and add each number of shoe available per shoe name?
Red
I hadn't thought if that. That is a good idea. I do not set prices by attribute, but i still might be able to use Easy Populate to accomplish this. I haven't tried that feature/mod yet but I will mess around with it and see what i can come up with. thX a lot! :DQuote:
Originally Posted by mauryg
Well, kind of. I am trying to add all shoe sizes to every product in the 'Shoes' category. (not to every product in the entire store) But you get the general idea.Quote:
Originally Posted by Redcinamn
That is what i am trying to avoid if i can help it. I have no problem doing it this way if i can't find a more efficient method. But if i can find a way to add all shoe sizes to all products in the 'Shoes' category in a more efficient shot, that would be a huge time saver for our initial setup. It won't be such a big deal later when we are just adding a few new pairs of shoes at a time but right now we are adding a lot. thX though. :wink:Quote:
Then you would go into the Products with attributes stock and add each number of shoe available per shoe name?
Red
-----
If i can use a cool little trick with Easy Populate as mauryg described, then all i really still have to figure out is how to hide sizes of shoes not in stock with the 'Cherry Zen' template.
thX again everyone for your great help! I am very quickly starting to see that i made the right decision by choosing Zen Cart just with the community support alone. :clap:
-CC
Candy,
I have confirmed that using EasyPopulate with the Attributes spreadsheet and setting the v_attribute_values_price column for EACH of the sizes to '0' (zero) WILL ADD that attribute to each of the products with NO PRICE. You will need to have a separate row in the spreadsheet for each shoe style. So if the price is the same regardless of size, this will add the size selection feature to each of the shoes. The price will be the base price if the "Price with Attributes" is set to NO. Once that is done you may find that "Stock with Attributes" will treat each of the sizes as a separate product and maintain the inventory for you.
Hope this helps.
That is fantastic mauryg! thX so much for going the extra mile and then some. It is truly appreciated and will save a lot of setup time.
Also, i want to thank everyone again for being so nice to someone who is new to the neighborhood. It didn't take long for me to feel at home. :D
P.S. Since i've gotten such great help, i thought i'd push my luck and ask again about hiding out of stock attributes. Any help would still be great. :wink: There seems to be some good starting suggestions here but i've still had no luck nor have i via searching the forums.
Hi,
Sorry if this has been posted, I've been searching the thread but don't see an answer.
I have one product with 2 attributes. When i try to add stock i get 2 drop down boxes, 1 for each attribute. You must select a value from each drop down box and enter the quantity.
My problem is that my attributes are not related, the product is made up fo 2 articles, eg a football strip, you buy one outfit and it is made up of a shirt and shorts. I have different quantities and different sizes, so i need to enter the quantities independantly.
Anyone had the same problem, any ideas.
Cheers
Andy
Stock by Attribute doesn't differentiate between attribute combinations created individually through the Admin, or in bulk through Easy Populate. It's happy to work with either. Though it would still be necessary to add the stock on combination at a time.Quote:
Originally Posted by mauryg
Actually your attributes aren't really attributes in the way in which Zen cart understands the term. They are two physically separate products combined to create a product bundle.Quote:
Originally Posted by gandalf
Zen Cart can't handle this at present. Indeed, to do so would require a very different data structure to that currently used. The complexity is that the sale of a particular product bundle (e.g. red shirt + blue shorts)can affect the stock of other product bundles (e.g. white shirt + blue shorts and yellow shirt + blue shorts). Handling this inter-dependancy between product bundles is not part of core code, nor to my knowledge planned to be added.
The best that I can suggest is treating your products as separate products (red shirt, white shirt, yellow shirt and blue shorts) and then linking each shirt to appropriate colored shorts, and visa-versa, via the cross-sell module. Otherwise it would require a ton of custom development.
Thanks Kuroi,
Understand, will check out your suggestion.
Thanks
andy
I no longer have the wherewithall to test it and run it with anything else.Quote:
Originally Posted by shannda
Can you tell us more about how you performed the upgrade? And what version you upgraded from?
Thanks for you reply. I was running Stock Attribute v3.01 under zencart 1.3.0.2. I followed the instructions step by step and since having the problem I've gone over several times. Basically at a loss, normally I can figure this stuff out but with this one I'm stumped.
The version 4.5 package doesn't include any instructions for upgrading from version 3. Which instructions did you follow? In particular, did you run any SQL?Quote:
Originally Posted by shannda
I have the same issue problem as shannda and am interested in the solution.
In my case, the shopping cart recognizes when the order will exceed the OVERALL available inventory level for a particular product and it properly displays the "mark product out of stock" message in the cart. However, when there is insufficient inventory for an INDIVIDUAL attribute (i.e. Small size), the cart does not display "mark product out of stock" (re: Admin>Config>Stock). What happens is the order becomes a purchase without sufficient inventory and the customer is not alerted that they are purchasing a "back order."
Suggestions greatly appreciated!
I am running a fresh install of v1.3.7.1 with a fresh install of the mod v4.5.
websitebob
p.s. great work on the mod!
I have heaps of test environments with the mod installed and have never been able to replicate this problem. If somebody has a non-live but publicly accessible Zen Cart with this problem and is prepared to let me poke about behind the scenes (i.e. give me FTP access) I'm rather curious to understand what is going on here too.Quote:
Originally Posted by websitebob
I installed this mod and did not realize that every product with attributes would suddenly be set to zero. We have shirts that are produced when ordered so the mod will not work for me as you have mentioned before in this thread in term of infinite stock items. How does one go about safely removing this mod?
Thanks Kuroi
I'd give you FTP access, except I'm working on a standalone (MAMP). I can email you a zip of the site (about 4MB) with a SQL dump if you'd like to test that. Just PM your preferred email.
Thanks and regards
websitebob
Hi.
I have installed danielcor's Stock Attribute 3.01.1 module and am getting the following error when i click DEFINE VARIANT in the Admin under Catalog > Products by Attributes Stock:
1146 Table 'realdnahair_co_uk_-_001.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 = 553]
Any idea what this means or what could be done?
Thanks, Kyle Duncan
It means that the table "product_attributes" doesn't exist in your database.Quote:
Originally Posted by kylelondonuk
How did you install the database patch?
I uploaded the SQL file from the download via zen admin install sql patches. it successfully created the zen_products_with_attributes_stock module.
but the table zen_products_attributes does exist... i've been using products that have attributes for a while now without problems.
is one of the php files with this module just missing the code that adds the zen_ prefix or something?
just a thought, i have super orders 2.0 installed, could this cause a problem since i know it also updated order php files?
Thanks, Kyle
sorry i meant that the SQL file i uploaded in Zen Admin successfully created theQuote:
Originally Posted by kylelondonuk
zen_products_with_attributes_stock TABLE, and added all the necessary values to the zen_configuration table. so it must be an error in one of the php files that came with the module i guess?
thanks
The SQL that comes with 3.01.1 doesn't use the prefix zen_. That was a bad approach taken in Danielcor's original 3.01 version. So I wonder whether you have downloaded the older version, which has a few minor bugs.
Eitehr way, you should be able to correct this by editing the "zen_" out of the table name in your database.
However, unless you are using Zen Cart 1.3.0, 1.3.0.1 or 1.3.0.2, I wouldn't recommend the Danielcor mod. Stock by Attributes is very sensitive to the version of Zen Cart with which it is paired.
Thanks to Kuroi for the prompt assistance.Quote:
Originally Posted by kuroi
I sent him a zip of my test site and he quickly found that I did not overwrite 3 of the files. Admittedly, I tried to go slowly through the mod installation. But, it gets tricky because several of the admin and includes files carry the same name in both folders.
My advice to anyone else out there.... always back up before you drag new files in from a mod and overwrite the existing files. Its easy to lose your place and its tricky to undo. Better yet, work with it first on a standalone server, if you can.
This mod rocks.
Kudos to Kuroi!
websitebob
i've been reading through this section for over an 2 hours now and i'm trying to figure out this one problem i have, hopefully there is an answer out there.
1. for Products marked with *** are out of stock warning in the shopping cart. instead of having the *** next to the item name i'd like to have the available stock quantity listed.
i seen this somewhere earlier i just don't know where it is.
I'm sorry that I'm slow in getting this, but I see the thread that you are referring to, but I don't understand what I'm supposed to change in the attributes.php file to make the quantity show in the attribute. Thanks for any information that you can provide!Quote:
Originally Posted by woodlandsprite
yeah i'm giving up on this i how version 1.4 will have all this covered for us
Does anyone know when version 1.4 will come out? I can't release my online store until the stocks is displayed by attribute, so I'm really anxious to make this work.
I think I heard 2008. I doubt you will get a more specific answer than that until the day it is released. Unless of course they revise 2008 to 2009:cry:
I too doubt that you will get an answer more specific than 2008.
Also a word of caution. Although the integration of stock by attributes into core code in 1.4 will be a major step forward, it won't suddenly deliver the many additional approaches to setting and displaying stock that are frequently asked for in this thread.
What it will do is make the development of these additional requirements as add-ons much more worthwhile.
Hi there
I would like some practical examples of how to set up option names values and attributes, is there any threads that explain this in examples way?
Thanks for your help
Franco
This is the definitive FAQ entry. I don't know of anything more illustrative than this.Quote:
Originally Posted by francocauter
Am I being stoopid?
Hi
I read the Wiki for this and was looking to add the values to each option - from the archive it suggests a post by grayson to amend
includes/modules/pages/product_info/main_template_vars_attributes.php
well... I can't find that file? has it been superceded... ? or is my install missing it?
Christine
Ok - I was being stoopid - the file has been superceded by attributes.php.
Have to say though it has taken me hours to find this out... guess I should have realised when the Wiki pointed to such an old thread.
Christine
When I run the SQL file to install this mod, I get this error:
1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[INSERT INTO zen_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')," );]
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.
...not exactly sure what's causing this, or what I can do to fix it. Any help would be appreciated!
@aesthetics
There's nothing to fix. It means that the configuration table entry is already there, so there's no need to run the SQL.
Maybe I'm missing something horribly obvious then...
The Readme file says to use the mod to click on Catalog/Products --> Products With Attributes.
...I don't have a "products with attributes" selection in that dropdown. Just my normal "categories/products" section.
Am I missing something?
Are you sure that it's "Stock by Attributes" that you're using and not one of the earlier versions upon which this was built, as none of the readme files since it's inception have said that. They all say that it's in the Catalog -> Products With Attributes menu.Quote:
Originally Posted by aesthetics
If you are using this mod specifically, but it doesn'ty show in the Admin > Catalog menu, that means that the files have been put in the wrong place. I'd recommend starting by checking the extra box file as that's the one that causes it to be shown up in the Admin menu system.
Sorry, it is Catalog --> Products With Attributes. It's most definitely Stock By Attributes.
When I uploaded the files, I uploaded the includes and admin files straight to the root directory (unless I mis-read, that's what the readme says to do to install the mod), so I'm not sure how they would have gotten in the wrong place.
Where is the extra box file so I can check it?
Sorry if these questions are way basic/vague. I'm new to this program. I really appreciate the help though!
Okay, sorry, I'm an idiot, hahaha.
When I copied the files into my root directory, I copied them into the root directory for the website, rather than the store. Oops!
Thanks for the help! I think I'm set!
Easy mistake and one that <cough, cough, embarassed look> I've made myself before now. :blush:Quote:
Originally Posted by aesthetics
I have read through everything I could find on negative stock problems in the forum, but I am still having trouble.
I am using Stock By Attributes 4.6 on ZenCart 1.3.7.1
I have config>stock>allow checkout set to false, and I set each stock quantity through catalog>products with attributes.
For example, I will have a T-shirt with the following attributes & stock:
T-Shirt Design #1
Small - 5
Medium - 2
Large - 1
X-Large - 8
Someone will be able to checkout with 2 Large t-shirts in their cart and stock goes to -1.
I don't know why this is happening. When I go to test it (on the same product that was just checked out) I am unable to checkout myself. So, it seems very inconsistent.
I have even had times when a certain size was set to zero (0), and they could still check out!
Any clue to why this might be happening? Possibly I have something configured incorrectly.
Any help is appreciated as this is driving me (and my customers) crazy.
Quote:
Originally Posted by kuroi
Thank you for the quick reply. I think my situation might be the latter link you posted. I am going to comb through my files and make sure.
I just went through my entire site and I don't have any duplicate copies of any files. So, I guess that is not causing the problem. I also have line 8 on orders.php showing up fine. Any other ideas?:(
Sorry for all the posts... I thought I would re-install the the stock by attributes mod again just to see if that would clear things up, but when I tried to install the stock_attribute.sql it gave me this error:
--
1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[INSERT INTO zen_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')," );]
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.
--
Would this have anything to do with my problem? I'm not sure why this is coming up.
I just tried to setup this module on my store and came across a couple of problems:
1. I was able to order items even though there were not enough in stock. On clicking 'checkout' there was no message to say that the item was out of stock but I was not able to proceed beyond checkout.
2. On trying to order any item in my store I was faced with the following error message:-
Fatal error: Cannot redeclare class order in /home/961/keela07/www.keela.co.uk/public_html/includes/classes/order.php on line 20
Any idea what might have gone wrong? It all looked fine from Admin. I have now stripped the contibution files off my site and it's working fine again.
PS. I had Configure > Stock set to the correct settings
This just means that you didn't clean out the configuration settings from the first install before you tried to re-install. It's not a problem. You can just ignore it as it confirms that they're already there.Quote:
Originally Posted by atomage
Okay, so if that is fine that means my problem is still something else then. any other ideas?
The most common cause of this problem is leaving a backup files littered across the site resulting in the wrong getting executed in some places, and errors about trying to do the same thing twice where that's not allowed.Quote:
Originally Posted by high2K
I am attempting to add the quantity of each attribute next to the product. I am using the following thread for instructons: http://www.zen-cart.com/forum/showth...=25987&page=28 (It's post number #272.) I'm updating the attributes.php file, and it all displays properly; however, the attribute information is not carried over to the shopping cart. Once I add an item to the shopping cart, it displays 1 shirt, but it doesn't indicate the size. Therefore, the order doesn't indicate the attribute either. When I undo the changes I made to the attributes.php page, the attributes are carried over to the shopping cart, but the quantity is not displayed on the product page. Any ideas what I need to check? I feel like I've gone over the instructions countless times, but I'm just not seeing what needs to be changed. ANY suggestions would be so very appreciated.
This didn't do the trick. It still says the product is backordered no matter what combination I use. :(Quote:
Originally Posted by kuroi
I'd love to get a quickie guide on how to tweak the database to get this done. Which tables, how do I find what I need? The SQL syntax for the INSERT or UPDATE would be helpful. I just want to be able to set this type of product to have all attributes to super high and never have to touch it again manually.
What version of Stock by Attribute are you using, and what version of Zen Cart?Quote:
Originally Posted by sobebabies
Why, is this fixed? I have v4.4 and 1.3.7. Upgrade scheduled but tough time of year!Quote:
Originally Posted by kuroi
4.4 is an all or nothing version which requires attribute stock to be set up for all attribute combinations, or they're treated as zero and orders then go to backorder.
Download version 4.6 (not 4.7) and take replace only your includes/functions/functions_lookups.php with the one from the newer version.
This is the change that allows the product level quantity to be used when no attribute level stock has been set. The change was made for a client in a very similar position to you and is working perfectly for him.
Thank you so much! :hug:
Is there a way to add 'X' stock to each product?
I already have the car populated with products and attributes. What I want, is to add 'X' stock to all products with an attribute.
I was thinking SQL?
ANyone have an idea?
I have ZenCart 1.3.7 and have just upgraded Stock By Attributes from 4.4 to 4.6, which seems to be fine.
One thing is confusing me though:
I have a product that has 3 attributes A, B and C, and I have put a quantity of 1 at product level and deleted all the product variants at attribute level. This now allows one product to be ordered for of each of the attributes - 3 in total.
Is this the expected behaviour, or should it only allow a total of one product to be ordered regardless which attribute is selected.
Any help would be appreciated.
SQL is the answer. But the devil will be in the detail of the type and number of attributes on each product, which version of stock by attributes you're using and whether you intend to use attribute stock for all products with attributes or just some of them. Even in the simplest of the cases, the SQL's going to be very complex. The table structure just doesn't really work well with this approach.Quote:
Originally Posted by osdude
I'm afraid that's how it works. But that's nothing to do with stock by attribute (which you've effectively disabled for this product). It's core Zen Cart doing this. Each time a customer adds a product to their cart, it checks against the product stock level and not other products already in their cart, or already in the carts of other shoppers on the site at the same time.Quote:
Originally Posted by dab
Thank you for your quick reply kuroi.
This helps me understand what is happening, and confirms that things are working as they should be. It makes a lot more sense to me now.
I do have many other products which make more effective use of your mod, but it was just this one that was confusing me.
Thanks again for your help.
I've played around on a test site and so far, I've managed to mess it up every time. My SQL knowledge is less than good, so I think my time would be better spent adding the products manually.Quote:
Originally Posted by kuroi
Is there a way to make new products add 'X' stock by default when adding attributes? I hadn't thought of this, but I will dig into the code to see if anything jumps out at me...
Thank you for your reply
New (?) problem with version 4.7 on ZC1.3.8.
Did a new install of Stock by attributes 4.7 in ZC 1.3.8. Setup up the following attribute stock:
8" Scrapbook
Blue - quantity = 1
Ivory - quantity = 3
Did a test buy, and was able to order without an out of stock warning:
Blue - qty = 4, and concurrently
Ivory, qty = 4
Received an out of stock warning for Blue if I ordered 5 or Ivory if I ordered 5.
I expected it to block attempts to order more than 1 Blue. or 3 Ivory. Is this a bug in the new release, or what is wrong?
frustrating problem with ver 4.3 on 1.3.6.
The quantity discounts is not calculating correctly.
item x should be 18.00 for quantity > 6. If I order 3 of one attribute set and 3 of another, the second 3 items receives the discount correctly, but the first 3 stay at the non discount price (18.50).
Have I set something incorrectly?
Zen Cart's attributes system (in 1.3 and earlier) knows nothing about stock. Moreover, stock by attributes holds stock for combinations of attributes, rather than for each attribute.Quote:
Originally Posted by osdude
So to add stock at the same time as adding an attribute, would require custom coding that reflects the specific way in which you are defining your products.
In every case that I have investigated it has been due to an FTP or installation error.Quote:
Originally Posted by cropinstop
Please take a look at this post and this post for an example of each. For version 4.7, the version info is updated toQuote:
* @version $Id: order.php 0000 2007-12-02 00:00:00Z kuroi $
Sorry crankyjim, I've no idea. This is the stock by attributes support thread which doesn't affect discounts, with or without attributes, in any way. I recommend doing a forum search on quantity discounts.Quote:
Originally Posted by crankyjim
Thanks for the reply.
I was thinking it might have something to do with the Stocks By Attributes add-on, since it seems to be affected by choosing the different attribute combinations. When only one attribute combination is selected, then the discounts calculate correctly.
I will keep looking. Thanks again! :)
In post 188 from http://www.zen-cart.com/forum/showth...=25987&page=19 is explained how to add stock quantities to attributes on the stock info page. I just want to have the text 'in stock' or 'out of stock' next to it.
Can somebody explain me how to implement this code:
with this code for drop down menusCode:if ($products_options->fields['quantity']) > 0) {
$products_options_details = $products_options->fields['products_options_values_name'] . ' [' . TEXT_ATTRIBUTES_IN_STOCK . ']';
} else {
$products_options_details = $products_options->fields['products_options_values_name'] . ' [' . TEXT_ATTRIBUTES_NOT_IN_STOCK . ']';
}
I just need an if command to have eitherCode:$products_options_array[] = array('id' => $products_options->fields['products_options_values_id'],
'text' => $products_options->fields['products_options_values_name'] .' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . ']');
TEXT_ATTRIBUTES_IN_STOCK or TEXT_ATTRIBUTES_NOT_IN_STOCK when not in stock.
Thanks
Hi i am a new Zencart user and have just intalled the Stock by attributes. Everything seem to be working correctly except that i can checkout with no stock. Does anyone know the cause and correction for this? I would be very greatful for any help.
Even though i have the Configuration>Stock>"Allow Check Out" to FALSE, i still appear to be able to check out on attributes that have no stock? Even though the warning that the out of stock warning appears ok, you can still proceed to the checkout.
I think this because i have to total stock updating (automatically) in the Catelog>Categories / Products sections. i.e if i add 10 units for size small, the total stock in Catelog>Categories / Products sections changes to 10.
Could this be something to do with running the stock attribute SQL? in the Tools>run SQL patches. When i try to run this i get the following:
" 1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[INSERT INTO zen_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')," );]
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. "
Nectarina
The SQL error is just telling you that you have run it once and don't need to run it again. As to the checkout issues, please read post 366 just a little way above yours.
I encounter a minor problem here: stock by attribute work great until I add a second att, which is readonly type. Now I always get the out of stock msg when I try to check out, any idea?
Thanks.
Well, I get why it doesnt work: when I add stock, this mod kinda forces me to include that readonly att as well, but on the store side, since it's a readonly att, it doesnt have any value to be passed along with the form.
Now we have to exclude readonly attributes to be counted for stock. Huhm
Hah, I solved my own problem, I rewrote the code a bit to put in a switch so that I can exclude readonly attributes. A quick dirty hack which can be further improved:
file edited: admin/includes/classes/products_with_attributes_stock.php
There can be a better way to do this, like putting a checkbox next to each attribute so we can check off to exclude it, but well, I need a quick solution for now.
PHP Code:<?php
class products_with_attributes_stock
{
function get_products_attributes($products_id, $languageId=1, $exclude_hidden=true)
{
global $db;
$query = ' select
patrib.products_attributes_id, patrib.options_values_price, patrib.price_prefix,
popt.products_options_name, pval.products_options_values_name
from '.TABLE_PRODUCTS_ATTRIBUTES.' as patrib, '.TABLE_PRODUCTS_OPTIONS.' as popt, '.TABLE_PRODUCTS_OPTIONS_VALUES.' as pval
where
patrib.products_id = "'.$products_id.'" AND patrib.options_id = popt.products_options_id
AND popt.language_id = "'.$languageId.'" and popt.language_id = pval.language_id
and patrib.options_values_id = pval.products_options_values_id';
if($exclude_hidden)
$query .= ' AND popt.products_options_type <> 5';
$attributes = $db->Execute($query);
if($attributes->RecordCount()>0)
{
while(!$attributes->EOF)
{
$attributes_array[$attributes->fields['products_options_name']][] =
array('id' => $attributes->fields['products_attributes_id'],
'text' => $attributes->fields['products_options_values_name']
. ' (' . $attributes->fields['price_prefix']
. '$'.zen_round($attributes->fields['options_values_price'],2) . ')' );
$attributes->MoveNext();
}
return $attributes_array;
}
else
{
return false;
}
}
function update_parent_products_stock($products_id)
{
global $db;
$query = 'select sum(quantity) as quantity from '.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.' where products_id = "'.(int)$products_id.'"';
$quantity = $db->Execute($query);
$query = 'update '.TABLE_PRODUCTS.' set products_quantity="'.$quantity->fields['quantity'].'" where products_id="'.(int)$products_id.'"';
$db->Execute($query);
}
function get_attributes_name($attribute_id, $languageId=1)
{
global $db;
$query = 'select patrib.products_attributes_id, popt.products_options_name, pval.products_options_values_name
from '.TABLE_PRODUCTS_ATTRIBUTES.' as patrib, '.TABLE_PRODUCTS_OPTIONS.' as popt, '.TABLE_PRODUCTS_OPTIONS_VALUES.' as pval
where patrib.products_attributes_id = "'.$attribute_id.'"
AND patrib.options_id = popt.products_options_id
AND popt.language_id = "'.$languageId.'"
and popt.language_id = pval.language_id
and patrib.options_values_id = pval.products_options_values_id';
$attributes = $db->Execute($query);
if(!$attributes->EOF)
{
$attributes_output = array('option' => $attributes->fields['products_options_name'],
'value' => $attributes->fields['products_options_values_name']);
return $attributes_output;
}
else
{
return false;
}
}
}
?>
@yellow1912
Thanks for posting your solution. There's plenty of scope to improve this mod. But I wouldn't recommend that anybody spend too much time on it, unless absolutely necessary (as it was for you here), as it will be rendered obsolete by Zen Cart 1.4.
Ok...
Installed this mod....
Then realised I had installed wrong version (installed version for Zen 1.38)...
Mod doesn't work, allows me to check out with more products than I have told Zen are available. Assume the problems lies with installing the wrong version...
How do I uninstall the wrong version so I can start again with the correct version...
Many thanks
Arkie...
Although there would be problems arising from installing version 4.7 instended for Zen cart 1.3.8 onto your 1.3.7 cart, from the symptoms that you describe, it sounds more like you have an incomplete installation.Quote:
Originally Posted by Arkwright
Seen a few of these recently, where FTP programs appear to have copied all of the files across, but in practise haven't overwitten existing files.
The good news is that since the only changes for 1.3.8 were to files that were also in 1.3.7 and the were no database changes, you don't need to uninstall, you can simply copy the files from version 4.6 onto your site. But do check that they arrive safely by checking your FTP programs error log and the dates modified on your server.
Is it possible to have the drop downs be dynamic based on stock? For example if I have shirts in sizes large and small but only have green in the small and not orange. Could the color drop downs on the product display only green if I have selected small?
You might want to try the latest version of StockAttribute by danielcor which uses AJAX to dynamically update the stock levels depending upon customer selections. However, it's based on an older version of Zen Cart and a slightly buggy version of the Attribute Stock mod from which the mod to which this thread refers was derived.
Thanks for the reply Kuroi...Quote:
Originally Posted by kuroi
I've uploaded all the files from 4.6. Checked my FTP error log and dates modified and everything checks out ok. No errors, dates modified as they should be...
Unfortunately hasn't made any difference whatsoever to my problem.
Zencart still allows a buyer to add more products than are available and allows them to go through checkout with them..
As an aside which may or may not be connected to my problem, I assume when I add a product from scratch, I put 0 in the quantity box and then add the attribute to the product and then add stock quantities to each attribute?
If this is the correct way to list a product and it's stock levels for each attribute, then I'm at a loss as to why I'm still having this problem...
Any ideas?
Thanks
Arkie.....
What settings do you have on the Admin > Configuration > Stock page?
Can you provide stock values (for product and individual attribute combinations) before and after from a purchase such as you have described?
Is it possible to get what code needs to be change for tpl_shopping_cart_default.php? I have a custom template and I would like to just add what is needed. Maybe diff the default template and the file in the stock by attributes zip?
Cal
Sounds like a good plan. I don't recall the changes being very big in that file, just the addition of low stock messages, I think.Quote:
Originally Posted by modernm
With regard to Admin>Config>Stock settings, I have them set as below:Quote:
Originally Posted by kuroi
Check stock level true
Subtract stock true
Allow Checkout false
Mark product out of stock Out of stock
Stock Re-order level 5
Show available stock level in cart when less than order true
Products status in Catalog when out of stock should be set to 0
Show Sold Out Image in place of Add to Cart 1
Product Quantity Decimals 0
Show Shopping Cart - Delete Checkboxes or Delete Button 3
Show Shopping Cart - Update Cart Button Location 3
Show New Products on empty Shopping Cart Page 1
Show Featured Products on empty Shopping Cart Page 2
Show Special Products on empty Shopping Cart Page 3
Show Upcoming Products on empty Shopping Cart Page 4
Stock levels before purchasing a product:
Total stock 17 items broken down as follows:
Size 8 = 3
Size 10 = 3
Size 12 = 3
Size 14 = 3
size 16 = 2
Size 20 = 3
I have just carried out a test purchase on Size 10 and have ordered 6 of the 3 available.
Toatal stock now reads 11 items, but my stock figures for each attribute haven't changed at all they still read as above.
With regard to my last post, was I correct in the way I was adding a product and adding the stock levels afterwards?
The mystery deepens....
Arkie....
I seem to have kind of broken my cart and I'm not quite sure how to fix it. I installed the incorrect version for stock attributes (products_with_attributes_stock) and really thought I had backed out if it (had everything working as normal) and then installed stockattribute_by_danielcor_3.01.1. Works well enough on the back end for adding stock numbers and such. Looks good on the front end until you click on a product that has variants on it and then it ends in a blank page.
Any ideas? Have I somehow skipped a step?
Thanks!
Janelle
http://www.quailsnestyarn.com
Yes. That was fine. The initial product level stock should become irrelevant once you start adding attribute stock.Quote:
Originally Posted by Arkwright
For everybody else, Arkie and I resolved this mystery by changing his FTP settings to always overwrite existing files so that the full stock by attributes fileset was installed.Quote:
Originally Posted by Arkwright
FTP programs are often reluctant to overwrite existing files, and even more so for existing files with newer last modified dates. If you have installed Zen Cart more recently than I last worked on some of the files then this may affect you and you will may need to force your FTP program to upload all the files in the package.
stockattribute_by_danielcor_3.01.1 is a good idea but appears to be based on the older stockattribute_by_danielcor_3.01 (note the last of ".1") without the updates for compatibility with later versions of Zen Cart that are built into the Stock by Attributes mod. So the chances of incompatibilities between the mod and your version of Zen Cart are quite high.Quote:
Originally Posted by janellez
Thanks so much for your answer. Which mod *will* work best with v1.3.7? I'm sure it's probably in this very thread but I can't seem to find it. I can back out of stockattribute_by_danielcor_3.01.1 too but I just need a simple mod that will allow me to set stock levels on attributes. I don't need any bells and whistles.
Thanks!
Janelle
In my view :D Stock by Attributes, but version 4.6 not 4.7.Quote:
Originally Posted by janellez
kuroi, you're fantastic! Thanks so much - works perfectly!
Janelle
Once again, here I am, asking for help :lookaroun!
I keep searching the forums but can't seem to find the answer with your mod, kuroi. I would like to put stock numbers next to my attributes in drop down menus. If I have to use radio buttons, that's fine too.
The code I'm finding through searching seems to be referring to other or older mods.
Thanks in advance!
Janelle
If this is the case, how do I sort it? I'm not sure what you mean about having backup files littered across the site. I have several backups sitting within the relevant folder - do mean that I should empty this before installing the contribution?Quote:
Originally Posted by kuroi
I have tried searching, but not sure how to word search to get relevant answer... if it's there!
I have recently had a clean install of 1.3.7.1, then upgraded to 1.3.8a.
Then installed SBA 4.7
I'm still getting used to it, but one thing I have noted is that if an item has a total of 10, but a particular attribute is out of stock, it still reduces the total when the out of stock attribute is checked out... even going so far as to make it a minus value.
Is this normal? I would have thought that it wouldn't reduce the quantity, when an out of stock item is checked out...?
I am currently downloading the site to do a file compare and see if I missed something, but I was fairly thorough... I think.
Hi.
I have just tried installing the SOL patch and received the following error.
1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[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')," );]
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
The original SQL patch as I have entered it is as follows:-
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'),"
);
Can any spot where I am going wrong please? Having stock attributes is critical to my site - if I can't get this to work I shall have to look for another package.
Philip
i added about 15 new products the other day and because the way SBA organizes everything alphabetically it was a pain in the but to work with is zencart 1.4 is it going to be easier to work on the attribute inventory numbers, or is it going to be the same, at least separating the stock by categories would make a huge difference i couldn't imagine having a large store with 100s of items
Hello
My info
www.ysandals.com
PHP 5.1
MySWL 5.0
Zen 1.3.8
Modified template Cherry-Zen
Linux Apache godaddy servers
Stocks by Attributes by Kurai Ver. 4.7
installed without any inconvenience and works perfect until I reached Item Number 50 (currently 476 and need to get over a 1,000).
which makes a pain in the :censored: the data entry, JUST the data entry is the inconvenience for me/us, so here I go:
Questions:
Is is possible to do the following
remember we sell mostly shoes (later we will add clothing but no so many variants)
Shoes comes average 8 different sizes and 3 different colors, so:
1) Is it another way to complete/fill stocks once the variants/atrributes are created like a matrix or table, where in one page for such item you can fill all stock in one page and NOT one by one.
2) Have a page break, currently all items are displayed with all atrributes and stock and variants in only one. Say cut off page 10, 15, 20 or 50 items
3)A search button to find items. currently CRTL F is the only way.
Other than That Thanks Kurai!
Marcelo
www.ysandals.com
This is Zen Cart's back ordering feature. If you look under Admin > Configuration > Stock there are switches for controlling whether or not Zen Cart allows this.Quote:
Originally Posted by jcgkiwi
You already have the patch installed. The error message is simply telling you that it can't add the same switch a second time.Quote:
Originally Posted by philip24
I agree.Quote:
Originally Posted by MB1
Stock by Attributes has its origins not in Zen Cart, but another package. It's even possible that it's older than Zen Cart itself. It is well past the natural end of its life and I have been doing no more than keep it on the life support machine until Zen Cart 1.4 is born.
I can't comment specifically on how this will work in Zen Cart 1.4, but the Zen Cart team have had the advantage of seeing how the existing mod works (and where it doesn't) and I'm confident that they will produce a more usable attribute stock facility, and provide an enhanced foundation for future mods in the this area.
Hmmm. Who's this Kurai dude? Somebody been taking credit for my work? :smile:Quote:
Originally Posted by marcelo63
The answer to your questions are: yes, yes and yes, or no, no and no depending upon how one looks at it.
This is open source software and none of the things that you have asked would be difficult to do for somebody with say intermediate PHP and MySQL skills and a good knowledge of this area of Zen Cart.
However, you can't do them in the current version, and because this mod is at the end of its life, it's unlikely that anybody will be making them available unless they disparately need the changes themselves.
Hint: If I were in your position, I would look instead at how you might be able to use MySQL to do a bulk upload of data from a CSV file exported from Excel.