Updating Shipping Rates
From NewHaven Software Wiki
(Difference between revisions)
Russ horton (Talk | contribs) (Created page with 'It's possible to update the shipping rates in CMS without installing an update. This can be done with SQL inputs using the files that the installer uses. Statements are below. <…') |
Russ horton (Talk | contribs) |
||
| Line 7: | Line 7: | ||
DELETE FROM SHIPDEFAULTS; | DELETE FROM SHIPDEFAULTS; | ||
INPUT INTO SHIPDEFAULTS (shipdefaultsid,description,defaultvalue) FROM C:\TEMP\SHIPDEFAULTS.CSV | INPUT INTO SHIPDEFAULTS (shipdefaultsid,description,defaultvalue) FROM C:\TEMP\SHIPDEFAULTS.CSV | ||
| + | |||
| + | NOTE: The latter query will overwrite any rates manually set in CMS Setup so you should confirm the user has not explicitly set those rate overrides before running the SQL. | ||
</source> | </source> | ||
| + | |||
| + | Note that CMS updates may contain other related updates like new shipping methods, changes to existing shipping options, and/or shipping integration changes that would not be encompassed by these rate only inputs. | ||
Revision as of 21:11, 3 June 2015
It's possible to update the shipping rates in CMS without installing an update. This can be done with SQL inputs using the files that the installer uses. Statements are below.
DELETE FROM SHIPRATES; INPUT INTO SHIPRATES FROM C:\TEMP\SHIPRATES.DAT; DELETE FROM SHIPDEFAULTS; INPUT INTO SHIPDEFAULTS (shipdefaultsid,description,defaultvalue) FROM C:\TEMP\SHIPDEFAULTS.CSV NOTE: The latter query will overwrite any rates manually SET in CMS Setup so you should confirm the USER has not explicitly SET those rate overrides BEFORE running the SQL.
Note that CMS updates may contain other related updates like new shipping methods, changes to existing shipping options, and/or shipping integration changes that would not be encompassed by these rate only inputs.
