WHY is it splitting my orders into multiples? (Option is set not to!)

[Soapi]

I'm getting so frustrated. I have the option to split orders (both for out of stock items or multiple addresses) set to NO. But for some reason I can not understand, random orders are being split into multiples!!

 

I was blaming one customer as she kept putting through three or four orders. But I've just done an order myself (as a customer through the front) and it's split my single order into THREE!!!

 

 

You can see that the order numbers are the same - so why is it doing this??

[Soapi]

Really need help with this as it's making it all so much more complicated...

[Soapi]

Please? Anyone? I use Prestashop for wholesale orders and they require a singular invoice in order to pay. I am losing business because it keeps splitting everything!

[Trip]

I actually have not a real idea.

Maybe you should check via phpmyadmin the table 'ps_configuration' if PS_ALLOW_MULTISHIPPING and PS_SHIP_WHEN_AVAILABLE are set to 0. Also you should look if there are maybe double entries for the variables.

If that is not the problem you can maybe give more infos like what version do you use and stuff like that?

Best regards, trip

[Soapi]

I don't seem to have those lines in my table...

 

Page number:	
   row(s) starting from row #   in   mode and repeat headers after   cells
Sort by key: 
+ Options
id_configuration id_shop_group id_shop name value date_add date_upd
  Edit   Inline Edit   Copy  Delete 1 NULL NULL PS_LANG_DEFAULT 1 2012-10-12 15:01:36 2012-10-12 15:01:36
  Edit   Inline Edit   Copy  Delete 2 NULL NULL PS_CARRIER_DEFAULT 2 2012-10-12 15:01:38 2012-10-16 09:58:41
  Edit   Inline Edit   Copy  Delete 3 NULL NULL PS_SEARCH_INDEXATION 1 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 4 NULL NULL PS_ONE_PHONE_AT_LEAST 0 0000-00-00 00:00:00 2012-10-16 10:34:41
  Edit   Inline Edit   Copy  Delete 5 NULL NULL PS_GROUP_FEATURE_ACTIVE 1 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 6 NULL NULL PS_CURRENCY_DEFAULT 1 0000-00-00 00:00:00 2012-10-12 15:03:16
  Edit   Inline Edit   Copy  Delete 7 NULL NULL PS_COUNTRY_DEFAULT 24 0000-00-00 00:00:00 2012-10-12 15:03:13
  Edit   Inline Edit   Copy  Delete 8 NULL NULL PS_REWRITING_SETTINGS 1 0000-00-00 00:00:00 2012-10-16 17:47:09
  Edit   Inline Edit   Copy  Delete 9 NULL NULL PS_ORDER_OUT_OF_STOCK 1 0000-00-00 00:00:00 2012-10-16 10:34:06
  Edit   Inline Edit   Copy  Delete 10 NULL NULL PS_LAST_QTIES 3 0000-00-00 00:00:00 2012-10-16 10:34:06
  Edit   Inline Edit   Copy  Delete 11 NULL NULL PS_CART_REDIRECT 1 0000-00-00 00:00:00 2012-10-16 10:34:06
  Edit   Inline Edit   Copy  Delete 12 NULL NULL PS_HELPBOX 1 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 13 NULL NULL PS_CONDITIONS 0 0000-00-00 00:00:00 2012-10-28 22:32:06
  Edit   Inline Edit   Copy  Delete 14 NULL NULL PS_RECYCLABLE_PACK 1 0000-00-00 00:00:00 2012-10-28 22:32:06
  Edit   Inline Edit   Copy  Delete 15 NULL NULL PS_GIFT_WRAPPING 0 0000-00-00 00:00:00 2012-10-28 22:32:06
  Edit   Inline Edit   Copy  Delete 16 NULL NULL PS_GIFT_WRAPPING_PRICE 0 0000-00-00 00:00:00 2012-10-28 22:32:06
  Edit   Inline Edit   Copy  Delete 17 NULL NULL PS_STOCK_MANAGEMENT 1 0000-00-00 00:00:00 2012-10-16 10:34:06
  Edit   Inline Edit   Copy  Delete 18 NULL NULL PS_NAVIGATION_PIPE > 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 19 NULL NULL PS_PRODUCTS_PER_PAGE 10 0000-00-00 00:00:00 2012-10-16 10:34:06
  Edit   Inline Edit   Copy  Delete 20 NULL NULL PS_PURCHASE_MINIMUM 0 0000-00-00 00:00:00 2012-10-28 22:32:06
  Edit   Inline Edit   Copy  Delete 21 NULL NULL PS_PRODUCTS_ORDER_WAY 0 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 22 NULL NULL PS_PRODUCTS_ORDER_BY 4 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 23 NULL NULL PS_DISPLAY_QTIES 1 0000-00-00 00:00:00 2012-10-16 10:34:06
  Edit   Inline Edit   Copy  Delete 24 NULL NULL PS_SHIPPING_HANDLING 0 0000-00-00 00:00:00 2012-10-16 10:13:05
  Edit   Inline Edit   Copy  Delete 25 NULL NULL PS_SHIPPING_FREE_PRICE 0 0000-00-00 00:00:00 2012-10-16 10:13:05
  Edit   Inline Edit   Copy  Delete 26 NULL NULL PS_SHIPPING_FREE_WEIGHT 0 0000-00-00 00:00:00 2012-10-16 10:13:05
  Edit   Inline Edit   Copy  Delete 27 NULL NULL PS_SHIPPING_METHOD 1 0000-00-00 00:00:00 2012-10-16 10:13:05
  Edit   Inline Edit   Copy  Delete 28 NULL NULL PS_TAX 1 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 29 NULL NULL PS_SHOP_ENABLE 1 0000-00-00 00:00:00 0000-00-00 00:00:00
  Edit   Inline Edit   Copy  Delete 30 NULL NULL PS_NB_DAYS_NEW_PRODUCT 20 0000-00-00 00:00:00 2012-10-16 10:34:06 Check All / Uncheck All With selected:  Change  Delete  Export

Edited November 19, 2012 by Soapi (see edit history)

[Jarred Mack]

What is contained in the duplicate orders? Are they all the same products, or do they have different products? Different addresses? Different carriers?

 

Have you made any modifications to your database? I recently modified my prestashop install to split shipping - it splits based off of the id_delivery_address, and assigns array values assuming that is correct - if it's not, it will actually create two new "orders" for a blank package. I don't have the code in front of me so I can't give a specific example, but there's a getPackages() call in the validation method of (I believe) the PaymentController - that will return an array which splits your order into "packages" if there are multiple addresses. If one of these values is wrong, there is code further down that will look for (for example) delivery address [5] and assign a value to it. If [5] doesn't exist, it will just create a new array([5] => array([key] => [value])), which gets treated as another order.

 

I hope that's not too confusing, but unfortunately I can't give exact details as I'm on my home PC at the moment.

[Soapi]

Different products. Same address. Same carrier.

 

The top order in the image for g.milham is one I created via the front office. So one shopping cart, one address, one carrier. When I finished the order, I went into the back office and it's 3 orders all with the exact same order number.

 

No modifications done to the database. It's a stock standard install of version 1.5.1.0

 

The orders are all linked, and it says like:

Warning: $120.94 paid instead of $327.00

This warning also concerns the next orders: #000023 #000024

Edited November 19, 2012 by Soapi (see edit history)

[Trip]

In my upgraded shop the variables are number 7xx and not under the first 30. If these variables are not present, which I doubt, there went something wrong during your installation/upgrade.

Maybe you should do a clean installation with demo products and test that on a local server. Than find out what is missing in your live shop. Add variables manually, do an upgrade to 1.5.2. or whatever. As I did not find a bug report so far, nor anyone else seems to have that problem, it seems that you messed something in the configuration or whatever.

Best regards, trip

[Soapi]

For some reason it was only showing me 30 lines...

 

I've just re-checked and see:

265 NULL NULL PS_ALLOW_MULTISHIPPING 0

 

and

266 NULL NULL PS_SHIP_WHEN_AVAILABLE 0

 

I don't think I installed it wrong. Everything else works fine. Surely if there was an error during installation, this wouldn't be the only problem I would face.

[Trip]

Hmm, yeah than sorry I have no other idea than try to reproduce the error on a clean installation and if it is not reproducable somehow try to find the differences.

Good luck, trip

[Soapi]

Arg.

 

Is there any prestashop employee that might know what is going on so that I don't have to spend hours searching through hay stacks?

[Trip]

Well you can try to call them or post it on the bug tracker. I know it is kind of frustrating and when the error appears radomly maybe hard to find the solution. I would download a clean 1.5.2 installation of ps and connect it to a backup of the prodcution database.

When this solves the problem you are at least sure that your database/configuration is correct and that a file or module caused the problem. After that you can copy pics, themes and maybe mails and 3'rd party modules to the "new" installation to get your shop migrated really fast. I am mean, ok I am sometimes lazy too and after an upgrade I usually have to fix some things I forgot to test or switch but did you ever test the checkout process or is there a specific event (installation of 3'rd party module), extensive playing with different options or was that right from the start buggy?

All the best, trip

[Trip]

Btw. you could try to change

/* Debug only */
@ini_set('display_errors', 'off');
define('_PS_DEBUG_SQL_', false);

to 'on' and 'true' in config/config.inc.php to see if errors are occuring in general or during checkout.

Regrads, trip

[Soapi]

No errors get shown :/

 

Just placed a test order with 12 products that got split into two orders. 1 of the orders has 4 products, the other order has the remaining 8 items. Same address, same everything.

[Trip]

Hmm, as posted before. I would upgrade shop, test different combinations with original database and your production db to see if it a configuration or software bug. If that is more clear post a bug on the tracker call ps team or try to sort out where the problem might be located. I found some bugs in ps and I am still waiting for the next version but the problem you have never occured so far in my tests and I am quite positive if this is the standard behaviour of the software many more people would participate in this thread.

Best wishes, trip

[Soapi]

Tried updating to see if that fixed it... white page of death everywhere. No error messages, just blank white pages. My site is now completely unusable *sigh*

 

The automatic updater didn't work, so I tried manual. White pages began after files were uploaded (before i could even upgrade!) and re-uploading them didn't fix it.

[mytwocentimes]

I see the SAME symptoms as @soapi originally highlighted --- carts are getting SPLIT into multiple ORDERS --- my clients see it because they see the SHIPPING COST jumping from EUR20 to EUR40 (two orders).

 

1.5.2 installed recently and tailored over the course of a week - unwilling to REDO everything just to test -

[mytwocentimes]

[sOLVED ... for my little problem]

 

In my case - I have THREE warehouses - if a client orders goods, prestashop KNOWS to split the cart and charge for shipping if the goods are coming from different warehouses. ONCE I moved some goods to the ONE warehouse, the splitting of the cart and double charging of the shipping STOPPED - I am sooooooo happy :-)

[Soapi]

[sOLVED ... for my little problem]

 

In my case - I have THREE warehouses - if a client orders goods, prestashop KNOWS to split the cart and charge for shipping if the goods are coming from different warehouses. ONCE I moved some goods to the ONE warehouse, the splitting of the cart and double charging of the shipping STOPPED - I am sooooooo happy :-)

 

Oh serious? So you can't use multiple warehouses without it splitting orders? Bummer. I have a lot of products and use the warehouses to split up the groups of items so it's easier to update. I guess I'll just have to smoosh them all into one warehouse. Bummer.

 

But thank you SO much for your post!!!!

[qicpf]

 

Posted 28 November 2012 - 01:38 AM mytwocentimes

 

 

[sOLVED ... for my little problem]

 

In my case - I have THREE warehouses - if a client orders goods, prestashop KNOWS to split the cart and charge for shipping if the goods are coming from different warehouses. ONCE I moved some goods to the ONE warehouse, the splitting of the cart and double charging of the shipping STOPPED - I am sooooooo happy :-)

 

 

Thank you for you post. You have solved many hours of digging.

[eec]

This 

 

[sOLVED ... for my little problem]

 

In my case - I have THREE warehouses - if a client orders goods, prestashop KNOWS to split the cart and charge for shipping if the goods are coming from different warehouses. ONCE I moved some goods to the ONE warehouse, the splitting of the cart and double charging of the shipping STOPPED - I am sooooooo happy :-)

 

Above post solved our similar problem of getting splited orders in Prestashop 1.6, issue was with the Warehouse settings.

Thanks

[rubensaid]

I will test this case, it may be an important feature for a marketplace

[Juhas0]

Hi, I was fighting with that and found another way.

Some of my products had "advanced warehouse" option check.

Product -> Quantities

and then checkbox: "I want to use advanced availability management for this product"

(I am not using english version of prestashop, so this message may look different in english version).

 

When I changed all my products so they now don't use advanced warehouse, everything seems to be working fine.