Return Authorization Module (RMA)

[clydejones]

I hope I don't sound like an idiot - I'm new to ZenCart, and having done a zillion mods for phpBB and Joomla, I am used to installing mods without any read me files.

I found this RMA Mod: http://www.zen-cart.com/index.php?ma...roducts_id=433


I installed it, using the same structure in which it came and it installed smoothly, and works great with one small hitch. When someone completes the RMA Form the email that comes thru to me only includes the customer's name, order number, item number and amount. The other fields are blank. It does dispatch the appropriate emails to the customer and to the admin though. You can see it in action on my site at: hxxp://www.scrapbooksuppliesdirect.com/shopping (url is munged - change x's to t's).

I hope this post is of help to you all and maybe getting someone to this point you can get me to the finish line.

Jeanne

The admin e-mail you receive should look similar to this one:

From: Customer Name
Email: [email protected]
Phone Number: 555-555-6789
Address: address
City: city
Post Code: zipcode
State: state
Order Number: 1234
Total Value: $5.00
Item Number: 5678
Item Name: Test Item
Action Requested: Return
------------------------------------------------------
Reason: Test Item return request.
------------------------------------------------------

I also noticed that when logged in and you go to the return authorization page the customer information fields are not automatically filled inas they should be.

Are using the latest version 2.2.2?

[ScrapbookSupplies]

The admin e-mail you receive should look similar to this one:

From: Customer Name
Email: [email protected]
Phone Number: 555-555-6789
Address: address
City: city
Post Code: zipcode
State: state
Order Number: 1234
Total Value: $5.00
Item Number: 5678
Item Name: Test Item
Action Requested: Return
------------------------------------------------------
Reason: Test Item return request.
------------------------------------------------------

I also noticed that when logged in and you go to the return authorization page the customer information fields are not automatically filled inas they should be.

Are using the latest version 2.2.2?

AHH! I see where my problem and confusion is coming from! On the page where I got the download from, the link at the top of the page must go to the older version, whereas the newest version (the 2.2 that you were talking about) is down a bit lower. I just assumed that the link at the top right where it says "download now" is the most current. Will try to fix it right now and see where it takes me.

Thanks for your input on it! Am going to leave my original reply (before I found the err of my ways ) in case anyone else has done the same thing.

Many thanks!!
Jeanne



I noticed this (that the fields were not pre-populated) but thought it was because I haven't processed any orders yet. Oh goodness! This really concerns me.

And... The email (phew!) - this is what it looks like (I was actually going to make a post to see if anyone knew how to customize it a bit so it would be easier to read, so thank you for posting the sample):

From: Email: sales1 @ scrapbookxsuppliesxdirect.com Phone Number: Address: City: Post Code: State: Order Number: 12345 Total Value: Item Number: Item Name: Action Requested: Refund ------------------------------------------------------ Reason: dafadsfdsfs ------------------------------------------------------ Office Use Only: From: Email: sales1 @ scrapbookxsuppliesxdirect.com IP Address: 70.216.85.107 - 70.216.85.107 Host Address: 107.sub-70-216-85.myvzw.com Date and Time: Mon Jun 16 2008 12:08:47 MDT


So, I suppose I have a problem here then - I thought I was good to go on it. It is version 1.3.6

????

[clydejones]

AHH! I see where my problem and confusion is coming from! On the page where I got the download from, the link at the top of the page must go to the older version, whereas the newest version (the 2.2 that you were talking about) is down a bit lower. I just assumed that the link at the top right where it says "download now" is the most current. Will try to fix it right now and see where it takes me.

Thanks for your input on it! Am going to leave my original reply (before I found the err of my ways ) in case anyone else has done the same thing.

Many thanks!!
Jeanne



I noticed this (that the fields were not pre-populated) but thought it was because I haven't processed any orders yet. Oh goodness! This really concerns me.

And... The email (phew!) - this is what it looks like (I was actually going to make a post to see if anyone knew how to customize it a bit so it would be easier to read, so thank you for posting the sample):

From: Email: sales1 @ scrapbookxsuppliesxdirect.com Phone Number: Address: City: Post Code: State: Order Number: 12345 Total Value: Item Number: Item Name: Action Requested: Refund ------------------------------------------------------ Reason: dafadsfdsfs ------------------------------------------------------ Office Use Only: From: Email: sales1 @ scrapbookxsuppliesxdirect.com IP Address: 70.216.85.107 - 70.216.85.107 Host Address: 107.sub-70-216-85.myvzw.com Date and Time: Mon Jun 16 2008 12:08:47 MDT


So, I suppose I have a problem here then - I thought I was good to go on it. It is version 1.3.6

????

The download link at the top right should get you v2.2.2

[ScrapbookSupplies]

It did, I read it too fast and the site would not let me edit my post again because too much time passed. So I wanted to re-install the mod again before I re-posted to make sure that I covered all of the bases. I looked at it too fast, with too many things happening around me. Once it got quiet I downloaded the package again, then ran thru the mod again, but still have the same problem.

All of the files are in the right place. This time I can't remember which file I edited to change the link name from "returns" to "return authorizations", which is no biggie. It's the rest of it that's making me crazy! eeee!

I will try to run the upgrade and see if that does anything.

Please let me know if anything comes to mind.

Thanks so much for your help,
Jeanne

[clydejones]

It did, I read it too fast and the site would not let me edit my post again because too much time passed. So I wanted to re-install the mod again before I re-posted to make sure that I covered all of the bases. I looked at it too fast, with too many things happening around me. Once it got quiet I downloaded the package again, then ran thru the mod again, but still have the same problem.

All of the files are in the right place. This time I can't remember which file I edited to change the link name from "returns" to "return authorizations", which is no biggie. It's the rest of it that's making me crazy! eeee!

I will try to run the upgrade and see if that does anything.

Please let me know if anything comes to mind.

Thanks so much for your help,
Jeanne

Make sure you have ALL the files installed. The YOUR_TEMPLATE folder(s) should be renamed to your custom template name (in your case - orange)


includes/extra_datafiles/returns_filenames.php

includes/languages/english/extra_definitions/YOUR_TEMPLATE/returns_defines.php

includes/languages/english/YOUR_TEMPLATE/returns.php

includes/languages/english/html_includes/define_returns.php

includes/languages/english/html_includes/YOUR_TEMPLATE/define_returns.php

includes/modules/pages/returns

includes/templates/YOUR_TEMPLATE/templates/tpl_returns_default.php

includes/templates/YOUR_TEMPLATE/css/returns.css

[ScrapbookSupplies]

Hi Clyde,

After going over it and over it and over it again I finally found the problem for real this time. I'm a little slow but at least I know where my issue is, fixing it is another story, am hoping you can shed some advice on it.

I finally re-ran the SQL query, and to my surprise it did not give me an error, so of course I felt silly at first, thinking I must have forgotten to run it the first time - but that didn't fix the problem. Then something told me to look at the dB thru MySQL, and I could not find any rows with the word "return" in them. So, I ran the query directly in the phpAdmin screen and got a #1146 Error - - Table 'scrapcha_zencart.configuration_group' doesn't exist. I will paste the exact error below, along with a copy of the query below. I think the only thing that I need to do is change the name from configuration_group_id to just configuration_group, but not being very familiar with My SQL, I am afraid to make any kind of change to it on my own. Also, we have a configuration_group but no configuration_group_title.

Can you tell? Please?



SQL Query ERROR:

SELECT @configuration_group_id := configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Return Authorization'
LIMIT 1 ;

ATTEMPTED QUERY:

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group VALUES (NULL, 'Return Authorization', 'Return Authorization Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO `configuration` VALUES (NULL, 'Phone Number', 'RETURN_PHONE', 'true', 'Display phone number field', @configuration_group_id, 1, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Total Value', 'RETURN_VALUE', 'true', 'Display Total Value', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Item Number', 'RETURN_ITEM_NUMBER', 'true', 'Display Item Number field', @configuration_group_id, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Only registered customers may submit a return request', 'REGISTERED_RETURN', 'false', 'Only registered customers may submit a return request', @configuration_group_id, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Set "Return Action" Dropdown List', 'RETURN_ACTION_LIST', 'Refund, Replacement, Repair', 'On the "Return Authorization" Page, set the list of actions , in this format: Action 1, Action 2', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_textarea(');

INSERT INTO `configuration` VALUES (NULL, 'Define Return Authorization', 'DEFINE_RETURNS_STATUS', '1', 'Enable the Defined Return Authorization Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

Thank you so much for your help!!

[clydejones]

Hi Clyde,

After going over it and over it and over it again I finally found the problem for real this time. I'm a little slow but at least I know where my issue is, fixing it is another story, am hoping you can shed some advice on it.

I finally re-ran the SQL query, and to my surprise it did not give me an error, so of course I felt silly at first, thinking I must have forgotten to run it the first time - but that didn't fix the problem. Then something told me to look at the dB thru MySQL, and I could not find any rows with the word "return" in them. So, I ran the query directly in the phpAdmin screen and got a #1146 Error - - Table 'scrapcha_zencart.configuration_group' doesn't exist. I will paste the exact error below, along with a copy of the query below. I think the only thing that I need to do is change the name from configuration_group_id to just configuration_group, but not being very familiar with My SQL, I am afraid to make any kind of change to it on my own. Also, we have a configuration_group but no configuration_group_title.

Can you tell? Please?

Thank you so much for your help!!

Open admin -> tools -> install sql patches
copy and paste the following sql statement into the text area and then press send.

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group VALUES (NULL, 'Return Authorization', 'Return Authorization Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO `configuration` VALUES (NULL, 'Phone Number', 'RETURN_PHONE', 'true', 'Display phone number field', @configuration_group_id, 1, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Total Value', 'RETURN_VALUE', 'true', 'Display Total Value', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Item Number', 'RETURN_ITEM_NUMBER', 'true', 'Display Item Number field', @configuration_group_id, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Only registered customers may submit a return request', 'REGISTERED_RETURN', 'false', 'Only registered customers may submit a return request', @configuration_group_id, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Set "Return Action" Dropdown List', 'RETURN_ACTION_LIST', 'Refund, Replacement, Repair', 'On the "Return Authorization" Page, set the list of actions , in this format: Action 1,  Action 2', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_textarea(');

INSERT INTO `configuration` VALUES (NULL, 'Define Return Authorization', 'DEFINE_RETURNS_STATUS', '1', 'Enable the Defined Return Authorization Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

[ohgoodiee]

Hi Clyde,

After going over it and over it and over it again I finally found the problem for real this time. I'm a little slow but at least I know where my issue is, fixing it is another story, am hoping you can shed some advice on it.

I finally re-ran the SQL query, and to my surprise it did not give me an error, so of course I felt silly at first, thinking I must have forgotten to run it the first time - but that didn't fix the problem. Then something told me to look at the dB thru MySQL, and I could not find any rows with the word "return" in them. So, I ran the query directly in the phpAdmin screen and got a #1146 Error - - Table 'scrapcha_zencart.configuration_group' doesn't exist. I will paste the exact error below, along with a copy of the query below. I think the only thing that I need to do is change the name from configuration_group_id to just configuration_group, but not being very familiar with My SQL, I am afraid to make any kind of change to it on my own. Also, we have a configuration_group but no configuration_group_title.

Can you tell? Please?



SQL Query ERROR:





ATTEMPTED QUERY:



Thank you so much for your help!!

New to this mod, but I too am getting this same error from phpMyAdmin. If I copy/paste into SQL Query, (inside of admin) I get the pink bar at top with "failed".

Any ideas?

Thanks...

[blackwolf]

I have just installed this mod and can't seem to see what it does different than the normal "contact us" form.

Can anyone help me?
Is it supposed to generate a random Returns Authorization number to be used or something?

[DivaVocals]

I have just installed this mod and can't seem to see what it does different than the normal "contact us" form.

Can anyone help me?
Is it supposed to generate a random Returns Authorization number to be used or something?

I'm not sure what's not clear about what's different about the RA form.. The fields specific to the purpose of this form CLEARLY distinguish it from the "Contact Us" form. As for the purpose of this form I believe the highlighted section tells it all:

This module adds a Return Authorization Request page to your store where your customer can read your returns policy and fill in a form to obtain a return authorization request. The contents of the form are emailed to the store owner.

In short this is a form that allows your customers to REQUEST a return.. If you've installed it, the admin controls and the form itself should give you a clear idea of the purpose and functionality of the RA form.. If this is still not clear, I suggest that now that you've got it installed that you should try using the form so you can understand how it works..