Post by Blair10 » Thu Jul 30, 2015 11:51 pm

can anyone help by means of a mod or a bit of coding (don't mind paying )?

I have a problem with my order notifications
for some reason my item options in my order notifications have started to appear in a random order
( not as per admin/options sort order or shop item page)
I spent a month making a huge spreadsheet which requires the selected options to be in the same order shown as in the item in the shop.
it used to appear in the correct order but something has gone wrong 8-(
really desperate !!
I am using 1.5.6.3
thanks
blair

Newbie

Posts

Joined
Mon Mar 24, 2014 9:40 pm

Post by Qphoria » Fri Jul 31, 2015 1:10 am

So you are saying you have the catalog/options sort order like this

Code: Select all

Color (1)
  Red
  Blue

Size (2)
  Sm
  Md
  Lg
But when someone buys a Tshirt you see something like

Code: Select all

Tshirt
  Size (2): Lg
  Color (1): Red
?

Where do you see this? In the admin order view? invoice? email?

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Blair10 » Fri Jul 31, 2015 2:02 am

thank you for your reply
I am using 1.5.6.3

yes in the order notification email I get when an order is placed

It is in the correct order When I place an order in the shopping basket and checkout confirmation stage
But both the order notification email and customer order confirmation email they are in the wrong order

I used to get the item then selected options in the same order as in the shop item page
(the shop item options are in the correct order as per admin/options/ sort order)
as per eg below

I used to get (which is correct )
1x heritage sash and case Mahogany (4 over 8 ) £1,370.00
-Mould. Ovolo
-Height. 2000
-Width. 1000
-Split. 50/50
-Horns. No
-Ironmongery. Brass
-Glazing. Single Glazed
-Finish. Primed

I now get(wrong order)
1x heritage sash and case Mahogany (4 over 8 ) £1,370.00
-Ironmongery. Brass
-Horns. No
-Split. 50/50
-Width. 1000
-Height. 2000
-Mould. Ovolo
-Finish. Primed
-Glazing. Single Glazed

I think the options end up in a different order each time

I recently installed a couple of extensions like picture on invoice and mass product edit but no option extensions
I have tried uninstalling them but still random order ?
any idea if its sortable ?
many thanks for your reply
blair

Newbie

Posts

Joined
Mon Mar 24, 2014 9:40 pm

Post by Qphoria » Tue Aug 04, 2015 2:48 am

The reason for this is because the sort order is from the option table
While the order details for the purchased items comes from the order_option table which doesn't persist the sort order.
I've added that to my option sort order fix script here:
viewtopic.php?f=131&t=155395

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by sh4m » Mon Mar 07, 2016 3:28 pm

Qphoria wrote:The reason for this is because the sort order is from the option table
While the order details for the purchased items comes from the order_option table which doesn't persist the sort order.
I've added that to my option sort order fix script here:
posting.php?mode=post&f=131
Hi,

how to get the fix script? the url not show any script.

Newbie

Posts

Joined
Mon Mar 07, 2016 2:29 pm

Post by paulfeakins » Tue Mar 08, 2016 2:15 am


For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by Qphoria » Wed Mar 09, 2016 4:04 am

Thanks Paul, I accidentally linked the form post url.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by paulfeakins » Wed Mar 09, 2016 6:03 pm

Qphoria wrote:Thanks Paul, I accidentally linked the form post url.
No probs!

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom
Who is online

Users browsing this forum: No registered users and 8 guests