Product Options Values Length

[Ajeh]

When you say longer in the database ... do you mean after the fact you are trying to update the Option Name in the Order?

For your downloads issue ... I need an URL to your Product that isn't working ...

Sounds like you do not have the Option Name set up as either a Radiobutton or a Dropdown ... or You do not have a default set so the Product gets added to the Order without a Download attached to it ...

[bettysue]

When you say longer in the database ... do you mean after the fact you are trying to update the Option Name in the Order?

I just fixed it as I was in the wrong field earlier, this time I increased the characters to 64 in products_option_name.

As far as the all attribute items which do not get added to the sales reports to show total sold, this is one of the items that has been dowloaded both in single files and the whole album:

http://www.buysoul.com/store/index.p...roducts_id=181

thank you,

betty

[bettysue]

I forgot to address 2 points that were in your reply:

Sounds like you do not have the Option Name set up as either a Radiobutton or a Dropdown

I have them set up as checkboxes. I thought in order for them to be able to select more than 1 item, we had to use checkboxes.

or You do not have a default set so the Product gets added to the Order without a Download attached to it ...

This one confuses me a bit.

If it means that am I making one of the downloads a default that is already checked? The answer is no as the client didn't want one checked by default.

If it means if there are any other regular products (such as the cd hard copy) for sale on the same product page as products for download. The answer is No, not on any of the downloads sold thus far. They have been ones that are all downloads only with no physical item listed.

betty

[Ajeh]

If you use Radiobuttons or Dropdowns you need multiple Option Names and matching Option Values ...

As checkboxes ... the only concern is has something been selected ...

If selected great ... if not there is not a catch for that ... yet ...

Your checkboxes are good in that you can selectively choose who is wanted ... but nothing blocks that Product from being added with nothing checked, at this time ...

If things are checked, they show in the Orders ...

If nothing is checked nothing shows in the Orders and the customer gets nothing ... although you gots money depending on your setup for pricing ...

[TecBrat]

... It worked, as did the removal of <nobr></nobr>

Thanks again.
TecBrat.

UPDATE:
You can also, and probably want to, remove the nobr tags from admin as well. I found them in the file "orders.php" around lines 362 and 365.
(older version of cart, so don't count on the line numbers.)
TecBrat.

[bettysue]

If things are checked, they show in the Orders

The items checked for download are showing up on the invoices, the payment, and paypal areas.

Where they are not showing up is in any reports. This part is crucial as they will soon (after upgrade to v1.35) have 2 added fields, UPC Code and IRSC code (which get assigned to each individual song for downoad) which have to be accounted for in daily sales to their governing bodies.

betty

[billc108]

In phpMyAdmin ...

Display the structure of:
products_options

Click edit on:
products_options_names

Change the Length/Values from 32 to 64 or the size you need up to 255

Then, display the structure of:
orders_products_attributes

Click edit on:
products_options

Change the Length/Values from 32 to 64 or the size you need up to 255

NOTE that you'll also have to manually change any existing text boxes' settings in order for this to apply to them. Any NEW Option Names that you create with a text type will automatically inherit the new settings.

How can I change a text entry from the standard one-line input to a text area input so that it can display multiple lines? ie:

Seth and Amber
January 17, 2006

We're doing a site with a lot of wedding stuff that'll have a ton of engraving/embossing/monogramming/etching.

Thanks.

[billc108]

How can I change a text entry from the standard one-line input to a text area input so that it can display multiple lines? ie:

Seth and Amber
January 17, 2006

We're doing a site with a lot of wedding stuff that'll have a ton of engraving/embossing/monogramming/etching.

Thanks.[/QUOTE]

Oops. Never mind, I just found that this can be configured in the Option Names editor by changing the number of rows.

[stiggy100]

Can anyone confirm this is still the way to go about this?

Just wanted to check as the thread is a few years old now. The maximum length in my admin doesn't seem to change the characters and length allowed.

Thanks in advance...

[Ajeh]

Just edit the Option Name you created and change the rows for multiple area ... then add the limit on charcters ...