amrevnc

You are very kind to have done this, @mtg169. None of the tools I found were capable of extracting the PDF data as a correct CSV.

That said, I wasn’t specific enough. I was talking about the Rate and Data Boundary Databases, which offer several advantages, the biggest being that businesses using them are not responsible for mistakes in the data (unlike the PDFs). However, one database has literally every address in the state, and thus has millions of rows, as I said.

But I decided to take the risk with the County list and pay any penalties incurred, and the city list is more accurate than it, so you have reduced my risk. May I ask what tool you used so I can update the list as rates change?

With much appreciation,
Jim

Thank you, @mtg169 and @slash1andy, but I had already talked by phone with NC Dept. of Revenue managers before I started this thread. The state only provides rates by county in a PDF–refuses to provide a CSV–so I would have to manually type them in.

As for the lists by address, the state only provides the rate codes in one database CSV and the addresses in another one with millions of lines. A query has to be run to combine the rates with the addresses (the state refuses to provide a pre-combined one). A standard mid-priced laptop like everyone on my team has does not have the memory to run such a query.

Furthermore, after trying out the plugins @mtg169 mentioned and another I found, there was a fatal flaw in each case. To summarize: I also need “County” in the “Standard rates” table in Woo; only Advanced Customer Fields *might* do that, but you have to be a programmer to add the necessary hooks in Woo; and the other plugins only modify the checkout field.

In short, if my product vendor can’t fix the problem with Woo, I’ll have to switch to a different shop platform.

Thank you for all of your time,
Jim

Okay, that is great news! I will try switching out for Stripe and killing Jetpack this weekend in hopes of fixing the problem. I’ll leave this open until then to reply with the results for future users.

Thank you very much, @mtg169!

Update: At the suggestion of Dreamhost, I deactivated all of the Woo plugins, Jetpack, and W3 Total Cache. I reactivated just WooCommerce, went to options.php, and was able to change the “no” to “yes.” I then reactivated everything else. Now the “/wc-api/v1/” and “v3” tests shows the API is enabled.

However, the original problem remains with the vendor plugin not syncing. I will go back to them for that support.

Thank you for your help.

Okay, thanks. It appears to have the perms:

drwxr-xr-x (0755)

Sorry for the multiple posts, but I thought I should share that I experimented with plugins last night without success. Specifically, I:

1. Turned off W3 Total Cache (after purging all caches)
2. Set Cloudflare to bypass its cache (that is, load directly from the site server)
3. One at a time, turned off each plugin not in place the last time the sync worked, and tried the sync
4. De- and reactivated the Printful plugin (the site I am trying to re-sync with)

Also note that earlier I created a new WooCommerce API key and revoked the old one.

After all this, the conditions in my original post remain true.

I have solved the problem. The answer was unintuitive, so I am adding it here for anyone else who runs into it.

I had made a change in the “functions.php” file of my child theme for an unrelated purpose (a workaround to enable Jetpack to display the social sharing icon for e-mail without using Akismet). Specifically, I added this line at the bottom of the file:

add_filter( ‘sharing_services_email’, ‘__return_true’ );

Removing that line fixed the issue. Don’t ask me why. 🙂