Post by tom327 » Fri Aug 16, 2013 1:07 pm

There was a comment about when your zip code list is very long and you need to input it into your extension:
. . . Use as many rows as you need, mine had about 400.
However, there is a one line addition to two different php.ini file to enable OC to use that many rows.
The details are listed in the installation instructions. It will take seconds to make the modification.
Is this the case? Will I need to modify these php.ini files to be able to use a long zip code list with your extension (for NY, that is probably the case).

Where would I find these two php.ini files? I'm assuming these are on my host, and not OC files?

Would I have to make sure my host company lets me do that?

Active Member

Posts

Joined
Thu Feb 16, 2012 7:33 am

Post by butte » Fri Aug 16, 2013 1:43 pm

In host control panel if you're allowed to make settings you'll find them under php. In your OC directories you'll find php.ini which may or may not give you control within your own account. Choices in sequence are master resets, control panel resets, directory php.ini resets. You'll be sure as soon as you see whether there is provision for making the changes.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Johnathan » Fri Aug 16, 2013 10:11 pm

1. Yes, the extension can restrict by geo zone and postcode. You don't need any modifications to do this.

2. There's a note in the instructions.txt file about max_input_vars limitations on certain servers. Your server may or may not have it, but if you notice rates not saving, then you'll need to add the line specified in that file to your php.ini and admin/php.ini files. Most hosting companies allow that to override the default value, but in rare cases you may need to contact them if you add it and the edit doesn't seem to work.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by tom327 » Tue Aug 20, 2013 2:17 am

There's a note in the instructions.txt file about max_input_vars limitations on certain servers. Your server may or may not have it, but if you notice rates not saving, then you'll need to add the line specified in that file to your php.ini and admin/php.ini files.
It looks like I am able to add a new line to my php.ini files to change max_input_vars settings if I need to.

Can you tell what the the setting should be, or what the exact line should look like in the php.ini file?

Active Member

Posts

Joined
Thu Feb 16, 2012 7:33 am

Post by Johnathan » Tue Aug 20, 2013 11:11 pm

Just add a line like this to both your php.ini and admin/php.ini files:

max_input_vars = 9999;

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by tom327 » Thu Aug 22, 2013 7:26 am

max_input_vars = 9999;
Thanks for the info.

I just finished consolidating NY State zip codes into as few ranges as possible. But they jump all over the place.

I begin with the original 2209 zip codes, and now I got it down to about 1,274 items (ranges of zip codes).

Can your extension handle that many? Or is the only issue just making sure I increase the max_input_vars?

I'm not sure how your extension makes use of the zip code information. But do you think I will have any kind of significant delay or problem in checkout if it has to "load' such a long list of zip codes?

Active Member

Posts

Joined
Thu Feb 16, 2012 7:33 am

Post by tom327 » Thu Aug 22, 2013 7:49 am

In regard to the zip code and interest data that I will input into the extension. You had commented that it should look something like this:
10000 10000 6.0%
11000 12000 6.2%
12250 13050 6.0%
I had a question about the percent:

In NYS, there are some sales tax rates like 8.375%

- Is there any problem using an interest rate with 3 decimal places like that?
AND
- Do you have to be consistent in that case and make all the other zip codes I enter also have 3 decimal places.

So instead of 8.0% it should be 8.000%

Active Member

Posts

Joined
Thu Feb 16, 2012 7:33 am

Post by Johnathan » Fri Aug 23, 2013 12:02 am

1. No issue with that many postcodes, as long as you've made the max_input_vars edit or your server doesn't have that limitation.

2. You can use as many decimal places as you want. It doesn't matter how you enter them -- 8% is equivalent to 8.000%

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by tom327 » Wed Aug 28, 2013 4:00 am

I was about to get the extension to try this out, but wanted to make sure I am getting the right one, to use so NYS local taxes will be added to sub-total and shipping in checkout.

Should I get the Formula Based fee/discount
OR
Shipping Based fee/discount extension?

It seems both had been mentioned, so I wanted to check?

Active Member

Posts

Joined
Thu Feb 16, 2012 7:33 am

Post by Johnathan » Wed Aug 28, 2013 10:31 am

If you need to apply taxes on the shipping cost, you'll need to use Shipping-Based Fee/Discount. It's basically Formula-Based + the ability to base rates on the shipping method and cost.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by kimbo » Thu Aug 29, 2013 10:08 pm

Jonathan's extension seems to be my answer for the NY county tax mess as well. However, since I am using Mijoshop, based on Opencart, I wanted to be sure the extension is compatible with that?
Thanks,
kimbo

kimbo
The Chloelina All Natural Soap Co.
chloelina.com


Active Member

Posts

Joined
Thu Aug 29, 2013 10:02 pm

Post by Johnathan » Fri Aug 30, 2013 12:56 am

Yes, it should work fine. MijoShop does mess up the admin panel interface a bit, but it's still usable.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by kimbo » Fri Aug 30, 2013 1:22 am

Thanks Jonathan. Is there anything I should be aware of in the admin panel when working with the extension? So far, I have only added all of the Ny counties as Geo ZOnes. Should I continue adding the tax classes and rates here or what until I have the extension?

kimbo
The Chloelina All Natural Soap Co.
chloelina.com


Active Member

Posts

Joined
Thu Aug 29, 2013 10:02 pm

Post by Johnathan » Fri Aug 30, 2013 9:47 am

You can set-up your counties as geo zones if you don't want to use the extension -- otherwise, you can use the postcode function of the extension to set taxes for those areas. Read my reply again to see that these are two different options

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by tom327 » Wed Sep 04, 2013 1:48 am

Thanks for all the help everybody.

I ended up using the Shipping Based Fee Discount extension to solve the problem of adding NY State County Sales Tax to my NY state orders.

I had to input a list I compiled of NY Zip codes with corresponding sales tax rates into the extension.

Now, when someone orders from NY, it charges them the correct NY County Sales tax based on their zip code.

It works great.

Active Member

Posts

Joined
Thu Feb 16, 2012 7:33 am

Post by modernmagic » Mon Sep 30, 2013 12:44 pm

tom327 wrote:I had to input a list I compiled of NY Zip codes with corresponding sales tax rates into the extension.
Tom327,

I also am in need of charging taxes in NY.

Do you think you can share your settings for the extension or at least the spreadsheet you used to import the rates? ;D

Joomla Web Site Designer at www.modernmagic.com


User avatar
New member

Posts

Joined
Sat Feb 09, 2013 4:55 am


Post by yowchuan » Sun Nov 10, 2013 8:06 pm

I believe I am facing a similar issue. Right now, OpenCart allows:

-Country
-- Zone
--- Geo Zone

Here's my limited understanding of OpenCart's system (correct me if I am wrong):

1. A Geo Zone allows a single shipping rule to be applied to all the Zones that is defined under the same Geo Zone.

2. Each Zone must be attached to a Country.

And now begins my issue with the above setup:

I am setting up a store for a florist that only delivers to cities that is around 100km from it's physical store. They are using their own delivery vans to send orders to the customers. The further the city, the higher the delivery. Unfortunately, I am not able to set Geo Zones on the city level.

Is there an extension that can solve the above issue?

Also, since the florist does not deliver to 99.99% of the Zones listed in OpenCart, is there an option for me to remove them so that during the check-out process, the customers will only see the available cities that the florist provide delivery to.

Thank you in advance for any guidance.

New member

Posts

Joined
Wed Feb 06, 2013 2:39 am

Post by Johnathan » Sun Nov 10, 2013 11:09 pm

You can disable or delete countries and zones through the admin, although that would take a lot of time since there are so many of them. For distance-based shipping, you have two options:

1. Re-purpose the countries and/or zones as cities, which are within the 100km of the store. You can then use these cities (i.e. "zones") when creating geo zones.

2. If the rates can be based on postcode, use something like Formula-Based Shipping to create shipping charges for postcode ranges.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by yowchuan » Mon Nov 11, 2013 12:33 am

Thank you Johnathan for your prompt response. Before I proceed to remove the Zones, I have a question: Will my removing of the zones causes problem for customers whose address is of the Zones I removed.

Example; If I remove United States, would a customer from New York who wants to send flowers through my florist face any problem when registering as a member (inputting his Billing Address which is in United States)?

Thank you!

New member

Posts

Joined
Wed Feb 06, 2013 2:39 am

Post by Johnathan » Mon Nov 11, 2013 10:08 pm

Well, he wouldn't be able to use New York if you re-purposed the zones. If you're U.S.-based only, then you could make the countries into states, and the zones into cities -- but you'd need to make sure to assign a "Your city doesn't matter" type zone for all the states except your own.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am

Who is online

Users browsing this forum: No registered users and 5 guests