Project Detail

Description

running joomla 1.0.15, virtuemart 1.13

we need this version of the UPS module installed
UPS Shipping Module, version 2.0.2009.01.01
debug and make it work
==========================

UPS Shipping Module, version 2.0.2009.01.01
Reggie Campbell

(secondary email )

If you find this module useful, please consider a donation! Paypal email . Thank you!


Requirements
--------------
-Joomla! 1.5 or higher
-VirtueMart 1.1.x
-PHP 5.0 or higher
-Patience for the author's uncanny ability to re-introduce bugs he has already fixed =)

Tested on Joomla 1.5.x with VirtueMart 1.1.x and PHP version 5.x
PLEASE TEST THIS MODULE IN A SANDBOX ENVIRONMENT BEFORE USING ON A LIVE SERVER


Features
--------------
-allows for bundled and unbundled shipments. Products designated as shipping seperately will have their postage rates queried seperately.
-reworked UPS XML response parser to allow shipments larger than 70lbs
-split package type into domestic and international types
-added support for customized shipping price discounts by product
-added support for shipping with insurance by product
-added support to skip handling charges on free-shipping packages
-added option for allowing only a certain number of a product in each package (bundled and unbundled)
-added option for showing a "free shipping" image on product flypage
-added option to restrict free shipping to basic ground services
-added option to restrict shipping items to certain locations
-added option to have free shipping on orders over a certain amount
-added option to skip Pickup Type declaration (workaround for UPS Error Code: 111370, Error Description: Unsupported Pickup Type)


Known Bugs
--------------
None


Installation
---------------
If you currently have version upsv2.2008.12.22 installed, simply extract and replace the files:
joomla\administrator\components\com_virtuemart\classes\shipping\upsv2.ini
joomla\administrator\components\com_virtuemart\classes\shipping\upsv2.php

If you have an older version, or this is your first upsv2 install, do the following:
BACK UP YOUR EXISTING INSTALLATION!
Then, extract/copy the appropriate file as such:

joomla\administrator\components\com_virtuemart\header.php
joomla\administrator\components\com_virtuemart\toolbar.virtuemart.php

joomla\administrator\components\com_virtuemart\classes\ps_checkout.php
joomla\administrator\components\com_virtuemart\classes\ps_config.php
joomla\administrator\components\com_virtuemart\classes\ps_country.php
joomla\administrator\components\com_virtuemart\classes\ps_html.php
joomla\administrator\components\com_virtuemart\classes\ps_order.php
joomla\administrator\components\com_virtuemart\classes\ps_product.php
joomla\administrator\components\com_virtuemart\classes\ps_restriction.php
joomla\administrator\components\com_virtuemart\classes\ps_shipping.php

joomla\administrator\components\com_virtuemart\classes\shipping\class.Package.php
joomla\administrator\components\com_virtuemart\classes\shipping\class.Shipment.php
joomla\administrator\components\com_virtuemart\classes\shipping\upsv2.ini <--- THIS WILL OVERWRITE YOUR EXISTING SETTINGS
joomla\administrator\components\com_virtuemart\classes\shipping\upsv2.cfg.php
joomla\administrator\components\com_virtuemart\classes\shipping\upsv2.php

joomla\administrator\components\com_virtuemart\html\admin.show_cfg.php
joomla\administrator\components\com_virtuemart\html\checkout.index.php
joomla\administrator\components\com_virtuemart\html\product.product_display.php
joomla\administrator\components\com_virtuemart\html\product.product_form.php
joomla\administrator\components\com_virtuemart\html\shipping.restriction_form.php
joomla\administrator\components\com_virtuemart\html\shipping.restriction_list.php
joomla\administrator\components\com_virtuemart\html\shop.product_details.php

joomla\administrator\components\com_virtuemart\languages\admin\english.php
joomla\administrator\components\com_virtuemart\languages\common\english.php
joomla\administrator\components\com_virtuemart\languages\product\english.php
joomla\administrator\components\com_virtuemart\languages\shipping\english.php

joomla\components\com_virtuemart\shop_image\shipping\free_shipping.png
joomla\components\com_virtuemart\shop_image\shipping\free_shipping_basic_only.png
joomla\components\com_virtuemart\shop_image\shipping\index.html

joomla\components\com_virtuemart\themes\default\images\administration\dashboard\no_shipping.png
joomla\components\com_virtuemart\themes\default\templates\checkout\restricted_items_found.php
joomla\components\com_virtuemart\themes\default\templates\product_details\flypage.tpl.php


Then, make the following database changes:

add a new field called 'ship_alone' to the 'jos_vm_product' table. See upsv2.sql for SQL query.
Field: ship_alone
Type: CHAR
Length/Values: 1
Collation: utf8_general_ci
Attributes:
NUll: not null
Default: N

add a new field called 'ship_modifier' to the 'jos_vm_product' table. See upsv2.sql for SQL query.
Field: ship_modifier
Type: VARCHAR
Length/Values: 255
Collation: utf8_general_ci
Attributes:
NUll: not null
Default: 100%

add a new field called 'ship_insured' to the 'jos_vm_product' table. See upsv2.sql for SQL query.
Field: ship_alone
Type: CHAR
Length/Values: 1
Collation: utf8_general_ci
Attributes:
NUll: not null
Default: N

add a new field called 'max_per_package' to the 'jos_vm_product' table. See upsv2.sql for SQL query.
Field: max_per_package
Type: CHAR
Length/Values: 255
Collation: utf8_general_ci
Attributes:
NUll: not null
Default: 9999

add a new table called 'jos_vm_order_shipment'. See upsv2.sql for SQL query.

add a new field called 'order_id' to the 'jos_vm_order_shipment' table. See upsv2.sql for SQL query.
Field: order_id
Type: INT

add a new field called 'order_shipment_obj' to the 'jos_vm_order_shipment' table. See upsv2.sql for SQL query.
Field: order_shipment_obj
Type: MEDIUMBLOB

add a new table called 'jos_vm_shipping_restrictions'. See upsv2.sql for SQL query.
add a new table called 'jos_vm_shipping_restrictions_associations'. See upsv2.sql for SQL query.
add a new table called 'jos_vm_product_restrictions'. See upsv2.sql for SQL query.

Find the module ID for the shipping function in the 'jos_vm_module' table. For example: SELECT module_id FROM `jos_vm_module` WHERE module_name = 'shipping'
Insert four new function values into the 'jos_vm_function' table using the module ID. See upsv2.sql for details and query.
Module ID / Function Name / Module / Real function Name / Permissions
------------------------------------------------------------------------------------
(module ID),'restrictionDelete','ps_shipping','restriction_delete','admin,storeadmin'
(module ID),'restrictionAdd','ps_shipping','restriction_add','admin,storeadmin'
(module ID),'restrictionUpdate','ps_shipping','restriction_Update','admin,storeadmin'
(module ID),'restrictionAssociationDelete','ps_shipping','restriction_association_delete','admin,storeadmin'