Is there another way to sort our orders by state other than printing out an entire list from excel?
Thanks.
Sorting Orders
-
- Posts: 5
- meble kuchenne Mikołów Knurów Czechowice-Dziedzice
- Joined: Fri May 06, 2016 11:07 am
- Website: www.drnuzum.com
- Paige
- Support Team
- Posts: 461
- Joined: Fri Feb 24, 2012 3:41 am
- Website: www.allprowebtools.com
- Location: Fort Collins, CO
- Contact:
Re: Sorting Orders
At this time there is not a way to do this, however what a wonderful suggestion!
Can you explain further what you are trying to accomplish so we can meet your needs in the future?
Can you explain further what you are trying to accomplish so we can meet your needs in the future?
-
- Posts: 5
- Joined: Fri May 06, 2016 11:07 am
- Website: www.drnuzum.com
Re: Sorting Orders
We are trying to find all the orders and print the invoices that are from Idaho for tax reasons.
Could you please add Idaho sales tax (6%) to the system, as our customers have not been charged and need to be for tax purposes?
Thanks.
Could you please add Idaho sales tax (6%) to the system, as our customers have not been charged and need to be for tax purposes?
Thanks.
- Paige
- Support Team
- Posts: 461
- Joined: Fri Feb 24, 2012 3:41 am
- Website: www.allprowebtools.com
- Location: Fort Collins, CO
- Contact:
Re: Sorting Orders
Thank you for explaining your needs, we do in fact have a report like what you're looking for! It can be found under Reports > Accounting > Sales Tax Liability, this report shows all orders and thee state they are to be taxed to.
To setup a taxes for Idaho:
To setup a taxes for Idaho:
- go to Store > Tax Rates
- under "Select" choose "state"
- for "Tax Rate" type in .06
- under "State" choose "ID"
- click "Save"
- click "Offline" on the tax rate to turn on auto tax calculations
-
- Posts: 48
- Joined: Tue Nov 24, 2015 3:14 pm
- Website: www.drnuzum.com
Re: Sorting Orders
Thank you for the information.
-
- Posts: 48
- Joined: Tue Nov 24, 2015 3:14 pm
- Website: www.drnuzum.com
Re: Sorting Orders
Can we print the customer addresses for this year through excel and if so what is the procedure?
- Paige
- Support Team
- Posts: 461
- Joined: Fri Feb 24, 2012 3:41 am
- Website: www.allprowebtools.com
- Location: Fort Collins, CO
- Contact:
Re: Sorting Orders
At the top right of Reports > Accounting > Sales Tax Liability there is a download button, if you click this it will export the data into a csv you can open in Microsoft Excel.
For the entire years worth of orders be sure to check the date range at the top of AllProWebTools, so that is set to the year you wish to report on.
For the entire years worth of orders be sure to check the date range at the top of AllProWebTools, so that is set to the year you wish to report on.
-
- Posts: 48
- Joined: Tue Nov 24, 2015 3:14 pm
- Website: www.drnuzum.com
Re: Sorting Orders
Thanks you for the information.
-
- Posts: 48
- Joined: Tue Nov 24, 2015 3:14 pm
- Website: www.drnuzum.com
Customer Sales Address List
I need to print all the sales of customers with their address from June 2015 till now. I am looking for Idaho sales, for tax purposes. I printed the sales tax liability info but it does not show all customers or Idaho.
- JohnB
- Support Team
- Posts: 1022
- Joined: Wed Nov 04, 2015 3:57 pm
- Website: www.allprowebtools.com
Re: Sorting Orders
Perhaps if you go to Store->View Orders, there is a button titled Download Orders CSV. Make sure the date selector at the top right is set to the correct date range, and you can download a spreadsheet of all the orders in that date range.
If this is not what you need, could you give me some more details on exactly what information you need other than the address for each individual order?
If this is not what you need, could you give me some more details on exactly what information you need other than the address for each individual order?