Webstera17

How do people get the great looking thumbnails that aren't distorted? I am adding inventory to our site at www.tnpaintballers.com & if you look you will see the thumbnails are all horrible. -Jason

I don't mean to double post this question, but haven't got a response yet. I searched this thread & found that a guy over a year ago asked this question & never got an answer for it. This RMA System works just find except for one area that I found. The RMA System is returning the list price. It isn't taking away the discount he got. I had a item for $50.00 & shipping for $5.00. The order total was $55.00, but he had a discount code that saved him $5.50. He only paid $49.50 total, but he should only get back $44.50 which is the $49.50 he paid less shipping since shipping cost aren't refunded. I was told that the RMA System by default doesn't return the shipping the customer pays at checkout. I can post code, but not sure while file to post.

Has anyone else ran into the same problem that I am having?

Sorry about those three post above...I was having problems w/internet. I attempted to post my reply, but page wouldn't load so I just tried it again until the page loaded. I didn't realize that it did post the first two time.

I was looking over the install file & seen something that doesn't make sense. Here you are replacing the display of the product model number with displaying the product code, but in that second piece of code from the install file you are still inserting the model into the db as well as the product code & you print the product code in the order email confirmation. Wouldn't it be easier to just use the existing product model column in the db & insert the product code into products_model since you are just adding a forward slash & the attribute number...AP1/G to the existing model number? You are just adding to the model number the attribute number & inserting the modified model you call the code number into the code field...right? ############################################################# ********** In catalog/admin/orders.php ***************** Find: around line 233 echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . Change To: echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['code'] . '</td>' . "\n" . ############################################################# ############################################################# ********** In catalog/checkout_process.php ***************** Find: around line 160 $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); Change To: $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_code' => $order->products[$i]['code'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); #############################################################

I was looking over the install file & seen something that doesn't make sense. Here you are replacing the display of the product model number with displaying the product code, but in that second piece of code from the install file you are still inserting the model into the db as well as the product code & you print the product code in the order email confirmation. Wouldn't it be easier to just use the existing product model column in the db & insert the product code into products_model since you are just adding a forward slash & the attribute number...AP1/G to the existing model number? You are just adding to the model number the attribute number & inserting the modified model you call the code number into the code field...right? ############################################################# ********** In catalog/admin/orders.php ***************** Find: around line 233 echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . Change To: echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['code'] . '</td>' . "\n" . ############################################################# ############################################################# ********** In catalog/checkout_process.php ***************** Find: around line 160 $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); Change To: $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_code' => $order->products[$i]['code'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); #############################################################

I was looking over the install file & seen something that doesn't make sense. Here you are replacing the display of the product model number with displaying the product code, but in that second piece of code from the install file you are still inserting the model into the db as well as the product code & you print the product code in the order email confirmation. Wouldn't it be easier to just use the existing product model column in the db & insert the product code into products_model since you are just adding a forward slash & the attribute number...AP1/G to the existing model number? You are just adding to the model number the attribute number & inserting the modified model you call the code number into the code field...right? ############################################################# ********** In catalog/admin/orders.php ***************** Find: around line 233 echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . Change To: echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['code'] . '</td>' . "\n" . ############################################################# ############################################################# ********** In catalog/checkout_process.php ***************** Find: around line 160 $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); Change To: $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_code' => $order->products[$i]['code'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); #############################################################

In the default OSC script when viewing an order you see the Model number which is like the item number for each item in the store. Will this contribution display the Model number like he has it above...AP1, AP1/G, AP1/R & etc? I am asking because I see the following MySQL Query line to run & this is adding another column. ALTER TABLE `orders_products` ADD `products_code` varchar(20) NOT NULL default '' AFTER `products_model`;

Look at the Database first & see if you have that column in your table already...

To try & answer your question look at the orders_products table & see if you already have that column products_returned as that is normally when you get that Duplicate column name error. If you already had an older version installed then you probably have all the right columns added from the previous install. You might either want to look at the sql file & see if it is adding any columns you don't you don't have & if so then add those columns manually.

Next to the quote & reply buttons at the bottom of each post you should see a edit button if not then it is too late to edit the post.

Can you edit this post & remove the link to www.shoppinginurpjs.com domain as it isn't showing anything, but is popping up a Username & Password field for cPanel each time the page loads. I put two letter d's in that link to show you that you don't have anything linked from your site & that it is just a blank link.

If you are talking about the person that never got an answer then no it was someone else...here is the link to their post. http://forums.oscommerce.com/index.php?act...&pid=638425

I searched this thread & found that a guy over a year ago asked this question & never got an answer for it. This RMA System works just find except for one area that I found. The RMA System is returning the list price. It isn't taking away the discount he got. I had a item for $50.00 & shipping for $5.00. The order total was $55.00, but he had a discount code that saved him $5.50. He only paid $49.50 total, but he should only get back $44.50 which is the $49.50 he paid less shipping since shipping cost aren't refunded. I was told that the RMA System by default doesn't return the shipping the customer pays at checkout. I can post code, but not sure while file to post.

I am having problems with the code in the Admin side. I get this when I click the Edit button 1054 - Unknown column 'A.products_id' in 'on clause' select count(*) as total from products A, products_description B, products_to_categories E left join specials C on C.products_id = A.products_id left join special_product F on A.products_id = F.product_id left join special_category D on E.categories_id = D.categ_id where E.categories_id = 5 and E.products_id = A.products_id and A.products_id = B.products_id and B.language_id = '1' I have tried to troubleshoot this, but I can't find any code in the category_specials.php file that has select count(*) as total in it. That bit of code isn't in that file. I re downloaded another version of this & still have the same errors. If I try to insert a new category sale I get this error 1054 - Unknown column 'A.products_id' in 'on clause' select A.products_id, B.products_price from products_to_categories A, products B left join specials C on C.products_id = A.products_id where A.categories_id = 1 and B.products_id = A.products_id and C.products_id IS NULL [TEP STOP] I was going to post my file below, but it very long.