Can I Export/Import my Tax Calculation Codes?

Yes!

Introduced with Shift4Shop version 9.1 is the ability to export and import your store's ZIP and Tax codes for tax calculation. Here's how:

1. Log into your Shift4Shop Online Store Manager.

2. Using the left navigation menu, go to Payment.

3. When the Payment page loads, click on the Setup Tax button located within the "Tax Manager" section.

Once you're on the Tax Manager page, look towards the top right and click on the Export/Import button.

Exporting

To export your existing tax codes simply click on the Export Data button located within the "Export" section. You may also click on the Schedule Recurring button to schedule a recurring export of the tax codes.

After exporting, you may edit the generated CSV file (to change or add codes) and then import it back to your store (see next section).

Importing

To import the tax codes from CSV click on the Browse button to locate the CSV file on your computer and then click Import Data to upload it to your store.

The import process will work in the background and you may check back on the page to see the import's status.

CSV fields

The CSV file that is generated during export (and necessary for import) contains the following column headers.

• id
  This is the database ID for the record. It is only used for existing records. If you are importing a new tax code record, then you will leave this column blank

• tax_country
  This is used to designate the country the tax record will be calculated for. Use the appropriate country code for this column. (i.e. US, CA, AU, etc)

• tax_state
  This is used to designate the state/province that the tax record will be calculated for. Use the appropriate abbreviation code for this column. (i.e. NY, BC, NSW, etc)

• tax1
  This column will be used for the tax percentage that will be calculated. For US based taxes, this is the only tax column you will need.

• tax2
  This column will be used for the Tax 2 percentage that will be calculated. This is typically used for juridictions that use more than one Tax table. For example, certain areas of Canada and other countries.

• tax2_include_previous
  This column is used to toggle the "Include Previous" option on Tax 2. This will be entered as a 1 or 0. (1=on|0=off)

• tax3
  Same as above, but for Tax 3

• tax3_include_previous
  Same as above, but for Tax 3

• include_shipping
  This column is used if you would like Tax to be calculated while including shipping charges. This will be entered as a 1 or 0. (1=on|0=off)

• include_discount
  This column is used if you would like Tax to be calculated while including applicable order discounts. This will be entered as a 1 or 0. (1=on|0=off)

• tax_code
  This column is used for any Tax code you may need to enter on the tax range. A tax code is used when you need to charge tax differently based on the type of product. (Click here for more information)

• tax_zip_low
  Enter the low-end zip code for the range the tax rule will cover. For example, if your range is 90200 to 90299, then this column would be 90200

• tax_zip_high
  Enter the high-end zip code for the range the tax rule will cover. For example, if your range is 90200 to 90299, then this column would be 90299

Once the CSV file is populated with your required information, you may import it into your store.