Tips and tricks for your Shopware store: Shopware USA / American states

29.11.2017
by Meike Müller
Shopware
Banner
As a certified Shopware agency, we would like to help you take your online store to the next level with useful tips and tricks. If you need help with your Shopware online store or if you have any further questions - feel free to contact us! And now have fun with our list of American states for Shopware:

The "28" in the script below needs to be replaced with the ID of the corresponding country.
You can find the list of countries and IDs in s_core_countries

HERE IS THE INSERT FOR THE USA OR: AMERICAN STATES IN ENGLISH:

INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Alabama', 'AL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Alaska', 'AK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Arizona', 'AZ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Arkansas', 'AR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Colorado', 'CO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Connecticut', 'CT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Delaware', 'DE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'District of Columbia', 'DC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Florida', 'FL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Georgia', 'GA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Hawaii', 'HI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Idaho', 'ID', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Illinois', 'IL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Indiana', 'IN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Iowa', 'IA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'California', 'CA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Kansas', 'KS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Kentucky', 'KY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Louisiana', 'LA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Maine', 'ME', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Maryland', 'MD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Massachusetts', 'MA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Michigan', 'MI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Minnesota', 'MN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Mississippi', 'MS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Missouri', 'MO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Montana', 'MT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Nebraska', 'NE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Nevada', 'NV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New Hampshire', 'NH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New Jersey', 'NJ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New Mexico', 'NM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New York', 'NY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'North Carolina', 'NC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'North Dakota', 'ND', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Ohio', 'OH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Oklahoma', 'OK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Oregon', 'OR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Pennsylvania', 'PA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Rhode Island', 'RI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'South Carolina', 'SC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'South Dakota', 'SD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Tennessee', 'TN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Texas', 'TX', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Utah', 'UT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Vermont', 'VT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Virginia', 'VA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Washington', 'WA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'West Virginia', 'WV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Wisconsin', 'WI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Wyoming', 'WY', 0, 1);


Shipping to the United States

In American stores, prices are always shown as net prices. Whether it's a department store, restaurant or online store, the prices you see are subject to local tax, which is comparable to VAT in Germany. The problem here is that the local tax is set and levied by the individual states.

While the local tax in Texas is 6.25 %, it can be higher or lower in other states. Therefore, when ordering in US online stores, the state to which the product is to be delivered must always be specified. Shopware has added all states in the basic settings for the USA for this case. You can also activate there that it is mandatory to enter the state. .

Do you want to take your online store to a new digital level? We at EXWE are at your side as a strong partner and help you from the creation of your store to the service & support of an existing webshop. If you have any questions, please feel free to contact info@exwe.de.

Was ist dein Projekt? Wenn du uns darüber erzählen möchtest, rufen wir dich zurück!

 
Meike
Meike
from 29.11.2017

Hello, my name is Meike. I take care of the EXWE back office and am responsible for our social media channels. All of our articles are meant to make your life easier and help you make decisions. Nevertheless, it can happen that something remains unclear, so: If you have questions about this article you can easily reach me at +49 231 93149827.

Du möchtest immer am Zenit der Technik bleiben? Keine News und Blogbeiträge mehr verpassen.
We also have the following interesting posts from our tech blog for you on this topic
Show Shopware Custom Products under variant selection

In this article, we will show you how to place the Custom Products options below the variants by customizing the Shopware theme.

Our HubSpot plugin - hand in hand with Shopware

Use our Shopware plugin between Shopware and the Hubspot universe now and benefit from simple and bundled data collection!

Shopware Download / Appendix Fix after update

Linked downloads are no longer displayed? Here you will find the problem-solving attachment fix that will make your downloads visible again.