Return Authorization Module (RMA)

[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''),');

[ScrapbookSupplies]

Oh Clyde!

Am still getting the error:

[quote}Error
SQL query:

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



MySQL said:

#1146 - Table 'scrapcha_zencart.configuration_group' doesn't exist [/quote]

I'll keep looking at it and see if I can figure it out too. I need to add an SQL class to my list of classes to take.

[clydejones]

Oh Clyde!

Am still getting the error:

[quote}Error
SQL query:

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



MySQL said:

#1146 - Table 'scrapcha_zencart.configuration_group' doesn't exist

I'll keep looking at it and see if I can figure it out too. I need to add an SQL class to my list of classes to take. [/QUOTE]

check your PM

[FunkyPapa]

Please forgive me if this is listed somewhere in this thread....but with 300+ posts I may have missed it.

On the return auth. page, at the top of the input fields instead of saying Return Authorization Request....It says "Specials" How can I fix this. I have used an editor and searched through all the files in the folders, however the word "specials" is not showing as listed in any of them. I have installed version 2.2.2 and zen cart version 1.3.8

Here is the LINK to what I'm asking about.

Thank you for any help.

[clydejones]

Please forgive me if this is listed somewhere in this thread....but with 300+ posts I may have missed it.

On the return auth. page, at the top of the input fields instead of saying Return Authorization Request....It says "Specials" How can I fix this. I have used an editor and searched through all the files in the folders, however the word "specials" is not showing as listed in any of them. I have installed version 2.2.2 and zen cart version 1.3.8

Here is the LINK to what I'm asking about.

Thank you for any help.

Make sure that ALL the listed files are uploaded. Make sure that you've renamed the YOUR_TEMPLATE folders to match the name of your custom template folder (in your case apple_zen)

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

[FunkyPapa]

I've double checked all the files you mentioned, they are all where they are supposed to be and named accordingly. I even re-uploaded just to be sure I had installed them all properly.