Here is a sample of the OSS Consulting services we provide:

  • Open Source Technology Strategy
  • Open Source Application Development
  • Custom Open Source Programming and Integration
  • Open Source Web Performance
  • Open Source Web site Security Analysis
  • Integration with Windows and Open Source Systems
  • Open Source Mail systems Setup/Integration
Home  |  Blog  

Neptune Web Blog

Solving Magento Unirgy Drop Ship USPS Flat Rate Shipping Problem

Friday, December 10th, 2010

Assuming you are running Magento 1.8 Enterprise, you may have noticed that certain shipping methods never appear in the checkout. These include USPS Flat Rate methods, but could include any method with a long name.

The problem is that Magento's Unirgy Drop Ship module will not display shipping methods with method codes greater than 30 characters.

(Around) line 72 of app/code/community/Unirgy/DropshipSplit/Model/Carrier.php (A similar problem occurs in non-Split module code) the carriers and methods within Drop Ship are validated against the vendors shipping methods. e.g.

foreach ($vRates as $rate) {
                    if (empty($systemMethods
[$rate->getCarrier()][$rate->getMethod()])) { continue; 
/* shipping method is skipped */
The method, being truncated at 30 characters, will fail on this test and the shipping method will not appear.
mysql> desc udropship_shipping_method;
+--------------+------------------+------+-----+---------+
| Field        | Type             | Null | Key | Default |
+--------------+------------------+------+-----+---------+
| shipping_id  | int(10) unsigned | NO   | MUL | NULL    |
| carrier_code | varchar(30)      | NO   |     | NULL    |
| method_code  | varchar(30)      | NO   |     | NULL    |
+--------------+------------------+------+-----+---------+

As you can see from the data, below, the full name of the shipping method is "Priority Mail Small Flat Rate Box". It is being cut off at 30 characters. The same thing happens with medium and large boxes.

Missing "Box"

To resolve, simply give more space in the column and update the records. E.g.

# give more space to column
mysql> alter table udropship_shipping_method
 modify method_code varchar(100) default null;
# update truncated shipping methods. 
#This may also occur with Medium and Large boxes. 
mysql> update udropship_shipping_method set method_code = 
'Priority Mail Small Flat Rate Box' where method_code =
 'Priority Mail Small Flat Rate ';

This one was so blatant, but took a long time to dig out, so I had to share it. Send me a comment (below) if this article helped.

If there is anything Neptune Web can help you with regarding Drop Shipping and Magento, give us a call.

Add a Comment:

(required, but never shown publicly)

Security:


Comments


No comments have been added.