FedEx Ship manager integration

[prestontmitch]

Although this isn't really a module, I wanted to let everyone know that you can use the database integration features of FedEx ship manager for insanely easy shipping with zencart.

You need an account with fedex, but its possible to configure the integration settings so that all you have to do is type in an order number, and you're printer will spit out a label. We use it to automatically create labels for multiple boxes within a single order as well.

If anyone has any questions, I'd be happy to help but please post here so others can see solutions.

Thanks!

[yl715]

can you explain what to do to get this running?

[propni]

Do you need to use the FedEx integrator with FedEx ship manager software? I just got my account with fedex and I am about to install ship manager and saw that option.

This is great news, it will make shipping soooo much easier!

[prestontmitch]

1. Download, install, and configure the correct ODBC connector for MySql for your operating system.
2. Download and install FedEx Ship Manager.
3. Run through the Integration Wizard after setting up your account number.
4. Use the "one label at a time" method.
3. You'll need to pull data from 3 tables:
zen_orders
zen_orders_products
zen_products
4. Map delivery addresses and the like from zen_orders
5. Map weight to the product weight field in zen_products by keying the zen_orders order id field to the matching zen_orders_products order id field, then map the zen_order_products product id field to the matching zen_products product id field.
6. If you ship each product individually like we do, map fedex number of packages to the quantity field in zen_orders_products.
7. The best way I've found for setting up the lookup field is to map it to the order number. When set up this way, typing in the order number will spit out a shipping label for each product in the order that has a valid shipping weight.


I don't have the time to write a full guide but this should give you an idea of how to do it. If you have any questions, please post and I'll reply when I have time.

Thanks,
Preston

[prestontmitch]

Any quesitons? I'd be happy to help.

[delia]

Are you talking about being able to use this where the cart is on a linux server? The function of the mentioned ODBC connector for MySql?

[prestontmitch]

Sorry I never saw your reply. If you have a mysql database on your server, you can use the ODBC driver from mysql to interface your local machine with your cart database.

[prestontmitch]

And no, you select the odbc driver for your local operating system and install it. Then you configure the settings to point to the mysql database on your website.

[ezlynx]

Okay, I'm going to see if I can figure out how to do this and help someone remotely set this up for her new cart. Unfortunately, I do not have the FedEx account and will not be able to see what they see. My friend has not worked with code at all. Any further tips or screen shots, especially to set up the connections to the various tables?

Also, on the mysql page http://dev.mysql.com/downloads/connector/odbc/5.1.html , I'm guessing for a 32 bit system (what she likely has) that the choice to download and run is this?:
Windows (x86, 32-bit), MSI Installer
Connector-ODBC

Is this file needed?
Windows (x86, 32-bit), ZIP Archive
Connector-ODBC

I'm guessing I need to provide her with the standard password/user/database connection info for her database.

You write:
"3. You'll need to pull data from 3 tables:
zen_orders
zen_orders_products
zen_products
4. Map delivery addresses and the like from zen_orders
5. Map weight to the product weight field in zen_products by keying the zen_orders order id field to the matching zen_orders_products order id field, then map the zen_order_products product id field to the matching zen_products product id field.
6. If you ship each product individually like we do, map fedex number of packages to the quantity field in zen_orders_products.
7. The best way I've found for setting up the lookup field is to map it to the order number. When set up this way, typing in the order number will spit out a shipping label for each product in the order that has a valid shipping weight."

This is the point where a screen shot and more advice for her would be invaluable.

[ezlynx]

I am guessing the three tables you refer to are "orders", "orders_products" and "products".

This is what they look like:

CREATE TABLE IF NOT EXISTS `orders` (
`orders_id` int(11) NOT NULL auto_increment,
`customers_id` int(11) NOT NULL default '0',
`customers_name` varchar(64) collate latin1_general_ci NOT NULL default '',
`customers_company` varchar(64) collate latin1_general_ci default NULL,
`customers_street_address` varchar(64) collate latin1_general_ci NOT NULL default '',
`customers_suburb` varchar(32) collate latin1_general_ci default NULL,
`customers_city` varchar(32) collate latin1_general_ci NOT NULL default '',
`customers_postcode` varchar(10) collate latin1_general_ci NOT NULL default '',
`customers_state` varchar(32) collate latin1_general_ci default NULL,
`customers_country` varchar(32) collate latin1_general_ci NOT NULL default '',
`customers_telephone` varchar(32) collate latin1_general_ci NOT NULL default '',
`customers_email_address` varchar(96) collate latin1_general_ci NOT NULL default '',
`customers_address_format_id` int(5) NOT NULL default '0',
`delivery_name` varchar(64) collate latin1_general_ci NOT NULL default '',
`delivery_company` varchar(64) collate latin1_general_ci default NULL,
`delivery_street_address` varchar(64) collate latin1_general_ci NOT NULL default '',
`delivery_suburb` varchar(32) collate latin1_general_ci default NULL,
`delivery_city` varchar(32) collate latin1_general_ci NOT NULL default '',
`delivery_postcode` varchar(10) collate latin1_general_ci NOT NULL default '',
`delivery_state` varchar(32) collate latin1_general_ci default NULL,
`delivery_country` varchar(32) collate latin1_general_ci NOT NULL default '',
`delivery_address_format_id` int(5) NOT NULL default '0',
`billing_name` varchar(64) collate latin1_general_ci NOT NULL default '',
`billing_company` varchar(64) collate latin1_general_ci default NULL,
`billing_street_address` varchar(64) collate latin1_general_ci NOT NULL default '',
`billing_suburb` varchar(32) collate latin1_general_ci default NULL,
`billing_city` varchar(32) collate latin1_general_ci NOT NULL default '',
`billing_postcode` varchar(10) collate latin1_general_ci NOT NULL default '',
`billing_state` varchar(32) collate latin1_general_ci default NULL,
`billing_country` varchar(32) collate latin1_general_ci NOT NULL default '',
`billing_address_format_id` int(5) NOT NULL default '0',
`payment_method` varchar(128) collate latin1_general_ci NOT NULL default '',
`payment_module_code` varchar(32) collate latin1_general_ci NOT NULL default '',
`shipping_method` varchar(128) collate latin1_general_ci NOT NULL default '',
`shipping_module_code` varchar(32) collate latin1_general_ci NOT NULL default '',
`coupon_code` varchar(32) collate latin1_general_ci NOT NULL default '',
`cc_type` varchar(20) collate latin1_general_ci default NULL,
`cc_owner` varchar(64) collate latin1_general_ci default NULL,
`cc_number` varchar(32) collate latin1_general_ci default NULL,
`cc_expires` varchar(4) collate latin1_general_ci default NULL,
`cc_cvv` blob,
`last_modified` datetime default NULL,
`date_purchased` datetime default NULL,
`orders_status` int(5) NOT NULL default '0',
`orders_date_finished` datetime default NULL,
`currency` char(3) collate latin1_general_ci default NULL,
`currency_value` decimal(14,6) default NULL,
`order_total` decimal(14,2) default NULL,
`order_tax` decimal(14,2) default NULL,
`paypal_ipn_id` int(11) NOT NULL default '0',
`ip_address` varchar(96) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`orders_id`),
KEY `idx_status_orders_cust_zen` (`orders_status`,`orders_id`,`customers_id`),
KEY `idx_date_purchased_zen` (`date_purchased`),
KEY `idx_cust_id_orders_id_zen` (`customers_id`,`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;


CREATE TABLE IF NOT EXISTS `orders_products` (
`orders_products_id` int(11) NOT NULL auto_increment,
`orders_id` int(11) NOT NULL default '0',
`products_id` int(11) NOT NULL default '0',
`products_model` varchar(32) collate latin1_general_ci default NULL,
`products_name` varchar(64) collate latin1_general_ci NOT NULL default '',
`products_price` decimal(15,4) NOT NULL default '0.0000',
`final_price` decimal(15,4) NOT NULL default '0.0000',
`products_tax` decimal(7,4) NOT NULL default '0.0000',
`products_quantity` float NOT NULL default '0',
`onetime_charges` decimal(15,4) NOT NULL default '0.0000',
`products_priced_by_attribute` tinyint(1) NOT NULL default '0',
`product_is_free` tinyint(1) NOT NULL default '0',
`products_discount_type` tinyint(1) NOT NULL default '0',
`products_discount_type_from` tinyint(1) NOT NULL default '0',
`products_prid` tinytext collate latin1_general_ci NOT NULL,
PRIMARY KEY (`orders_products_id`),
KEY `idx_orders_id_prod_id_zen` (`orders_id`,`products_id`),
KEY `idx_prod_id_orders_id_zen` (`products_id`,`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;


CREATE TABLE IF NOT EXISTS `products` (
`products_id` int(11) NOT NULL auto_increment,
`products_type` int(11) NOT NULL default '1',
`products_quantity` float NOT NULL default '0',
`products_model` varchar(32) collate latin1_general_ci default NULL,
`products_image` varchar(64) collate latin1_general_ci default NULL,
`products_price` decimal(15,4) NOT NULL default '0.0000',
`products_virtual` tinyint(1) NOT NULL default '0',
`products_date_added` datetime NOT NULL default '0001-01-01 00:00:00',
`products_last_modified` datetime default NULL,
`products_date_available` datetime default NULL,
`products_weight` float NOT NULL default '0',
`products_status` tinyint(1) NOT NULL default '0',
`products_tax_class_id` int(11) NOT NULL default '0',
`manufacturers_id` int(11) default NULL,
`products_ordered` float NOT NULL default '0',
`products_quantity_order_min` float NOT NULL default '1',
`products_quantity_order_units` float NOT NULL default '1',
`products_priced_by_attribute` tinyint(1) NOT NULL default '0',
`product_is_free` tinyint(1) NOT NULL default '0',
`product_is_call` tinyint(1) NOT NULL default '0',
`products_quantity_mixed` tinyint(1) NOT NULL default '0',
`product_is_always_free_shipping` tinyint(1) NOT NULL default '0',
`products_qty_box_status` tinyint(1) NOT NULL default '1',
`products_quantity_order_max` float NOT NULL default '0',
`products_sort_order` int(11) NOT NULL default '0',
`products_discount_type` tinyint(1) NOT NULL default '0',
`products_discount_type_from` tinyint(1) NOT NULL default '0',
`products_price_sorter` decimal(15,4) NOT NULL default '0.0000',
`master_categories_id` int(11) NOT NULL default '0',
`products_mixed_discount_quantity` tinyint(1) NOT NULL default '1',
`metatags_title_status` tinyint(1) NOT NULL default '0',
`metatags_products_name_status` tinyint(1) NOT NULL default '0',
`metatags_model_status` tinyint(1) NOT NULL default '0',
`metatags_price_status` tinyint(1) NOT NULL default '0',
`metatags_title_tagline_status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`products_id`),
KEY `idx_products_date_added_zen` (`products_date_added`),
KEY `idx_products_status_zen` (`products_status`),
KEY `idx_products_date_available_zen` (`products_date_available`),
KEY `idx_products_ordered_zen` (`products_ordered`),
KEY `idx_products_model_zen` (`products_model`),
KEY `idx_products_price_sorter_zen` (`products_price_sorter`),
KEY `idx_master_categories_id_zen` (`master_categories_id`),
KEY `idx_products_sort_order_zen` (`products_sort_order`),
KEY `idx_manufacturers_id_zen` (`manufacturers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

[/SCR]