Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[cefyn]

Brilliant, mc, thanks. The changes in lines 54,114, and 128 are enough for the server to accept the file upload.

[mc12345678]

Brilliant, mc, thanks. The changes in lines 54,114, and 128 are enough for the server to accept the file upload.

Thanks for the feedback and identification of the issue, will incorporate those changes to the file.

[frank18]

Just also realized... Never said from where the "latest version" was obtained.... The fully functional version that works for ZC 1.5.1, 1.5.3, 1.5.4 and 1.5.5 can be found: https://github.com/mc12345678/Stock_...butes_Combined

A few questions how to install your version (Stock_By_Attributes_Combined-master):

Does it require to first merge / upload the 2 folders admin and includes and then merge the contents of say the folder 1_5_5 for a ZC 1.5.5e store?

Ofc renaming the admin and YOUR_TEMPLATE folders.... and running http://YOUR_DOMAIN/YOUR_ADMIN/stock_by_attr_install.php to install SBA

Is that the correct procedure?

Thanks

[mc12345678]

A few questions how to install your version (Stock_By_Attributes_Combined-master):

Does it require to first merge / upload the 2 folders admin and includes and then merge the contents of say the folder 1_5_5 for a ZC 1.5.5e store?

Ofc renaming the admin and YOUR_TEMPLATE folders.... and running http://YOUR_DOMAIN/YOUR_ADMIN/stock_by_attr_install.php to install SBA

Is that the correct procedure?

Thanks

Yes, that would be the recommended sequence of incorporation. The base includes and admin directories, and then the same for the ones within the specific version.

[frank18]

Yes, that would be the recommended sequence of incorporation. The base includes and admin directories, and then the same for the ones within the specific version.

Thanks mc

[propcity]

I have tried a few services to no avail to sync my inventory for eBay and Zencart. SBA is needed for the variations on the products I carry, but I don't think there are any sites out there that support the additional database table created by SBA.

Does anyone know of such an integration? I'd be most grateful for your knowledge.

Thanks!

[mc12345678]

I have tried a few services to no avail to sync my inventory for eBay and Zencart. SBA is needed for the variations on the products I carry, but I don't think there are any sites out there that support the additional database table created by SBA.

Does anyone know of such an integration? I'd be most grateful for your knowledge.

Thanks!

The generated table is not as important as the data that is maintained/obtained. The customid is added to data collected from the order class when it is known. For example, if the order is pulled by order number or if working through the checkout process and the product has attributes, then product data is updated to include a field called customid. If instead the products_model needs to be used, then it too could be updated as necessary to accept the customid as entered. If the global $order variable is present, then the following would be an example of the data returned:

$order->products[$index]['customid']['value']

It is also possible to "calculate" the customid by providing the attribute information that would be expected as needed to determine the customid through a class function.

Basically in any program related situation, the specific table structure should have no bearing on the operation of an external program provided there is a some sort of interface available to provide the data needed. So the real question is what data is needed and of course based on what available information so that if the function doesn't exist that it can be added.

[jeking]

I'm wondering if this is possible. A client needs to track only some attributes, specifically color and size. They need to mark some combinations as out of stock because they do not exist. Currently size and color are standard Zen Cart drop-downs so a customer can order any combination.

If we install SBA and I set only those combinations to zero, what happens to all other other attributes and combinations? Meaning, do I need to add a stock level for *everything* or if combination is not set in SBA, will it be allowed to be ordered?

[mc12345678]

I'm wondering if this is possible. A client needs to track only some attributes, specifically color and size. They need to mark some combinations as out of stock because they do not exist. Currently size and color are standard Zen Cart drop-downs so a customer can order any combination.

If we install SBA and I set only those combinations to zero, what happens to all other other attributes and combinations? Meaning, do I need to add a stock level for *everything* or if combination is not set in SBA, will it be allowed to be ordered?

If I understand correctly:
product has 2 attributes (size and color)
sizes are: 4, 5, 6, and 7 (as an example)
colors are: red, blue, and green (again limited example)
But... Size 7 doesn't come in green and sizes 4 and 5 don't come in red and blue, respectively.
The attributes are added as combinations (4 and blue - quantity 5, 5 and red -quantity 10, 6 and all colors quantity of 4, etc...)

The question becomes what do you want to ultimately display? (ie. out-of-stock for product that do not ever exist, out-of-stock for product that only can exist, or don't show out-of-stock for product regardless of their on-hand quantity or potential existence?)
You could display an out-of-stock for 7-green, by defining 7-green as a stock of 0 and allowing out-of-stock to be displayed, but more than likely if you want to show out-of-stock related quantities, then you would want to only define those quantities as possible/in-stock.

So, with Dynamic Dropdowns enabled, showing out-of-stock product, if you only define the group(s) that exist/are possible and ignore those that do not/can not exist, then the customer (with javascript enabled) will be shown the options that exist (in quantity) or those that could exist (as out-of-stock until replenished).

If the customer disables javascript, then they will "see" all of the options, but upon submission of their request (add-to-cart), should be told that the quantity is out-of-stock/doesn't exist and be requested to choose a different option.

Now... If back at the start of this, you wanted to have 3 selections, only two of which are stock dependent, SBA does not yet directly support such a review, because the add-to-cart feature/function specifically looks to validate that the selection(s) made exist within the SBA table in order to prevent selling an item that is not in stock.

Now... Are there ways to work around that, I think the answer is yes, though I haven't tried to fill the database with data to support other than if a product is entered with combination style attributes AND individual style attributes, if a combination is not found, but a quantity can be generated from the individual attributes then the quantities across each of the individual attributes would be reduced. This doesn't help/automate the overall stock tracking, but until that next feature has been flushed out, it is not possible (without other code modification) to identify a modifiable attribute as non-stock dependent (a read-only attribute is not modifiable but also could be displayed for a given product).

Perhaps overkill, but my plan is to implement the ability to "excuse" an attribute from stock tracking at almost all conceivable "levels" to minimize the effort to generate product attribute quantities and to simplify the database lookup process...

Hope that helps.

[jeking]

If I understand correctly:
product has 2 attributes (size and color)
sizes are: 4, 5, 6, and 7 (as an example)
colors are: red, blue, and green (again limited example)
But... Size 7 doesn't come in green and sizes 4 and 5 don't come in red and blue, respectively.
The attributes are added as combinations (4 and blue - quantity 5, 5 and red -quantity 10, 6 and all colors quantity of 4, etc...)

The question becomes what do you want to ultimately display? (ie. out-of-stock for product that do not ever exist, out-of-stock for product that only can exist, or don't show out-of-stock for product regardless of their on-hand quantity or potential existence?)
You could display an out-of-stock for 7-green, by defining 7-green as a stock of 0 and allowing out-of-stock to be displayed, but more than likely if you want to show out-of-stock related quantities, then you would want to only define those quantities as possible/in-stock.

So, with Dynamic Dropdowns enabled, showing out-of-stock product, if you only define the group(s) that exist/are possible and ignore those that do not/can not exist, then the customer (with javascript enabled) will be shown the options that exist (in quantity) or those that could exist (as out-of-stock until replenished).

I do think you understood the question correctly.

Ultimately either out of stock or not displaying any unavailable combination does the job. I was hoping to avoid setting up all the available combinations as the unavailable is a shorter list, but ok, it sounds like it will do the job.

One piece I'm not clear on. Let's say a product has a third attribute, say Gift Box which is a yes/no option. Do we need to account for that in SBA somehow?