RMA Returns system

[automotiveuk]

A new project_project entry has been added:

RMA Returns system

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

[poppatopz]

this is excellent thanks for your work on these mods, i have only two questions, i ported your files directly into a fresh install and it worked but i noticed that you you had the faq, and rewards mods already tied into this and was wondering how hard it would be to import these into mine, also on the RMA how does the customer request a rma all i see on any of these menus (even logged in as a customer) is just the track rma. is there something i need to add menu wise or a link that will pull up a form they can use.

[poppatopz]

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /home/shop/public_html/includes/functions/general.php on line 47

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /home/shop/public_html/includes/functions/general.php on line 47

this is an error i am getting from the file return_product.php on both the billing and delivery address does anyone know what needs to be done to fix this.

[automotiveuk]

Hi poppatopz,

RMA if you do a test purchase from your shop and set the order has despatched and them login in under your test account and go view orders you should see a link under that order do you wish to return this product then the system will generate an RMA number. the link will only show if the order has been despatched.

I think uploaded my english.php thats why it has both mods in if you go and get a copy of beyond and compare from scooter software and just compare my files to your own files its a windows app just right click your file and select
left side compare and then on second file select compare to what ever file and bobs your uncle.

All the best
Darren

[drillsar]

Im trying to install this, There seems to be a issue with this:

The Table return_status returns a error in SQL, I beleive it's suppused to be like this:

DROP TABLE IF EXISTS returns_status;
CREATE TABLE returns_status (
returns_status_id int(11) NOT NULL default '1',
language_id int(11) NOT NULL default '1',
returns_status_name varchar(32) NOT NULL default '',
PRIMARY KEY (returns_status_id,language_id),
KEY idx_returns_status_name (returns_status_name)
) TYPE=MyISAM;
INSERT INTO returns_status VALUES (1, 1, 'Pending');
INSERT INTO returns_status VALUES (2, 1, 'Awaiting Return');
INSERT INTO returns_status VALUES (3, 1, 'Cancelled');
INSERT INTO returns_status VALUES (4, 1, 'Complete');

Also another problem is in the Admin I get really strange things happening, I get a whole bunch of sql statements. I'm thinking it's a bug, Anyone experience this isue?

[drillsar]

I figured why I was getting problems: In php.ini find this:

short_open_tag and make sure it's on

[drillsar]

The RMA Needs to be updated, Here's my suggestions:



READ ME File way out dated

SQL Change:

Instead of this:


# Table structure for table `returns_status`
#
DROP TABLE IF EXISTS returns_status;
CREATE TABLE returns_status (
returns_status_id int(11) NOT NULL default '',
language_id int(11) NOT NULL default '1',
returns_status_name varchar(32) NOT NULL default '',
PRIMARY KEY (returns_status_id,language_id),
KEY idx_returns_status_name (returns_status_name)
) TYPE=MyISAM;
#
# Dumping data for table `returns_status`
#
INSERT INTO returns_status VALUES (1, 1, 'Pending');
INSERT INTO returns_status VALUES (2, 1, 'Awaiting Return');
INSERT INTO returns_status VALUES (3, 1, 'Cancelled');
INSERT INTO returns_status VALUES (4, 1, 'Complete');


Should Be this:

DROP TABLE IF EXISTS returns_status;
CREATE TABLE returns_status (
returns_status_id int(11) NOT NULL default '1',
language_id int(11) NOT NULL default '1',
returns_status_name varchar(32) NOT NULL default '',
PRIMARY KEY (returns_status_id,language_id),
KEY idx_returns_status_name (returns_status_name)
) TYPE=MyISAM;
INSERT INTO returns_status VALUES (1, 1, 'Pending');
INSERT INTO returns_status VALUES (2, 1, 'Awaiting Return');
INSERT INTO returns_status VALUES (3, 1, 'Cancelled');
INSERT INTO returns_status VALUES (4, 1, 'Complete');


Add SQL Statement:

insert into admin_files (admin_files_id, admin_files_name, admin_files_is_boxes, admin_files_to_boxes, admin_groups_id) values ('124', 'returns.php', '1', '0', '1');

[bdepew]

How do I go about changing the restocking fee percentage amount?

[bdepew]

also when i click on "return reasons", "refund methods", "returns status" and "return text edit" i get Access Denied No Right Permission Access Please contact your Web Administrator to request
more access or if you found any problem. "

why would i get that? i changed the file permissions to 777 on each of these.?

[shona324]

Hi, wonder if anyone can give me any advice with this.

Installed RMA module and everything fine catalog side but when I try to access admin I get a screen with only the following on it


$orders_status['return_reason_id'], 'text' => $orders_status['return_reason_name'] ); } return $orders_status_array; } function tep_get_return_reason_name($return_reason_id, $language_id = '') { global $languages_id; if ($return_reason_id < 1) return TEXT_DEFAULT; if (!is_numeric($language_id)) $language_id = $languages_id; $status_query = tep_db_query("select return_reason_name from " . TABLE_RETURN_REASONS . " where return_reason_id = '" . $return_reason_id . "' and language_id = '" . $language_id . "'"); $status = tep_db_fetch_array($status_query); return $status['return_reason_name']; } function tep_calculate_deduct($price, $tax) { global $currencies; return (($price / 100) * $tax); } function tep_get_returns_status() { global $languages_id; $orders_status_array = array(); $orders_status_query = tep_db_query("select returns_status_id, returns_status_name from " . TABLE_RETURNS_STATUS . " where language_id = '" . $languages_id . "' order by returns_status_id"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_status_array[] = array('id' => $orders_status['returns_status_id'], 'text' => $orders_status['returns_status_name'] ); } return $orders_status_array; } function tep_get_returns_status_name($returns_status_id, $language_id = '') { global $languages_id; if ($returns_status_id < 1) return TEXT_DEFAULT; if (!is_numeric($language_id)) $language_id = $languages_id; $status_query = tep_db_query("select returns_status_name from " . TABLE_RETURNS_STATUS . " where returns_status_id = '" . $returns_status_id . "' and language_id = '" . $language_id . "'"); $status = tep_db_fetch_array($status_query); return $status['returns_status_name']; } function tep_get_refund_method() { global $languages_id; $orders_status_array = array(); $orders_status_query = tep_db_query("select refund_method_id, refund_method_name from " . TABLE_REFUND_METHOD . " where language_id = '" . $languages_id . "' order by refund_method_id"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_status_array[] = array('id' => $orders_status['refund_method_id'], 'text' => $orders_status['refund_method_name'] ); } return $orders_status_array; } function tep_get_refund_method_name($refund_method_id, $language_id = '') { global $languages_id; if ($refund_method_id < 1) return TEXT_DEFAULT; if (!is_numeric($language_id)) $language_id = $languages_id; $status_query = tep_db_query("select refund_method_name from " . TABLE_REFUND_METHOD . " where refund_method_id = '" . $refund_method_id . "' and language_id = '" . $language_id . "'"); $status = tep_db_fetch_array($status_query); return $status['refund_method_name']; } function tep_remove_return($order_id, $restock = false) { if ($restock == 'on') { $order_query = tep_db_query("select products_id, products_quantity from " . TABLE_RETURNS_PRODUCTS_DATA . " where returns_id = '" . tep_db_input($order_id) . "'"); while ($order = tep_db_fetch_array($order_query)) { tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity + " . $order['products_quantity'] . " where products_id = '" . $order['products_id'] . "'"); tep_db_query("update " . TABLE_PRODUCTS . " set products_status = 1 where products_quantity > 0 and products_id = '" . $order['products_id'] . "'"); } } tep_db_query("delete from " . TABLE_RETURNS . " where returns_id = '" . tep_db_input($order_id) . "'"); tep_db_query("delete from " . TABLE_RETURNS_PRODUCTS_DATA . " where returns_id = '" . tep_db_input($order_id) . "'"); tep_db_query("delete from " . TABLE_RETURN_PAYMENTS . " where returns_id = '" . tep_db_input($order_id) . "'"); }


I know I've probably done something wrong or missed something but wonder if anyone can give me any advice on where I may have went wrong.

I'm using the latest stable oscmax and php5.

Thanks in advance