Printable View
Is there a way to not have an attribute option appear if the stock for that option is zero? Rather than have the customer sent to the cart and then find out it is not available...
ie product AA has 3 options: small, medium & large. Stock values are : 1, 0, 1 respectively. Ideally the selections presented on the product page are: small and large as that is all that is in stock.
In our dreams...
Quote:
Originally Posted by ssteel
ssteel said:Sort of. I'm zc 1.3.9h, using SbA v 1.4.9 with ajax (I haven't updated as folks seem to be having trouble with new versions that I am not having. So I am very afraid!)Quote:
Is there a way to not have an attribute option appear if the stock for that option is zero? Rather than have the customer sent to the cart and then find out it is not available...
I also use Product Attribute Grid v1.1.1
So my product page shows a grid - in my case by colour and size of socks. It shows HOW MANY are in stock underneath each type. If the stock is zero, the 'add # to cart' box for that type is replaced with a red 'x' - so at least the customer can not enter a buy for something not existing, and therefore won't be sent off to the cart before they find out.
If the customer enters a number higher than the number showing in stock for a type, they will be allowed to go to the checkout page - where they will get an error message about stock shortfall and they can revise their order.
sample product with an out of stock attribute:
http://www.meafordwool.com/Heavy-Wool-Socks/Sport
You can have it not show the option at all or you can have it show as out of stock.Quote:
Originally Posted by ssteel
Search for Dynamic Dropdowns by SBA
I have SBA and Dynamic Dropdowns by SBA and can confirm that these two working together will appear the way the other poster requested. That is, out of stock items will no longer appear as an option.Quote:
Originally Posted by CarolineBogart
-lindasdd
THANKS!!!!!!!! I've been pulling my hairs for days trying to find out how to solve the problem as customers with product out of stock in their cart were unable to place the order and with no error message they had no idea what to do!
Thanks a lot!
:hug:
When I uncomment this code if I add a product that is in stock to a cart which already contains something flagged as out of stock, although the header message remains:
"Products marked with *** are out of stock. Items not in stock will be placed on backorder."
The "***" flag is removed from the item which is out of stock. :(
Quote:
Originally Posted by CarolineBogart
jodpcc: if I understand the question, I'd quibble with the fact that it's a problem. If I'm going to change code of that nature, I'm going to also wipe cache or reset the server or something to wipe out people's carts. It's not a fair test to change the code in mid cart like that.
I obviously didn't explain very well :blush:
The sequence of events is :
I revert to the standard module and uncomment the code in question.
I add a product that is in stock to my cart
I add a product that is out of stock to my cart
I add a product that is in stock to my cart
When I add the product which is out of stock it correctly processes i.e.
I get a header message saying "Products marked with *** are out of stock. Items not in stock will be placed on backorder."
A "***" flag appears next to the out of stock item in the cart.
When I add the next product which is in stock it processes incorrectly i.e.
I correctly get a header message saying "Products marked with *** are out of stock. Items not in stock will be placed on backorder."
Unfortunately the "***" flag no longer appears next to the out of stock item in the cart.
So I have reverted back to the "Athena Code" :smile: which processes correctly for me. I would appreciate it if some others could confirm the sequence of events on their systems for the standard module with the code uncommented as suggested by CarolineBogart, as this might be an issue specific to my system.
Quote:
Originally Posted by CarolineBogart
I'm sorry I've been too swamped to try this in my test cart but have been monitoring this thread and will try late today.
Yeah...sorry CarolineBogart - wish it worked but two things:
unlike jodpcc I still got the out of stock warning next to the original our of stock product....but no warning at all for the additional out of stock products I put in the cart.
when I put the old header_php back, everything was fine.
(had some down time so went for it...wouldn't hurt to play with this idea a bit more, if only the code writer for this version of the mod would comment)
I have the same problem as icebeer posted on page 129.
The SAVE Button doesn't work on the admin Products with Attributes Stock page.
I have to change Quantity for all variants one by one.
I see in Version: 1.4.11 this bug was fixed;
(- fixed ability to update multiple stock attributes at once (use "save" button at top or bottom of page))
I'm using Version: 1.4.13 on Zen Cart™ Version: v1.3.9h.
Can anybody tell me how to fix this problem?
I'm looking at the file products_with_attributes_stock.php and the XJAX files hoping to find something.
IN the file (products_with_attributes_stock_ajax.js)Quote:
Originally Posted by webstar59
Should it read #save not #store
I see no identifier named #store anywhereCode:$(document).ready(function() {
// bind form using ajaxForm
$('#store').ajaxForm({
// target identifies the element(s) to update with the server response
target: '#hugo1',
success: saved
// success identifies the function to invoke when the server response
// has been received; here we apply a fade-in effect to the new content
});
});
Just now found the error in the file products_with_attributes_stock.php on line 482.Quote:
Originally Posted by webstar59
echo '<div id="pwa-table"';
IS MISSING >
It should read echo '<div id="pwa-table">';
Everything is working now.
I wounder what next bug I'll find if any. Hoping this is it
Just now found the error in the file products_with_attributes_stock.php on line 482.Quote:
Originally Posted by icebeer
echo '<div id="pwa-table"';
IS MISSING >
It should read echo '<div id="pwa-table">';
:clap: Fantastic webstar59, just applied this change and seems to work perfectly :o) Didn't even realise this feature existed (well I guess it didn't til just now), have just been trudging through updates one at a time :cry:Quote:
Originally Posted by webstar59
*sigh* :cry: I've spent hours reading through this thread to try to get this mod to work properly for me. I updated my header_php.php file with the code Athena posted on page 114 and it just will not work for me. I don't understand. It seems to be working for everyone else. I have no clue what to do and I'm almost ready to give up. :(
edited to add: I'm having the issue with the quantities not working properly in the shopping cart. Whenever something is added that's out of stock, it puts everything in the cart out of stock whether it's in stock or not.
I must say I'm having exactly the same problem. Going to read up some more.
HELP ! ! ! I downloaded the addon as instructed, but it is showing up in my back office just like this:
Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync Quantities 2751-Inch Riflescope Rings0Add Quantity For Product VariantSync Quantities 29030mm & 35mm Precision Matched Scope Rings-2Add Quantity For Product VariantSync Quantities 27430mm Riflescope Rings-2Add Quantity For Product VariantSync Quantities 312Bino HUB Binocular System-23Add Quantity For Product VariantSync Quantities 276Bubble Level-7Add Quantity For Product VariantSync Quantities 240Comfort Strap0Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
9 Model: Comfort Strap (Regular)
0 Edit Quantity Delete Variant
10 Model: Comfort Strap (Compact)
0 Edit Quantity Delete Variant
186Crossfire-1Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
6 Model: 8 x 42
0 Edit Quantity Delete Variant
218Crossfire Riflescope-6Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
23 Model: 1 Inch Tube 3.5-10x50 V-Plex
1 Edit Quantity Delete Variant
325Curl Combo Pack0Add Quantity For Product VariantSync Quantities 238Custom Molded Case0Add Quantity For Product VariantSync Quantities 185Diamondback-8Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
16 Model: 10 x 50
1 Edit Quantity Delete Variant
17 Model: 10 x 42
0 Edit Quantity Delete Variant
27 Model: 7 x 36
0 Edit Quantity Delete Variant
217Diamondback Riflescope-25Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
19 Model: 1 Inch Tube 4-12x40 BDC
-3 Edit Quantity Delete Variant
20 Model: 1 Inch Tube 2-7x35 BDC
1 Edit Quantity Delete Variant
320Drop Tine Deluxe0Add Quantity For Product VariantSync Quantities 317Forky Day Pack0Add Quantity For Product VariantSync Quantities 329Full Curl Bag0Add Quantity For Product VariantSync Quantities 326Full Curl Pack0Add Quantity For Product VariantSync Quantities 328Full Curl System0Add Quantity For Product VariantSync Quantities 184Fury-5Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
18 Model: 10 x 42
1 Edit Quantity Delete Variant
316G2 Day Pack0Add Quantity For Product VariantSync Quantities 323G2 MAQ Quiver Pack0Add Quantity For Product VariantSync Quantities 314G3 MAQ Quiver Pack0Add Quantity For Product VariantSync Quantities 315G3 Tree Stand Pack0Add Quantity For Product VariantSync Quantities 286Hurricane R/T0Add Quantity For Product VariantSync Quantities 327Hybrid Curl Frame0Add Quantity For Product VariantSync Quantities 195Impact-1Add Quantity For Product VariantSync Quantities 277killFLASH® ARD-1Add Quantity For Product VariantSync Quantities 279killFLASH® ARD for StrikeFire & SPARC0Add Quantity For Product VariantSync Quantities 278killFLASH® ARD Threaded0Add Quantity For Product VariantSync Quantities 310Main Beam-1Add Quantity For Product VariantSync Quantities 311Main Beam XL0Add Quantity For Product VariantSync Quantities 194Nomad-13Add Quantity For Product VariantSync Quantities 259Nomad ScopeSkin-9Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
26 Model: Small Angled
2 Edit Quantity Delete Variant
319Ranger Optic Holster0Add Quantity For Product VariantSync Quantities 188Raptor0Add Quantity For Product VariantSync Quantities 182Razor-3Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
15 Model: 10 x 42
1 Edit Quantity Delete Variant
303Razor HD-1Add Quantity For Product VariantSync Quantities 191Razor HD-18Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
21 Model: Razor HD 20-60x85 Angled
-4 Edit Quantity Delete Variant
263Razor HD 35mm Rings-1Add Quantity For Product VariantSync Quantities 262Razor HD Riflescope-2Add Quantity For Product VariantSync Quantities 282Recon R/T Tactical Scopes0Add Quantity For Product VariantSync Quantities 283Recon R/T Tactical Scopes with VMS0Add Quantity For Product VariantSync Quantities 237Replacement Tethered Caps-1Add Quantity For Product VariantSync Quantities 193Skyline-1Add Quantity For Product VariantSync Quantities 192Skyline ED-4Add Quantity For Product VariantSync Quantities 260Skyline ScopeSkin-24Add Quantity For Product VariantSync Quantities 321SlingShot0Add Quantity For Product VariantSync Quantities 324SlingShot MAQ Pack0Add Quantity For Product VariantSync Quantities 233SnipePod V2 27"-15Add Quantity For Product VariantSync Quantities 232Snipepod V2 30"-23Add Quantity For Product VariantSync Quantities 202Solo0Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
22 Model: Solo 8 x 25
1 Edit Quantity Delete Variant
322Spike Fanny Pack0Add Quantity For Product VariantSync Quantities 219Strikefire AR-15 Flat Top Red/Green Dot Scope (High Mount)-12Add Quantity For Product VariantSync Quantities 220Strikefire Hunting Red/Green Dot Scope (Low Mount)-9Add Quantity For Product VariantSync Quantities 284Talon HD-7Add Quantity For Product VariantSync Quantities 234Tripod Replacement Plates3Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
25 Model: High Country Quick Release Plate
5 Edit Quantity Delete Variant
318Typical 7-Pocket0Add Quantity For Product VariantSync Quantities 189Vanquish-1Add Quantity For Product VariantSync Quantities 183Viper-16Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
12 :
4 Edit Quantity Delete Variant
13 :
1 Edit Quantity Delete Variant
307Viper-1Add Quantity For Product VariantSync Quantities 304Viper HD-17Add Quantity For Product VariantSync Quantities 306Viper HD-3Add Quantity For Product VariantSync Quantities 305Viper HS0Add Quantity For Product VariantSync Quantities 289Viper PST-4Add Quantity For Product VariantSync Quantities 216Viper Riflescope-19Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
11 Model: 1 Inch Tube 4-12x40 BDC
1 Edit Quantity Delete Variant
222Viper Sun Shade-2Add Quantity For Product VariantSync Quantities
Stock ID Variant Quantity in Stock Edit Delete
24 Model: Viper 50mm
1 Edit Quantity Delete Variant
248Vortex Competition Shirt0Add Quantity For Product VariantSync Quantities 249Vortex Hoodie - Green0Add Quantity For Product VariantSync Quantities 247Vortex Long Sleeve Shirt - Camo0Add Quantity For Product VariantSync Quantities 250Vortex Polo - Brown-1Add Quantity For Product VariantSync Quantities 251Vortex Polo - Grey-1Add Quantity For Product VariantSync Quantities 252Vortex T-Shirt - Strikefire0Add Quantity For Product VariantSync Quantities 285Vulture HD0Add Quantity For Product VariantSync Quantities
Any ideas?
Thanks,
VIP Optics
Further information, I used Athena's code and it is now working fine. :-)Quote:
Originally Posted by CES
Slight problem I had with one of my items showing out of stock when they were in stock for all variations. I deleted them all and inserted new variations individually, not 'all at once' and it seems to have worked!
Finally a fix for that! It was such a tiny thing that we all missed it!Quote:
Originally Posted by webstar59
So now I have a new problem. I haven't followed all of this thread so can't be sure this hasn't been discussed but it is a very strange item indeed.
The cart has 2 products that has a choice of fabrics and colors. So there are three separate attributes with images. Each has a different option name but using a dropdown with these means that each places something into the cart. One choice, three attributes - 2 of which say please choose.
I switched to radio buttons with no default. Only one choice shows in the shopping cart.
Fast forward to Stock by Attributes. When you go to insert the attribute with stock, all three choices show up. If you change one to the color and the other 2 to please choose, the shopping cart then requires that to show in the cart - in other words - just like with the dropdowns.
The client hates that and I can't blame her - it's actually confusing to the buyer.
So the question is, has anyone run into this scenario before?
It's a first for me and I work with zen cart full time.
Okay yes I have read through all I can find but I can't find anything that will help with my situation. Currently I own a t-shirt company. All my products have attributes from the option name size. There are 5 sizes. The problem I have is that people are able to order sizes that are out of stock. It does give a warning during the checkout. I want the system to not show the size in the drop down if the quantity is less than 1. Does anyone know how I can accomplish this?
You can see my link to my test item. Currently small has 4 and all other sizes have 0 but still allows you to order the item. Please help.
http://www.wickedfitapparel.com/inde...u2fmiq82ls7ee0
Copy the code update on post 1133 of this thread - page 114 by athena. Replace all the code in your header_php.php file for this module. After code update, attributes with a zero stock level will not show so they cannot be selected.
I did that and it still doesnt work. Does anyone know what php the drop down is controlled by. I want to write my own code that will check the products_with_attributes table and if the quantity is 0 then have it now show in the drop down.
Using the latest version of Zen Cart 1.3.9h.
I am getting ready to implement this mod, and I have scanned through the installation, but the first step kinda stumps me.
It kinda sounds like I need to mod/create/change the database before uploading the MOD to my cart. How do I do that? If there is a post that spells that out just point me there and I'll read it. I'm not asking anybody to spell out what's already been posted.
I would like to point out that "read this thread" is a little onerous. At 133 pages its a bit hard to find anything. I've read quite a bit of it, but...
Its the first step listed, but sounds like something you have to do after you upload it.Quote:
Create a new database table and a new configuration switch by running the 'stock_attribute.sql' via Admin->Tools->Install SQL Patches. If you prefer to use another method to create this table, you will need to edit the file if you use a prefix such as "zen_" for your tables.
The mod contains two sql patch files - stock_attribute.sql and update_1_4_10.sql. These files set up tables in your database so the mod has a place to put the data.
BACKUP YOUR DATABASE - BACKUP YOUR DATABASE - BACKUP YOUR DATABASE.
Copy the contents of the stock_attribute.sql file and log into your admin section.
Go to TOOLS and look for INSTALL SQL PATCHES
Open and paste the code into it and press SEND
Same for the other file
Ok, I uploaded it using File Zilla and then tried it. I got this.Quote:
Originally Posted by Bob La Londe
Quote:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stock_attribute.sql' at line 1
in:
[stock_attribute.sql;]
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.
Thanks. Not at all what I expected.Quote:
Originally Posted by Pablo
Ok, the stock attribute worked fine cut and paste, but the update gave me this error.Quote:
Originally Posted by Bob La Londe
Quote:
1062 Duplicate entry 'STOCK_SHOW_IMAGE' 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 ('Display Images in Admin', 'STOCK_SHOW_IMAGE', 'false', 'Display image thumbnails on Products With Attributes Stock page? (warning, setting this to true can severly slow the loading of this 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.
That means you already had that entry in your database and MySql won't let you have duplicate entries exactly the same.
Since it was already there, you can just ignore the warning.
I do not see this option.Quote:
Catalog->Products with Attributes Stock
You do not have the module installed in the correct folders. Be sure to rename the admin folder to your new admin folder name and the YOUR_TEMPLATE folder named to the template you are using.
Before uploading so that it overwrites files right?Quote:
Originally Posted by Pablo
If you are using Filezilla, the best way to do it is to select the files in the individual folders and drag them to the proper folder on your server. That was the way I installed mine and it worked great. A little slower, but you get all the files in the right place.
I have products with attributes that I use radio buttons for. Is there a way to line up the buttons horizontally instead of vertically??
I am having the problem when that when an out of stock item is added, no warning message comes in the header saying an item is out of stock and on *** message comes by the item(suggesting which item it is). Also at checkout, there is not a value of how many units of stock are available (even with this setting turned on in admin).
I have added version: stock_by_attributes_1-4-13
The fact of the problem is that when I make the setting DO NOT ALLOW CHECKOUT WHEN ITEM OUT OF STOCK the customer has no way of knowing which item it is.
So I have made it so the customer CAN check out with an out of stock item in cart. OF course they dont know it will be back ordered b/c they dont get the header message nor the *** message by item. And whats worse is I sometimes cant get the item in stock.
Im not sure why, but this could just be b/c of my custom cart, however I read the forums and it seems other have had this problem as well.
Is there a known solution? I would love to have at least the Header notification come up.
Copy the code update on post 1133 of this thread - page 114 by athena. Replace all the code in your header_php.php file for this module.
Thank you sir! that solution worked perfectly! No more letting people over order ;)
Have found a little problem on my store (1.39h with SBA) about "restock product quantity", as Athena showed, it seems ok if "bought" ONE item with attribute, then deleted the order, the item back correctly with attribute.
However, if bought SEVERAL items with different attributes. After deleted the order, the items did not back with attribute. Only the "Total Quantity" comes back in original number.
Example:
Item A
Quantity 3
boot size 8 - 2
boot size 6 - 1
Item B
Quantity 5
shirt size M - 2
shirt size L - 3
"bought" a size 8 Item A, two size L Item B. Now:
Item A
Quantity 2
boot size 8 - 1
boot size 6 - 1
Item B
Quantity 3
shirt size M - 2
shirt size L - 1
I deleted the order and checked "Restock product quantity" and it come back like this:
Item A
Quantity 3
boot size 8 - 1
boot size 6 - 1
Item B
Quantity 5
shirt size M - 2
shirt size L - 1
Thanks in advance for kind help!
Quote:
Originally Posted by athena
OK...
I have Zen Cart 1.3.9 with the stock by attributes and dynamic drop downs. I also overwrote the header_php.php file in the shopping cart as per Athena back in post 1133.
I am still getting out of stock items showing up in my drop downs and I can't figure out why. I'm pretty sure I have everything turned off regarding showing out-of-stock items.
Can anyone give me point in the right direction? Please?
A link to your site please - and which product is showing that is out of stock?
A link to the product is here: http://r-c-s.ca/index.php?main_page=...roducts_id=105
In the drop down the 200/57 item should not be there as it is out of stock, all the others are there and should be.
OK - If you add this item to your cart it will show as being out of stock, but you don't want the customer to have to go through all that to find out it's not in stock. Check the list for this product in your admin "Products with Attributes Stock" and be sure the product is listed and that it has zero quantity next to it. If it is not listed then "Products with Attributes Stock" cannot control it regardless of it's stock level.
I have done that and even added new variants after the header modification and still I have items in the list that should not be there... :frusty:
Hi!
I need a little help reguarding stock by attributes..
I use this query to retrieve all the details of products from my database:
I'm stuck on retrieving data from stock by attributes, I need, for every product, to retrieve attributes and obviously the stock for attributes.Code:$query_prodotti = "
SELECT concat( '" . $productURLstart . "',pt.type_handler,'" . $productURLend . "' ,p.products_id) AS product_url,
p.products_id,
p.products_quantity,
p.products_model,
p.products_type,
p.products_image,
p.products_price,
p.products_date_available,
p.products_weight,
p.products_tax_class_id,
pd.products_name,
pd.products_description,
cd.categories_name,
cd.categories_id,
m.manufacturers_name,
s.specials_new_products_price,
s.expires_date,
FROM
" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id=p.products_id and pd.language_id=".$lingua."
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " pc on pc.products_id=p.products_id
LEFT JOIN " . TABLE_CATEGORIES . " c on c.categories_id=pc.categories_id
LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd on cd.categories_id=pc.categories_id
LEFT JOIN " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id
LEFT JOIN " . TABLE_SPECIALS . " s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) )
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt on p.products_type = pt.type_id
WHERE p.products_status=1 and c.categories_id=34 and c.categories_status=1 and cd.language_id=".$lingua;
Exemple:
Red T-Shirt, Summer Clothes, XXL, 4
Red T-Shirt, Summer Clothes, M, 2
Where "Red T-Shirt" is the product, "Summer Clothes" is the category (and no problem for that), "XXL" and "M" are attributes and "4" and "2" are the respective stock.
Is there an angel with the part of the query I miss?
Thanks..
Quote:
Originally Posted by Savvonet
Try this mod
http://www.zen-cart.com/index.php?ma...y+Populate+CSV
I noticed that if you put the out of stock item in the cart, it does not show how many you have in stock - which should be zero - however the attribute should not be showing at all.Quote:
Originally Posted by ssteel
Please copy the code from your header_php.php file and post it so I can compare. This is only file that controls this action.
Also please provide a a screen shot of your admin/configuration/stock page.
I copied this from Athena's post... header_php.php is as follows:
<?php
/**
* shopping_cart header_php.php
*
* @package page
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 0000 2007-12-02 00:00:00Z kuroi $
*/
// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_SHOPPING_CART');
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
// Validate Cart for checkout
$_SESSION['valid_to_checkout'] = true;
$_SESSION['cart_errors'] = '';
$_SESSION['cart']->get_products(true);
if (!$_SESSION['valid_to_checkout']) {
$messageStack->add('shopping_cart', ERROR_CART_UPDATE . $_SESSION['cart_errors'] , 'caution');
}
// build shipping with Tare included
$shipping_weight = $_SESSION['cart']->show_weight();
/*
$shipping_weight = 0;
require(DIR_WS_CLASSES . 'order.php');
$order = new order;
require_once('includes/classes/http_client.php'); // shipping in basket
$total_weight = $_SESSION['cart']->show_weight();
$total_count = $_SESSION['cart']->count_contents();
require(DIR_WS_CLASSES . 'shipping.php');
$shipping_modules = new shipping;
$quotes = $shipping_modules->quote();
*/
$totalsDisplay = '';
switch (true) {
case (SHOW_TOTALS_IN_CART == '1'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . TEXT_TOTAL_WEIGHT . $shipping_weight . TEXT_PRODUCT_WEIGHT_UNIT . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
case (SHOW_TOTALS_IN_CART == '2'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . ($shipping_weight > 0 ? TEXT_TOTAL_WEIGHT . $shipping_weight . TEXT_PRODUCT_WEIGHT_UNIT : '') . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
case (SHOW_TOTALS_IN_CART == '3'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
}
// testing/debugging
// require(DIR_WS_MODULES . 'debug_blocks/shopping_cart_contents.php');
$flagHasCartContents = ($_SESSION['cart']->count_contents() > 0);
$cartShowTotal = $currencies->format($_SESSION['cart']->show_total());
$flagAnyOutOfStock = false;
$products = $_SESSION['cart']->get_products();
for ($i=0, $n=sizeof($products); $i<$n; $i++) {
if (($i/2) == floor($i/2)) {
$rowClass="rowEven";
} else {
$rowClass="rowOdd";
}
switch (true) {
case (SHOW_SHOPPING_CART_DELETE == 1):
$buttonDelete = true;
$checkBoxDelete = false;
break;
case (SHOW_SHOPPING_CART_DELETE == 2):
$buttonDelete = false;
$checkBoxDelete = true;
break;
default:
$buttonDelete = true;
$checkBoxDelete = true;
break;
$cur_row++;
} // end switch
$attributeHiddenField = "";
$attrArray = false;
$productsName = $products[$i]['name'];
if (STOCK_CHECK == 'true') {
$flagStockCheck = zen_check_stock($products[$i]['id'], $products[$i]['quantity']);
if ($flagStockCheck == true) {
$flagAnyOutOfStock = true;
}
$stockAvailable = zen_get_products_stock($products[$i]['id']);
}
// Push all attributes information in an array
if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
if (PRODUCTS_OPTIONS_SORT_ORDER=='0') {
$options_order_by= ' ORDER BY LPAD(popt.products_options_sort_order,11,"0")';
} else {
$options_order_by= ' ORDER BY popt.products_options_name';
}
foreach ($products[$i]['attributes'] as $option => $value) {
$attributes = "SELECT popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
FROM " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa
WHERE pa.products_id = :productsID
AND pa.options_id = :optionsID
AND pa.options_id = popt.products_options_id
AND pa.options_values_id = :optionsValuesID
AND pa.options_values_id = poval.products_options_values_id
AND popt.language_id = :languageID
AND poval.language_id = :languageID " . $options_order_by;
$attributes = $db->bindVars($attributes, ':productsID', $products[$i]['id'], 'integer');
$attributes = $db->bindVars($attributes, ':optionsID', $option, 'integer');
$attributes = $db->bindVars($attributes, ':optionsValuesID', $value, 'integer');
$attributes = $db->bindVars($attributes, ':languageID', $_SESSION['languages_id'], 'integer');
$attributes_values = $db->Execute($attributes);
//clr 030714 determine if attribute is a text attribute and assign to $attr_value temporarily
if ($value == PRODUCTS_OPTIONS_VALUES_TEXT_ID) {
$attributeHiddenField .= zen_draw_hidden_field('id[' . $products[$i]['id'] . '][' . TEXT_PREFIX . $option . ']', $products[$i]['attributes_values'][$option]);
$attr_value = $products[$i]['attributes_values'][$option];
} else {
$attributeHiddenField .= zen_draw_hidden_field('id[' . $products[$i]['id'] . '][' . $option . ']', $value);
$attr_value = $attributes_values->fields['products_options_values_name'];
}
$attrArray[$option]['products_options_name'] = $attributes_values->fields['products_options_name'];
$attrArray[$option]['options_values_id'] = $value;
$attrArray[$option]['products_options_values_name'] = zen_output_string_protected($attr_value) ;
$attrArray[$option]['options_values_price'] = $attributes_values->fields['options_values_price'];
$attrArray[$option]['price_prefix'] = $attributes_values->fields['price_prefix'];
}
if ( STOCK_CHECK == 'true' ) {
// Added to allow individual stock of different attributes
unset($attributes);
if(is_array($products[$i]['attributes'])){
$attributes = $products[$i]['attributes'];
} else {
$attributes = '';
}
// End change
$stock_check = zen_check_stock($products[$i]['id'], $products[$i]['quantity'],$attributes);
if (zen_not_null($stock_check))
{
$flagAnyOutOfStock = true;
$flagStockCheck = $stock_check;
$stockAvailable = zen_get_products_stock($products[$i]['id'], $attributes);
}
}
} //end foreach [attributes]
$linkProductsImage = zen_href_link(zen_get_info_page($products[$i]['id']), 'products_id=' . $products[$i]['id']);
$linkProductsName = zen_href_link(zen_get_info_page($products[$i]['id']), 'products_id=' . $products[$i]['id']);
$productsImage = (IMAGE_SHOPPING_CART_STATUS == 1 ? zen_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], IMAGE_SHOPPING_CART_WIDTH, IMAGE_SHOPPING_CART_HEIGHT) : '');
$show_products_quantity_max = zen_get_products_quantity_order_max($products[$i]['id']);
$showFixedQuantity = (($show_products_quantity_max == 1 or zen_get_products_qty_box_status($products[$i]['id']) == 0) ? true : false);
// $showFixedQuantityAmount = $products[$i]['quantity'] . zen_draw_hidden_field('products_id[]', $products[$i]['id']) . zen_draw_hidden_field('cart_quantity[]', 1);
// $showFixedQuantityAmount = $products[$i]['quantity'] . zen_draw_hidden_field('cart_quantity[]', 1);
$showFixedQuantityAmount = $products[$i]['quantity'] . zen_draw_hidden_field('cart_quantity[]', $products[$i]['quantity']);
$showMinUnits = zen_get_products_quantity_min_units_display($products[$i]['id']);
$quantityField = zen_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"');
$buttonUpdate = ((SHOW_SHOPPING_CART_UPDATE == 1 or SHOW_SHOPPING_CART_UPDATE == 3) ? zen_image_submit(ICON_IMAGE_UPDATE, ICON_UPDATE_ALT) : '') . zen_draw_hidden_field('products_id[]', $products[$i]['id']);
$productsPrice = $currencies->display_price($products[$i]['final_price'], zen_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . ($products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->display_price($products[$i]['onetime_charges'], zen_get_tax_rate($products[$i]['tax_class_id']), 1) : '');
$productsPriceEach = $currencies->display_price($products[$i]['final_price'], zen_get_tax_rate($products[$i]['tax_class_id']), 1) . ($products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->display_price($products[$i]['onetime_charges'], zen_get_tax_rate($products[$i]['tax_class_id']), 1) : '');
$productArray[$i] = array('attributeHiddenField'=>$attributeHiddenField,
'flagStockCheck'=>$flagStockCheck,
'flagShowFixedQuantity'=>$showFixedQuantity,
'linkProductsImage'=>$linkProductsImage,
'linkProductsName'=>$linkProductsName,
'stockAvailable'=>$stockAvailable,
'productsImage'=>$productsImage,
'productsName'=>$productsName,
'showFixedQuantity'=>$showFixedQuantity,
'showFixedQuantityAmount'=>$showFixedQuantityAmount,
'showMinUnits'=>$showMinUnits,
'quantityField'=>$quantityField,
'buttonUpdate'=>$buttonUpdate,
'productsPrice'=>$productsPrice,
'productsPriceEach'=>$productsPriceEach,
'rowClass'=>$rowClass,
'buttonDelete'=>$buttonDelete,
'checkBoxDelete'=>$checkBoxDelete,
'id'=>$products[$i]['id'],
'attributes'=>$attrArray);
} // end FOR loop
// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_SHOPPING_CART');
?>
The screen shot of the admin/configuration/stock:
http://r-c-s.ca/images/screenshot.jpg
Checked your files and everything seems OK. You may want to change "Show available stock level in cart when less than order" to TRUE. It's your option, but if the customer places 5 in the cart and you only have 3 in stock - It will show so they don't have to guess how many they can buy.
Check your file products_with_attributes_stock.php on line 482.
If it reads echo '<div id="pwa-table"';
It IS MISSING >
It should read echo '<div id="pwa-table">';
This probably won't fix the other problem, but it sure fixes a lot of the "SYNC" and "SORT" problems.
Ran some tests and found your problem! You need to UNINSTALL "Dynamic Drop Downs". This mod does not work with "Attributes with Stock" and is what is causing zero stock level products to still show up. Be sure to remove the update you placed on your database also.
So I've been reading a bunch of other threads and it looks like the SBA version I have is not compatible with dynamic drop downs.
So here is a stupid question and benchmark of how little I know... Do I need to uninstall my version 4_13 of SBA? There does not appear to be a removal script in the download... Or can I just install 4_7 over top of what I have?
I don't believe removing SBA version 4_13 and replacing it with version 4_7 will correct your problem - and besides 4_7 has a lot of features and updates missing. What I believe you need to do is COMPLETELY REMOVE Dynamic Drop Downs. However if you decide to install 4_7, you will have to remove each individual file of 4_13 to reinstall 4_7.Quote:
Originally Posted by ssteel
This may be misplaced, but wanted to interject that I have both SBA and Dynamic Dropdowns working just fine on my site with no customizations to get it working properly.
I believe in order to get it to display the way I wanted I had to use:
Title Value
Product Info Single Attribute Display Plugin sequenced_dropdowns
Product Info Multiple Attribute Display Plugin sequenced_dropdowns
If I'm not totally off base with this remark let me know if I can be of any other assistance in relaying my own settings.
-lindasdd
Quote:
Originally Posted by lindasdd
Which version of SBA and DD are you using?
lindasdd
do you have a product with two attributes that are linked (i.e. the choice of the first attribute determines the stock availability and which attributes are shown of the second attribute because together they form one product) This is where it dynamic drop downs fails to work for me and most others I believe.
If you have it working in this way would like to know how. - I am trying to get it to show "out of stock" or "in stock" against each choice in the second drop down once the first has been chosen.
Regards
M
MikeyG,
Sorry for the lack of follow up - I've been out of the US.
I do not have a dependent attribute structure similar to what you mentioned. I just have one level.
What actually does happen for you in the second dropdown? Are you saying it still shows as in stock? Or does it disappear? I would think as long as it disappears you should be all set.
SSteel,
All the latest versions.
-lindasdd
P.S. You might have to get someone more versed in the programming for this MOD to do some custom work for you to make it work properly the way you'd like.
Has anyone used this with all business template?
I tried installing and the files have been loaded on server but I don't see anything in admin.
I goto the product with attributes. I click to edit attributes but I don't see a new field in attribute settings for quantity. AM I looking in the wrong place?
I got it loaded but it allows checkout when attributes aren't loaded with stock.
I was hoping when you highlighted an item in the dropdown the add to cart button would change to out of stock. Or just have the out of stock attribute not show at all
I will read through this and hopefully come up with an answer
Quote:
Originally Posted by mysh
I got this running and setup.
I have encountered a problem. I can change product by hitting edit quantity button, but if I just try to fill in the number on the list screen and hit the save button, the save button does nothing. It doesn't seem to be a link at all
Any known fix for this issue? I found another thread where someone was having same issue but no follow up
reading through this I found someone offer a fix for the save button issue. I corrected the code and now the save button actually registers but it brings up this error msg
1146 Table 'peimei_zc11.products_with_attributes_stock' doesn't exist
in:
[UPDATE products_with_attributes_stock SET quantity = '31' WHERE products_with_attributes_stock.stock_id =416 LIMIT 1]
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.
Sorry if this is an inappropriate post, but I am desperate to get this mod working correctly.
I am looking to hire someone who is confident in being able to correct this mod on my site.
There seems to be a lot of things wrong. The save button doesn't work when loading the quantity in admin(this is the less important issue)
The big issue is it allows checkout of items no matter the stock status. Also once the item is in the cart it only shows the parent product name it does not show the attribute name.
Please PM me if this is something you think you can fix.
site link - http://gator1736.hostgator.com/~peimei/
You need to re-send your SQL patch for this mod. Parts are missing from your database.
I have reinstalled those tables so many times now.
I actually fixed the table error with the save button. It was because I had a prefix and one of the files with the mod was not setup to see the prefix. So I removed the prefix from my tables hoping it would cure all my issues. It only fixed the save button
I have hired 2 people over the weekend to fix my problem. Both have failed.
I have asked them to just take both SBA and dynamic dropdown off and do a complete reinstall, but i don't think either did this.
I would do it myself but I am alittle scared to mess with the databases and remove the table entries for those mods.
Whats frustrating is it worked when I first installed it. I don't understand what went wrong. I know everyones favorite answer is it was installed wrong, but I have gone over the files atleast 5 times. Checking the version id on the top of the phps. All of them match, I have removed all the files and reinstalled them numerous times.
Dynamic dropdown seems to really create problems when used with SBA. I have read post that would disagree, but it does cause problems.Quote:
Originally Posted by mysh
Try removing the Dynamic Dropdown files and just use SBA. Don't worry about the database files, they can remain but just won't be used.
Yes I finally removed it and started making progress. I think I have everything working well now and I even paid someone last night who wrote a code so SBA without dynamic would still show the out of stock text next to the OOS items in the dropdown
SInce I asked so many questions here and some of the info in this thread helped get me to the point I am now. Once I launch I will write up the steps i took to maybe help save someone else hours or days of messing around
On your web sit you have E-Liquid 10ML 0MGQuote:
Originally Posted by mysh
Flavor
Spearmint**Out of Stock
Strawberry**Out of Stock
If you have SBA properly installed and are showing a zero stock level for this attribute, the choice will not display to the customer in the dropdown list. You can still click on this and add it to your cart (with warning messages of course).
For the most part this is how I want it. I don't want the out of stock items to disappear from the dropdown. I prefer they stay in the dropdown with the out of stock text.
The perfect scenerio would be to have a pop up warning come up when someone tries to add a out of stock item, but I'll settle for the warning in the cart for now. Most people won't add a item that clearly states out of stock next to it(i hope)
I have a zen install running 1.3.8a with SBA installed -- this addon has not been updated in several years. Please tell me how to determine what version of SBA is installed? I seem to have downloaded all updates but cannot determine which one I am currently running :oops:
Took a chance and upgraded step by step from 4.7 to 4.10 and I am THRILLED with the improvements. HOWEVER, the SAVE button does not seem to work after changing multiple stock quantities? Am going to pour back through this thread to see if that's already been addressed.
Then my next (long overdue) adventure will be (finally) updated to ZC 1.3.9 ...
The fix is hereQuote:
Originally Posted by aly22
http://www.zen-cart.com/forum/showth...ve#post1068750
Hi Pablo,Quote:
Originally Posted by Pablo
I actually tried that "fix" earlier -- I was able to click the "Save" button -- but got the following error:
1146 Table 'mysite_zc1.products_with_attributes_stock' doesn't exist
in:
[UPDATE products_with_attributes_stock SET quantity = '17' WHERE products_with_attributes_stock.stock_id =55 LIMIT 1]
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 have run the sql update for version 4.10 through admin and am unable to re-load the sql as the table already exists. Not sure what to try next. Am I missing something about this error message?
Ok, I tried again by making the change referenced in your link: http://www.zen-cart.com/forum/showth...ve#post1068750
by editing the file admin/products_with_attributes_stock.php
This makes the "save" button clickable
But I still had the above-mentioned error.
Found a fix for that here: http://www.zen-cart.com/forum/showpo...postcount=1035
by editing admin/includes/classes/products_with_attributes_stock.php
This seems to work now ... I was able to update quantities and click save (and it saved).
Its likely because you have a prefix. There is another fix you need to apply if you are using prefix on your databases.
Or you can drop the prefix off all your databases.
I don't remember what file needs to have the correction but it is referenced in this thread
Right, mysh -- I think that's what I did.
I added the prefix zen_ to line 227 in admin/includes/classes/products_with_attributes_stock.php
using code recommended by kuroi:
$sql = "UPDATE " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " SET quantity = '$value' WHERE stock_id =$id LIMIT 1";
and that resolved the error.
My SBA seems to be working now, at least as far as being able to use the "save" button and update multiple quantities at once.
NEW QUESTION: Does anyone also use Zen Lightbox with SBA Ajax version? I'm having an issue now where my lightbox popups are showing up blank! I do not know whether this is a related issue or something I failed to notice was broken before today.
It doesn't appear that this mod was incorporated into v1.5.0, any plans to verify / port it to work with 1.5.0?
Thanks,
--Ron
I am currently modifying this add-on to include a unique part number for each stock variant. I think I have seen other people asking for this feature. This will allow me to sync the Zen product quantities with my internal inventory control system quantities via SQL command line tools and a scheduled task. I'm not a PHP programmer, but I'm pretty good at hacking up existing code to make it do what I want. I have the bulk of it done but have hit a wall. If anyone wants to jump in and help finish it up, I'll be glad to share what I've done. The unique part number exists, I can add the part number in the Admin, the number displays in the admin and cart. I can't figure out how to carry the part number through the rest of the checkout process and put it on the invoice...
Added field to products_with_attributes_stock table:
http://b2c.bauerfeindusa.com:8080/we...ject/table.jpg
Modified the Admin module to include populating this field:
http://b2c.bauerfeindusa.com:8080/we...t/populate.jpg
Modified the Admin module to show this field:
http://b2c.bauerfeindusa.com:8080/we...dm-display.jpg
Modified tpl_shopping_cart_default.php to display the part number:
http://b2c.bauerfeindusa.com:8080/we...rt-display.jpg
Thanks,
--Ron :frusty:
rhuseby would that allow me to make specials for a specific attribute?
Sometimes I just want a certain attribute on sale and rightnow I can only see how to make the parent product as a whole on sale
No, I am only modifying it to have a unique part number for each variant of an item. I'm sure someone could modify it for you for $...
--Ron
Hi.
Some of my items are suddenly showing up as Sold out, with stock 0 in the shop.
This happens only to some products, and all but 1 or 2 of the items are used in stock by attribute page.
Any idea why this happens?
Is there an issue with products_with_attributes_stock.php?
I've added a .htpasswd to the admin directory in hope of preventing this from happening.
Cheers
Endre
Not sure if this is the correct place to post but I have been searching the forums for information and this is the only one that comes close.
I am using Zen cart 1.3.9h (new install)
and have installed SBA 1.4.13
view here trial site
I have a problem trying to figure out how to use only one attribute for tracking the stock of an item with several attributes
I have a specific shirts and hoodie of 1 color for a product then I have attributes for size, if it is personalized, where it is personalized, and what name.
I am given 6 variations (in SBA) per size when all I am trying to track is the number in stock for a particular size as the other attributes are done after the order is made.
the old saying size does matter.. :blush:
So am I doing something wrong or does this module not handle this type of scenario. If not can someone recommend one that does? or a process I can follow to correct this.
Thank you in advance.
Gary
Am wondering if some of the actual attribute settings might come into play -- in the regular, ZC attribute parameters rather than relying solely on SBA? I had set up an item that had 2 sets of attribute configurations:
Shirt A (with dropdown color choices)
or Shirt B (with dropdown color choices).
I set up quantities correctly for each, but Shirt A came up "out of stock" every time. So I gave up and finally just did one single dropdown like this:
Shirt A, color
Shirt A, color2
Shirt B, color
Shirt B, color 2
-- and assigned the same quantities as I had before and it's all working just fine now.
But I wonder whether in your case, simwombat, the multiple attribute issue could be controlled some way via the Define the Attribute Settings? Like maybe changing the Attribute Required for Text or something? Just a guess ... until I get a test store back up to experiment and troubleshoot.
That is a good idea but makes my drop down 36 items long and then I still have to worry about the text block where they add what they want printed on the item.:wacko:
I am sure someone has run into this before and solved it.
I did give it a shot but it was very awkward to use even when I broke it down by size.. - still had the text issue as well.
Thanks for the suggestion..
Gary
I have to admit, I haven't read all 139 pages of this thread, but can anyone tell me why all the support info seems to refer to SBA v4.x and the only download I can find is:
Version: 1.4.13
Last Updated: Apr 06 2011
Author: That Software Guy
Is there a more recent download available or has the numbering changed? :blush:
OK, I've figured out that 1.4.x supersedes 4.x, but I still have my original question regarding the installation instructions, which state:
Prepare the package for upload to your server by renaming the following folders to match your template name: includes/modules/YOUR_TEMPLATE and includes/templates/YOUR_TEMPLATE.
Having just downloaded and decompressed the most recent version of the add-on, I find that the includes/modules/ folder contains no files and a single sub-folder called Pages.
I have renamed includes/templates/YOUR_TEMPLATE but I can not find includes/modules/YOUR_TEMPLATE.
Is there an error in the instructions or in the zipfile? Can I safely ignore this inconsistency or do I need to fix something?
Any assistance is appreciated. Thanks
I found that this program installed very easily.
I ran the SQL file as it said then used FTP to upload the other files overwriting existing files. Worked great for me. My only problem was getting the stock to count off 1 attribute instead of all attributes.
Good luck with that..
simwombat: are you sure you used the order.php file that came with the download? I think it handles the stock quantity update and it appears to be working fine for me. If I place an order it subtracts the quantity for that attribute combination only, all other quantities stay correct for me...
\includes\classes\order.php
Yes I did use the package as downloaded. I used FTP to drop all files in place and overwrite the existing.
I think you may misunderstand my question. It does subtract for the attribute combination but I do not want to use a combination.
I just want it to subtract by only one of the 6 attributes. I want it to subtract when a size of an item is chosen. I have 6 combinations of each size which I do not want.
I am selling shirts and hoodies and just want to select the size attribute as that is the way they are ordered.
I get 10 small and 10 large and then while the person orders a small they then add if they want it personalized, and where they want it personalized, and what name they want to personalize it with.
Then I perform that work that they asked for. and it is still a small shirt that is sold. I do not order them with names already on them as I have no idea who is going to order. So that combination is impossible for me to put into inventory like SBA does.
I hope that is clearer..
you can see what I mean at this site just go to a hoodie or t-shirt and you will see the attributes that do not get completed till order is made.
Thank you for your help and I hope I did not misinterpret your reply as to its meaning.
Gary
ZC 1.3.9h (recently upgraded)
Stock by Attributes 1.4.13
Some (not all) customers are seeing the "out of stock" indicator at checkout (three asterisks) when there is actually plenty of stock.
There is no "out of stock" indicator that appears on the product page.
The cart will not allow the user to checkout
The relevant lines from admin > configuration > stock are:
Check stock level true
Subtract stock true Info
Allow Checkout false Info
Mark product out of stock *** Info
Stock Re-order level 5 Info
Show available stock level in cart when less than order false Info
Display Images in Admin false Info
Products status in Catalog when out of stock should be set to 0 Info
Show Sold Out Image in place of Add to Cart 1
Where should I be looking?
Thanks,
John
I have a problem that should be simple to fix, but I don't see a way to do this. Nothing that I have tried has worked. I am using Stock by Attributes version 1.4.10. I have a product that has two color variations. I am going to stock only one color.
I want to remove the drop-down color choice from the product page, but do not see a way to do it. I tried using Delete Variant for both color attributes, but that doesn't work. The Save button does not work on the admin page.
How do I remove a product from the Stock by Attributes contribution?
I found the bug fix for the Save button issue and that works.
http://www.zen-cart.com/forum/showth...ve#post1068750
I still need to figure out how to delete a product from this mod.
If I try to use Delete Variants, the product page shows Out of Stock.
How do I delete the entire product entry in Stock by Attributes?
Never mind. I finally found it. I had to delete all of the attributes related to the product on the Catalog > Attributes Controller page.
I was previously trying to delete individual attributes on the Catalog > Products With Attributes Stock page. I could not delete the attributes from there.
Hi all,
I just downloaded and tried to install SBA to my Zen Cart.
Zen Cart ver 1.3.9h
SBA ver 1.4.14
I am using a norwegian translation of Zen Cart.
I followed the instructions in the included readme file, inserted the extra rows in the SQL database and renamed the MY_TEMPLATE folder to my template name. I also made norwegian versions of the SBA language files.
Then I uploaded everything to the server.
The problem is that SBA does not work at all. Nothings shows, no changes made. No menu item in "Catalog", no nothing.
I just simply can't figure out why this is not working.
Any suggestions?
Thanks in advance,
Kristian W.
Norway
Hello i found this topic through Searching for "stock_attributes.css" .
I have not never installed the module "Stock by Attribute v4.0" but in my admin panel whenever i refresh the "who is online" i see that my ip is looking at file "/admin/includes/stock_attributes.css" which does not exist.
How can this happen?
It did not happen a few days ago and i think that maybe it started happening since i moved my files to another hosting server of the same hosting company.
I have this installed and it seems to be working as I need. My only complaint is the fact that all of the products that have defined attributes loads on 1 single page. I have several thousand products so the load time basically sucks.
I would like to be able to break it down into several pages.
Any suggestions on how I may accomplish this?
Has anyone tested this with the new zc version 1.5? I've been using it with v1.3.9h and am wanting to upgrade to 1.5, but I need some sort of way to manage my stock by attributes.
Is there a way to make an out of stock attribute show as being out of stock on the products page? Currently the customer doesn't know the product is out of stock till they add it to the cart but then it comes across as the whole product range being out of stock not just that one attribute.
I'm having a problem installing this module. When I install all of the appropriate files, It will no longer let me log into the admin side of my website. I've narrowed it down to two files, admin/orders.php and admin/includes/functions/general.php
I have my admin on my site, but when I compare my current files to the ones in stock by attributes, they appear to be identical.
Thank you.
There is code for showing attribute stock levels on the product page. I think it (the solution) is actually posted somewhere in the 140 pages of this thread. It has to do with editing your template file for the product info. I seem to recall that it doesn't work with dropdown attributes, but will work with radio selections.Quote:
Originally Posted by psr racing
I tried version 1.1.14 of stock by attributes in Zen Cart v1.5, but I don't think it fully works. When I try to add a product to the cart it goes to a blank screen. I have to go back and then click go to cart. I think Stock by Attributes is causing this. I will remove it and see if the cart works.Quote:
Originally Posted by TamaraSFL
Update: I tried removing Stock by Attributes and the cart still doesn't work. Therefore, Stock by Attributes might work in Zen Cart v1.5 and my problem is something else. Maybe it's my template.