Back to connectors… Back to Magento...

Handling Configurable Products in Magento 1.0 (4 replies)

fperloff
8 years ago
fperloff 8 years ago

Hi, we seem to be having an issue where configurable products are importing twice? Once for the parent and once for the selected configurable. This is obviously leading to stock being decremented twice.

Can you please assist with the logic needed to handle configurable products?

Support
8 years ago
Support 8 years ago

fperloff, as you've found out Magento exports both the parent and selected configurable AND depending on your setup this selected product may or may not have a price.

What you need to do is to filter out the unwanted (parent) product, keep the child and copy the parent's price to the child.

  1. In a map transform prior to your order being created add a formula to the field you use to set the price in your ERP solution, to:

    IIf(PreviousRecord("product_type") = "configurable", PreviousRecord("fieldName"), %fieldname)

    Replacing the fieldName value with the actual field name containing your price value. Please note that you need to keep the quote marks.

  2. Following the Map transform you now need to add a Filter transform where you have the following formula on the OrderDetails dropdown.

    %product_type "configurable"

    This will have the effect of filtering all configurable products.

https://www.realisable.co.uk/wp-content/uploads/2018/11/MagentoConfigurableProductHandling.png
perloff
8 years ago
perloff 8 years ago

There's a typo in the comment by "Support." The code for step 2 should read:

%product_type "configurable"

perloff
8 years ago
perloff 8 years ago

Oh my goodness - the forum software munges characters. There needs to be a "not equals" (a left carat followed be a right carat) between %product_type and "configurable"

 

davidthom
2 weeks ago
davidthom 2 weeks ago

Taking the train across Perth takes forever so I started looking for some decent mobile entertainment to kill the time on my commute. A bloke at work told me about the licensed ilucki casino site and the massive variety of classic fruit machines is just brilliant. It never crashes and I feel totally secure wagering my own Aussie dollars. I always use PayID for quick deposits without any hidden fees. I managed a decent baccarat win last week and the money was transferred to my CommBank account in hours.

Contact

    Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

    Looking to purchase IMan, please see our resellers here.

    Realisable Software
    Ph: +44 (0) 208 123 1017

    Copyright © Realisable. All rights reserved.
    Realisable is a registered trademark

    Close

    Request Demo

      Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

      Looking to purchase IMan, please see our resellers here.

      Realisable Software
      Ph: +44 (0) 208 123 1017

      Copyright © Realisable. All rights reserved.
      Realisable is a registered trademark

      Close

      Access Downloads

        Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

        Looking to purchase IMan, please see our resellers here.

        Realisable Software
        Ph: +44 (0) 208 123 1017

        Copyright © Realisable. All rights reserved.
        Realisable is a registered trademark

        Close