Stocks by attributes

[GeorgieBrown]

Hi- can anyone help please - I followed the advice of entry #642 about only showing attribute options for those items 'in stock' - by altering the attributes.php file as described:

but I get this error message in my product page:
1146 Table 'cheekyshoe.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:
[select pov.products_options_values_id, pov.products_options_values_name, pa.*, pwas.* from products_options_values pov, products_attributes pa LEFT JOIN TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK pwas ON pwas.stock_attributes = pa.products_attributes_id where pa.products_id = '180' and pa.options_id = '20' and (pwas.quantity > 0 or pwas.quantity IS NULL) and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]

I checked the database and the table is there, but I'm new to all this so I'm a bit stumped as to where to go next.
Any help much appreciated.

Many thanks

PS. Most recent version installed

[bhensarl]

I've searched this thread and the rest of the forum with no luck, so here goes...
We sell t-shirts and donate $1 of each shirt to the customer's choice of one of three local charities. I've got SBA set up to keep track of the stock of the different sizes of each shirt (M, L, XL, XXL), and that works perfect. What I'd like to do is add another dropdown for the customer to choose between the three charities, but I don't want it to interfere with SBA. The way it was initially set up (which makes sense because I think it's the way SBA was designed) I would have to set up the stock like this:
-Shirt#1 ; Size: M ; Charity: A
-Shirt#1 ; Size: L ; Charity: A
-Shirt#1 ; Size: XL ; Charity: A
-Shirt#1 ; Size: XXL ; Charity: A

-Shirt#1 ; Size: M ; Charity: B
-Shirt#1 ; Size: L ; Charity: B
-Shirt#1 ; Size: XL ; Charity: B
-Shirt#1 ; Size: XXL ; Charity: B

-Shirt#1 ; Size: M ; Charity: C
-Shirt#1 ; Size: L ; Charity: C
-Shirt#1 ; Size: XL ; Charity: C
-Shirt#1 ; Size: XXL ; Charity: C

And so on for each shirt.
I obviously don't need to set inventory dependant upon the charities chosen, because which charity they choose has no effect on the number of shirts I have. Is there a work around to not include the "Charity" attribute in SBA? Can anyone think of a different way to do the charitable donation? Thanks in advance.
I'm running ZC 1.3.8a and SBA 1.4.9.
Brian

[first trading]

Simply set up another option in Attributes in your admin area. Call it carity donation and have your options in there. Set a default charity also. When your customer buys a shirt they can select a charity and if they dont a default will always be selected.

This would require you to then see which charity was selected by viewing their order and you would then need to send the money to the charity.

[bhensarl]

Thanks for the help, first trading!
Isn't that what I was explaining above, though? With Stock by Attributes I need to set stock levels for each of my two attributes, Size and Charity. I'm wondering if there's a way to make the Charity not a part of SBA. I already set it up using the two attributes (Size and Charity) and when I try to check out after selecting both attributes, it tells me the shirts are out of stock. I assume this is because SBA is sending a signal that the shirt isn't in stock because I haven't entered how many of each combination I have in inventory. I'd like to have SBA ignore the Charity attribute. Any ideas?
Brian

[bhensarl]

In case I didn't explain it clearly enough earlier, what I'm trying to do is have SBA basically ignore setting stock for one of my attributes and use another. I'd like to be able to set the stock levels of t-shirts with the Size attribute, but I don't want to have to set stock for t-shirts by Size and Charity.

[DivaVocals]

In case I didn't explain it clearly enough earlier, what I'm trying to do is have SBA basically ignore setting stock for one of my attributes and use another. I'd like to be able to set the stock levels of t-shirts with the Size attribute, but I don't want to have to set stock for t-shirts by Size and Charity.

Short answer this mod doesn't have that feature..

[totalsam]

Hello,

I am wondering if this module can be used in the following way - be warned this is complicated.

I wish to use the module to track stock of our products. We sell jewellery and what I wish to do is to use the module in the following way. (I have numbered the issues for ease of reference)

Example product:

Heart Pendant, on a range of chains. The whole item comes in a box.

1. Now I know that if I was to use say chain length & style as an option I could use this mod, for example, 16" Belcher Chain, 18" Belcher chain, 16" Cable chain and 18 cable chain. If defined these as option values it would offer an available quantity.

2. Now alot (not all) of the products come with the box for packaging, if I was to additionally set up a "Read Only" attribute that couldn't be seen by the customer, could this calculate stock levels for this as well?

3. Finally the heart pendant itself is available on a chain, on its own, or with other pendants, so itself needs independant stock management.


4. If the attributes were assigned over multiple products, for example the chains may be sold on a star pendant as well, would the quantities be product or attribute related. ie if we sold 2 heart pendants on 16" belcher and one star on a 16" belcher would the stock on all products with those attributes decrease by 3 or would just the heart decrease by 2 and the star by 1?


Sorry if any of this sounds vercomplicated, its a confusing thing to figure out!!!

Thanks in advance!
Sam

[DivaVocals]

Gonna admit, that I didn't read all of that.. (Sorry too much to digest..) so I'll just say this and you can determine if this module meets you needs. SBA allows you to create multiple attribute combs (variants) per product and you can then assign stock levels to each one of these product variants. Product variants can consist of one or more attributes.

Variant examples:

T-Shirt sizes:
Small - Qty 2
Medium - Qty 3
Large Qty 12


T-Shirt size/color combo:
Small/Blue - Qty 2
Medium/Blue - Qty 3
Large/Blue Qty 12
Small/Red - Qty 2
Medium/Red - Qty 3
Large/Red Qty 12
Small/White - Qty 2
Medium/White - Qty 3
Large/White Qty 12

Hello,

I am wondering if this module can be used in the following way - be warned this is complicated.

I wish to use the module to track stock of our products. We sell jewellery and what I wish to do is to use the module in the following way. (I have numbered the issues for ease of reference)

Example product:

Heart Pendant, on a range of chains. The whole item comes in a box.

1. Now I know that if I was to use say chain length & style as an option I could use this mod, for example, 16" Belcher Chain, 18" Belcher chain, 16" Cable chain and 18 cable chain. If defined these as option values it would offer an available quantity.

2. Now alot (not all) of the products come with the box for packaging, if I was to additionally set up a "Read Only" attribute that couldn't be seen by the customer, could this calculate stock levels for this as well?

3. Finally the heart pendant itself is available on a chain, on its own, or with other pendants, so itself needs independant stock management.


4. If the attributes were assigned over multiple products, for example the chains may be sold on a star pendant as well, would the quantities be product or attribute related. ie if we sold 2 heart pendants on 16" belcher and one star on a 16" belcher would the stock on all products with those attributes decrease by 3 or would just the heart decrease by 2 and the star by 1?


Sorry if any of this sounds vercomplicated, its a confusing thing to figure out!!!

Thanks in advance!
Sam

[Hunterheads]

Paraphrased...Hi- can anyone help please
I get this error message in my product page:
1146 Table 'zencart.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:

The table is there...
I dont have all day to look at 800+ Entries...
ANy insight would be greatly appreciated...

[kuroi]

The table is there...
I dont have all day to look at 800+ Entries...
ANy insight would be greatly appreciated...

The problem isn't the table, it's the pointer to the table.

TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK is a constant that holds the name of the table, which is actually "products_with_attribute_stock".

So either you have an incomplete version of the mod (you don't say which version you're using), which is missing admin/includes/extra_datafiles/products_with_attributes_stock_database_tables.php or that file hasn't been installed properly.

Also there's no need to read through 800-odd thread entries - there's a "search this thread" option towards the top that makes finding answers on this topic much quicker.