Back to connectors… Back to Magento...

Handling Configurable Products in Magento 1.0 (3 replies)

fperloff
5 years ago
fperloff 5 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
5 years ago
Support 5 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
5 years ago
perloff 5 years ago

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

%product_type "configurable"

perloff
5 years ago
perloff 5 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"

 

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