Handling Configurable Products in Magento 1.0 (3 replies)
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.
- 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.
- 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.
There's a typo in the comment by "Support." The code for step 2 should read:
%product_type "configurable"
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"
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?