Printable View
Just out of curiousity, does this version have the capability to have a product as an attribute? As in, my wife sells teas, and we want to provide a discount on a tea ball/infuser if you buy a bag of tea, so, as near as I can tell, the "attribute" on either the tea ball or the tea would have to be a product.
Mal
I think your question sounds very much like the way it is done in post #1790.Quote:
Originally Posted by Malaperth
There the product is listed as always required (set as the base attribute) and can be discounted, in addition you can have optional attributes, such as the infuser and they can also be discounted if desired.
http://www.zen-cart.com/showthread.p...02#post1231102
Zen Cart Vs 1.5.1
Hi All,
I am looking for a solution to my duplicate page issue whereby I have lets say 10 products exactly the same with the exception of a colour variant.
I control the stock by uploading CSV (through some 3rd party software) with a Model number in the column.
Is this plugin what I am looking for to create one product only with the variants of the model numbers and colours?
If this is my solution, is there a way of creating this other than each manual product and variants?
Any advice would be much appreciated.
Thanks
Renz
Based on your description of the problem I would say yes this mod will help you.Quote:
Originally Posted by Renz
Have a look at this sample http://www.1potteryhouse.com/tiki/su...sun-wall-decor
In the sample I have 3 sizes, but these can just as easily be colors, and when you add them to the SBA stock page, you can assign each a unique part number (I call it Custom ID on the page just to make it a generic field for many uses).
You will have to create one product and assign it all the colors via the attributes page "catalog -> Attributes" (standard part of Zen Cart only used by this mod).
The instructions packaged with this mod should help you see what is needed to be accomplished to make this work.
As always, try this on a TEST site/installation prior to making any change to an active site.
Thanks for your fast response from what you say it's exactly what I need.Quote:
Originally Posted by potteryhouse
1. How do I handle images with the model number in SBA
2. I assume every product I wish to change has to be done manually there is no way of marrying products up yes?
3. Do I need to re-allocate the images manually as well to the Image Handler for this? (Ie change their number so they are added to the SBA or is the a provision in the control for model, image number colour)
4. How do I control no checkout if the product is nil stock.
Thanks
Regards
Renz
Please see notes added below your questions.Quote:
Originally Posted by Renz
Hi Pottery House
2. I assume every product I wish to change has to be done manually there is no way of marrying products up yes?
(It is not clear to me what you are asking here. could you add more detail.)
Lets say I have already a web site that has 5 of the same products (on different pages) and the only difference is the colour, if I wanted to consolidate them into one and add the image number and model number as the variant, is there any way of doing this from my existing ones (ie delete 4 and make 1 with variants) or is each and every product that has a duplicate must eb done manually?
3. Do I need to re-allocate the images manually as well to the Image Handler for this? (Ie change their number so they are added to the SBA or is the a provision in the control for model, image number colour)
(Here again, It is not clear to me what you are asking. Images are still handles via the Zen Cart default functionality via the attribute controller.)
Basically asking if I add an Image number to this SBA next to the model number, which is already on the server will it find it or do I need add each additional image to product.
Thank You
Regards
Renz
See notes aboveQuote:
Originally Posted by Renz
The only issue with setting up the Attributs as mentioned in the post you sent me to is that I need to use the exact same "unique identifier" in order to keep track of it's stock amount, as the attribute "Tea Ball" is attached to multiple products. Otherwise, SbA thinks that each tea ball is a separate item that it needs to keep track of. I hope that made sense.Quote:
Originally Posted by potteryhouse
Mal
Hey potteryhouse,
Using ZC 1.5.1 and just upgraded to SBA 1.5.2.
I merged everything over accordingly, however, now any item that has two dropdown options are being listed as out of stock, even if the quantity is high and the system recognizes that it has a quantity. See below for example links. Thanks!
http://www.piratespressrecords.com/s...set-p-393.html
http://www.piratespressrecords.com/s...irt-p-570.html
http://www.piratespressrecords.com/s...hirt-p-21.html
Never mind. This has been resolved. Thanks!
Quote:
Originally Posted by Christian_Wagner
Hi potteryhouse,Quote:
Originally Posted by potteryhouse
There is this free Phreebooks Open Source ERP (https://github.com/phreebooks/PhreeBooksERP and http://www.phreebooks.com/pb-forum/) which has a POS and ZenCart module that allow stocks from the Phreebooks inventory to be uploaded to Zencart and also download sales order from Zencart. I think this Phreebooks Plus Zencart is one of the best free solution for small business who has an outlet using POS and an online store and want to keep a single inventory for both. Everything is perfect for Phreebooks now except for products with attributes.
Currently, Phreebooks have it own product attributes but it has a problem when uploaded to Zencart. For example, if I have a product with 6 colors and 5 sizes, when uploaded to Zencart, Zencart will list it as 30 different product instead of 1 product with different attributes like Stock by Attribute. It a pity that the current version of Phreebooks can't work with Stock by Attribute.
In your next version, would you be able to add some connectors to link up your Stock by Attribute and Phreebooks product attributes? It will be perfect if this can be done and I am sure it will benefit a lot of both ZenCart and Phreebooks user.
Hi,
My attributes are only appearing on certain products. It appears to be on products that I have more than one attribute option on eg, size & colour
I haven't changed anything that i'm aware of, but even if I had, i would have thought it would effect all products, not just some.
The products that the drop-downs aren't showing on, seem to be picking up something in the background as prices are showing as 'starting at'. I have checked the source code, and the script stops at stock by attributes and is just blank, then carries on after.
I have checked the php stock by attributes as I was told of a bug that sometimes but random spaces, commas in but can't see anything unusual.
Does anyone else know of this problem and if it can be resolved? Would installing the new version maybe fix this issue?
Thank you
This is a link to one of the problem products: http://www.therummagehole.co.uk/~the...roducts_id=559
However, this product is working fine: http://www.therummagehole.co.uk/~the...&products_id=1
Hello,
I'm running version 1.3.9h of zencart ... which version of the add on should I use ? can I use the latest one ?
thanks
The most current version will cause some problems, I think you are better off using:Quote:
Originally Posted by Akasashasha
Stock by Attributes - Version: 1.4.14
That said, I recall that 1.4.14 does have a few quirks you should read through the forum to understand.
I just downloaded the most recent SBA from the downloads area. This is on a fresh upgrade of Zencart from 1.3.9 to 1.5.1. All products already existed before re-installing SBA for Zencart v1.5.1. This is the very first mod I have re-installed.Quote:
Originally Posted by potteryhouse
I have my attributes set up exactly as shown in your screenshot; however, I am getting an 'Out Of Stock' next to my display-only attribute. This attribute has not been added in the SBA page for any product. Do I need to add a stock level to a display-only attribute? Or am I doing something wrong?
Attachment 13739
The version I placed out for testing (in a previous post on this thread) should resolve the issue you described.Quote:
Originally Posted by k1ra
Also, I am working on a final update to this test version to be placed in the downloads. I hope to have that ready soon.
stock_by_attribute_1.5.X_TEST_3.zip
Please let me know your results. Thanks
The ability to list 1 products with multiple product attributes is DEFAULT Zen Cart Behavior. All SBA does is allow you to track STOCK LEVELS by each attribute combo. Phreebooks is the issue here.. What you are asking after is REALLY a modification needed for Phreebooks so that it properly uploads products with attributes to Zen Cart as one product with multiple attributes..Quote:
Originally Posted by Defanci
Has there been any progress as to a product used as an attribute that needs to have the exact same ID each time it is used as I posted before?
Mal
Quote:
Originally Posted by Malaperth
Sounds to me like what you need is a DISCOUNT module so that you can link products in a way that the purchase of one yields a discount on the other.. This kind of functionality isn't what SBA is used for. SBA is to track stock of product variants (attribute combinations).Quote:
Originally Posted by Malaperth
I'd suggest looking for discount add-ons in the plugins section of this site or look for the "That Software Guy" website. swguy is the undisputed "Duke of Discounts" as he has the most and best discounting add-ons for Zen Cart..
http://www.zen-cart.com/member.php?22320-swguy
His "Better Together" module sounds like what you should be looking at..
Quote:
Originally Posted by DivaVocals
Possibly, but, from what I can tell, that add-on does not keep track of stock, and that is what I need.
Mal
You are mixing apples and oranges here.. your words:Quote:
Originally Posted by Malaperth
Zen Cart OUT THE BOX allows you to keep track of stock.. so create your two products (tea ball/infuser & bag of tea), set your stock levels for each product and use a DISCOUNT MODULE like "Better Together" so that when a bag of tea is purchased the customer will be offered a discounted price if they then purchase the tea ball/infuser..Quote:
my wife sells teas, and we want to provide a discount on a tea ball/infuser if you buy a bag of tea
You REALLY can't do this with the default product attributes not without some serious re-coding of the default attributes management in Zen Cart.. This still isn't really an SBA modification..
Ok, was just responding to what Pottery House said to do, which was inadequate. Guess I'll try Better Together and see what happens. Thanks!
Mal
Perfect! That did seem to get rid of the 'Out Of Stock' message next to my read-only attributes on all existing products!Quote:
Originally Posted by potteryhouse
I just upgraded a site to 1.5.1, using SBA v1.5.2. They only have quantities set up for a few of their attributes. On their old site with a much older version of SBA, if attributes don't have quantities set, they default to the total product quantity and still allow checkout. On the upgraded site, if they don't have quantity for the attributes on a product, they show as out of stock. I'm not sure how to get around this? They have many products with attributes that don't require stock levels, so they don't want to have to go through and add stock to every attribute.
I will be uploading an updated version to the plugins for the Zen Team to check soon. No sure what is involved for them, but I suspect it will take them a couple days based on their workload before they can get to it. In the mean time I think the version i posted in this thread as TEST 3 should work okay, it is almost the same as what I will be submitting. Main differences are the instructions have been updated, the version number in the files are updated, and the script to add attribute combinations in the stock pace is updated.Quote:
Originally Posted by Danielle
http://www.zen-cart.com/showthread.p...02#post1231102
stock_by_attribute_1.5.X_TEST_3.zip
I have now noticed that when I add a product to cart, and the quantity is more than what is available, I get the *** in the Shopping Cart Display, but there is no 'Out Of Stock' notification on the Product Info Display. I am using radio buttons.Quote:
Originally Posted by k1ra
Based on you description, this is correct.Quote:
Originally Posted by k1ra
There is stock available so the product info page will not show as out of stock. But if a customer orders more than what is available, they get the out of stock or low stock warning in the shopping cart.
You can turn these warning off if you do not want then, the setting is described in the instructions.
The setting is in the "Configuration -> Stock" page, (Check Stock level - Check to see if sufficient stock is available . Options (True/False))
Also note, the latest version is now available in the downloads plugin area. I am removing the TEST version, so the link in the forum will no longer work for those old tests versions.
Hi Potteryhouse et al.,
I'm currently testing my FEC install and noticed that, while SBA continues to work wonderfully by displaying low stock in the shopping cart as appropriate, it no longer displays it on the order confirmation page the way it did without FEC installed. I upgraded to SBA 1.5.3 hoping this would help, but it didn't. I noticed the SBA code resides on the confirmation page betweenand the product looping thingy, so I inserted it (the SBA code) in that spot in the 3 FEC tpl files that contain the above code (tpl_fec_confirmation_default.php, tpl_checkout_stacked.php, and tpl_modules_esl_ordertotal.php), but that didn't solve the problem. I am going to ask on the FEC support thread, as well, but perhaps Potteryhouse or someone else here can point me in the right direction as to what else I need to do?Code:<?php echo $stock_check[$i]; ?>
One question that comes to mind is - does the SBA code in tpl_checkout_confirmation_default.php use any jquery file(s)? If so, which one(s)? FEC has you install the CSS/JS Loader, which changes how jquery is called, perhaps it's simply not calling the jquery files needed on the confirmation page...
Thank you!
Magz
Hi all,
Firstly, sorry if this has already been discussed.
Using the latest version of SBA from the downloads section on zen cart 1.5.1 which also has latest version of edit orders installed.
If you create or edit an order via admin the stock quantity for the variant is not adjusted, although the total stock quantity is.
Has anybody else experienced this issue?
This issue isn't really caused by SBA, more a case of Edit Orders following a different process to the norm.
I've resolved it by editing the functionality of Edit Orders module and variant quantities are now updated correctly.
the "norm" being the SBA stock variant quantities?? lets be clear.. Edit Orders is not "following a different process".. Edit Orders manages the STOCK Zen Cart inventory management.. you needed to modify things to work with SBA stock management.
Quote:
Originally Posted by strelitzia
I'm well aware of this. What i was referring to as "the norm" is that when adding a product to a customer order via Edit Orders, it does not go through the normal shopping cart process where the SBA code is followed, so in that respect, yes, Edit Orders does follow a different process.Quote:
Originally Posted by DivaVocals
my comment was not directed to you as much as it was making sure it was clear for those following this thread.. your prior post implies something that's not completely true. edit orders follows the stock check out & inventory path. when editing an order... and that is what I was trying to make clear. SBA's inventory management is not the norm and it is not the stock inventory path..SBA is a modification to the stock inventory process..
Quote:
Originally Posted by strelitzia
Ok, I've searched all over and can't find an answer.
When I try uploading "products_with_attributes_stock.php" into my renamed admin folder I get a "226 ***MALWARE DETECTED***" error.
I'm using FileZilla and my hosting is with GoDaddy. :censored:
v1.5.1
Hi,Quote:
Originally Posted by outbreak
First let me say there is not any malware in this plugin that I am aware of. I have looked through most of the code while making updates and nothing seemed out of place to me from that respect. If you have a specific piece of code identified please let us (the forum) know so it can be looked at.
There are 6 files with the name you identified that are placed into the admin in different directories, I will assume at this point that the file in question is in the main admin folder and not a sub-directory of admin.
In the past I have heard from a user that GoDaddy did not like the eval() (php statement) that was used in this file as part of a loop, I rewrote that section to remove the eval(). It is possible that GoDaddy does not like the way the new loop works. Since I have never used their service I can not test this, but if you want to try this and let us know if it resolves the warning here is my suggestion.
Try to upload the same file from version 1.5.2. The primary change to this file was the loop for adding all variables at the same time, there are also some cleanup / sanitation of user provided variables to try and protect your input.
I should note that the version of the file from 1.5.2 does have the eval() code in it that GoDaddy complained about to another user of this mode.
If this resolves the malware warning, you might consider just using that file version, it will not provide the newer options but I think is will still work as long as GoDaddy does not complain about the eval(). Remember to thoroughly test you site to ensure things work as they should.
As a note, I also use FileZilla, and have not seen this kind of warning while using it. What local antivirus are you using, that may be what is flagging the file.
I’ve tried both FileZilla and CuteFTP – once the file gets loaded onto the server, it’s then immediately deleted. I did however try GoDaddy’s built in FTP program and the file loaded fine. Attached is a screen capture (of only the relavent info) of CuteFTP’s log which is the same as FileZilla.
I apologize, when I said 1.5.1 – that’s my Zen Cart version. I’m using SBA version 1.5.3. I’m also running Symantec Endpoint Protection, however I ran both that and Malwarebytes on my system and they didn’t detect anything. So it’s strange that I can’t upload using any FTP, but I can using GoDaddy’s built in FTP program.
Attachment 13894
Hi all,
first thanks to potteryhouse, great job man :-)
I found an issue (no big deal really) but i'm not able to understand if it's related to just me or is "common" (searched the thread but didn't found anything).
If you use "sync quantity" on a product that doesn't have any quantity variant defined it will put the grand total to 0, so basically if You have mixed articles, some with SBA defined and sone not, and You use the "sync all quantity" function all the articles without SBA defined will have the Grand quantity set to 0.
It doesn't generate any log error so I assumed it's some sort of result out of ordinary...
If some one walked into this and have any info to share it will be appreciated :-)
SBA: 1.5.3
ZenCart: 1.51
I'm, 99.9% sure this is an issue with GoDaddy. I've use CuteFTP and FileZilla on two different computers and get the same message. However when I use GoDaddy's built in FTP, everything works fine.Quote:
Originally Posted by outbreak
Also, it was NOT ONLY this module, it happened with MANY other modules and even the Zen-Cart install.
BTW, this module is EXCELLENT! Thanks for the hard work!
Thank you, I'm just giving back to the community when I can, since we do use and like Zen Cart.Quote:
Originally Posted by outbreak
Hello. I am trying to figure out this SBA addon. My question is, say I have 3 pink shirts (S,M,L) and I have 1 of each size. These shirts have a monogram on them. Say I also am using these same 3 shirt for a different product that has a different monogram. Since these will be personalized I don't make them upfront.
HOW do I put the stock of these attributes when they are used on different products using the color attribute to define what is in stock.
do you only have a few monograms or is this something you want to do over lots of products using the same 3 tshirtsQuote:
Originally Posted by vibrantdesignz
bn
I mainly want to define the stock by the size and color. On adult shirts I have 2-3 products that use the same size/color shirts.
Product #1: Left chest monogram
Product #2: Applique/Pocket Monogram
Both listed products use the same size/color shirts.
The monogram part is just an addon for people to choose the variety of the shirt.
Is this a GENERIC stock pool to which an OPTIONAL applique/monogram can be applied?? You say that you have 2-3 products which use the same size/color combo.. Do you keep these size/color combos as unique counts separate or are they from the SAME pool of shirts..Quote:
Originally Posted by vibrantdesignz
Let try and clarify what I mean.. You have 20 large pink shirts in total. Are 10 allocated for one product and 10 allocated for another product with the ONLY difference between the two products being the applique/monogram??
Either way if I understand you correctly, are you saying that the applique/monogram is an OPTIONAL attribute and is not to be INCLUDED in the stock tracking..
The amount of shirts are the total shirts I have. I have 3 shirts in total that I want to use for both listings. Yes, the monogram/applique is an optional attribute.
That's what I thought you were getting at.. the short answer is you can't have TWO products sharing the SAME stock.. If you have 10 large pink t-shirts you can't SHARE them with two products..Quote:
Originally Posted by vibrantdesignz
SBA allows you to create product variants based on attribute combos. (color/size for example) you can then track stock for each variant.. So if you have two products which vary because of a logo or some other variance you will need to decide how many of your large pink t-shirts will be allocated to each product.
Okay. I thought that was probably the answer, but I wanted to double check. Thank you for you quick reply. I appreciate the help.
I took over the size that somebody else built and then disappeared. The site uses Zen Cart 1.5.0 and some old version of the Stock by Attribute addon. Its files have a date stamp of 10/16.12.
As of 3/2/14, stock numbers stopped updating when a product with an attribute is sold. The addon was working flawlessly before that. No changes were made to the site around that time, so my guess is something changed in the host environment. The host is GoDaddy, pretty unhelpful with the issue.
I want to update the addon to its latest version, but http://www.zen-cart.com/downloads.php?do=file&id=202 says the addon only works with Zen Cart 1.5.1.
Do I have to update Zen Cart in order to update the addon? I would rather not doing it right now because the previous designer left no documentation, and I am still wandering through the code figuring out what other addons were used, etc. I feel that without knowing what's under the hood I may break something else if I update Zen Cart to 1.5.1.
The stock problem can't wait until I am done, so I would rather update only Stock by Attributes right now. Is it safe? Or will I end up with a broken site?
The site in question is at http://southernwhimzy.com/.
Forgot to add: the Stock by Attributes addon currently in use has a string in its files like this one:
version $Id: products_with_attributes_stock.php 389 2008-11-14 16:02:14Z hugo13 $
I can't figure out what version it is, but maybe someone else knows.
Attempting to install SBA 1.5.3 on my Z-C 1.5.1 install - at the end of a long upgrade from 1.3.8.a running SBA (probably) 4.7. After merging and uploading, I run the Full/Upgrade DB Install and receive an error.
Log reports:
PHP Fatal error: 1054:Unknown column 'sort' in 'products_with_attributes_stock' :: ALTER TABLE `products_with_attributes_stock`
ADD COLUMN `customid` VARCHAR(255) NULL DEFAULT NULL AFTER `sort`; in path/to/store/includes/classes/db/mysql/query_factory.php on line 120
Any thoughts or suggestions? I'm stumped.
did you look in your database to see does the sort column exist ?
looks like its wanting to add the customid after the sort column in that table
checking my database there is sort column then custom id column
bn
if you find sort column missing you could try the following in your admin -> install sql patches
remember backup as im no expert !!
ALTER TABLE products_with_attributes_stock ADD sort int(11) NOT NULL default 0 after quantity;
then run the stock by attributes install again
hope this helps
bn
Looks like two lines in the installation script need to be swapped:Quote:
Originally Posted by Randolph Hoppe
In the installation file on lines 416 and 417 re-order the lines:
to:Code:alterSBAtableCustomid();//Call function to Alter table products_with_attributes_stock to add customid
alterSBAtabeSort();//Call function to Alter table products_with_attributes_stock sort field
Code:alterSBAtabeSort();//Call function to Alter table products_with_attributes_stock sort field
alterSBAtableCustomid();//Call function to Alter table products_with_attributes_stock to add customid
Thanks, all. I think I'm good now!
Hi,
There is a field called stock_attributes in the table of products_with_attributes_stock.
There are some numbers in this field and I have no idea what they refer to.
Can someone please give me some clue?
Thanks in advance!
Those are references to the products attributes, it is how the mod is able to trace the product ID to the applicable attribute.Quote:
Originally Posted by caborela
The IDs are extracted (based on) a products attributes from the table "products_attributes" the IDs are from the field "products_attributes_id"
Note that if there are attribute combinations, than there will be two or more references there separated by comma.
This sample query (used only to help explain the example) may help you understand:
Here we do a SELECT query from three tables "products", "products_attributes", and Products_options".
The resultant IDs from the select query are than inserted into this mods new table "products_with_attributes_stock" into the applicable fields (products_id, stock_attributes, quantity).
This is just an example query, for explanation of the new tables field data, you should never run query's you do not fully trust or understand or have not tested on a TEST system!Code:INSERT INTO products_with_attributes_stock (products_id, stock_attributes, quantity)
SELECT p.products_id, pa.products_attributes_id, p.products_quantity
FROM products p
LEFT JOIN products_attributes pa ON (p.products_id = pa.products_id)
LEFT JOIN products_options_values pv ON (pa.options_values_id = pv.products_options_values_id)
WHERE pa.products_attributes_id is not null
AND pa.options_values_id > 0
ORDER BY p.products_id, pa.products_attributes_id
ON DUPLICATE KEY UPDATE
`products_id` = products_with_attributes_stock.products_id;
I hope this helped.
Thanks, potteryhouse! :laugh:
Hey all - running into a slight problem with SBA regarding products with multiple drop downs. Not sure how it needs to be properly set up in order to have the correct stock for each item (ie. "Black" in "Youth Large"). Right now it'll show certain items as being in stock even when they are sold out in the backend.
I set this up at the recommendation of our hosting company, GeekHost. For the record, they're absolutely amazing with what they do and even though this is not a module they made they've been super helpful with this problem. :D
For clarity, the product also has a "White" color on the product page. See pics for reference. Any help on this to optimize the backend would be greatly appreciated!
Attachment 13993
Attachment 13994
On just one product entry, for a test, I suggest you try removing (delete the SBA entry) for the Stock IDs 1487 to 1491, these are the single entry items, it looks to me like you need the attribute combinations, that will be left. Than set the quantities as you need and test. The mod looks at this table, first for combinations, than for single entries, to find stock available.Quote:
Originally Posted by Christian_Wagner
Just a suggestion.
Unfortunately it tells me the product is out of stock :(. That's how we used to do it and when we upgraded to the new version it messed it up.Quote:
Originally Posted by potteryhouse
I must ask, are you using Zencart 1.5.1 and upgrading from mod version 1.4.x ??Quote:
Originally Posted by Christian_Wagner
If so, did you run the installation script "admin/stock_by_attr_install.php", (and test on a test site first?).
Are you using mod version 1.5.3, you may need to follow the small correction here to the install script:
http://www.zen-cart.com/showthread.p...01#post1242901
The script adds some configuration settings to the "Configuration -> Stock" page in admin.
See instructions "Instructions/htm/notes.html" for some additional notes.
Currently working on 1.5.2. Not sure why but I'm having trouble installing 1.5.3 even though I installed 1.5.2. :(Quote:
Originally Posted by potteryhouse
What issue (error messgaes) are you having with the installation of version1.5.3 mod?Quote:
Originally Posted by Christian_Wagner
Also, note that version 1.5.3 supports the multiple attribute combination you want, 1.5.2 did not.
The install script has a file check option to see if all the files are in the correct place, you might try running that to see if it helps narrow the install problem down.
Quick question, and I apologize if it's already been asked. I would like to remove the quantity remaining, how would I go about that?
Thank you!
Sorry for the late reply. Been trying to make it work. Sadly, I haven't. After merging the files in Araxis and installing correctly, it makes the store non-functional. Just a blank white screen. Not sure what the issue is.Quote:
Originally Posted by potteryhouse
I am willing have a look at the files you modified it you would like.Quote:
Originally Posted by Christian_Wagner
Just zip the modified files up and send me an FTP link, there is a chance I might find your problem...
Please Do Not include private information like database name, passwords, or secret admin folder name, sanitize any of these that may be in the files.
Hi, I read your question, but am not clear on what you need, do you want to zero out the values in the database table for these attributes, or is this text on the web page you want changed?Quote:
Originally Posted by outbreak
Sent. Thanks!Quote:
Originally Posted by potteryhouse
Based on the files you sent, it looks like you forgot to update the attributes.php file.Quote:
Originally Posted by Christian_Wagner
This file was moved to a template override folder in version 1.5.3, but if you just replace the one in \includes\modules with the new one things should get better.
\includes\modules\YOUR_TEMPLATE\attributes.php
The version under your \includes\modules folder is no longer any good, will not work with the code updates.
Hi Can anyone help, when i first installed SBA i had a minimum delivery section which i deleted, now my site keeps going wrong, when i add a attribute i get a error message on checkout and shipping estimate, if i dont add one it works fine does anyone know of an easy fix ive tried updating the database and trying again but it does the same everytime i reinstall it and now im not getting the delivery option
Need more information before being able to venture a guess.Quote:
Originally Posted by Tony Kast
What version of SBA did you install? As there are several versions of this branch of the mod and there are also other branches that are supported in other threads.
In what file (and what line number) did you delete the "minimum delivery section"?
Also need to know which version of Zen Cart you store is using?
Hi Thanks for your reply, i unistalled the module and reinstalled it a few times and i managed to get the minimum delivery option back, im now having another problem though all of my items are showing out of stock, regardless of how many i have they all say the same amount and then out of stock when i test a check out, im using Stock By Attribute (SBA) installation script SBA Version 1.5.3 for Zen Cart Version 1.5.1 By POTTERY HOUSE my shop is at sharerescue.co.uk/shop
thanks for any help you can offer
The issue looks like a simple configuration problem.Quote:
Originally Posted by Tony Kast
The instructions included with the mod should help you, if you have suggestions to make the instructions clearer or otherwise improved please send to me as I am currently working on a new version that improves the selection list and rotates the image on selection change.
Basically, you should do the following.
1. in admin, goto 'configuration -> stock' and make changes as you need to make you page look as you want.
2. in admin, goto 'catalog -> Product with Attribute stock (aka SBA)' and add stock and combinations that you need for each product.
The instruction with the mod should help with understanding what each option does.
Note that each time you run the SBA installation script it resets all options to a default state, thus if you previously made these changes but than ran the installation script again, everything is reset.
Zen Cart v1.5.1, SBA 1.5.3. Clean install with only the SBA files in a new template.
I have "SBA Display Custom ID" = true.
I created an product with 2 attributes, size XL and XXL, and gave them each a custom ID (11111111111111 and 22222222222222).
When I add both XL and XXL to the shopping cart, it looks like this:
However, once I get to checkout_comfirmation, it now looks like this: (testtest123 is the product model)Code:test
item # 11111111111111
Size - XL
test
item # 22222222222222
Size - XXL
And so it stays once I completed the order. In Customers/orders, and everywhere else (invoice, etc).Code:test
item # 11111111111111
Size - XL
test
item # testtest123
Size - XXL
It seems that the custom ID is replaced by the product model for all but the first attribute.
What could be causing this? How can I fix it?
It seems the error is introduced in this section: (/includes/functions/extra_functions/products_with_attributes.php line 98)
Removing the if/else and leaving only the second option solves the custom ID issue.PHP Code:if(sizeof($attributes) > 1){
$first_search = 'where options_values_id in ("'.implode('","',$attributes).'")';
} else {
//even though there is only one attribute, it is still in an array and must be retrieved
foreach($attributes as $attribute){
$first_search = ' where options_values_id="'.$attribute.' "';
}
}
Obviously you could also raise the number in the if statement so that it is never triggered.
This however seems like a flimsy solution at best.
The issue remains on the other pages though. (orders, invoice etc)
Altering this in the same way solves the customer ID issue on the other pages.. (/admin/includes/classes/products_with_attributes_stock.php line 513)
Im not sure I would risk using this on my live site, but it seems to work alright on my test sites.PHP Code:if(sizeof($attributes) > 1){
$first_search = 'where options_values_id in ("'.implode('","',$attributes).'")';
} else {
//even though there is only one attribute, it is still in an array and must be retrieved
foreach($attributes as $attribute){
$first_search = ' where options_values_id="'.$attribute.' "';
}
}
For non SBA-products, the product model replaces the custom ID. This works fine in the cart, but yet again, not in the checkout nor order/invoice/etc.
Reading the code, it seems like this was supposed to work. (/includes/templates/YOUR_TEMPLATE/templates/tpl_checkout_confirmation_default.php line 165)
That elseif is suposed to grab the products_model and use it in place of the custom ID, but it does not work.PHP Code:<?php
// START "Stock by Attributes"
$customid = null;
$tmpCheck = null;
if( STOCK_SBA_DISPLAY_CUSTOMID == 'true'){
if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
//create array for use in zen_get_customid
for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) {
$attributes[] = $order->products[$i]['attributes'][$j]['value_id'];//value_id option_id
}
$customid = '(';
//get custom ID
for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) {
if( $tmpCheck != zen_get_customid($order->products[$i]['id'],$attributes) ){
$tmpCheck = zen_get_customid($order->products[$i]['id'],$attributes);
$customid .= ' ' . zen_get_customid($order->products[$i]['id'],$attributes) . ' ';
}
}
$customid .= ')';
}
elseif(isset($order->products[$i]['products_model'])){
$customid = '(' . $order->products[$i]['products_model'] . ')';
}
}
echo $customid;
// END "Stock by Attributes"
?>
At line 158, several calls in the non-SBA code omits the products_ prefix, so I did the same. And that worked.
Now, if I alter /admin/orders.php to display custom ID instead of product model, there will be a consistent display throughout the catalog and admin.PHP Code:<?php // now loop thru all products to display quantity and price ?>
<?php for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { ?>
<tr class="<?php echo $order->products[$i]['rowClass']; ?>">
<td class="cartQuantity"><?php echo $order->products[$i]['qty']; ?> x</td>
<td class="cartProductDisplay"><?php echo $order->products[$i]['name']; ?>
<?php echo $stock_check[$i]; ?>
At every step, each product or product attribute, representing actual products in my store, are listed with their unique EAN.
This may not be how everyone uses SBA, but it certainly is how I want it to work.
At any rate.. are these alterations I've made fixes to flaws in the code, or should I look elsewhere for the actual cause of my problem?
Thanks for any help!
I plan to look at this soon (within a week I hope), to verify your findings, and provide an update. Thank you for the information (and code samples), there are always scenarios we overlook or do not see when working and testing code updates, this testing and feedback you and others provide is very important. I will post what I find, and a package for others to test prior to adding to plugins.Quote:
Originally Posted by SHK
Brent
Hi!
I have problems with Custom ID too
a made fresh install on test server. zencart 1.5.1 and last stock by attributes, nothing else
1. I have only one product with 3 colors and 3 sizes, and Custom IDs
Attachment 14091
2. Lets add them to the cart, we see that custom id is showing correctly
Attachment 14092
3. Let's go to checkout page - Only One custom ID is showing, others are blank ( )
Attachment 14093
4. And now we confirm order and let's go to admin panel to watch new order
Attachment 14094
Only one Custom ID is showing, second custom id is wrong :-// other are blank
I need a solution for this. Thank you
I installed this and everything seems to be working fine but am getting a blank page when I checkout - the file link on URL is -
http://importedhai.com/index.php?mai...ckout_shipping
Can you please help what file am I missing out - Thanks
I think it's the includes/modules/pages/pages/shopping_cart/header_php.php file. I'm having a similar problem.Quote:
Originally Posted by AmitVKaria
Have you checked your error log? If so, please post the error message.
The error log in my cPanel isn't showing anything. I've had a problem installing the mod for some time now. I'm not sure where it's going wrong :/Quote:
Originally Posted by jeking
Not cPanel, your Zen Cart log. If you're using 1.3.9, it will be in your cache folder in your store root.
I'm an idiot.Quote:
Originally Posted by jeking
Error: [09-Jun-2014 22:04:40 UTC] PHP Fatal error: Call to undefined function cartProductCount() in store/includes/modules/pages/shopping_cart/header_php.php on line 178
Nope, not an idiot. Just learning.
Check your install to be sure everything is where it belongs. As the error says, the function has not been defined.
I thought I had it installed properly. Merged everything properly using Araxis (or so I thought) but I'm not sure where it could be going wrong.Quote:
Originally Posted by jeking
Want to see if the files are correct?Quote:
Originally Posted by jeking
See PM.
I spoke to PotteryHouse and Jeking privately. Make sure you guys follow EXPLICITLY where to place the files and ANY file that is a PHP will be called by ZenCart. Even if you keep a backup, it'll try to call for it and therefore confuse the site if you have two of the files. Make sure any backups have an extension like "_php" or ".bak"
Thanks guys!
Ola!
I am just looking for some clarification on the Gift Wrap issue as I have read the last 50 pages of this thread and now my head is shot.
I have zencart v1.5.1. using "Stock by Attributes" (version 1.5.3) installed on a personalised mugs site
The reason for installing SBA is to primarily add EAN code for all attribute products using the custom id field so they can be available for a Amazon Marketplace inventory feed. As this is the case I could just turn "check stock level" off but I am just interested in getting it working.
So here's the story:
I have one text field that is for customers to add their personalisation which is not required for stock purposes - I then have two drop downs - one for design colour and one for mug type, both are required for stock purposes.
If I add all the above details to an order the checkout shows "out of stock". If I leave the personalisation field blank its fine.
If I add the personalisation field into SBA as a variant and assign it a qty its also fine however if I did this I would then have to spend ages cleaning up the Amazon product feed.
Is this the only way of dealing with the Gift wrap issue?
Cheers
Brinley
I see what you are saying, I will have a look at this and get back to you.Quote:
Originally Posted by welshop.com
I think it should be a small change to one of the tests in the attributes.php file, it should be ignoring text fields.
I had thought I had accounted for this already...
I'm attempting to install SBA Version 1.5.3 for Zen Cart Version 1.5.1 but get errors:
Adding to configuration:
Inserted PRODUCTS_OPTIONS_TYPE_SELECT_SBA into configuration: 1
/admin/products_with_attributes_stock.php FAILURE
/includes/modules/classic/attributes.php FAILURE
/includes/templates/classic/templates/tpl_shopping_cart_default.php FAILURE
/includes/templates/classic/templates/tpl_account_history_info_default.php FAILURE
/includes/templates/classic/templates/tpl_checkout_confirmation_default.php FAILURE
I have attempted to upload these 5 'missing files' several times via FTP and although they appear to transfer don't show server side for some reason?
This a clean install hosted on Goddaddy linux.
Any help would be great thanks.
***UPDATE***
I have managed to use Godaddy's FTP system to upload the missing files and all is working!
Thank you for what looks like a great addon, the sync feature especially is quite excellent. :cool:
Hi,
I have installed stock by attributes version 1.53 on a test server. There is nothing else installed apart from the stock Zen Cart install.
I can export the SBA data to a csv file, however when I change the quantities of the products with a custom id and import them back, the quantities don't get updated?
I really hope this can be resolved, or somebody can help, as this is the main reason I need this module.
Thanks
Has the latest version been fixed to work properly with the Dynamic Filter plugin? As it says it has but it still doesn't work?
Thanks
I just tested this feature on my test server, I was able to both change the attribute quantities and add custom IDs.Quote:
Originally Posted by kitten091182
Please make sure that you uploaded the changed file to the server (i.e., replaced the original with the updated file) and try again.
Let us know how it goes.
Hi, is there any plans of getting this mod updated / ported to work with the latest version of Zen Cart 1.5.3 or is it already compatible?
Hi,Quote:
Originally Posted by potteryhouse
Which changed file in particular are you referring to? I re uploaded all the files and still no joy. I can change quantities/custom ids on the page, but cannot change them still by importing the CSV. No worries if you can't help, I can just run a query directly through SQL.
Thanks
Have a look at the instructions provided with the mod "stock_by_attribute_1.5.3\Instructions\htm\export-import.html"Quote:
Originally Posted by kitten091182
You need to have run the export to generate the file, than make changes to this file and re-upload and run the import.
Here are a couple notes from the instructions:
"this script exports a comma delimited csv file called tableSBAdata.csv, placing it under YOUR_ADMIN/temp/ folder."
" update the quantities and customid for attribute variants"