Updating Shipping Rates - Revision history

Russ horton at 21:52, 3 June 2015

2015-06-03T21:52:54Z

← Older revision		Revision as of 21:52, 3 June 2015
Line 1:		Line 1:
	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. The files referenced here must be obtained from Dev or can be pulled from the %temp% directory (e.g. C:\Users\RUSSHO~1\AppData\Local\Temp\{8C2B21D6-A9F2-4AD9-89A0-162571D179E8}) ~~after an install has started~~.		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. The files referenced here must be obtained from Dev or can be pulled from the %temp% directory (e.g. C:\Users\RUSSHO~1\AppData\Local\Temp\{8C2B21D6-A9F2-4AD9-89A0-162571D179E8}) while you are at the database update screen (where you select the db's to update).

	<source lang="tsql">		<source lang="tsql">

Russ horton at 21:49, 3 June 2015

2015-06-03T21:49:18Z

← Older revision		Revision as of 21:49, 3 June 2015
Line 1:		Line 1:
	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. The files referenced here must be obtained from Dev or can be pulled from the %temp% directory (e.g. C:\Users\RUSSHO~1\AppData\Local\Temp\{8C2B21D6-A9F2-4AD9-89A0-162571D179E8})		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. The files referenced here must be obtained from Dev or can be pulled from the %temp% directory (e.g. C:\Users\RUSSHO~1\AppData\Local\Temp\{8C2B21D6-A9F2-4AD9-89A0-162571D179E8}) after an install has started.

	<source lang="tsql">		<source lang="tsql">

Russ horton at 21:49, 3 June 2015

2015-06-03T21:49:02Z

← Older revision		Revision as of 21:49, 3 June 2015
Line 1:		Line 1:
	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.		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. The files referenced here must be obtained from Dev or can be pulled from the %temp% directory (e.g. C:\Users\RUSSHO~1\AppData\Local\Temp\{8C2B21D6-A9F2-4AD9-89A0-162571D179E8})

	<source lang="tsql">		<source lang="tsql">

Russ horton at 21:11, 3 June 2015

2015-06-03T21:11:47Z

← Older revision		Revision as of 21:11, 3 June 2015
Line 8:		Line 8:
	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.		WARNING: 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.		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.

Russ horton at 21:11, 3 June 2015

2015-06-03T21:11:30Z

← Older revision		Revision as of 21:11, 3 June 2015
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.

Russ horton: 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. <…'

2015-06-03T21:09:06Z

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. <…'

New page

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.

<source lang="tsql">
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
</source>