We had the Premium Matrix Rates running and then we purchased Product Matrix Rates with volumetrics. We have installed the new extension over the top of the old one and several issues have occurred.
So far the shipping tab with the dimensions on has not appeared and there was some issues with the package_id attribute not being created so my colleague had to manually create this attribute for the checkout to work.
These fault both point to the database not getting upgraded correctely (I think). Is it possible for you to look in to the issue for me so we can apply the extension to our live site.
Solution
As Premium Matrix Rates was previously installed and Product Matrix Rates (with Volume support) was being added in its stead, the package_id attribute would not need to be created as it is an attribute created by the standard version.
- This article details the correct installation procedure and includes notes for upgrading at the bottom of the article: http://support.webshopapps.com/productmatrix/installing-extension-2/ (Option 1)
- If the SQL has not run successfully you will need the "Manually rewind core_resource" section of this article for upgrading: http://support.webshopapps.com/productmatrix/sql-failed-to-run-successfully/ (Option 2)
This should resolve the issue of the missing package_id attribute. You can manually create it but i would avoid that. If you do see the notes below.
Shipping Tab Still not appearing
The above deals with failed upgrades but if you are still having problems with the shipping tab not appearing it could be because of the extension not being configured correctly
Assumptions
- The upgrade was successful or repaired as above
- The attributes all exist in the database
I spoke with the developers and the fix/final step is easier.
- Assign the variables to the shipping group attribute set. The drag attributes thing.
- http://wiki.webshopapps.com/extensions/product-matrix/product-matrix-with-volume-support#TOC-Adding-Volume-Attribute-to-your-Attribute-Set
- My instructions
- Go to Catalog --> Manage Attribute Sets
- Edit default
- Now drag the ship_height, ship_weight and ship_depth Unassigned Attributes over to the shipping Group.
"the set_resource script (provided previously) needs to be used" when was this provided? I don't seem to have this.
- When you have assigned these attributes the shipping tab appears. So the extension has installed correctely.
The package_id has been set as a text-based attribute after manually creating it
The attribute will function as a text-based attribute, though this would cause discrepancies if there are any spelling mistakes.
If you choose to use the attribute as a text-based attribute, rather than drop-down you will need to select "Use text based shipping group" from system > configuration > shipping methods > Product Matrix > "Advanced Options"
To re-create the attribute as a drop-down you can delete the attribute then re-run the SQL using the set_resouce script, as per this article: http://support.webshopapps.com/productmatrix/sql-failed-to-run-successfully/
The Wiki steps omitted the specific attribute set name as this can vary by website though yes, the default attribute set would need to be edited.
For reference, the Wiki has been superseded by our Knowledgebase here: http://support.webshopapps.com/productmatrix/
Notes from webshopapps
The package_id attribute should have been created when the original version of Product Matrix was installed on the site. Without that attribute the shipping rates would not have been returned correctly with the older version of the extension.
The attributes are not created on installation when the SQL has not run correctly, which is often caused by the SQL running before all of the files have finished copying across correctly. To avoid this, the "etc" directory from the ZIP file should be copied last.
In the event that the SQL is not run correctly the set_resource script (provided previously) needs to be used. This will run the SQL installation steps accordingly.
My Way Forward Notes
When I intially had this issue this is what I decided to do.
After deciphering the answers this is what I have worked out and I hope it makes sense for a way forward of fixing the matrix rates
Option 2 that you ran worked and added the shipping tab, and I guess the height/depth/width attributes. The attributes are not automatically assigned, these have to be done manually so they appear in the shipping tab
What he did to fix the dev site one
- He manually assigned the ship_depth/ship_height/ship_width by following these instructions here……. (but it should say edit the ‘default’)
Issues with the dev site one
- The package_id, the attribute you created manually is a text box, and should be a dropdown in the global scope
What I propose with the Dev site
- Delete the package_id and recreate but selecting it as a dropdown in the global scope and its label name = “Shipping Group”
or - Uninstall the matrix rates, delete the attributes package_id/ship_depth/ship_height/ship_width and re-run the install procedure but copying in the etc folder last as per webshopapp instructions(see response below)……….. so the SQL is run last which should create all the attributes again
or - Perform ‘option 2’ again as you did last time but after deleting package_id/ship_depth/ship_height/ship_width
What I propose with the live site
- Run ‘option 2’ to remove any traces of the old matrix rates extension and then install the new version
or - Copy the new extension over except the /etc/ folder and put this in last so the SQL is correctely triggered. as per webshopapp instructions(see response below)
With all of these it will require manual actions by myself or you to install the attributes for the shipping tab.