Community Add-Ons

- SQL bug fix as posted in forum
- Fixed major Security hole in return_product.php using a modification of the code posted by Demoalt to account for oID as well.
- Fixed the incorrect "bug fix" by tocpcs below back to the original format.

Do not email questions use the Support Forum:
http://forums.oscommerce.com/index.php?showtopic=61077

Guy below, even though he was well intended, did not know what he was doing. The "bug fix" he posted basically hard codes the status to the status wording. Prior to that it pulled the order status 1 2 3 from the orders table and compared it to this piece of code:
if (($orders_status == '1') OR ($orders_status == '2') ) {

Do not use the version below use version 2.5h. I'll post a new version later today with the fix and with some other fixes.

See bug fixes in the readme file.

It was confusing before, took me ages to work out exactly where the change goes, but at least future users can now work out where the change goes.

This is for "account_history_info.php"

The bug fix I made was:

if (($order->info['orders_status'] == 'Pending') OR ($order->info['orders_status'] == 'Processing')) {
$return_link = '';
}

Because in the older version, it referenced some non existent variable with eitehr number 1 or 2.

Fixed now, enjoy.

Free translated from English to Danish.

Both admin and catalog included.

Note: not full RMA Returns 2.h, only language files.

Version by: Keith W.

Same as 2.5h below except repackaged with two missing files admin included.

SUPPORT:
http://forums.oscommerce.com/index.php?showtopic=61077

Version by: Keith W.
- Fixed error introduced in version 2.5e with the addition of the multiple line admin notes, the error occurs when a ' is in a sentence such as you'll, I duplicated in 2.5g in the catalog and admin returns_products.php. This version fixes that error in all files simply overwrite the 3 files affected.

SUPPORT:
http://forums.oscommerce.com/index.php?showtopic=61077

Didn't realize sminonp didn't properly sent catalog/return_product.php so the date and message are stored in Admin RMA system and not overwritten by new comments before posting.
Quick fix,
DOWNLOAD THIS VERSION NOT THE PREVIOUS POST

Fully compatible with previous versions.

RMA now keeps status changes history (similar to orders)
I also modified buttons in Admin Comments to add text (with automatic date/time stamp) rather than replace it.
Few ugly formatting issue have been fixed as well.
Side note: somebody should take guts to rewrite the whole thing (orders info should be taken from orders tables instead of creating private copy)

I replaced (I) icon with name of the status in admin and fix the query of filtering by status (had syntax error, which is not caught until you tried to filter by return status)

There was never an RMA packing slip option prior to this. I hope this helps those who previously wanted one but didn't have time or the knowledge to do so.
-Brett

--- Fixes ---
admin/return_text.php is multilanguage

Extras: german_comment_bar_return.html for admin

RMA System 2.5c

This update fixes the problem people were having with the product id not being transfered in the admin when trying to schedule a return.

Full Version Attached

SUPPORT:
http://forums.oscommerce.com/index.php?showtopic=61077

RMA System 2.5b

Further cleanup of install and removal of another contrib mixed into the initial version.

Full Version Attached

RMA System 2.5a

Simple correction in the updating instructions

In the updating instructions step 3 should be:
3) admin/includes/filenames.php


Full Version Attached

RMA System 2.5

--- New Features ---
* Ability to create RMAs from admin.
* Shows RMAs that have not been completed in Red in Admin now.
* Can list different contact email and contact name when creating from admin for customers who received item as a gift!

--- Fixes ---
* Clean up of some unrelated contribs in the install
* Incorporated order # fix by Sean Stewart
* Incorporated clickable url fix by Taryn Young
* Improved layout in Product Returns edit section

SUPPORT:
http://forums.oscommerce.com/index.php?showtopic=61077

Seans' file contained an easy to overlook error causing a Fatal error, cannot redeclare class order issue , here's the fix: Delete Line 240 in admin/returns.php:

include(DIR_WS_CLASSES . 'returns.php');

I also uploaded a couple of tricks for clickable "order_id" and refunds by CCGV links.
User friendly, that's what it's all about! Hope this helps someone, it took me ALL evening to fix!

This will fix the problem when an RMA update email goes out and gives a link to the wrong order ID.

This is v2.4.1 bundled with the updated install guide.

I noticed a small mistype and error in the installation guide.

--
Chapter 5:

find:
admin includes/database_tables.php

replace with:
admin/includes/database_tables.php

Chapter 6:

find:
admin includes/database_tables.php

replace with:
admin/includes/filenames.php
--

I have zipped up the version with these corrected mistypes as written above,.

--- Enhancements ---
* Customers can no longer click multiple times on the return request button.
* Returns status added to heading title of Track Return page

--- Fixes ---
* Fixed missing error message if RMA was entered incorrectly
* Better rendering of account history, RMA request, and return tracking pages
* Fixed incorrect variable name in Addressbook Enhancer extra
* Improved installation documentation

Support:
http://forums.oscommerce.com/index.php?showtopic=61077

--- New Features ---
* Customers will not see restocking fee notice if restocking fee is set to zero
* Product return link not shown to customers for Pending or Processing orders
* Order number added to Returns detail page

--- Fixes ---
* Returned products are now properly added back to stock
* Refund now properly includes any tax that was added to the order
* Return status now properly defaults to Pending
* Much improved Customer Returns box navigation in admin
* Voucher refund email routines improved
* Better integration with MS2 filename/tablename definition structure
* Unneeded gv_tracking table deleted
* Many English improvements
* Enhanced documentation and version history

A more detailed version history is included in the archive.

In order to eliminate the need for multiple downloads, this version includes the RMA infobox and Address Enhancer extras contributed previously. With the possible exception of the Credit Class / Gift Voucher contribution, no other patches or files should be required.

Questions, comments, and suggestions should be posted via the link below. Before posting, please read the enclosed ReadMe as well as the forum posts in the following thread in order to reduce redundant messages.

http://forums.oscommerce.com/index.php?showtopic=61077

Enjoy!

--Justin

Update to Version 2.3 only. Added #7 notes text on where to change return text information(admin/comment_bar_return.html) and changed the phone number to generic x's.

Once this is uploaded, if you want you can add IceTheNet (RMA Box Fix) and Chris Martin (RMA Returns Address Enhancer) updates. 2.3a MUST be installed first as noted.

ITNetwork Designs
IceTheNet.com
Contribution:

This will give the rma system it's own catagorie box

Simple instructions to add a seperate rma box and add multilingual capabilities

This will update RMA Returns System 2.3 to work with Ryan Hobbs' Address Enhancer update.

Also included is a copy of admin/returns.php with Sebastian's Credit Class & Gift Voucher fixes.

Please note this is an update only. You will first need to download Cathy & Sebastian's RMA Returns 2.3 package.

Chris

Minor fixes for the date format called out in the SQL statement for returns_products. This eliminates the need for the ALTER statement in the readme file. All other files remain the same.

Ok...got it right this time. Only change to this file is the altered SQL statement from the notes.

ALTER TABLE returned_products CHANGE returns_date_finished returns_date_finished DATETIME DEFAULT "0000-00-00 00:00:00";

No changes to files, just added back in the SQL notes that I forgot in 2.2e version and to be safe, recopied the 2.2b SQL statement to this one.

If you already have this contribution added and if you are using the Gift Voucher contribution (CCGV 5.10), refer to Sebastians fixes in this thread as this contribution does not have CCGV installed, only provides the GV SQL and files for Admin:
http://forums.oscommerce.com/index.php?showtopic=61077&st=160

Errors were being caused by version 2.2d as these were taken from the 2.2c.zip files which may have been German fixes only. I used 2.2b (last known working) to update to 2.2e. All works fine again now!

Used clean osCommerce 2.2 Milestone 2 files, no contributions added. Instructions and usage included in the ReadMe file. Fixes taken from other forum members. Thanks to all that helped find the errors!

Added IceTheNet's packing slip fix under admin/returns.php (commented out in case you want to put it back).

German files located in 2.2c.zip but may need updated again.

Any problems, most information found now currently found at:
http://forums.oscommerce.com/index.php?showtopic=61077

ITNetwork Designs
IceTheNet.com
Contribution:

To RMA package a wonderful application to track returns.
This is a quick fix only to a problem I discovered that really annoyed me.

For some reason the RMA system includes a packing slip with no module.
Easy fix is to just remove the link.
If you need a packing slip for RMA module you will have to make your own module.
I just can't think of a reason.

Corrected the Admin returns reasons, refunds & status so that you can edit or add directly from the Admin.

Cleaned up folders so that only new php files are included. Changes to existing files noted in ReadMe6-25-04 file.

Included the updated German files

Updated german files, so they read a bit more fluid. Feel free to change them according to your needs :-)

I removed the restocking fee, since this does not apply to us.

Clean-up work that I did to make it work on my sites. Requested by forum members to go through my files and help update. If you get errors, let me know, it may jog my memory if I missed something.

I apologize, but this mod is not working and I haven't been able to fix it, so please do not use it.

Sorry, the last .zip file contained a faulty readme.txt

You'll have the ability to sort your Returns Ascendingly, Descendingly, etc.

For OSC 2.2MS2

Must have the RMA returns system mod
installed to use this mod.

http://www.oscommerce.com/community/contributions,1136

You'll have the ability to sort your Returns Ascendingly, Descendingly, etc.

For OSC 2.2MS2

Must have the RMA returns system mod
installed to use this mod.

http://www.oscommerce.com/community/contributions,1136

A very small tweaking to Linda Olivers RMA - comment_bar_return mod. This .zip does not cantain Linda's release.

incl. language file in german

fixed the problem when customer return 2 or more items, the total is way off, its now display a correct total in both admin and customer account

fixed to work with gift voucher. now you can issue credit gift voucher for the returned item with no error :)

fixed date error, fixed fatal tep error, fixed parse error

I have added a few more buttons and a lot more text. Edit to suit.

It would be nice if this record actually did append rather than overwrite. Perhaps someone can work it out and post it for everyone else.

Updated files, sorry wrong file last time.

This one is correct

Okay, this version includes the missing functions, and admin file, and also includes a few othertweaks, and updated (correct) installation instructions

Okay, this release has a few more mods included to improve compatability.

It is recommended that this version is download and used.

The file headers have also been changed to reflect that the software is released under the GPL license, which I forgot to alter in the first relase. Sorry

Minor changes to the admin/ returns.php file to improve compatability with later releases

Upload to dmin directory, overwriting existing file

This is a small mod to the file, forgot to include inteh package which allows the customer to specify how many of any item is to be returned

Just upload and overwrite the existing file

This is a complete returns tracking and processing system with integration for the Credit Class GV ssytem for making refunds.

This package was developed around a late 2002 version (new checkout procedure), however testing is still ongoing for new 2.2CVS compatability

There are bound to be afew bugs / problems with this package, we are sure to have missed some of them, if you find any, please post to the forums on the following thread

http://forums.oscommerce.com/viewtopic.php?t=40183