Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sat Nov 25, 2017 6:54 am

You did not properly read my last question. The question above is the: store ID if they both match - not the order ID or store name. Please confirm the last question indicating if the store ID that is related with the return ID you are sending a comment with by also comparing that store ID with your admin - > systems - > stores list.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Sat Nov 25, 2017 7:18 am

Hi,

maybe i don't understand your question but i don't see any store_id in returns tables in db:
http://recordit.co/7XE3ZWp9Na
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sat Nov 25, 2017 7:22 am

You are filming the wrong table. Yes, the order ID is there. Although, from your order table where the store ID is located, what is the number linked with that order ID that is linked with the return ID from the return table you just filmed? All these relations needs to work. As for the store list, you did highlighted the name. Although, you did not showed the store_id at the bottom of the browser. Click on the edit button on the title row of that store and look on the URL for the store_id. Then, look again in the order table for that store ID related to that order ID. Both store IDs must match.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sat Nov 25, 2017 10:24 am

Followed is a query that allows to see differed store IDs with the same order IDs between the order and the returned orders. Execute it in your PHPMyAdmin's Opencart database's SQL tab:

Code: Select all

SELECT `o`.`order_id` AS `order_id`, `r`.`order_id` AS `return_order_id`, `o`.`store_id` AS `order_store_id`, `s`.`store_id` AS `store_id` FROM `oc_order` `o` INNER JOIN `oc_store` `s` ON (`s`.`store_id` != `o`.`store_id`) INNER JOIN `oc_return` `r` ON (`o`.`order_id` = `r`.`order_id`)
Note: Replace all instances of: oc_ with your database table prefix name if using a different one. Then, provide the query result as a capture on your next reply.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Sat Nov 25, 2017 2:27 pm

Hi,

here is the phpmyadmin screenshot as you kindly asked and the screenshot of my order list with store name.


Thanks for your help!
Last edited by guidone on Sun Nov 26, 2017 3:56 pm, edited 1 time in total.
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sat Nov 25, 2017 8:38 pm

Exactly what I predicted. The codes I provided above do work as intended. Although, you've been working on the only order from your entire returned orders list where the store ID does not match. Fortunately, there's only one result from your screenshot where it has been affected from your store name recreation. Although, you've been only focusing on the store name between the store list and the returned order which is why you believed for two pages of this forum that the store name indications was the same. The sentence is the same but not the ID in this case.

For only one result, simply replace the 0 value from the order_store_id with your store_id's value in PHPMyAdmin. This should resolve the issue. Although, since you are not the only one reporting this issue since Opencart has been blinding people merchants from the truth on this functionality, this is indeed unacceptable. It requires an extension for this.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Sun Nov 26, 2017 12:40 am

Hi,

thanks to your fix of main issue mail From, i was trying to edit lang file to delete store name in subject mail

Code: Select all

$_['text_subject']       = '%s - Return Update %s';

(Store Name - Return Update ID Number)
but if i simply change to

Code: Select all

$_['text_subject']       = 'Return Update %s';
Subject change to
(Return Update Store Name)
not as i need
(Return Update ID Number )
Why??

Regards
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sun Nov 26, 2017 12:59 am

Based on the explanation I provided above, you cannot delete a store name that already has vanished from the database, obviously. Unless you are trying to achieve another goal, you'd have to explain in details what you are trying to accomplish from your last statement.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Sun Nov 26, 2017 2:14 am

Hi, i would like to hide Store Name in Subject mail (when admin sends updates on history returns) editing lang file in
/admin/language/en-gb/mail/return.php

Code: Select all

$_['text_subject']       = '%s - Return Update %s';
First variable %s it's Store Name
Last variable %s it's Return ID

but i don't know why if i simply change lang like this

Code: Select all

$_['text_subject']       = 'Return Update %s';
it doesn't work and Subject mail become "Return Update Store Name"
instead of
"Return Update Return ID"
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sun Nov 26, 2017 2:36 am

Simply replace"

Code: Select all

$_['text_subject']       = 'Return Update %s';
with:

Code: Select all

$_['text_subject']       = 'Return Update';

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Sun Nov 26, 2017 2:58 am

Yes, i hoped it was possible to have ID return variable in Subject but maybe it's not possible.
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sun Nov 26, 2017 3:25 am

guidone wrote: ↑
Sun Nov 26, 2017 2:58 am
 Yes, i hoped it was possible to have ID return variable in Subject but maybe it's not possible.
It is about to be possible very soon.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sun Nov 26, 2017 6:17 am

Extension ready: viewtopic.php?f=198&t=199963

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Sun Nov 26, 2017 1:43 pm

Great! no version for OC 2.2?
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Sun Nov 26, 2017 11:41 pm

A better reason to upgrade to the latest release for better platform monitoring purposes based on globalization change. ;)

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by guidone » Mon Nov 27, 2017 12:02 am

you're right but with over 40 paid extensions for OC 2.2 and deep customization it's not an option for me ;)
User avatar
guidone
New member
Posts
95
Joined
Thu Mar 28, 2013 7:39 pm
Top

Re: Returns (RMA) notification multi-store issue

Quote

Post by straightlight » Mon Nov 27, 2017 12:04 am

I see. Well, for 40 purchased extensions, you are in luck on seeing one that is finally free as it can easily be converted to v2.x releases. ;)

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top
Post Reply
Return to “Bug Reports”
Who is online

Users browsing this forum: No registered users and 92 guests