<?xml version="1.0"?>
<rss xmlns:atom="http://www.w3.org/2005/Atom" version="2.0">
		<channel><title>[Support Center] Recently Changed Articles</title><link>http://unirgy.com/support/portal/rss/kb/recent_changes</link><description></description><item><title>How to configure Magento to have subdomains for each vendor</title><description>1. Configure webserver to point all subdomains to Magento root.  
  
2. Make wildcard DNS to point all subdomains to the same server, or add subdomains to DNS for every new vendor, depends on how often you have new vendor registrations.  
  
3. Set Admin &gt; System &gt; Configuration &gt; Web &gt; Default Pages &gt; Default Web URL = "umicrosite"

4. In addition you might need to set
"Configuration &gt; Web &gt; Redirect to Base URL if requested URL doesn't match it = No", 
otherwise vendor urls will redirect to website base URL

5. Also you can consider "Configuration &gt; Drop Shipping &gt; MicroSite Options &gt; Update Store Base URL". This allows you to change urls on microsite pages to http://vendor.domain.com/&lt;url path&gt; (depends on how you configured "Configuration &gt; Drop Shipping &gt; MicroSite Options &gt; Subdomain level to use for vendor")

6. And make sure you have URL Key set in vendor preferences.

7. As long as vendor landing page show Layered Navigation make sure you set "Is Anchor" = Yes for store root category.</description><link>http://unirgy.com/support/portal/kb/article/11</link><pubDate>Mon, 20 Aug 2012 16:27:30 GMT</pubDate><guid isPermaLink="false">ebfdc7c7d6438d7f52799404e867ee3f</guid></item><item><title>Printing labels using thermal printer</title><description>If a vendor is configured to print EPL (thermal) shipping labels, by default you'll just see a download with extension .EPL  
  
To configure your computer to print the labels automatically on the thermal printer, follow these instructions (Windows only):  
  
1. Share a locally connected USB thermal printer using Windows Sharing, and give the shared printer a meaningful name (ex. LP2844)  
  
2. Create a batch file, for example print.bat, with this line:  
COPY %1 \\\\MYCOMPUTER\LP2844  
  
Where MYCOMPUTER is the name of your computer and LP2844 is the name of the printer share you've created in step 1.  
  
3. When you have downloaded .EPL file, choose to open it using the .bat file you've created in step 2.  
  
4. Additionally, you could create a Windows association of .EPL files with print.bat file.</description><link>http://unirgy.com/support/portal/kb/article/7</link><pubDate>Thu, 05 Jul 2012 20:30:16 GMT</pubDate><guid isPermaLink="false">33acec562db1b1941e6308ab2b70df58</guid></item><item><title>Billing and licensing FAQ</title><description>&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;Q. Are the uDropship, uRapidFlow and uGiftCert extensions fully open source?&lt;/strong&gt;&lt;br/&gt;
A. No, the commercial extensions contain ionCube encoded files with essential functionality. Most of the code that usually requires customization is open, and if help is required with protected files, we'll be glad to add event hooks or provide hidden API on specific request. For more information on ionCube loaders: &lt;a href="http://ioncube.com/loaders.php"&gt;Loaders Download&lt;/a&gt; , &lt;a href="http://ioncube.com/loader_installation.php"&gt;Installation instructions&lt;/a&gt;
&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Can I pay you directly using credit card?&lt;/strong&gt;&lt;br/&gt;
A. No, we do not accept credit cards directly, without PayPal or GoogleCheckout. If you wish to pay using check or wire transfer, please submit the order using Online Invoice method, and the FreshBooks invoice will be sent to you. A temporary license will be generated for you until the payment arrives.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. How can I ensure the quickest order processing?&lt;/strong&gt;&lt;br/&gt;
A. Make sure to specify production domain or server information for licensing in comments (depending on the license, domain name or server IP/MAC address).&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Are dev/test/staging domains included in the license?&lt;/strong&gt;&lt;br/&gt;
A. Yes, the 127.0.0.1 (localhost) is always included in the license, and if you have other dev/test/staging domain, please include it in order comments.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Are the subdomains included in the domain license?&lt;/strong&gt;&lt;br/&gt;
A. Yes, the domain license is for 2nd level domain and all its subdomains.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Once I purchase an extension, can I later purchase and install add-ons?&lt;/strong&gt;&lt;br/&gt;
A. Yes.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Once I purchase a 1 week license, can I later upgrade to the permanent license for the difference in price?&lt;/strong&gt;&lt;br/&gt;
A. Yes.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Once I purchase a domain license, can I later upgrade to the server license for the difference in price?&lt;/strong&gt;&lt;br/&gt;
A. Yes.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Is it a considerable amount of work to upgrade extension editions or install add-ons later?&lt;/strong&gt;&lt;br/&gt;
A. No, the installation is just unpacking an archive into Magento root folder.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;li&gt;&lt;strong&gt;Q. Do you offer an affiliate program?&lt;/strong&gt;&lt;br/&gt;
A. Yes, please contact me for details.&lt;br/&gt;&lt;br/&gt;&lt;/li&gt;

&lt;/ul&gt;</description><link>http://unirgy.com/support/portal/kb/article/21</link><pubDate>Thu, 31 May 2012 21:59:29 GMT</pubDate><guid isPermaLink="false">8aaa8b849b9cc9a23259ffd0149c640f</guid></item><item><title>How to change vendor interface URL from /udropship to /vendor</title><description>If you have local custom module, add this to your module's etc/config.xml, otherwise add this to app/etc/local.xml:

&lt;xmp&gt;
&lt;!-- ADD THIS: --&gt;
     &lt;frontend&gt;
        &lt;routers&gt;
            &lt;udropship&gt;
                &lt;args&gt;
                    &lt;frontName&gt;vendor&lt;/frontName&gt;
                &lt;/args&gt;
            &lt;/udropship&gt;
        &lt;/routers&gt;
        &lt;secure_url&gt;
            &lt;udropship_vendor&gt;/vendor/vendor/&lt;/udropship_vendor&gt;
        &lt;/secure_url&gt;
     &lt;/frontend&gt;
&lt;!-- RIGHT BEFORE LAST CLOSING TAG --&gt;
&lt;/config&gt;
&lt;/xmp&gt;</description><link>http://unirgy.com/support/portal/kb/article/15</link><pubDate>Thu, 06 Oct 2011 01:13:54 GMT</pubDate><guid isPermaLink="false">a9f2db3739ac9018063025f0652f8961</guid></item><item><title>Sending of certificate notificattion emails</title><description>Depends on a setting, you should set when recipient gets notification emails.
It could be 'On order completion', 'On order placement', and 'never' if you don't want to send emails.
The setting that decides this is in System &gt; Configuration &gt; Gift Certificates &gt; Email Delivery Options &gt; Send new GC confirmation</description><link>http://unirgy.com/support/portal/kb/article/24</link><pubDate>Wed, 28 Sep 2011 21:03:38 GMT</pubDate><guid isPermaLink="false">8eeac996302abc0c1fd34aed3905ffad</guid></item><item><title>Missing GC details on product page</title><description>To get gift certificate specific html in your template you need to 
have a call like `&lt;?php echo $this-&gt;getChildHtml('product_type_data');?&gt;`, it could be the case that you don't want 
to display this for other product types, so you may wrap it in a conditional statement like:

`
&lt;?php if ($_product-&gt;getTypeId() == 'ugiftcert'): ?&gt;
&lt;?php echo $this-&gt;getChildHtml('product_type_data');?&gt;
&lt;?php endif;?&gt;
`</description><link>http://unirgy.com/support/portal/kb/article/23</link><pubDate>Tue, 20 Sep 2011 20:05:27 GMT</pubDate><guid isPermaLink="false">57db763d2f764aeb5dd46b2deedf31d9</guid></item><item><title>Making Dropship work with GoogleCheckout</title><description>Configuration:

&lt;ol&gt;
&lt;li&gt;Go to &lt;strong&gt;Admin &gt; System &gt; Configuration &gt; Google API &gt; Shipping - Merchant Calculated&lt;/strong&gt;&lt;/li&gt;
&lt;li&gt;Enable Merchant Calculated rates&lt;/li&gt;
&lt;li&gt;Add all Dropship Shipping Methods&lt;/li&gt;
&lt;/ol&gt;

There are few bugs in Magento 1.3.2.3 that prevent Dropship from working with GoogleCheckout.

Here are the changes that need to be done to make it work correctly:

&lt;ol&gt;
&lt;li&gt;Edit app/code/core/Mage/Shipping/Model/Shipping.php&lt;ol&gt;
&lt;li&gt;Around line 175:&lt;pre&gt;
// ADD:
$request-&gt;setAllItems($address-&gt;getAllItems());
// RIGHT BEFORE:
return $this-&gt;collectRates($request);
&lt;/pre&gt;
&lt;/li&gt;&lt;/ol&gt;&lt;/li&gt;
&lt;li&gt;Edit app/code/core/Mage/GoogleCheckout/Model/Api/Xml/Callback.php&lt;ol&gt;
&lt;li&gt;Around line 141:&lt;pre&gt;
// ADD:
$limitCarrier = array_unique($limitCarrier);
// RIGHT BEFORE:
foreach($googleAddresses as $googleAddress) {
&lt;/pre&gt;
&lt;/li&gt;
&lt;li&gt;Around line 163:&lt;pre&gt;
// COMMENT OUT:
#$address-&gt;setCollectShippingRates(true)-&gt;collectShippingRates();
&lt;/pre&gt;&lt;/li&gt;
&lt;li&gt;Around line 245:&lt;pre&gt;
// RIGHT AFTER:
    $result-&gt;SetShippingDetails($methodName, $rates[$methodName], "true");
    $merchantCalculations-&gt;AddResult($result);
}
// ADD: 
else {
    $result-&gt;SetShippingDetails($methodName, 0, "false");
    $merchantCalculations-&gt;AddResult($result);
}
&lt;/pre&gt;&lt;/li&gt;&lt;/ol&gt;&lt;/li&gt;
&lt;/ol&gt;

Even if all is configured and coded correctly, you still might experience issues with GoogleCheckout, because of hardcoded 3 second timeout for merchant calculation API callback, if your vendors are using external API to calculate rates, such as UPS, USPS, FedEx.

&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
In versions 1.4.1.0, 1.4.1.1 you will also face magento bug (fixed in 1.4.2).

&lt;ul&gt;
&lt;li&gt;Edit app/code/core/Mage/GoogleCheckout/Model/Api/Xml/Callback.php
&lt;ol&gt;
&lt;li&gt;Find method _importGoogleTotals (in 1.4.1.0 starts at line 417) and following code in it
&lt;pre&gt;
...
if (!empty($method)) {
            Mage::getSingleton('tax/config')-&gt;setShippingPriceIncludeTax(false);
            $rate = Mage::getModel('sales/quote_address_rate')
                -&gt;setCode($method)
                -&gt;setPrice($shipping['shipping-cost']['VALUE']);
...
&lt;/pre&gt;
&lt;li&gt;Replace it with 
&lt;pre&gt;
if (!empty($method)) {
            Mage::getSingleton('tax/config')-&gt;setShippingPriceIncludeTax(false);
            list ($gcCT, $gcMT) = explode(' - ', $shipping['shipping-name']['VALUE'], 2);
            $rate = Mage::getModel('sales/quote_address_rate')
                -&gt;setCode($method)
                -&gt;setPrice($shipping['shipping-cost']['VALUE'])
                -&gt;setCarrierTitle($gcCT)
                -&gt;setMethodTitle($gcMT);
&lt;/pre&gt;

&lt;/ul&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;If you find errors like "Merchant Calculations: We were looking for data in your merchant-calculation-results, but were not able to find it: shipping-name" in your integration console mostly likely you added one method in magento admin "Configuration &gt; Google API &gt; Google Checkout Shipping - Merchant Calculated &gt; Allowed Methods". To eliminate that errors:
&lt;ol&gt;

&lt;li&gt;Find method _responseMerchantCalculationCallback (in 1.4.1.0 starts at line 114) and following code in it (at line 171)
&lt;pre&gt;
...
if ($gRequestMethods = $this-&gt;getData('root/calculate/shipping/method')) {
        $carriers = array();
        $errors = array();
...
&lt;/pre&gt;
&lt;li&gt;Replace it with 
&lt;pre&gt;
$gRequestMethods = $this-&gt;getData('root/calculate/shipping/method');
        if ($gRequestMethods) {
            // Make stable format of $gRequestMethods for convenient usage
            if (array_key_exists('VALUE', $gRequestMethods)) {
                $gRequestMethods = array($gRequestMethods);
        }
        $carriers = array();
        $errors = array();
&lt;/pre&gt;


&lt;/ol&gt;
&lt;/ul&gt;
</description><link>http://unirgy.com/support/portal/kb/article/3</link><pubDate>Wed, 10 Aug 2011 01:28:18 GMT</pubDate><guid isPermaLink="false">e11a2c013fce68b7049a13ffc0af9c21</guid></item><item><title>Having issues with line breaks in Excel</title><description>Apparently Excel and Google Docs have a bug that does not allow them to correctly load fields with line breaks.

Please try OpenOffice or LibreOffice to open the files with line breaks in fields.</description><link>http://unirgy.com/support/portal/kb/article/22</link><pubDate>Sun, 12 Jun 2011 08:00:28 GMT</pubDate><guid isPermaLink="false">683dcddeee9f5058816a1c3eb6d458f7</guid></item><item><title>How to disable/uninstall uDropship extension</title><description>&lt;p&gt;These steps are required to disable the extension:&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;1. Remove shipping carrier configuration values from database:&lt;/strong&gt;&lt;/p&gt;

&lt;pre&gt;DELETE FROM `core_config_data` WHERE `path` LIKE 'carriers/udropship/%' OR `path` like 'udropship/%';&lt;/pre&gt;

&lt;p&gt;&lt;strong&gt;2. Delete product Dropship attributes in Admin &gt; Catalog &gt; Product Attributes.&lt;/strong&gt;&lt;/p&gt;

&lt;pre&gt;DELETE FROM `eav_attribute` WHERE `attribute_code` LIKE 'udropship_%';&lt;/pre&gt;

&lt;p&gt;&lt;strong&gt;3. Disable the extension in configuration:&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;Edit app/etc/modules/Unirgy_Dropship.xml and change "&lt;active&gt;true&lt;/active&gt;" to false.&lt;/p&gt;
&lt;p&gt;Repeat for any Unirgy_Dropship*.xml add-on file in the folder.&lt;/P&gt;

&lt;p&gt;&lt;strong&gt;4. Refresh Magento cache, log out from admin and re-login.&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;It is not required to remove any files to fully disable extension functionality.&lt;/strong&gt;&lt;/p&gt;
&lt;hr style="border:1px"/&gt;
&lt;p&gt;&lt;strong&gt;The following steps are optional for uninstallation, but required before future re-installation of the extension and add-ons:&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;5. Delete all udropship tables:&lt;/strong&gt;&lt;/p&gt;
&lt;pre&gt;
-- if you have uMicrosite add-on installed:
ALTER TABLE admin_user DROP FOREIGN KEY FK_ADMIN_USER_VENDOR;
DROP TABLE IF EXISTS udropship_vendor_registration;

DROP TABLE IF EXISTS udropship_label_batch;
DROP TABLE IF EXISTS udropship_label_shipment;
DROP TABLE IF EXISTS udropship_vendor_shipping;
DROP TABLE IF EXISTS udropship_vendor_product;
DROP TABLE IF EXISTS udropship_vendor_statement;
DROP TABLE IF EXISTS udropship_vendor;
DROP TABLE IF EXISTS udropship_shipping_method;
DROP TABLE IF EXISTS udropship_shipping_website;
DROP TABLE IF EXISTS udropship_shipping;
&lt;/pre&gt;
&lt;p&gt;&lt;strong&gt;6. Delete reference to extension's DB resources:&lt;/strong&gt;&lt;/p&gt;
&lt;pre&gt;DELETE FROM core_resource WHERE code in ('udropship_setup', 'umicrosite_setup',
'udmulti_setup', 'udsplit_setup', 'udmrate_setup', 'udlocator_setup');&lt;/pre&gt;
&lt;p&gt;&lt;strong&gt;7. Refresh Magento cache, log out and re-login to admin&lt;/strong&gt;&lt;/p&gt;</description><link>http://unirgy.com/support/portal/kb/article/8</link><pubDate>Fri, 28 Jan 2011 23:52:08 GMT</pubDate><guid isPermaLink="false">36a16ee87bf2b88c5104327bd47f628a</guid></item><item><title>How to uninstall uRapidFlow/Pro ?</title><description>Before disabling or uninstalling extensions, disable Magento Configuration cache during the procedure, to avoid intermittent issues with the site.

To disable uRapidFlow, edit `app/etc/modules/Unirgy_RapidFlow.xml` and `Unirgy_RapidFlowPro.xml`, and change `&lt;active&gt;true&lt;/active&gt;` to `&lt;active&gt;false&lt;/active&gt;`.

To fully uninstall uRapidFlow, delete the following files and folders:

* `app/etc/modules/Unirgy_RapidFlow.xml`
* `app/etc/modules/Unirgy_RapidFlowPro.xml`
* `app/code/community/Unirgy/RapidFlow/`
* `app/code/community/Unirgy/RapidFlowPro/`
* `app/design/adminhtml/default/default/layout/urapidflow.xml`
* `app/design/adminhtml/default/default/template/urapidflow/`
* `app/locale/en_US/Unirgy__RapidFlow.csv`
* `skin/adminhtml/default/default/urapidflow.js`
* `skin/adminhtml/default/default/urapidflow.css`

Then drop DB table `urapidflow_profiles`</description><link>http://unirgy.com/support/portal/kb/article/20</link><pubDate>Fri, 21 Jan 2011 17:53:23 GMT</pubDate><guid isPermaLink="false">1ee48fb029406398fa76b06ad9df9133</guid></item><item><title>How to add Dropship Vendor attribute to layered navigation?</title><description>&lt;p&gt;The 'udropship_vendor' attribute has a custom frontend_input type 'udropship_vendor', to allow having thousands of vendors without crashing.
&lt;/p&gt;
&lt;p&gt;Magento allows adding to layered navigation only for specific frontend_input types, which does not include the custom ones.&lt;/p&gt;

&lt;p&gt;To allow adding udropship_vendor attribute to layered navigation filtering, and you don't need to have ability to setup thousands of vendors, run this SQL statement (Magento CE &gt;1.4.1.0):&lt;/p&gt;

&lt;pre&gt;UPDATE eav_attribute SET frontend_input='select' WHERE attribute_code='udropship_vendor';&lt;/pre&gt;

Then edit the udropship_vendor attribute and add it to layered navigation.</description><link>http://unirgy.com/support/portal/kb/article/19</link><pubDate>Sun, 16 Jan 2011 06:53:41 GMT</pubDate><guid isPermaLink="false">89536400fd9acb65ff9f88db30ff08ec</guid></item><item><title>How to send vendor notifications manually on demand</title><description>&lt;p&gt;First you will need to create a custom order status, that will not be a part of standard Magento sales order workflow, and enable it in order state "processing".

&lt;p&gt;Edit &lt;b&gt;app/etc/local.xml&lt;/b&gt; and add right before the last &lt;code&gt;&amp;lt;/config&amp;gt;&lt;/code&gt;:
&lt;xmp&gt;
&lt;!-- ADD: --&gt;
    &lt;global&gt;
        &lt;sales&gt;
            &lt;order&gt;
                &lt;statuses&gt;
                    &lt;ready_to_ship&gt;
                        &lt;label&gt;Ready To Ship&lt;/label&gt;
                    &lt;/ready_to_ship&gt;
                &lt;/statuses&gt;
                &lt;states&gt;
                    &lt;processing&gt;
                        &lt;statuses&gt;
                            &lt;ready_to_ship/&gt;
                        &lt;/statuses&gt;
                    &lt;/processing&gt;
&lt;!-- You can also add this status to "pending" state --&gt;
                    &lt;pending&gt;
                        &lt;statuses&gt;
                            &lt;ready_to_ship/&gt;
                        &lt;/statuses&gt;
                    &lt;/pending&gt;
                &lt;/states&gt;
            &lt;/order&gt;
        &lt;/sales&gt;
    &lt;/global&gt;
&lt;!-- RIGHT BEFORE: --&gt;
&lt;/config&gt;
&lt;/xmp&gt;

&lt;p&gt;If you have Magento cache enabled, refresh it.

&lt;p&gt;Next, configure uDropship to use this new custom order status to send the notifications to vendors.

&lt;p&gt;Go to &lt;b&gt;System &gt; Configuration &gt; Drop Shipping &gt; Vendor Options.&lt;/b&gt;
Find &lt;b&gt;Make Available to Dropship on Order Status(es)&lt;/b&gt; multiselect, and choose only &lt;b&gt;Ready To Ship&lt;/b&gt; status.

&lt;p&gt;Now, when a new order comes in, to notify and make it available for vendors, you will need to change the order status manually to &lt;b&gt;Ready To Ship&lt;/b&gt;.</description><link>http://unirgy.com/support/portal/kb/article/18</link><pubDate>Fri, 03 Sep 2010 18:33:29 GMT</pubDate><guid isPermaLink="false">7e576b0ef1cc8c280db5a1318b04bba2</guid></item><item><title>How to make uDropship work with Fontis AustraliaPost shipping method?</title><description>&lt;p&gt;Edit &lt;strong&gt;app/code/community/Fontis/Australia/Shipping/Carrier/Australiapost.php&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;Replace getAllowedMethods() method (last) with:&lt;/p&gt;

&lt;pre&gt;
    public function getAllowedMethods()
    {
        return array(
            'STANDARD' =&gt; 'Standard',
            'EXPRESS' =&gt; 'Express',
            'AIR' =&gt; 'Air Mail',
            'SEA' =&gt; 'Sea Mail',
            'EPI' =&gt; 'Express Post International',
            'EPI-EC' =&gt; 'Express Post International with Extra Cover',
        );
    }
&lt;/pre&gt;</description><link>http://unirgy.com/support/portal/kb/article/17</link><pubDate>Thu, 06 May 2010 01:28:57 GMT</pubDate><guid isPermaLink="false">e5bbcb269538eca892e75ed2e43688c1</guid></item><item><title>In category view, products do not show images and are out of stock</title><description>For Magento 1.3.x run this query: &#xD;
&lt;pre&gt;&#xD;
UPDATE eav_attribute SET used_in_product_listing=1 &#xD;
WHERE entity_type_id IN (&#xD;
  SELECT entity_type_id FROM eav_entity_type &#xD;
  WHERE entity_type_code='catalog_product'&#xD;
) AND attribute_code IN (&#xD;
  'name', 'description', 'short_description', &#xD;
  'price', 'special_price', 'special_from_date', 'special_to_date', &#xD;
  'image', 'small_image', 'thumbnail', &#xD;
  'status', 'tax_class_id', 'url_key', 'required_options', &#xD;
  'price_type', 'weight_type', 'price_view', 'shipment_type', &#xD;
  'image_label', 'small_image_label', 'thumbnail_label'&#xD;
); &#xD;
&lt;/pre&gt;&#xD;
&#xD;
For Magento 1.4.x run this query: &#xD;
&lt;pre&gt;&#xD;
UPDATE catalog_eav_attribute SET used_in_product_listing=1 &#xD;
WHERE attribute_id IN (&#xD;
  SELECT attribute_id FROM eav_attribute &#xD;
  INNER JOIN eav_entity_type USING(entity_type_id) &#xD;
  WHERE entity_type_code='catalog_product' AND attribute_code IN (&#xD;
    'name', 'description', 'short_description', &#xD;
    'price', 'special_price', 'special_from_date', 'special_to_date', &#xD;
    'image', 'small_image', 'thumbnail', &#xD;
    'status', 'tax_class_id', 'url_key', 'required_options', &#xD;
    'price_type', 'weight_type', 'price_view', 'shipment_type', &#xD;
    'image_label', 'small_image_label', 'thumbnail_label'&#xD;
  )&#xD;
); &#xD;
&lt;/pre&gt;&#xD;
&#xD;
Refresh Magento cache.</description><link>http://unirgy.com/support/portal/kb/article/16</link><pubDate>Tue, 02 Mar 2010 07:26:01 GMT</pubDate><guid isPermaLink="false">833023209163efc79febac9476ddd101</guid></item><item><title>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.cost' in 'field  list'</title><description>If you get this error during product save, that means the Magento flat catalog is not updated.  
  
The issue is fixed by running:  
System &gt; Cache Management &gt; Catalog &gt; Rebuild Flat Catalog Product</description><link>http://unirgy.com/support/portal/kb/article/14</link><pubDate>Fri, 05 Feb 2010 10:40:11 GMT</pubDate><guid isPermaLink="false">67ad2a2b85c1264fd45d92a04c735ed9</guid></item><item><title>My vendors do not receive new order notifications and don't see new orders in their interface</title><description>Most common causes for that:  
  
1. Orders not reaching the status configured in System &gt; Configuration &gt; Drop Shipping &gt; Vendor Options &gt; Make Available to Dropship on Order Status(es).  
  
For example, you're testing with Check/MO payment method, which leaves order in status "Pending", with default configuration of making orders available to dropshippers on "Processing". In this particular case, creating an invoice for the order would bring it to "Processing" and fire up vendor notifications.  
  
You'll need to figure out on what stage you want your vendors to receive the notifications, and update the configuration accordingly.  
  
2. Orders were made not using Dropship or Dropship Split shipping methods.  
  
If the regular Magento shipping methods are enabled (flat rate, UPS, FedEx, etc), and customer used them to complete the order, the order will not be processed sing Dropship logic, and the notifications will not be sent to vendors.</description><link>http://unirgy.com/support/portal/kb/article/4</link><pubDate>Wed, 03 Feb 2010 09:56:34 GMT</pubDate><guid isPermaLink="false">2385eee2941776e7cb821fa0dd6f5f60</guid></item><item><title>Does uDropShip support buyers paying sellers directly?</title><description>The uDropship does not provide this functionality.   
  
I believe there's a good reason why most or likely no software out-of-the-box supports multiple real-time charges for the same order.  
I'll attempt to describe the complications of direct payment from buyer to seller.  
  
The ordering process relies on authorization/capturing of the funds before accepting the order on frontend.   
  
If the transaction succeeds, the customer sees 1 payment on the credit card statement. The store owner has now full control over payout to the vendors and withholding commissions, transaction fees or adjustments for negative customer experience when it is a vendor's fault.  
  
If the transaction fails, the order does not go through, the credit card statement does not contain any charge, the customer gets error notification and gets a chance to re-enter payment information.  
  
That is, when there's only 1 authorization/charge for the order, the whole payment goes to online store, and later distributed to the suppliers.  
  
Let's see how it will work if you want to charge for each vendor separately during the checkout.  
  
If all the transactions succeed, the customer sees a number of payments on the credit card statement for each supplier. There are few issues with that:  
  
a) Absolute majority of my clients didn't want the customers to have multiple charges on CC statement for the same order.  
b) If the vendor for some reason is unable to fulfill the ordered products (either not in stock, or order request was misplaced), and you want to transfer the fulfillment request to another vendor, you will have to request a refund from the vendor or chargeback the vendor payment. Both options are troublesome.  
c) Online store owner will have to charge the vendors for commissions, transaction fees separately, hoping that the charges will go through.  
  
If the customer's credit card is maxed out after first (few) charges, and some charges are declined, there a situation: the customer was charged partial amount, but the order didn't go through.   
  
Now you have to choose:  
1. a) If you're authorizing only, cancel the authorizations. Not all payment APIs allow cancelling authorizations, relying on expiration of few days.   
b) If you're charging automatically, refund the successful charges and not let the order through. The refunds can take time as well, depending on payment API.  
While the authorization cancellation or refund processing takes its time, the customer funds are locked and he won't be able to use them for this or other transactions. This situation is highly unfavorable.  
  
2. Let the order through and mark only the paid items as ready for fulfillment, and notify only paid vendors about the order. This option requires:  
a) accounts receivables management  
b) partial stock inventory locking for the failed part of the order  
c) manual or automatic handling of partial order cancellation in case the remaining payment wasn't made.  
  
There are more implications, but the ones above should show that multiple order payments will introduce a substantial overhead of handling the orders, on top of Magento customization complications.</description><link>http://unirgy.com/support/portal/kb/article/13</link><pubDate>Fri, 29 Jan 2010 20:56:21 GMT</pubDate><guid isPermaLink="false">cf925df9277d3cfb6804773e25e5245f</guid></item><item><title>Is your dropshipping extension editable? Is it open sourced or closed?</title><description>The extension contains 1 small ionCube encoded file, which contains an essential functionality, which usually does not need customization.  
  
In case the customization is still needed, I'm able to provide information about method parameters/returns and available event hooks upon request.  
  
All other code, configuration, phtml templates, email templates are open for your customization and editing.</description><link>http://unirgy.com/support/portal/kb/article/12</link><pubDate>Fri, 15 Jan 2010 03:03:48 GMT</pubDate><guid isPermaLink="false">96e803ced69c7ca5374eb2903e2db4ce</guid></item><item><title>Installation of extension through MagentoConnect fails</title><description>If you get the following or similar error message:  
  
Failed to download magento-community/Unirgy_Giftcert within preferred state "stable", latest release is version 0.9.4, stability "beta", use "channel://connect.magentocommerce.com/community/Unirgy_Giftcert-0.9.4" to install  
Cannot initialize 'channel://connect.magentocommerce.com/community/Unirgy_Giftcert', invalid or missing package file  
Install Errors  
Package "channel://connect.magentocommerce.com/community/Unirgy_Giftcert" is not valid  
PEAR ERROR: install failed  
  
Add "-beta" suffix to the extension key for install, like this:  
  
magento-community/Unirgy_Giftcert-beta</description><link>http://unirgy.com/support/portal/kb/article/10</link><pubDate>Tue, 22 Dec 2009 02:49:51 GMT</pubDate><guid isPermaLink="false">6312c301d057ccf0e838e87e25eb9fdd</guid></item><item><title>What is the correct sequence of uDropship extension installation?</title><description>1. Upload the license file to Magento root.  
  
2. Unpack and upload archives downloaded from provided links to Magento root.  
  
3. If Magento Cache is enabled, refresh it.  
  
4. If Flat Product Catalog enabled, refresh it.  
  
5. Log out from Magento admin and re-login.</description><link>http://unirgy.com/support/portal/kb/article/9</link><pubDate>Tue, 22 Dec 2009 01:52:58 GMT</pubDate><guid isPermaLink="false">5857515194fd36cb566cd8708f2758ba</guid></item><item><title>Vendors do not receive notifications and do not see the orders in vendor interface.</title><description>There are few configuration issues to check:&#xD;
&#xD;
&lt;ul class="disc"&gt;&#xD;
&lt;li&gt;&lt;strong&gt;Shipping carriers other than "Drop Shipping" are enabled.&lt;/strong&gt;&#xD;
&#xD;
&lt;p&gt;When customer make an order with a regular Magento system shipping carrier directly (i.e. UPS, USPS, FedEx, FlatRate, FreeShipping, etc.), the order does not pass through dropship logic, and no related records are generated in database. Make sure that only "Drop Shipping" (or "Drop Shipping (Split), if you have this add-on installed") carrier is enabled.&lt;/p&gt;&#xD;
&lt;/li&gt;&#xD;
&lt;li&gt;&lt;strong&gt;The order did not reach one of a configured statuses to become available for dropship vendor.&lt;/strong&gt;&#xD;
&#xD;
&lt;p&gt;There's a configuration that allows store owner to decide at which stage the orders are automatically available to dropship vendors.&lt;/p&gt;&#xD;
&#xD;
&lt;p&gt;Admin &gt; System &gt; Configuration &gt; Drop Shipping &gt; Vendor Options &gt; Make Available to Dropship on Order Status(es)&lt;/p&gt;&#xD;
&#xD;
&lt;p&gt;The notifications will be sent to vendors and be available in the vendor interface only when the orders will reach one of selected statuses. The notifications will be sent only once per order.&lt;/p&gt;&#xD;
&#xD;
&lt;p&gt;&lt;strong&gt;Example:&lt;/strong&gt; the store is configured to use an offline payment method (Check/MO) and when the order comes in, it has "Pending" status, until an invoice is generated and order becomes "Processing" or "Complete". By default dropship is configured to become available to vendors on order status "Processing" only, and will trigger only when the invoice is generated. If you'd like the order to become available to dropship right away, you'll need to add "Pending" status in the configuration.&lt;/p&gt;&#xD;
&lt;/li&gt;&#xD;
&lt;/ul&gt;</description><link>http://unirgy.com/support/portal/kb/article/6</link><pubDate>Sat, 05 Dec 2009 22:43:07 GMT</pubDate><guid isPermaLink="false">ef5d0b55eaa12439019faa6efa939b97</guid></item><item><title>The labels are not attached to vendor notification emails</title><description>Check the following configurations:&#xD;
&lt;ul&gt;&#xD;
&lt;li&gt;Global configuration:&lt;ul&gt;&#xD;
&lt;li&gt;&lt;strong&gt;System &amp;rarr; Configuration &amp;rarr; Drop Shipping &amp;rarr; Vendor Options &amp;rarr; Attach Shipping Label to Vendor Notification&lt;/strong&gt; = Yes&lt;/li&gt;&#xD;
&lt;li&gt;&#xD;
&lt;/ul&gt;&lt;/li&gt;&#xD;
&lt;li&gt;Vendor configuration (if the problem is vendor specific):&lt;ul&gt;&#xD;
&lt;li&gt;&lt;strong&gt;Vendor Information &amp;rarr; Used Carrier&lt;/strong&gt; - should be one of Fedex, UPS, USPS&lt;/li&gt;&#xD;
&lt;li&gt;&lt;strong&gt;Preferences &amp;rarr; Integration &amp;rarr; Attach Shipping Label to Notifications&lt;/strong&gt; = Yes&lt;/li&gt;&#xD;
&lt;li&gt;&lt;strong&gt;Preferences &amp;rarr; Shipping Labels &amp;rarr; Label Type&lt;/strong&gt; - should be one of PDF, EPL&lt;/li&gt;&#xD;
&lt;/ul&gt;&lt;/li&gt;&#xD;
&lt;/ul&gt;</description><link>http://unirgy.com/support/portal/kb/article/5</link><pubDate>Thu, 12 Nov 2009 14:27:04 GMT</pubDate><guid isPermaLink="false">6a680045bcf610ce480e06eab11b91d4</guid></item><item><title>When using pear from shell php not found</title><description>When trying to run ./pear you get this or similar error message:
&lt;pre class="brush: bash;"&gt;
$ ./pear mage-setup
Running initial setup...
exec: 94: php: not found
&lt;/pre&gt;
The issue is that each *NIX setup can have PHP executable located in different place, and you will need to edit ./pear file to accomodate this.

Just replace:
&lt;pre class="brush: bash;"&gt;
MAGE_PEAR_PHP_BIN="/usr/local/bin/php"
&lt;/pre&gt;

With your location of PHP CLI executable and you should be good to go.

Another thing to watch is that your PHP CLI should have the same configuration and php extensions as PHP used in webservice, to avoid issues with PEAR package php extension dependencies.</description><link>http://unirgy.com/support/portal/kb/article/2</link><pubDate>Sat, 20 Jun 2009 09:20:06 GMT</pubDate><guid isPermaLink="false">fc8ab4479f5f805b33bc42b39653f5c9</guid></item></channel></rss>
