Tips and tricks for your Shopware store: Shopware USA / American states
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.
What is your project? If you want to tell us about it, we'll call you back!
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.
You always want to stay at the cutting edge of technology Don't miss any more news and blog posts.
We also have the following interesting posts from our tech blog for you on this topic
Shopware 6: What are dynamic product groups?
What are dynamic product groups in Shopware and what can they be used for? And how can you create them? You can find out all this in our article.
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!
How do I convert my store system to Shopware 6?
Would you like to carry out a Shopware 6 migration? We'll show you what to look out for and how to make the move a success.
