Attributes HOW-TO

[Ajeh]

Did you delete the TEXT value from the products_options_values table?

Sort the table on products_options_values_id

If TEXT is missing add:

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

Then check your products_options_types table ... you should have 6 values in there:

If not, you can delete what is there and re-add them with:

INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (0, 'Dropdown');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (1, 'Text');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (2, 'Radio');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (3, 'Checkbox');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (4, 'File');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (5, 'Read Only');

Be sure to backup your database before doing any changes.

[SkyeWolf]

OK, maybe this has bee covered and I missed it LOL...but I'm having difficulty wrapping my brain around the whole attributes thing.

I sell prints in varying sizes at varying prices. I have:

Poster prints in 11 x 14, 16 x 20 and 20 x 30 and Fine Art Canvas in Small and Large sizes, each size has a different price (obviously) Right now I have the products structure set up rather cumbersome with a section for each size. Can I do this with attributes instead so that the customer can chose the size they want from a dropdown box and it will be priced correctly? and if I can, how do I do it? The attributes interface is baffling to me...

If you want to take a look at what I'm talking about it's here:

http://www.skyewolfimages.com/cart/

[Ajeh]

If managing inventory is not an issue you could have the Product Price set up 2 ways.

1 Product Price 7.99
Attributes:
Option Name: Size
Option Value:
11 x 14 (No Price)
16 x 20 + 10.00

2 Product Price 0.00
Price by Attributes Yes
Option Name: Size
Option Value:
11 x 14 7.99
16 x 20 17.99

All display prices would read the lower price

[SkyeWolf]

Thank You!! Between your reply and my own stubbornness I think I figured it out!

[Ajeh]

Glad that this could help you see the various alternatives available :)

[ddalton]

Is there a date attribute, how do I setup a date attribute?

[Kim]

Date? As in choose from a calendar? Or insert certain dates to choose from?

[decorlines]

Hello all and thank you for the much needed info in this thread. But (and there's always a but) I have question as well. I have looked all through this thread and others, but have not found this issue.

I have several products that feature the same artwork (throw, pillow, tote bag, etc). So, I'll have one product description and have the customer choose which item they want (throw or pillow, etc) in a drop down menu, each with different pricing.

I would like the attributes to read Item (Price), such as

Throw ($39.95) instead of Throw (+$23.00)

But, of course, when I put in just $39.95, it gets added to the base price when selected (a throw ends up being $56.90 instead of $39.95).

In other words, I'd like the attribute drop down to list the ACTUAL price of the item instead of the + or - from the base price and then have that acutal price end up in the shopping cart. Is there a way to do that?

Any help is appreciated.

Thanks in advance!

[Kim]

Set your product price to $0 and priced by attributes.

[decorlines]

Thanks--that worked perfectly and actually made so much sense that I should smacked! ::tup