taxes based on state?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
5 years ago
Hello-

I've just finished upgrading a site from 3.40 to 4.0 and realized that there is no longer a way to just have taxes applied to orders from a particular state. I've looked through the marketplace for a plugin and only see tax providers for integration with 3rd party tax services.

Is there really no plugin available for just applying a percentage to every order placed by customers from a particular state?

Thanks!
5 years ago
When you Configure - Manual (Fixed or By Country/State/Zip), be sure to click on the mode button in upper right (if it says "Fixed Rate", it will change to "By Country").   Also, be sure to set the default tax address on the Tax Setting page.
5 years ago
Thanks, but what I'm having trouble with is actually FINDING that plugin..
It's not included in nopCommerce 4.0 and the only thing like it in the Marketplace is $99 and only works on older versions:
https://www.nopcommerce.com/marketplace.aspx?category=11&version=37&searchterm=

Please point me in the right direction!

Okay..nevermind..
It must've been accidentally deleted from my 4.0 production site..I looked in the 4.0 dev site and it was there, so I'll just grab it from that installation.
5 years ago
Well...crud...
I copied that plugin (v 1.14) into my production site and I see it in the list now.
However, when I try to install it, I get a red error banner across the top of the page saying that there's already an object named 'TaxRate' in the database.....duh???

This database was upgraded from 3.40, so I'm sure there IS already a table by that name...why wouldn't this plugin take that into consideration?

Do I need to just delete that table from the database and try again?

Thanks-

Okay, so I just renamed that table and now it is letting me install...ignore me..

Log level  
Error
Short message  
There is already an object named 'TaxRate' in the database.
Full message  
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'TaxRate' in the database.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass59.<ExecuteStoreCommand>b__58()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass59.<ExecuteStoreCommand>b__57()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters)
   at System.Data.Entity.Internal.InternalContext.ExecuteSqlCommand(TransactionalBehavior transactionalBehavior, String sql, Object[] parameters)
   at System.Data.Entity.Database.ExecuteSqlCommand(TransactionalBehavior transactionalBehavior, String sql, Object[] parameters)
   at System.Data.Entity.Database.ExecuteSqlCommand(String sql, Object[] parameters)
   at Nop.Plugin.Tax.FixedOrByCountryStateZip.Data.CountryStateZipObjectContext.Install()
   at Nop.Plugin.Tax.FixedOrByCountryStateZip.FixedOrByCountryStateZipTaxProvider.Install()
   at Nop.Web.Areas.Admin.Controllers.PluginController.Install(IFormCollection form)
ClientConnectionId:83797f95-8dfe-4120-9b37-cce9d16fe845
Error Number:2714,State:6,Class:16
5 years ago
That tax plugin is standard / out-of-the-box,  so maybe you deleted the plugin folder when you set up your new site.
5 years ago
Yup..that's got to be what happened.
Thanks.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.