scafidi454

My reply was less than three days ago, and there was no resolution.

What a waste of time and effort here. Always providing generic and canned info.

Joined the Dev group on Slack; also, no help yet, but I am keeping an eye on it.

I understand your challenge with the Maxmind integration.

I have the databases, the keys, the GeoIP.conf, the documentation, but the problem is it seems the geoipupdate program hast to be in /usr/local/etc, which is a root directory I have no access to.

Since you’ve upgraded to a VPS and have root access, you should be able to place the geoipupdate program in /usr/local/etc.

– Yea; did that already. The problem is the difference between crontabs. I’m working with my host.

I got WP All Import Pro, but it doesn’t seem to be able to import/transform the CSVs into taxes.

WooCommerce tax table does not directly support GeoLite2-City.CSVs. You may need to write a custom script to convert the CSV to a compatible format.

– Maxmind won’t work as it only looks up based on IP, which isn’t sufficient for mobile users, different shipping locations, spoofed IPs, etc.

As far as the tax calulcations, it appears it’s only working for local/home state, and not out of state.

WooCommerce Tax should calculate taxes based on the shipping address. If it’s not working as expected, please ensure you have the correct settings under WooCommerce > Settings > Tax.

– I said I was using the guide; don’t you think I already have been troubleshooting with the tax settings?

Do I need to purchase? https://www.maxmind.com/en/geoip-api-web-services

If you can update the database manually, you do not need to purchase the API. The API is a paid service that provides automatic updates, but it’s not mandatory for the integration.

However, as mentioned in our docs, you must get license keys from MaxMind for easy inntegration:?https://woocommerce.com/document/maxmind-geolocation-integration/#create-a-maxmind-license-key

– Yea, I have the keys. The service won’t work for my use.

Error loading configuration: the EditionIDs option is required

Please ensure that the EditionIDs in your GeoIP.conf match the databases for which you have a license. The error message suggests that there might be a discrepancy.

– Yes, they are. I said I was using the guide, which includes modifying the default GeoIP.conf, which I did. It’s fine.

If you are still having problems, we recommend asking development questions on the #developers channel of the?WooCommerce Community Slack. Many of our developers hang out there and will be able to offer insights into your question. You can also seek help from the following:

– I will check the slack group, but if it’s anything like the previous support/comments I’ve received, it won’t be useful either.

• A local web developer <- This option is so obvious, I don’t know why people mention it.
• Codeable.io <- will look
• WooExperts <- will look

I hope this information is helpful. If you need further assistance, please don’t hesitate to ask.

– Haven’t gotten any solutions in the few posts I’ve made (this year only) in the past eight years of having this account.

anastas10s,

I have the key in correctly.

The cron job is entered and seems to be working (no errors received).

However, I will want to export to other countries, eventually. So, I’d prefer to get this setup correctly in the beginning.

Additionally, I upgraded my server from a shared to VPS. So, I have root access now.

After downloading the .tar.gz needed, following the install guide, etc., I am not able to get the cron updating job to run, but it’s a permissions issue I’m working on with my host.

As far as the tax calulcations, it appears it’s only working for local/home state, and not out of state.

By default, the MaxMind integration only does country lookups, and not city.

So, I’m trying to figure out how to import the GeoLite2-City .CSVs into WooCommerce’s tax table.

However, looking at the file, it’s not going too work / match up by default.

Will WooCommerce Tax calculate exact (state, city, etc.) taxes based on the shipping address? I have it installed, but I don’t think it’s working.

I have also tried using Geolocate and no location by default, as some users may not be where their IP is at.

This is what I’m referencing.

https://woocommerce.com/document/maxmind-geolocation-integration/

https://dev.maxmind.com/geoip/updating-databases/#3-run-geoip-update

https://dev.maxmind.com/geoip/updating-databases

https://github.com/maxmind/geoipupdate

https://github.com/maxmind/geoipupdate/releases

Do I need to purchase?
https://www.maxmind.com/en/geoip-api-web-services

I’d rather do it manually if it’s free for now; I’m just starting out.

Threadi,

I got it worked out; really simple actually. Thankfully, I found it on a RedHat forum:
https://www.redhat.com/sysadmin/beginners-guide-redirects-htaccess

The URL structure I was referring to is similar to this one:
https://www.turnkeymsp.net/product/chromebook-2-8gb-mercury-gray/

The issue was being able to go directly to a link like that without it redirecting to the homepage, but the above fix worked.

I had to amend my .htaccess redirects from:

Redirect to HTTPS (301 – permanent)
RewriteEngine On
RewriteCond %{HTTP_HOST}
RewriteCond %{HTTPS} !=on RewriteRule . https://www.turnkeymsp.net%{REQUEST_URI} [R=301,L]

To:

Redirect to HTTPS (301 – permanent)
RewriteEngine On
RewriteCond %{HTTP_HOST} !^www.(.)$ [OR,NC]
RewriteCond %{HTTPS} !=on RewriteRule . https://www.turnkeymsp.net%{REQUEST_URI} [R=301,L]

Once I saw that extra “!^www.(.)$ [OR,NC]” directive, I knew it was what I needed. All my sites started working properly again!

I had it setup before, but lost it a long time ago. Gotta love breaking your site!

Thank you for your response!
(WARNING: MARKETING BELOW!)

• This reply was modified 4 months, 2 weeks ago by Jan Dembowski.
• This reply was modified 4 months, 2 weeks ago by Steven Stern (sterndata). Reason: removed long bit of resume (see notes)

I don’t use Slack often but I have the desktop app and I can’t find you.

Add me @turnkeymsp or maybe [email protected]

I think I got it; i was trying to use the integration plugin absolute path. After downloading magento and unzip -xf the tarbal to the dir, it still didn’t work. Using Softaculous installer on cPanel worked, but now I have to figure out how to do the integration with the API information I have. Will add you as soon as Slack finished installing.

CSV Importing won’t work. I have several documents that have to be called on…

It came back… Hmm…

Actually, just saw there was an option to put it in vacation mode (Crisp). However, that hasn’t changed anything either. It’s like the Crisp script overrode the FB Messenger script.

bump