2

We use an extension by Celigo that pushes products from our CRM/ERM (Netsuite) into Magento. Somehow the system pushed a couple duplicates (still looking into why). I need to delete the duplicate products but there are existing orders that reference these duplicate products. For now I have disabled the duplicates in Magento so no new orders are created. Ideally I would like to change the orders to reference the correct product but I don't know if that is possible. If I can, the sync back to our CRM/ERM should actually accept the order. The duplicate is currently causing this to fail.

Tl;dr What happens to an order if I just delete the product associated with it?

1
  • Marius, thanks for the spelling correction. I could not for the life of me remember what was the correct word usage. Mar 27, 2015 at 21:50

1 Answer 1

3

Flying this by the seat of my pants but I think you'll be fine as long as any custom modules you have installed are doing their things correctly.

When you create an order the data from the quote item is copied to the order item and essentially becomes decoupled from the actual product.

This is pretty verifiable.

  1. Look at a product in an order history
  2. Find the product in the catalog
  3. Rename it
  4. See that the order history name has not changed

The reason for this decoupling is the exact kind of thing you're asking. So that changing the catalog does not affect historical order information.

Now, I'm just going to sit back and wait for Marius to tell me why I'm wrong :)

4
  • 1
    When did I become the boogeyman? You are 100% right. I might only add that there will be no "reorder" button in the orders list in the customer's account. But that's a useless feature anyway.
    – Marius
    Mar 27, 2015 at 9:54
  • 1
    Haha, just taking the piss man :) Mar 27, 2015 at 9:55
  • Although this question was for Magento 1, I'm writing for Magento 2 in case someone is reading. The image however, still remain associate to the current live product image. I just tested on Magento 2.3.5-p1. May 30, 2022 at 8:56
  • I thought it would be hard to also decouple images, oh my that would start consuming resources very quickly having a copy (although small) of every product image for each order. Name and SKU are important to keep decoupled, I believe (did not test) that prices are also saved in the order table. ( I remember looking at the table once and it had almost all the order's data including prices, discount, special price, tax etc. May 30, 2022 at 8:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.