Need help with Joomla? We are available for hire to help with Joomla customization, upgrades, maintenance, and custom development.
Explore our services

Change the order number in email subject line?

  • spitjack
  • Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 weeks 1 day ago #180014 by spitjack
No matter what start number I put in any seemingly related fied, it has no effect. My notifications are off by a count of 241, the number I put in after J2 store conversion. It has had no effect - EShop started over from 1 anyway.

__
a 'spit' is a rod upon which savory food was roasted, turned in ancient times by a worker called a 'jack', a middle English word for an ordinary laborer (eg jack of all trades, steeplejack, lumberjack). Today, this is done by a 19th C machine.

Please Log in or Create an account to join the conversation.

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
3 weeks 1 day ago #180015 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Change the order number in email subject line?
Hello spitjack,

Thank you for submitting the question here. Please go to EShop -> System -> Configuration -> Option tab, at "Start Order ID" enter 241, then Save the Configuration and place a new test order to test, the Order ID should be started by 241 then.

I hope this is useful.

Sincerely, Giang

Please Log in or Create an account to join the conversation.

  • spitjack
  • Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 weeks 23 hours ago - 3 weeks 23 hours ago #180019 by spitjack
Replied by spitjack on topic Change the order number in email subject line?
That number was already there - I put it in at installation. What I did in the meantime was go to the database, find the most recent order, and change the value in the order number field. Hopefully EShop will just increment from there. But you might consider why putting 241 on that line (which is still there) had no effect.

__
a 'spit' is a rod upon which savory food was roasted, turned in ancient times by a worker called a 'jack', a middle English word for an ordinary laborer (eg jack of all trades, steeplejack, lumberjack). Today, this is done by a 19th C machine.
Last edit: 3 weeks 23 hours ago by spitjack. Reason: re-phrase for clarity

Please Log in or Create an account to join the conversation.

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
3 weeks 9 hours ago #180023 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Change the order number in email subject line?
Hello spitjack,

If you set 241 there and Save the configuration, then the system will reset the start id of #__eshop_orders table to 241.

Sincerely, Giang

Please Log in or Create an account to join the conversation.

  • spitjack
  • Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 weeks 1 hour ago - 3 weeks 1 hour ago #180026 by spitjack
Replied by spitjack on topic Change the order number in email subject line?
I had done exactly that when I installed and migrated J2store several years ago. The number 241 has been sitting on that line after multiple configuration changes - but I will look for that table specifically. The problem is that in the notification email, this offset is ignored, the subject line in the confirmation email reads "Order #124", not "Order #365". 

__
a 'spit' is a rod upon which savory food was roasted, turned in ancient times by a worker called a 'jack', a middle English word for an ordinary laborer (eg jack of all trades, steeplejack, lumberjack). Today, this is done by a 19th C machine.
Last edit: 3 weeks 1 hour ago by spitjack. Reason: better phrasing of the problem

Please Log in or Create an account to join the conversation.

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
2 weeks 4 days ago #180069 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Change the order number in email subject line?
Hello Spitjack,

Once order id is set, the real order id will be used on everywhere with same value.

Sincerely, Giang

Please Log in or Create an account to join the conversation.

Moderators: Giang Dinh Truong