Imported Orders containing configurable products creates many order lines

[youngi]

Orders that have configurable products are imported into openERP with:
a line for the configurable product (and contains the pricing and quantity info)
a line for each of the options of simple products (pricing of 0)

I think the same bug is the reason of that too:
if importing a cancelled or invoiced or shipped order(of course invoiced or shipped status in magento) creates too many order lines according to:
ordered quantity, shipped quantity, cancelled quantity

I'm attaching screen shots of a cancelled order imported to openERP

of course importing already processed orders is not necessary at all, I'm just mentioning it because I think it's the same bug causing configurable product to have a line as well as its simple product

[youngi (youngilaboungi)]

configurable product line in order

[youngi (youngilaboungi)]

configurable product in magento order page

[youngi (youngilaboungi)]

an imported cancelled order, lines in openERP order

[youngi (youngilaboungi)]

an imported cancelled order, lines in magento

[Salvador Sierra (salvador-sierra)]

Hi,

same issue here. Configurable Product order duplicates the lines as youngi describes.

cheers

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

Hello,

I should say we didn't took care of bundle, virtual and configurable product
sales. However products with options work already well.
Our customers don't have these kind of products, so it's unlikely we take
care of them soon unless of course it's contributed by you or others.

The general idea I guess would be to store configuration options inside the
sale order line properties field, much like we did for the
mrp_bom_customization OpenERP module.

Just to make sure, what you call Magento configurable products are product
that are not actually in stock, that have possible options and when the
customer orders it,
on order (eg Make To Order OpenERP MRP process), then you will produce or
buy the product according to the selected options, right?

On the the contrary what we are able to deal with are product with options
which are a bit like the OpenERP product_variant_multi we made along with
Smile and Tiny.

Finally, for bundles, the simplest is to create Magento product that map to
OpenERP product having a BOM made of several products. Thus, selling the
product will actually lead to the delivery of the several sub-products. Of
course, better integration of this with Magento is certainly possible.

Thoughts?

On Sat, Dec 5, 2009 at 3:58 PM, ssierra <email address hidden> wrote:

> Hi,
>
> same issue here. Configurable Product order duplicates the lines as
> youngi describes.
>
> cheers
>
> --
> Imported Orders containing configurable products creates many order lines
> https://bugs.launchpad.net/bugs/487890
> You received this bug notification because you are subscribed to Magento
> Open ERP Connector.
>
> Status in Magento Open ERP Connector: New
>
> Bug description:
> Orders that have configurable products are imported into openERP with:
> a line for the configurable product (and contains the pricing and quantity
> info)
> a line for each of the options of simple products (pricing of 0)
>
> I think the same bug is the reason of that too:
> if importing a cancelled or invoiced or shipped order(of course invoiced or
> shipped status in magento) creates too many order lines according to:
> ordered quantity, shipped quantity, cancelled quantity
>
> I'm attaching screen shots of a cancelled order imported to openERP
>
> of course importing already processed orders is not necessary at all, I'm
> just mentioning it because I think it's the same bug causing configurable
> product to have a line as well as its simple product
>
>
>

[Salvador Sierra (salvador-sierra)]

Hi Raphaël,

you are really making a great job with this connector!

About his issue, you are right we are the configurable product is one that does't exist it is just only a way to group different options so the customer can configure it. E.g. size + color. This doesn't mean we are going to produce it, in our case all the options are stockable products.

You say that you are able to manage options, how do you do this? Are you able to select the options from the product or what you have are different products in the catalog?

The benefit of the configurable product is that you have the different products with their own variances, but you only show one that can be configured.

cheers

[Ana Juaristi Olalde (ajuaristio)]

Hi Raphaël:

Testing magento conector, I found this bug is still happening on last published connector version. You set this bug as low but I think it's important.

Imaging this test case. You sale mountain shoes. You always buy all your products to_stock. You never make partial deliveries but only complete deliveries.

On importing sales order line is duplicated for each product. If you have got a product "Salomon shoes red T10" you will obtain a sales order having this 2 lines

Salomon Shoes qty: 1 price: 0€
Salomon Shoes red T10 qty: 1 price: 65€

So... if you directly confirm the order you will directly have got the packing created with 2 lines witch is incorrect. The impact is that "Salomon shoes" generic product will never have stock so your packing will stay always confirmed, never disposable to send. You will have no necesary stock moves even if you cancel the packing line.

The only way to make it work correctly would be deleting the line containing generic product on sales order or simply don't generating it.

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

Ana, it's not that it's not really important.
It's more that: on demand configurable products are more complex than the
basics and it's not too simple to fix properly (cause we would need to
propagate on_demand configuration options (there are several ways to do it),
not even sure if Magento API pass enough info natively or not (unlike
OpenERP, Magento API is not integrated at the core)...).
So I just meant, we, the main maintainers (until others is proven; some have
no shame attempting:
http://blog.smile.fr/le-blog-des-experts/pont-openerp-magento-le-retour ),
will not likely to fix it very soon unless we get some specific customer
paying us to do so. Of course, if in the meantime somebody contributes it,
we would welcome the patch and give the appropriate credits (say unlike Tiny
:-).

Nonetheless I believe features are slowly completed. We for instance now
have a project with CampToCamp to fix a few bugs (multi-shop especially), I
hope we could tackle that kind of things next. For now I believe what is
important is to tell users what work and what doesn't (and it's explicit on
the Launchpad project page now on demand configurable products are not
implemented yet). I understand that some buinesses can only work with on
demand configurable products, but we've seen that other who thought so can
actually very well generate different product variant (on stock) and
properly select them in the ecommerce.

Raphaël Valyi
http://www.akretion.com

On Tue, Mar 2, 2010 at 6:31 PM, Ana Juaristi Olalde <email address hidden>wrote:

> Hi Raphaël:
>
> Testing magento conector, I found this bug is still happening on last
> published connector version. You set this bug as low but I think it's
> important.
>
> Imaging this test case. You sale mountain shoes. You always buy all your
> products to_stock. You never make partial deliveries but only complete
> deliveries.
>
> On importing sales order line is duplicated for each product. If you
> have got a product "Salomon shoes red T10" you will obtain a sales order
> having this 2 lines
>
> Salomon Shoes qty: 1 price: 0€
> Salomon Shoes red T10 qty: 1 price: 65€
>
> So... if you directly confirm the order you will directly have got the
> packing created with 2 lines witch is incorrect. The impact is that
> "Salomon shoes" generic product will never have stock so your packing
> will stay always confirmed, never disposable to send. You will have no
> necesary stock moves even if you cancel the packing line.
>
> The only way to make it work correctly would be deleting the line
> containing generic product on sales order or simply don't generating it.
>
> --
> Imported Orders containing configurable products creates many order lines
> https://bugs.launchpad.net/bugs/487890
> You received this bug notification because you are subscribed to Magento
> Open ERP Connector.
>
> Status in Magento Open ERP Connector: New
>
> Bug description:
> Orders that have configurable products are imported into openERP with:
> a line for the configurable product (and contains the pricing and quantity
> info)
> a line for each of the options of simple products (pricing of 0)
>
> I think the same bug is the reason of...

[Ana Juaristi Olalde (ajuaristio)]

Hi again:

Thank you for your incredibly quick answer.

I think a very easy patch don't impacting at all, on just included connector functionality would be as simple as deleting all price=0 order lines where order line product is different to shipping cost.

I know it's a very ugly fix and it's not the real solution but it could apparently work and it would be 5 minutes building such an easy function on connector. I can try to build it next week if you find it interesting.

[Kyudo (killerloop-1)]

Hello ana

i find you solution interesting for resolve this problem for the moment, can u say me if u make it, and how?

Thx a lot

[Jens Knobi (jens-knobi)]

what is the status about the configurable products??? I think it is very important to use them.

[youngi (youngilaboungi)]

A year ago i was implementing this module for tests. Then since it was still away of our needs I have built a Magento-Checkout App POS solution. I did face this many order lines bug even in my magento module and it is because of Magento's own problem delivering order information. Eventually I fixed this issue. Since I am back at looking into Openerp again, I might solve this issue from Magento side. Will post my findings asap.

[Kyle Waid (midwest)]

This bug has been fixed. You can find a development branch proposed for merging. I will see that it is merged when I am sure it works correctly. For now test the branch and let us know if it works.

[Kyle Waid (midwest)]

https://code.launchpad.net/~sharoonthomas/magentoerpconnect/openerp6-module-with-configurable-and-options