Ordered product list in cart/checkout

[LHorton]

Please can somebody help me control the order in which items are listed in the cart and checkout pages of my site?

Customers will typically order 20-30, or more, different items at a time, entering quantities for each and then using a single add to cart button to add the list to the cart.

My problem is this:

Items are listed in the cart page in a seemingly random order. This makes it very difficult for my customer to check down the list at the checkout stage.

Is there a way to have the items listed as an alphanumeric ordered list?

Example list from cart (random order)

Drill, HSS Jobber, Dormer 2.00mm
Drill, HSS Jobber, Dormer 2.10mm
Drill, HSS Jobber, Dormer 1.80mm
Drill, HSS Jobber, Dormer 1.00mm
Drill, HSS Jobber, Dormer 1.10mm
Drill, HSS Jobber, Dormer 1.70mm


Items listed on product page are listed in size order as shown here:

Item Code Description Price (Exc VAT) Qty:
DR100 Drill, HSS Jobber, Dormer 1.00mm
DR110 Drill, HSS Jobber, Dormer 1.10mm
DR120 Drill, HSS Jobber, Dormer 1.20mm
DR130 Drill, HSS Jobber, Dormer 1.30mm
DR140 Drill, HSS Jobber, Dormer 1.40mm
DR150 Drill, HSS Jobber, Dormer 1.50mm
DR160 Drill, HSS Jobber, Dormer 1.60mm
DR170 Drill, HSS Jobber, Dormer 1.70mm
DR180 Drill, HSS Jobber, Dormer 1.80mm
DR190 Drill, HSS Jobber, Dormer 1.90mm
DR200 Drill, HSS Jobber, Dormer 2.00mm
DR210 Drill, HSS Jobber, Dormer 2.10mm
Add Selection to Cart



Thanks

[HowardW]

Hi Lee
This has been a problem for ages. There is at least one thead on this. We have to do an query on the Access database to produce the picking lists and then export them to Excel - some of our orders run to hundreds of items.
I think you need to put in on the wishlist
Regards
Howard

[jont]

Could you run a sort filter using Crystal to list them in alphabetical order?

[TraceyHand]

neither of those solutions help the customer to check his cart before checking out though, do they?
Seems a bit strange that they appear to be ordered randomly. I wonder if someone from Actinic could explain why, in these circumstances?

[Darren B]

I guess something in the cart script effects the ordering, what? i aint got a clue but something must cause the order. What are the part numbers for these items? section id's who knows, its the magic again

D

[TraceyHand]

the OP listed the part numbers in the original post and did also say that all the products were on the same page so section IDs should be the same.

It does seem weird that they don't add in the order they appear on the page when using the single add to cart option

[jont]

neither of those solutions help the customer to check his cart before checking out though, do they?

Solution 2 was in reply to solution 1

Could it be the order in which they are added to the database?

[Darren B]

The items from cart did not have the part numbers listed against it, true about the section id though

got to be alphanumeric somewhere though?

[TraceyHand]

I know the ones in the CART didn't (sheesh..) but the ones from the list on site did!
It's not rocket science to cross reference!

[Darren B]

What would you know about rocket science, leave the technical stuff to the men you ahve seen what happens when they let women on the space shuttle

[LHorton]

Ordered product list in cart/checkout

Thanks for all the comments. I will definitely add this to the Actinic wish list, but that doesn’t sound as though it will be a very quick solution. What makes this even more frustrating is that our competitor’s site list items in a nice logical order!

A bit more testing has shown that, when adding products from several sections, the sections are listed in the cart in the order they are added, but the products within the sections seem to be randomly ordered. The product reference/part numbers (not displayed in the cart) would order the list the same as on the section page – ie the order we need.

Thanks again
Lee

[TraceyG]

Hi,

We can sort the products alphabetically when they are in a section using a single add to cart button by doing the following:

- locate 'ShoppingCart.pl' in your site folder and open it in an text editor such as notepad

- find the following line in 'sub AddMultipleItems':

my ($Status, $Message, $bFailure, $pFailures, $bAllowedToBuy);

- change it to:

my ($Status, $Message, $bFailure, $pFailures, $bAllowedToBuy, %hProductList);

- then find the following lines (a few lines down):

                #
                # products deleted from the catalog should not be tolerated at this point, so error out
                #
                if ($Status != $::SUCCESS)
                        {
                        ACTINIC::ReportError($Message, $sPath);
                        }

- insert the following directly after these lines:

  $hProductList{$$pProduct{'NAME'}} = $sProdref;
     }
  foreach my $sProdName ( sort keys %hProductList)
     {
     $bFailure = $::FALSE;
     my ($pProduct);
     my $sProdref = $hProductList{$sProdName};
         @Response = ACTINIC::GetProduct($sProdref, $sSectionBlobName, $sPath);        # get this product object
         ($Status, $Message, $pProduct) = @Response;
     if ($Status != $::SUCCESS)
                {
                ACTINIC::ReportError($Message, $sPath);
                }

- close and save the file

- update the site

So if a customer adds items from a section using a single add to cart button the products will be listed in alphabetical order. If they then add from from another section that product will be added after the previous products and any further products bought from a 'single add to cart button' section will be listed at the end but in alphabetical order.

I'm afraid that we can't do any more than that as any other kind of sorting would require changes to the C++ code of the software. I have added this to the wishlist though.

[LHorton]

Thanks Tracey, This solution works exactly the way we need.

The shopping cart now has items grouped by section (in the order they are added using the single add to cart button), but listing alphabetically within each section group. Perfect!

Thanks again
Lee

[LHorton]

Hi TraceyG,

I am trying to improve the email sent out to customers when they submit an order.

Above, you very kindly provided a solution to list products alphabetically when they are added to the cart using a single add to cart button. Is there a similar solution to list the items in the customer email in the same order? The example below illustrates the problem where the discount is shown part way through the order instead of at the bottom of the list.

Your Order (Prices in British Pounds)
DESCRIPTION QUANTITY PRICE COST
----------------------------------------------------------------------
Abrasive paper sheets, 1200 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 180 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 240 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 280 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 320 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 400 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 500 10 ý0.95 ý9.50
grit
Order Total Discount -ý31.05

Abrasive paper sheets, 600 10 ý0.95 ý9.50
grit

Abrasive paper sheets, 800 10 ý0.95 ý9.50
grit

Best Quality Cork Sheet 1.2mm 20 ý6.06 ý121.20
Thick
======================================================================
Subtotal: ý175.65
Shipping (Standard Postage): ý2.65
VAT: ý31.18
Total: ý209.48

******************************************************


(The ý instead of a pound sign is to do with my email host I believe).

Thanks for any help.

[TraceyG]

Hi,

where the discount is shown part way through the order instead of at the bottom of the list

If you consolidate the discount lines, it should just show them at the bottom in the 'totals' area. You can set this in 'Marketing | Discounts & Surcharges Settings | Miscellaneous tab'. Let me know if that helps.