<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to patches</title><link href="https://sourceforge.net/p/magmi/patches/" rel="alternate"/><link href="https://sourceforge.net/p/magmi/patches/feed.atom" rel="self"/><id>https://sourceforge.net/p/magmi/patches/</id><updated>2016-12-12T00:03:56.904000Z</updated><subtitle>Recent changes to patches</subtitle><entry><title>Multiselect Values not Updating/Creating for Magento 1.9.3</title><link href="https://sourceforge.net/p/magmi/patches/26/" rel="alternate"/><published>2016-12-12T00:03:56.904000Z</published><updated>2016-12-12T00:03:56.904000Z</updated><author><name>Diamond</name><uri>https://sourceforge.net/u/diamondguy/</uri></author><id>https://sourceforge.net26aa462bdabb42135d6d7cc22587cb5f1b7a6da4</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Came across this patch. Somehting to update in the release if it worthy. Also would liek to share it with other people. Sepent over 3 days trying to figure this out since drop down attributes caule work fine.not sure what the issues was with multiselect.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://magehelperblog.com/magmi-multiselect-issue-magento-1-9-3/#comment-625" rel="nofollow"&gt;http://magehelperblog.com/magmi-multiselect-issue-magento-1-9-3/#comment-625&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>is_in_stock doesn't change when min_qty is not defined</title><link href="https://sourceforge.net/p/magmi/patches/25/" rel="alternate"/><published>2016-02-23T19:03:51.759000Z</published><updated>2016-02-23T19:03:51.759000Z</updated><author><name>Desarrollo Rollpix</name><uri>https://sourceforge.net/u/desarollpix/</uri></author><id>https://sourceforge.neta5ce4bfa2c3941f25512016dda3bbae2b58e3d0e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;We've a problem importing products without &lt;strong&gt;min_qty&lt;/strong&gt; attribute in version 0.7.22. When this happens, the attribute &lt;strong&gt;is_in_stock&lt;/strong&gt; doesn't change. For this reason we did next fix in &lt;strong&gt;/engines/magmi_productimportengine.php&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;We changed line 1084&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;mqty&lt;/span&gt;&lt;span class="x"&gt; = (isset(&lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;item&lt;/span&gt;&lt;span class="x"&gt;["min_qty"]) ? &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;item&lt;/span&gt;&lt;span class="x"&gt;["min_qty"] : 0);&lt;/span&gt;
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;For next code&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;&lt;span class="x"&gt;// Get product min_qty and use_config_min_qty from database&lt;/span&gt;
&lt;span class="x"&gt;            &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;sql&lt;/span&gt;&lt;span class="x"&gt; = "SELECT min_qty, use_config_min_qty FROM &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;csit&lt;/span&gt;&lt;span class="x"&gt; WHERE product_id = &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;pid&lt;/span&gt;&lt;span class="x"&gt;";&lt;/span&gt;

&lt;span class="x"&gt;            &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt; = &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;this&lt;/span&gt;&lt;span class="x"&gt;-&amp;gt;selectAll(&lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;sql&lt;/span&gt;&lt;span class="x"&gt;, null);&lt;/span&gt;

&lt;span class="x"&gt;            // Check product inventory configuration&lt;/span&gt;
&lt;span class="x"&gt;            if (&lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt;[0]["use_config_min_qty"]==1)&lt;/span&gt;&lt;span class="err"&gt;{&lt;/span&gt;&lt;span class="x"&gt;                &lt;/span&gt;
&lt;span class="x"&gt;            // Get min_qty from general configuration (Catalog &amp;gt; Inventory &amp;gt; Qty for Item's Status to Become Out of Stock)&lt;/span&gt;
&lt;span class="x"&gt;        &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;ccd&lt;/span&gt;&lt;span class="x"&gt; = &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;this&lt;/span&gt;&lt;span class="x"&gt;-&amp;gt;tablename("core_config_data");&lt;/span&gt;
&lt;span class="x"&gt;                &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;sql&lt;/span&gt;&lt;span class="x"&gt; = "SELECT value FROM &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;ccd&lt;/span&gt;&lt;span class="x"&gt; WHERE scope = ? AND path = ?";&lt;/span&gt;

&lt;span class="x"&gt;                &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt; = &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;this&lt;/span&gt;&lt;span class="x"&gt;-&amp;gt;selectAll(&lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;sql&lt;/span&gt;&lt;span class="x"&gt;, array('default','cataloginventory/item_options/min_qty'), 'value');&lt;/span&gt;

&lt;span class="x"&gt;                &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt; = &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt;[0]["value"];&lt;/span&gt;

&lt;span class="x"&gt;            }else&lt;/span&gt;&lt;span class="err"&gt;{&lt;/span&gt;&lt;span class="x"&gt;&lt;/span&gt;
&lt;span class="x"&gt;                // Get min_qty from product inventory&lt;/span&gt;
&lt;span class="x"&gt;                &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt; = &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt;[0]["min_qty"];&lt;/span&gt;
&lt;span class="x"&gt;            }                &lt;/span&gt;

&lt;span class="x"&gt;        // Set &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;mqty&lt;/span&gt;&lt;span class="x"&gt; with &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt; if min_qty is not set&lt;/span&gt;
&lt;span class="x"&gt;            &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;mqty&lt;/span&gt;&lt;span class="x"&gt; = (isset(&lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;item&lt;/span&gt;&lt;span class="x"&gt;["min_qty"]) ? &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;item&lt;/span&gt;&lt;span class="x"&gt;["min_qty"] : &lt;/span&gt;&lt;span class="p"&gt;$&lt;/span&gt;&lt;span class="nv"&gt;db_mqty&lt;/span&gt;&lt;span class="x"&gt;);&lt;/span&gt;
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;Please tell me if there is another way to do that, or to improve our code.&lt;/p&gt;
&lt;p&gt;Thanks for developing this project.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#24 Multiselect list bug</title><link href="https://sourceforge.net/p/magmi/patches/24/?limit=25#c0a8" rel="alternate"/><published>2016-02-11T11:12:51.686000Z</published><updated>2016-02-11T11:12:51.686000Z</updated><author><name>Björn Tantau</name><uri>https://sourceforge.net/u/tantau-limora/</uri></author><id>https://sourceforge.net673e614331d70b2010e55a583d6f501200164d31</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;You could also try the Value Trimmer plugin.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#5 Grouped Product Importer</title><link href="https://sourceforge.net/p/magmi/patches/5/?limit=25#c1ab" rel="alternate"/><published>2016-01-05T17:08:19.292000Z</published><updated>2016-01-05T17:08:19.292000Z</updated><author><name>jayabharathi</name><uri>https://sourceforge.net/u/snjb14/</uri></author><id>https://sourceforge.netf06f13b792c9d24e4201a91e3924590a34e9ca44</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;If anyone is still looking to import the default quantity of the product associated with grouped product, under grouped_skus column of import file, use the following format &amp;lt;sku1&amp;gt;::&amp;lt;position&amp;gt;::&amp;lt;qty&amp;gt;, &amp;lt;sku2&amp;gt;::&amp;lt;position&amp;gt;::&amp;lt;qty&amp;gt; and so on.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#5 Grouped Product Importer</title><link href="https://sourceforge.net/p/magmi/patches/5/?limit=25#740f/22e9" rel="alternate"/><published>2016-01-05T14:37:01.787000Z</published><updated>2016-01-05T14:37:01.787000Z</updated><author><name>jayabharathi</name><uri>https://sourceforge.net/u/snjb14/</uri></author><id>https://sourceforge.net4dd06dfffe38c7c5a6371fe3b97d84c8fb3bc168</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi.. Have you managed to accomplish this. I have the same issue and it would be great to know the solution. Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Multiselect list bug</title><link href="https://sourceforge.net/p/magmi/patches/24/" rel="alternate"/><published>2015-12-07T15:13:47.494000Z</published><updated>2015-12-07T15:13:47.494000Z</updated><author><name>Jacco de Heus</name><uri>https://sourceforge.net/u/jaccodeheus/</uri></author><id>https://sourceforge.net920daf2956791de316501a967deecb95d7ffe943</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hello,&lt;/p&gt;
&lt;p&gt;The export of products (with an extension) will ruin the labels for multiselect lists.&lt;br/&gt;
Example export list: Monday , Tuesday , Wednesday , Thursday&lt;br/&gt;
The spaces will ruin the array because there aren't trimmed.&lt;/p&gt;
&lt;p&gt;array(&lt;br/&gt;
&lt;span&gt;[0]&lt;/span&gt; =&amp;gt; Monday&lt;br/&gt;
&lt;span&gt;[1]&lt;/span&gt; =&amp;gt;  Tuesday&lt;br/&gt;
&lt;span&gt;[2]&lt;/span&gt; =&amp;gt;  Wednesday&lt;br/&gt;
)&lt;/p&gt;
&lt;p&gt;So I added this on line 466 after $multiselectvalues (function handleVarcharAttribute in magmi_defaultattributehandler.php):&lt;/p&gt;
&lt;p&gt;foreach($multiselectvalues as $key =&amp;gt; $value) {&lt;br/&gt;
                $multiselectvalues&lt;span&gt;[$key]&lt;/span&gt; = trim($value);&lt;br/&gt;
}&lt;/p&gt;
&lt;p&gt;If you add this there will not created new label/options with spaces before and after the label.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#22 DefaultAttributeHandler Performance Optimisation</title><link href="https://sourceforge.net/p/magmi/patches/22/?limit=25#8278/e435" rel="alternate"/><published>2015-09-21T20:56:38.744000Z</published><updated>2015-09-21T20:56:38.744000Z</updated><author><name>sam brown</name><uri>https://sourceforge.net/u/emulex/</uri></author><id>https://sourceforge.netc1ec60d053fae688ad34c815d4b131aa88c79079</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have found that the statement that calls mysql with REGEXP ? - chooses to not use the proper index magmi_search1 unless you add a like ? statment with at least the first character of the VALUE ! this causes much slowdown after 300K products!&lt;/p&gt;
&lt;p&gt;mysql&amp;gt; SELECT SQL_CACHE value FROM catalog_product_entity_varchar WHERE value like 'f%' AND attribute_id='97' AND entity_id!='1056988'  AND store_id='0' AND value REGEXP '^fio\-carepack\-io\-accel\-for\-c\-class\-sup-(\d+)?';&lt;br/&gt;
+-----------------------------------------+&lt;br/&gt;
| value                                   |&lt;br/&gt;
+-----------------------------------------+&lt;br/&gt;
| fio-carepack-io-accel-for-c-class-sup-1 |&lt;br/&gt;
+-----------------------------------------+&lt;br/&gt;
1 row in set (0.49 sec)&lt;/p&gt;
&lt;p&gt;mysql&amp;gt; SELECT value FROM catalog_product_entity_varchar WHERE  attribute_id='97' AND entity_id!='1056988'  AND store_id='0' AND value REGEXP '^fio\-carepack\-io\-accel\-for\-c\-class\-sup-(\d+)?';&lt;br/&gt;
+-----------------------------------------+&lt;br/&gt;
| value                                   |&lt;br/&gt;
+-----------------------------------------+&lt;br/&gt;
| fio-carepack-io-accel-for-c-class-sup-1 |&lt;br/&gt;
+-----------------------------------------+&lt;br/&gt;
1 row in set (1 min 9.79 sec)&lt;/p&gt;
&lt;p&gt;This is with the above index applied!&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#5 Grouped Product Importer</title><link href="https://sourceforge.net/p/magmi/patches/5/?limit=25#740f" rel="alternate"/><published>2015-08-19T09:10:11.786000Z</published><updated>2015-08-19T09:10:11.786000Z</updated><author><name>Manuel Gallego</name><uri>https://sourceforge.net/u/spainbox/</uri></author><id>https://sourceforge.net7b6a9fa653997c39d75c88b65009751027ef9284</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hello Joe,&lt;/p&gt;
&lt;p&gt;We use grouped products with quantities.&lt;br/&gt;
Is it possible to indicate quantity of every associated products of the grouped products?&lt;/p&gt;
&lt;p&gt;Thank you in advance.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#22 DefaultAttributeHandler Performance Optimisation</title><link href="https://sourceforge.net/p/magmi/patches/22/?limit=25#3c64" rel="alternate"/><published>2015-03-26T16:38:28.539000Z</published><updated>2015-03-26T16:38:28.539000Z</updated><author><name>Sergio</name><uri>https://sourceforge.net/u/scvikic/</uri></author><id>https://sourceforge.net7de7f5eac069f4bc227d0fddc12cc7082a657d3b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;On 300k products I have 4 million records, table file is just under 1GB.&lt;br /&gt;
We'll see how it handles 1 million skus after import is done.&lt;/p&gt;
&lt;p&gt;IMHO this isn't a big issue, if you have a really large store, you can probably invest in RAM/SSD to handle the large indexes, ain't that big of a deal these days.&lt;/p&gt;
&lt;p&gt;BTW great work on MAGMI ;)&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#22 DefaultAttributeHandler Performance Optimisation</title><link href="https://sourceforge.net/p/magmi/patches/22/?limit=25#8278" rel="alternate"/><published>2015-03-26T16:15:16.082000Z</published><updated>2015-03-26T16:15:16.082000Z</updated><author><name>Sebastien Bracquemont</name><uri>https://sourceforge.net/u/dweeves/</uri></author><id>https://sourceforge.net99823ff16b90956c2ea2c1802000c5636d81d28b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Yes, an index is a "quick" fix, however, since this table may have millions of records, the index can be huge. so i'll try to find an alternative.&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>