Community Add-Ons

Imprint Text Options
for osCommerce Online Merchant v2.2

you can have a lot of text options, to be assigned with product, and
set different options enabled for different products, using checkboxes, when
add/edit product.
so, for example, you sell mugs with imprinting, then you can assign fields
'name' and 'date of birth' to mug_1 product, 'date' and 'phrase' with mug_2, so
customer will fill this fields and it will be stored into db.
ps: BACKUP BEFORE INSTALLING! :)

Legend:

Download

Report

Expand All / Collapse All

Fixed the product_info.php file.

This is a full package.

Support thread:
http://forums.oscommerce.com/index.php?showtopic=147933&st=0

Primeiramente gostaria de agradecer o DENUZ e todos que ajudaram a desenvolver essa maravilhosa contribuição
que me ajudou muito na hora que eu mais precisava!

Em 2º Lugar: Gostaria de Agradecer a Adriana, que posto no fórum o link dessa contribuição, bj para ela :)

Bom, agora vou postar aqui uma coisa que não consegui fazer com as contribuições, que é mostrar o
"Imprint Text Options" na Página account_history_info.php.

ATENÇÃO BACKUP ANTES MODIFICAR! :)

1º INÍCIO (START)
Abra o Arquivo "account_history_info.php"

Procure pelo código:

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
echo ' <tr>' . "n" .
' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . ' x</td>' . "n" .
' <td class="main" valign="top">' . $order->products[$i]['name'];

if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {
echo ' - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '';
}
}

2º FIM (END)
Substitua (Replace) por esse código.

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
echo ' <tr>' . "n" .
' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . ' x</td>' . "n" .
' <td class="main" valign="top">' . $order->products[$i]['name'];

if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {
echo ' - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '';
}
}

// denuz text attr

$attr_q = tep_db_query("select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $HTTP_GET_VARS['order_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id");
while ($attr = tep_db_fetch_array($attr_q)) {
echo ' - ' . $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text']);
echo '';
}

// eof denuz text attr
// Jeferson Ivo - Brasil 05/02/2009 ##ÓD##

Okay everyone, I rewrote the code today. I am going to publish it in a package on the contrib page. I urge everyone (as will be noted on contrib page) to use this new contrib.

For my purposes, I only needed 1 text option per product (name). But yesterday I realized that my mod only allows that. So if you installed it, and you used more then one text per name (name, color) it would not work.

So I re-wrote it, shortened up some of the queries, etc. I would like to clean up the code a little more, but for now it works and I wanted people to download the new one not the old one before I went on vacation.

I also took out the check box option. Again, after realizing the people have more then one text option on a product page, it would look redundant. Now the system will recognize if there is text entered into that specific field or not. It will then run the rest of the system accordingly.

Please note for the other contrib, the charge per custom field contrib I wrote, that will be updated as well. You should note this:

You have a product page with two fields on it: Name, Color

----A customer buys that product with both fields filled out.

The system will charge that customer for 1 Custom entry. Not two. Charging for every entry in one qty would not make sense.

Same goes for if the custom adds two of those products to their shopping cart, the first one has only the Name field entered and the second one has the Color field entered. The system will charge them for two customizations.

Understand? I want to make that as simple as possible.

It would not make sense if you had color, name, age, size, etc. on each product page and charged for each one. If you want to do that, let me know, and I will see if I have time to rewrite the code to do so.

Other wise, like I said:

1. Customer buys product (1 qty) with two fields(name,color) filled out.
---System charges the customer for one customization.

OR

2. Customer buys more then 1 of the same product (xx qty) and fills out the two fields(name,color) for each qty differently - Example:

product = bottle

[b]Name | color[/b] (fields)

Jon | blue

mind | (blank)

over | (blank)

(blank | matter

Now thats the qty of 4 for the same product (bottle). The system will charge them for 4 customs. Not 8, that would not be right.

And so on for every other product in their shopping cart.

Okay, I will release the new contribs a little later.

Now to install:

What does this do? Well, there has been a lot of talk about how its dumb why a customer can't add the same product with another field.
What this does is add the second customized entry to the same column in the database, but puts a seperator of "|---|" in between the multiple entries.
You can change it to what ever you want, but do remember that there is two instances of this in this code, and they must both match for it to work.

I also added a check box on the product_info.php page where the customer selects whether they want to customize or not. This will stop the mod from
adding an empty value in. Of coarse I could rework it to see if its empty to just not insert it, but I am tied up enough to even write this mod for
everyone.

Another feature is that it now adds a numeric value (new column in database) per customized field. Even if the customer gets 3 of the same product,
and two of those have customized fields tied with it, the value will be shown as 2. This is more primarly for the other contrib I released, where
you can now charge per customized entry (it uses this value).

I would seperate it for this contrib, but tell you the truth I dont have the time to do so.

USE AT YOUR OWN RISK. AND ALWAYS BACK UP BACK UP BACK UP

I am always still learning in coding, so anyone who has even better knowledge could clean it up if they want.
This does what its supposed to do for me and thats all I need.

----This is the complete package. New directions and new code. This comes with two text files for using More Entries, and Charge which requires More Entries.

Its complete, with the missing code and everything now in here. Enjoy

our success? individual commitment to a group effort

Community Add-Ons

Imprint Text Optionsfor osCommerce Online Merchant v2.2

Imprint Text Options
for osCommerce Online Merchant v2.2