Shopify Custom Tax Calculation

We have pretty recently on-boarded a client. They have Shopify Plus and they have a situation regarding taxes that we need to help them with if we can. They are located within the United States.

They have a fairly unique taxation situation that hopefully we are looking to get help with. Within their product portfolio, they offer several different categories of products. One category of products is subject to a separate tax of 59.27% in their state. This 59.27% tax only needs to be calculated on the COST of producing the products within this category, not how much the product is being sold for. This means that no matter how much the product is being sold for, there still this extra tax that needs to be added to the cost of the products. At the same time, sales tax needs to be added to the retail price of the product, but both taxes need to be independently calculated from each other and cannot compound on one another. This 59.27% tax only needs to be calculated within their state.

Here is an example - one product costs $3 at retail price to the consumer on the online store. The cost to produce this product is 76 cents, so the 59.27% tax will cost 45 cents and needs to be charged at the time of purchase. There is still sales tax of approximately 7% on the $3 as well. Essentially, its 3.00*0.07 + 0.45 . Additionally, if the price if the product is discounted to another amount such as $2, there is still a $0.45 tax on it regardless, so now it would be 3.00*0.07 + 0.45. The governing body would like for this separate tax to be displayed as its own line item on invoices when the client is checking out. There would be approximately 40 products with about 210 variants that would would all require a different $ value that would need to be assigned to each product.

Here's what we think the deliverable would entail:

An admin page where the admin can set a special tax rate for each state. To start, it should only show California and a button to Add State

An admin page where the admin can select a product, then add a value for "Production Cost"

During checkout, if the customer has an account that is marked as "tax exempt", we do nothing and they can checkout normally

If the customer does not have an account or has an account that is not marked as "tax exempt" AND they have a Shipping Address in California (or any other state that has been set up with a tax rate), we calculate (state tax rate X production cost) and we add this amount to the total cost. The amount should appear on its own line above the total cost and be named "Sin Tax"

The Sin Tax line must appear during checkout and also on invoices

An admin page where the admin can run a report to show the total amount of tax collected for a particular time period (year to date, by month, total all time, date range), by State and for All States

Here's a simplified explanation of the calculation portion.

We need to multiply two numbers together and then save the result in a product meta field

We'd have one database table called "States" that would contain STATE_NAME and RATE (so, for example "California" and "3")

Then, we'd have another table called "Products" that would contain PRODUCT and COST (for example "Shoes" and "2")

Now, we multiply those two numbers and store the result in a product metafield (so, in this example, we'd end up with "Shoes" and "6")

Now what we need to do is add the $6 to the total cost for the product if the customer's shipping address is within California.

We need it to be an extra add-on fee that gets added to the total cost of the order, after taxes.

This amount does not get affected by any discounts or taxes.

I'm not sure if a solution for this could be coded using an app, or if it could be coded into Shopify using scripts since they are on Shopify Plus, but I would like to know if you could possibly see a way you could help us deliver a solution for our client.

Skills: Shopify, Accounting, Excel, PHP, HTML

About the Employer:
( 0 reviews ) Los Angeles, United States

Project ID: #21230086

31 freelancers are bidding on average $1143 for this job


Please accept my bid for your shopify tax calculation as i have been developing similar type of websites since 2002 and i can start working immediately after a short discussion. Skills: Wordpress, PHP, Drupal, MySQL, More

$1100 USD in 7 days
(246 Reviews)

Hello [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Hope you like these. Looking forward for your kind More

$2000 USD in 10 days
(928 Reviews)

Your requirements need to be more explicate so I would strongly recommend you to kindly interact further and share the details. ** SHOPIFY EXPERT on Shopify's official site: [login to view URL] More

$1800 USD in 12 days
(965 Reviews)

Hello, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 11+ years of experience and I'm here for you! M More

$750 USD in 7 days
(121 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$1125 USD in 7 days
(368 Reviews)

We're a Pvt. Ltd. company based in New Delhi, India with more than 5 years of experience on Shopify . I am a Shopify Partner developer and have designed several websites successfully. I’ve gone through the project de More

$1200 USD in 30 days
(260 Reviews)

Hello juanw35 !, We are a company of Developers and Designers born in 2014 in the city of Rosario, Argentina. We are agile and efficient, ranked # 1 in Argentina (SouthAmerica) ( For this reason, we usu More

$1560 USD in 15 days
(216 Reviews)

Hello, We have experience working with Shopify plus website & yes, can provide you a solution using Shopify app in a well-formatted way for a 'Shopify Custom Tax Calculation' based on mentioned workflow. Shopify Plus More

$1250 USD in 22 days
(70 Reviews)

HI there, I have gone through project details, AS per given details we need to research more on this, yes we have experience in shopify PLUS and shopify private/public app development. Thank you

$1075 USD in 12 days
(224 Reviews)

Expert in making complex web calculate applications Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-car More

$1186 USD in 35 days
(85 Reviews)

hello, i am shopify expert and i am ready to start work on your project i got the concept of this tax calculation and ready to start work thanks.............................

$980 USD in 8 days
(199 Reviews)

""Tax Calculation" shopify [login to view URL] [login to view URL] [login to view URL] Ruby On rails : [login to view URL] [login to view URL] [login to view URL] https://www.1001belges More

$1125 USD in 7 days
(21 Reviews)

Hi there, I hope you are doing great. I have checked the details I have great experience with Accounting, Excel, HTML, PHP, Shopify. I feel confident about getting this job done. Please start the chat so we can discuss More

$1500 USD in 10 days
(38 Reviews)

Hi, " Thanks for describing about project in easy way with example" I have more than 8 years experience in Shopify. I have understood your requirement all of the mentioned in the project description. I assure you More

$850 USD in 10 days
(122 Reviews)

Hi I can perfectly handle your project for Shopify Custom Tax Calculation . i would appreciate if ypou please interact with me. ** SHOPIFY EXPERT on Shopify's official site: [login to view URL] More

$1000 USD in 3 days
(86 Reviews)

Hi,dear. I understand your proposals and I am very interested in this job - 'Shopify Custom Tax Calculation'. I've already done this kind of project before. I am senior software developer and I am able to perform this More

$1250 USD in 5 days
(18 Reviews)

Hello, Good day! I am a professional developer and I am providing Web Designing and Development services. I would like you to know that I am interested in your project. let's discuss it further over chat. You may che More

$1000 USD in 7 days
(63 Reviews)

Dear Client, Thanks for providing opportunity to bid on the project I have 8+ years of experience in designing and developing site on shopify Some of the Shopify sites are:- [login to view URL] https://dev-mage More

$750 USD in 10 days
(16 Reviews)

392108Hi there! This is Sarah from Exceleron Solutions here. Your post caught my eye and I’d really be interested in bringing this idea of yours to life. Along with that, I can assure you that our rates are more than r More

$1125 USD in 7 days
(19 Reviews)

Hello, I am software developer with enough experiences on PHP for 13 years. I can work by full time for your project and trying to satisfy the requirements. Client's idea + Programmer's good coding is the perfect resul More

$1000 USD in 7 days
(4 Reviews)