Updating Shipping Rates

From NewHaven Software Wiki
Revision as of 21:09, 3 June 2015 by 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. <…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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